Re: mysql_fetch_array() question

On Tuesday 05 November 2002 05:47, Graeme McLaren wrote: > Hi, Anyone know how I can use two mysql_fetch_array() functions similar > to the code below? I've tried a few different ways but I keep getting > Resource ID #4. I need to do this to retrieve an email address from one > table and retrieve details from another. > > Cheers for any tips - I'm stumped with this one, > > Graeme :) > > $query = "SELECT Name, Address FROM users"; > $query2 = "SELECT EmailAddress From Members"; > > $result = mysql_query($query); > $result2 = mysql_query($query2); > > while($details = mysql_fetch_array($result) and $Email = > mysql_fetch_array($result2)) > { > echo "Name: $details[Name]"; > echo "Address: $details[Address]"; > echo "Email: $Email[EmailAddress]"; > } Unless I've missed something you're going about this the wrong way. For what you want to do, you should (in general) be able to accomplish it using just a single query. What fields do the tables 'users' and 'Members' contain? There should be a field there (like eg. userid) which links the two together. If there isn't one then you should seriously restructure your tables so that there is one. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Cats are smarter than dogs. You can't make eight cats pull a sled through the snow. */