is my mysql update syntax correct ?

[cyber_alchemist]

I am bit new to sql so is this correct for updating these fields and its values ?

UPDATE tourDB
                        SET
                         tour_name = '$tour_name', 
                         tour_type = '$tour_type', 
                         nights  = '$nights',
                         overview = '$overview',
                         itinerary = '$itinerary', 
                         inclusions = '$exclusions', 
                         twin_triple_sharing = '$single_occcupancy', 
                         child_with_no_bed = '$child_with_no_bed',
                         inf_below = '$inf_below,'
                         keywords = '$keywords',
                         title = '$title',
                         description = '$description',
                         url = '$url',
                         categories = '$categories'
                         WHERE 
                         tour_id = '$tour_id'

I want to update these where tour_id column has a value of $tour_id

[requinix]

It may sound like a silly question, but does it work and update the fields the way you want it to?

[cyber_alchemist]

well, if I replace the php variable's with constants, it works...? but other than that , it not working , maybe i have some problem with my php programme ??? what do suggest , by looking the update query ??  I am stuck for 3 hrs working around this problem 

[requinix]

What you posted looks fine (honestly, I would have said something if it didn't) so if there's a problem then it must be with what you haven't posted.

 

So how about showing us the rest of your code?

[cyber_alchemist]

yes , sure, I will post in PHP section then ? 

[cyber_alchemist]

posted it here http://forums.phpfreaks.com/topic/283080-cant-update-my-tables/