updating multiple rows at a time (Mysql)

Outer · 02-09-2005, 06:43 PM

I need to update multiple rows of data in Mysql using PHP. It is a list of over 300 items and they all have their own specific row and ID

how would I go about doing that?

Thx

adam_uk · 02-10-2005, 05:47 AM

get me table names and column names and i might be able to help you

CreativeLogic · 02-10-2005, 07:26 AM

They all need to have something common unless you want to update EVERY row in the table. If they have something in common then do WHERE row = 'somethingincommon' and if you just want to update every row then just leave out the where statement.

02-09-2005, 06:43 PM	THREAD STARTER #1 (permalink)
Outer NamePros Member Join Date: Jan 2005 Location: Texas USA Posts: 71	updating multiple rows at a time (Mysql) I need to update multiple rows of data in Mysql using PHP. It is a list of over 300 items and they all have their own specific row and ID how would I go about doing that? Thx __________________ I wonder...

02-10-2005, 07:26 AM	#3 (permalink)
CreativeLogic NamePros Regular Join Date: Sep 2003 Posts: 889	They all need to have something common unless you want to update EVERY row in the table. If they have something in common then do WHERE row = 'somethingincommon' and if you just want to update every row then just leave out the where statement. __________________ Online Time Tracking :)

02-10-2005, 05:47 AM	#2 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	get me table names and column names and i might be able to help you

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)