Archive for September 1st, 2008

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

Return top

INFORMATION

Change this sentence and title from admin Theme option page.