Breathing Spring

Archive for the ‘mysql’ Category

Insert or Replace Plus adding string to string in mysql

INSERT INTO answers( player, answer )
VALUES (
‘lamis’, ‘-1-0′
) ON DUPLICATE
KEY UPDATE answer = CONCAT(answer, ‘-1-0′)

Get one row values

$result=query(“SELECT * FROM cmspages where page_id=$page_id”);
$row= mysql_fetch_array(($result);
$row['page_name'];

Main MySql Queries

Insert Query :

insert into $table (something,otherthing) values (‘$new’,'$new2′)

Select Query

Select * from $table where something=something

Update query:

Update $table  set feild1=value1 , feild2=value2 where something= something

delete query :

delete * from table where something=something

add one to mysql field

the long way is

<?php
$sql_query = mysql_query("SELECT `number` FROM `numbers` WHERE `pageid` = '$pageid'", $link);
while($rs = mysql_fetch_array($sql_query)) {
$num = $rs[0] + 1;
}
$sql_query = "UPDATE `numbers` SET `number` = '$num' WHERE `pageid` = '$pageid'";
if(mysql_query($sql_query)) {
echo "Record updated successfully";
}
?>

the short way

UPDATE table SET foo = foo +1 WHERE bar = x