Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
April 17, 2006, 2:59 pm
rate this thread
What is the best way to do this with making repeated calls to the
database for each item?
Actual application is:
I have an array (in PHP) of serial numbers of units about to be
I want to check the ship record (a table in a MySQL database) to check
if that serial number has been used before.
According to our quality policy we never reuse serial numbers, serial
numbers are unique. So prior to printing the packing slip I want to
warn the shipping guy/gal a serial number may be incorrect.
I could brute force it and increment through the "to be shipped array"
and check each item against the table. But that is, as I said brute
force, and I am having to be concerned with system speed lately.
Re: Check if any items in an array (php) is in a table (mysql).
Load the shipped table as an associative array and then do an isset() on
the $array[$serial_number] in question. Only load those rows that have
the shipped status set the way you need.