There's some basic phpMysql info at:
http://twebman.lunarpages.com/php/Create a table for your Mysql database "on-the-fly" at:
http://twebman.lunarpages.com/php/tablemaker.phpA typical php connection looks like this:
$dbcnx = @mysql_connect("localhost","USER NAME", "PASSWORD");
mysql_select_db("DATABASE NAME");
Now the query..
$myquery = "SELECT * FROM tablename WHERE columname = '$variablename'"; (doesn't have to be a variable, could be a value)
$myresult = (mysql_fetch_array($rmyquery)) Notice the variable name of the query in the parentheses. That's important.
the "$dbcnx", "$myquery" and "$myresult" are arbitrary variable names. You can use whatever you like there. Just make sure to name your query in the parenthesis of mysql_fetch_array.
[ March 27, 2003, 04:40 PM: Message edited by: TWebMan ]