I'm attempting to add a standard sequence (increments of 1) for all records meeting a given criteria. My SQL select statement would look something like this:
Code: Select all
mysql_query("SELECT * FROM myTable WHERE city='Tampa' ORDER BY recordSequence ASC")Any ideas are extremely appreciated. Thank you!!