Extracting info from rows?

magwen

I have been using PHP for a few months now and am having following problem.

This is an example of a table in my database.

User_id Prod_id

1 1
2 1
3 2
4 3

From a page in the website, I select a prod_id, another table is then created where each user_id is listed alongside the product_id i.e. in the above case, I would select product_id 1 and the list would be output as such:

The following persons are using the (product name)

User_id User_name(drawn from another table in the database)
1

2

I have attempted using loops (while and for), but am continually getting all of the user_id's listed for all of the products.

Any ideas.

Thanks

leatherback

Hi there, you will need to use a join for your query:

$query = "
select * from PRODUCTS_TABLE
left join PRODUCTS_TO_USER_TABLE on PRODUCTSTABLE.ID = PRODUCTS_TO_USER_TABLE.PRODUCTID
left join USERTABLE on PRODUCTS_TO_USER_TABLE.USERID = USERTABLE.ID"

replace all the caps with relevant table/fieldnames

magwen

leatherback thank you,

the join does what I want it to do when I run the query through phpmyadmin, but now my problem is extracting data from the join to a table in php.

I am obviously using the incorrect loop, and will work at it until I get the output that I am looking for.

Thanks once again.

leatherback

Hi,

afer you do:
$result = mysql_query($query);

if($result)
  {
  while($row = mysql_fetch_array($result))
    {
    echo $row['SomeColum'];
    // or
    $MyVar = $row['SomeColum'];
    }

echo $MyVar;

magwen

Leatherback, your help is appreciated.

I have solved the problem, and it is great to know that there are experienced coders out there who are willing to assist the newbies with the problems that they may be experiencing.