[SOLVED] UPDATE quote

[Ken2k7]

Is it mandatory to have the quotes in the UPDATE query as shown below:

 

mysql_query("UPDATE member SET name='$name', age='$age', location='$loc', sex='$sex', interests='$interests' WHERE id='$id'");

 

or can I do this:

 

mysql_query("UPDATE member SET name=$name, age=$age, location=$loc, sex=$sex, interests=$interests WHERE id=$id");

 

Thanks in advance. I would've tested myself but this requires another php file that I haven't created yet, so that's why I'm asking. It's like a mini-project.

[matthewhaworth]

I think SQL is lenient and will allow it without quotes, but if it's a string, it should have quotes.

[vijayfreaks]

Hi..

        if its int,float then its ok..

        but if its string then ur data contain , or anything junk sql injection then you will have error or

        there would be problem in data..

 

Regards,

Vijay

[matthewhaworth]

Hi..

        if its int,float then its ok..

        but if its string then ur data contain , or anything junk sql injection then you will have error or

        there would be problem in data..

 

Regards,

Vijay

 

You like to come in threads and repeat what I say don't yer lol.