does UPDATE has any limitation on number of updates??

mehrzadsoft

hi
dear friend when i use the 1st query every thing is ok, but by using 2nd one it does not work!

why not??

help me.

1st:
$query = "UPDATE $tblname SET body='$body', title='$title', idcat='$idcat', fayear='$fayear', famonth='$famonth', faday='$faday', wshow='$wshow' WHERE id=$id " or die(mysql_error());

2nd:
$query = "UPDATE $tblname SET body='$body', title='$title', idcat='$idcat', fayear='$fayear', famonth='$famonth', faday='$faday', wshow='$wshow', show='$show' , desc='$desc', dshow='$dshow' WHERE id=$id " or die(mysql_error());

thorpe

what does not work meen? are you getting any errors, the query looks good from here.

superwormy

Are you even executing the query...? I don't see any calls to mysql_query() at all...

mehrzadsoft

it seems correct but when i want to update with 2nd one it does not update selected query.

have sql another command for updating?

superwormy

You realize you have to use mysql_query("your query here") to run the query right? Your code you posted doesn't have mysql_query() in it at all...