Posted by Jochem Maas on 11/11/77 11:15

Mathieu Dumoulin wrote:
> Prathaban look carefully, we are here to give acurate info and you are
> giving mistaken information. The "$id" thing is wrong, you'll actually
> create a parse error X|

a more correct answer would have been:

there is not way to know for sure whether the syntax is correct (
lets assume the PO was referring to the SQL syntax).

1. because the DB engine used is not specified (ok so its probably mySQL!)
2. the values of the vars in the string that $query is set to are not
mentioned (they could contain anything, i.e. something that breaks the SQL syntax)

<to-the-OP>
HAVE YOU TRIED RUNNING THE QUERY??? trying things out is 'sometimes' quite a
good way of determining the validity of the syntax that you are unsure about.
</to-the-OP>

BTW: its probably not worth mentioning that it was not really a php question
to begin with right? ;-)

>
> ...
>
> Prathaban Mookiah wrote:
>
>> It should be "$id".
>>
>> Note that missing "
>>
>>
>> Prathap
>>
>>
>> ---------- Original Message -----------
>> From: "Ross" <ross@aztechost.com>
>> To: php-general@lists.php.net
>> Sent: Thu, 5 May 2005 12:09:18 +0100
>> Subject: [PHP] is this the correct syntax
>>
>>
>>> Am trying to do an update of a record...
>>>
>>> Is this the correct syntax..
>>>
>>> $query= "UPDATE $table_name SET fname='$fname', sname='$sname' WHERE
>>> id= $id";
>>>
>>> R.
>>>
>>> --
>>> PHP General Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>> ------- End of Original Message -------
>
>

[Back to original message]