[thelist] re: mySQL INSERT query failing...

Tom Dell'Aringa pixelmech at yahoo.com
Thu Jun 17 10:23:07 CDT 2004


Note when I added 

$scout = $_POST['scoutReport'];
$pid   = $_POST['pid'];
mysql_query("INSERT INTO scouting (playerID, report) VALUES ('" . $pid .
"','" . $scout . "')", $conn);
printf ("Updated records: %d\n", mysql_affected_rows()); <-- added this

I get a '-1' which apparently indicates query failure:

http://us2.php.net/manual/en/function.mysql-affected-rows.php

But I still have no idea why...

Tom

=====
http://www.Pixelmech.com/ - read my latest blog posting!

John 3:16





More information about the thelist mailing list