How do you set more than one record?

[acuken]

I'm trying to update records in a Db. I have a record called "classOffering" and I have associated records for that offering called "classSessions". You have 1 classOffering for 1 to 6 classSessions. The process I use has the user create the classOffering and say how many classSession there will be then I create how ever many sessions they say. I then display the classSessions so they can be edited and updated in the Db. I can't seem to update and set more than one record even though there are more.

I know I need to use a while or foreach statement, but I can't seem to do it.

Here's my code so far:

[pre]

$sessSet = "UPDATE classSessions

                  SET startDate= '$startDate', startTime= '$startTime', time= '$time'

                  WHERE classSessions.sessionId = $sessionId

                  ";

[/pre]

 

Thanks for any help.

[blacknight]

have you searched google .......

 

http://stackoverflow.com/questions/3432/multiple-updates-in-mysql

 

the first 10 results answered your question....

 

 

[acuken]

Thanks, I have been googling and I have tried a foreach statement and a do while statement. I hope I don't need to create a temporary table.