On Wednesday 06 November 2002 21:46, Steve Jackson wrote: > It doesn't contain a single result. It returns 16 order numbers (which > is correct - 8 should be in the table emails with no checked and > therefore the query has worked and pulled out 8 from the orders table > also). What I want the function to do is say OK where the orderid's > match pull out all the address details for each orderid and display what > I want displayed accordingly. At the moment I get this array returned by > using print_r($row). > Array ( [0] => 100040 [orderid] => 100040 ) Array ( [0] => 100041 > [orderid] => 100041 ) Array ( [0] => 100043 [orderid] => 100043 ) Array > ( [0] => 100044 [orderid] => 100044 ) Array ( [0] => 100046 [orderid] => > 100046 ) Array ( [0] => 100050 [orderid] => 100050 ) Array ( [0] => > 100051 [orderid] => 100051 ) Array ( [0] => 100052 [orderid] => 100052 ) > > Where do I go from here?
Well, like I said in my previous post if you remove the line: $orderid = $row; then your second query *should* work. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* New members are urgently needed in the Society for Prevention of Cruelty to Yourself. Apply within. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php