RE: [PHP] Can anyone tell me why this code doesn't insert anything?

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','name@domain.com','12345','Smith')"; > $result = mysql_query($query);