Put a space before WHERE and _ALWAYS_ use MySQL_error() with your
queries... you'll stop wasting your time and ours.
MySQL_query($query) or die("Error in Query: $query >> " .
MySQL_error());
Good idea to print out the query if you can, that way you know what's
actually being sent to MySQL.
---John Holmes...
> -----Original Message-----
> From: Phil Reid [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 18, 2002 7:33 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] URGENT
>
> I am in urgent need of help! (AGAIN)
>
> Can anyone spot anything wrong with this query?
>
> $sql = "UPDATE IGNORE customer SET forename = '$forename', surname =
> '$surname', e-mail ='$email', company = '$company', homephone =
> '$homephone', workphone = '$workphone', mobilephone = '$mobilephone',
> address1 ='$address1', address2 ='$address2', address3 = '$address3',
> local = '$local', city = '$city', postcode = '$postcode', id = '$id'";
> $sql .= "WHERE username='$username'";
>
> mysql_query( "$sql");
>
> I need to get it working NOW!
>
> I will be very grateful if I receive the same level of help as before.
> Thanks a lot.
>
>
> Phil Reid
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
