Multiple Rows In Sql Query Help?!?!!?!?!?!

[binarylime]

question...

i have a database table as such :

crew_id, start_date, po_number.

This table holds work information on any given day. There can be infinite amount of work to do each day. An example would be

Row 1 : 1, 4-25-2003, 1234
Row 2 : 1, 4-25-2003, 1235
Row 3 : 1, 4-26-2003, 1236
Row 4 : 1, 4-27-2003, 1237
Row 5 : 1, 4-27-2003, 1238
etc etc etc etc etc etc

Now, when I do a select * from table where crew_id=1 and start_date="4-25-2003" I can put that query into an array...

So, when I echo $row[3] I should get 1234.... but how do I get the rest of row[3]'s from the next lines in the array?

• jesse

[brad_fears]

If I'm reading your post correctly, you just need a while statement like this:

while ($r = mysql_fetch_array($result)) {
$po_number = $r["po_number"];
echo $po_number;
}

That should print out each value of the po_number field. Or you could assign each value to an array within the while statement.

--Brad Fears

[binarylime]

Mr. Fears - we meet again.

Yes, you did read my question correctly -- lack of coffee assisted me in my clearly recognizable bungle of words.

Your tip worked 100% and totally eliminated about 10 lines of code that I had previously written...

Thanks again for all the help! 🙂