Hawx wrote:
On Mon, 27 Apr 2009 07:19:23 -0700, "Miller, Terion"
<tmiller@xxxxxxxxxxxxxxxxxxxx> wrote:
I need help/advice figuring out why my query dies after 2 records. Here
is
the query:
// Build your INSERT statement here
$query = "INSERT into `warrants` (wid, name, age, warrant, bond,
wnumber,
crime) VALUES (";
$query .= " '$wid', '$name', '$age', '$warrant',
'$bond', '$wnumber', '$crime' )";
$wid = mysql_insert_id();
// run query
mysql_query($query) or die ("GRRRRRRR");
echo $query;
It inserts two records and dies half way thru the 3rd?
Thanks in advance for clues to fix this.
T.Miller
Make sure any apostrophes in the variable strings are escaped correctly.
Check the addslashes() function.
No - use the mysql_real_escape_string function. Addslashes is the wrong
thing to use here.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
