Jump to content


Photo

Adding together 2 fetch row results


  • Please log in to reply
1 reply to this topic

#1 pmzq

pmzq
  • Members
  • PipPip
  • Member
  • 17 posts

Posted 18 April 2006 - 01:30 PM

Hy all,

I'm trying to retrieve multiple rows with the fetch_row() command in a while loop with PHP

This works fine!

Now I want to fetch some more rows with the same command from another database.

After this I want to add the row results from the first fetch to the second fetch so all rows will be in 1 variable like $row.

Does anyone have an idea how this is done is it even possible ?
or should I first join the two tables from different databases and the do the fetch_row() command ?

Hop to hear something soon!

thnx pMzQ,

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 18 April 2006 - 05:21 PM

Interesting... can I ask why? You'd have to be sure that you alias the columns appropriate so that you don't get hash key collisions. In principle, there's no reason that you can't add the second row's column to $row; but how are you going to match them up? Do there share a UID, etc.?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users