Is there a finite # of variables that can be SET?

[badgoat]

For example,

$query = "UPDATE table SET name = '".$_REQUEST['newname']."'

Is there a limit to the variables that can be set? And if there is and one gets to that point, how does one create a second query to update even more?

[thorpe]

if your tables have that many fields that you think your going to reach some sort of limit, it really is time to start looking at normalizing your db.

but, to answer your q?

Is there a finite # of variables that can be SET?

not that im aware of.

[badgoat]

thorpe, I am seriously planning on normalizing my db.. I just read more this morning on how to (and I am skeered)

[devinemke]

what RDBMS are you using? mySQL tables can have up to 3398 columns.

[badgoat]

MySQL. Thankfully I am nowhere near the 3398 limit.. Less than 70, if I count correctly.