Update Multiple values of a row

[Micah_D]

$hitUpdateQuery = "UPDATE Table1 SET NumberTimesHit = '{$hitRow['NumberTimesHit']}' WHERE ClientIP = '{$hitRow['ClientIP']}'";

I want to update another value in the row, how can I do that... Please help! I think I can do it on this line, I am just not sure!

$hitUpdateQuery = "UPDATE Table1 SET NumberTimesHit = '{$hitRow['NumberTimesHit']}'  AND Value2 = '{$hitRow['Value2']}' WHERE ClientIP = '{$hitRow['ClientIP']}'";

That is what I think I should do, please help!
micah

[HalfaBee]

Replace the AND with a comma.

Reading the manual may have helped here. 🙂

HalfaBee

[Micah_D]

sorry some times, I just don't have time to read everything... Simple questions can be answered easily, and I can work on other things at the same time...

Thanks for the help!

[HalfaBee]

No problem.

I keep a windows helpfile of the mysql
and php manual on my desktop just for these sort of questions.
One or two clicks and you have the answer. ( Even I have to look things up sometimes )

At least I didn't tell you to RTBM or RTFM and not answer the question. 😃

HalfaBee