Breathing Spring

Archive for the ‘mysql’ Category

Insert or Replace Plus adding string to string in mysql

No Comments »

December 5th, 2008 Posted 8:06 am

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

Posted in mysql

Get one row values

No Comments »

September 1st, 2008 Posted 7:37 am

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

Posted in mysql

Main MySql Queries

No Comments »

September 1st, 2008 Posted 7:34 am

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

Posted in mysql

add one to mysql field

No Comments »

August 12th, 2008 Posted 9:03 am

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

Posted in mysql