2002 - 2004 << Back | Fwrd >>

mysql_query()

$mysql_link=mysql_connect(host,'USERNAME','PASSWORD') or die("ERROR: cannot connect to MySQL server.");

mysql_select_db()

if (mysql_select_db('some_db_name',$mysql_link))


     echo "DB selected.";


  else


     echo "Could not select the DB.";

CREATE TABLE table_name (firstcol char(25),


secondcol char(25),


...)

$mysql_query("CREATE TABLE table_name (firstcol char(25), secondcol char(25)) ");

$mysql_query("DROP TABLE table_name");

INSERT INTO table_name (firstcol[,secondcol]) VALUES ("hello!","GOOD MORNING")

mysql_query("INSERT INTO table_name (firstcol,secondcol) VALUES ('hello!','GOOD MORNING') " );

DELETE FROM table_name WHERE firstcol= "hello!"

$mysql_query("DELETE FROM table_name WHERE firstcol = 'hello!' ");

UPDATE table_name SET firstcol = "bye!" WHERE firstcol = "hello!"

$mysql_query("UPDATE table_name SET firstcol = 'bye!' WHERE firstcol = 'hello!' " );

SELECT firstcol FROM table_name

$result = mysql_query("SELECT firstcol FROM table_name");


while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {


echo "<br>Data:" .$row[0];


}

mysql_close($mysql_link);

mysql_create_db("new_DB",$mysql_link);

mysql_drop_db("new_DB",$mysql_link);