What happens if you echo out $query to the browser window and try to
copy and paste the query into a command line mysql session (be sure to
connect to the database using the same authentication credentials that
you have in the script)? Does it work?
--Sam
Brian Dunning wrote:
> This inserts nothing into the database, but returns no error that I
> can see. How come? What's wrong with it?
>
> $dbname = "my_database";
> $dbconnection =
> mysql_connect("mysql05.powweb.com","my_user","my_pass");
> mysql_select_db($dbname, $dbconnection); $query = "INSERT INTO
> invoices
> ('ip','total','creation','first_name','email','session','last_name')
> VALUES
> ('0.0.0.0','0.00',NOW(),'Bob','[EMAIL PROTECTED]','12345','Smith')";
> $result = mysql_query($query);
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
