How do I operate mySQL remotely (batch mode?), and how do I pass values to and from PHP to a mySQL database? The documentation at the mySQL website doesn't make either clear...
Would this line work if I was connected to my database, and wanted to see if a user name existed, where the input from the form was named id?
mysql_query("SELECT * FROM users WHERE userid = $id") or die("No worky.");
How do I update the mySQL database from PHP? On a registration form for instance?
$query = "INSERT INTO table (field name, second field, 3rd, 4rth) VALUES ('stuff to insert in first field', 'in second', '3rd', '4rth')"; mysql_query($query, $connect);
Try looking at the php/mysql tutorial on www.webmonkey.com for a really quick and easy look at some basic functions to manipulate mysql databases with php.
