[RESOLVED] Fetch Array within While Loop

phpstatus

Ok I hope I can make this clear.

I'm trying to program a friend list for my member community website. I have 2 seperate tables.

First table: Lists all the friends name's

Second table: This table is for image names that belong to each user "blah.jpg"

So this is the code I have to display the friends and their images on a member's page...

<?
$listfriends = mysql_query("SELECT * FROM friend_list WHERE uname = '$u'");

while($flist_row = mysql_fetch_array($listfriends)){
$fid = $flist_row['f_name'];

$fphoto_query .= "SELECT img_path FROM images";
$fphoto_query .= " WHERE uname = '$fid' AND main = '1'";
$fphoto_result = mysql_query("$fphoto_query");

$fphoto_name = mysql_fetch_array($fphoto_result);
$fphoto = $fphoto_name["img_path"];

print "<img src=photos/thumbs/small/s_$fphoto> <a href=profile.php?u=$fid>$fid</a> ";
}
?>

I know the code is kinda messy. I have yet to clean it up, but I would like to get it working first.

I get this error message on the member page...

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/blah/public_html/blah/inc/blah.inc on line 553

Any ideas??

Houdini

Where did you connec to to the MySQL server and where did you select the database? That would be one reason the query failed, you have to first connect then select the database that has the tables you are referring to.

Also you might want to elminate one line of code by combining two to have the below,

$fphoto_query = "SELECT img_path FROM images WHERE uname='$fid' AND main = '1'";

phpstatus

actually the server and database connection is fine.

thats done at the top of the script.

The code works for getting the friend names, and it gets the first image, but for some reason it doesnt loop to get any other images.

mourisj

You do not need to nest 2 queries to achieve this. You can use a query that looks (roughly) like this:

select fl.field1, ... , i.field1, i.image_path
from friend_list fl, images i
where fl.u_name = $u
and fl.u_name = i.u_name
and i.main = '1'

You execute this query and loop through it and you hopefully won't run into trouble.

I hope you understand what I mean, with the unfinished query. Unfortunately I don't have the time to work this out more in detail (and I never manage to write those queries with the JOIN syntax some people prefer here).

HTH

JJ Mouris

phpstatus

thanks...im going to try that out and see if it works for me. appreciate it.

phpstatus

<?
$list_friends = mysql_query("SELECT fl.f_name , i.img_path
FROM friend_list fl, images i WHERE fl.uname = '$u' AND i.uname = '$fid' AND i.main = '1'");

while($flist_row = mysql_fetch_array($list_friends)){
$fid = $flist_row['fl.f_name'];
$f_photo = $flist_row['i.img_path'];

print "<img src=photos/thumbs/small/s_$f_photo> <a href=profile.php?u=$fid>$fid</a> ";
}
?>

I tried this but it doesnt work. The reason why is kinda obvious.

What I'm trying to achieve is the following;

I want to run a query to find all of Member A's friends in the "friend_list" table.
With each loop $fid will = each of Member A's friends. With each loop I want a seperate query done in the "images" table with each of Member A's friends.

Basically "friend_list" is a table that has the username (uname) of a member and the name of the friend on his friend list (f_name)

With each loop I wish to take the value of f_name (a friend's username) and input it into a query for the image table.

The image table is just a list of usernames (uname) and a path to their image (img_path).

So I'd like all the username's of each friend and their image to show on Member A's page.

Sorry if I wasn't clear. Does anyone have any idea?