MySQL with PHP plz help..

a_gajic posted this at 15:41 — 16th August 2001.

They have: 71 posts

Joined: Aug 2001

a very simple question i think but i dont know how to do it..

in php you have to use commands like mysql_query etc what is that command if u want to insert into the database?

thanks
adam.

----

ugh, sorry it works with mysql_query i had a typo lol

sersun posted this at 08:26 — 20th August 2001.

They have: 32 posts

Joined: Aug 2001

I assume you already are connected to the database, using
mysql_connect() and mysql_select_db()

For simplicity, first create your SQL statement as a separate variable, then run the query:

$sql = "INSERT INTO tablename (apples, oranges) " .
"VALUES('$apples', '$oranges')";

mysql_query($sql);

Hope that helps

sersun