[SOLVED] Code that should work, but doesn't

[mikesta707]

Hey, I can't figure out what is wrong with my code. I have tried a bunch of ways to make the code work, but it doesn't.

 

here is the code:

 

Code:

<?
$sql = mysql_query("SELECT fid FROM facebook WHERE uid='$user_id'");

if (!$sql) {//test if SQL was valid
echo "There was an error";
print mysql_error();
exit();
}

$array = mysql_fetch_array($sql, MYSQL_ASSOC);//mysql_assoc because the array doesn't function properly without it

$i = 1;// array entry number

echo "<h2><fb:name uid='$user_id' possessive='true' useyou='false' /> Stoner Friends</h2><br>";//output. you can ignore this

echo sizeof($array) . "<br>";//just to test how big the array is is.

foreach ($array as $fid) {//my array loop

echo "$i: <fb:name uid='$fid' /><br>";



$i++;//update entry number
}
?>

 

by the way the stuff that looks like <fb:xxxx /> is FBML, the markup language used for facebook apps

 

$user_id is set in my config file, and I have even tried making it global. the variable works in every other page i've used it for.

I have tried an @ infront of mysql_fetch_array.

What should output is:

1. friend 1

2. friend 2

3. friend 3

 

What it is outputting is:

1. friend 1

 

It gets the right info for the first entry, but doesn't output the rest of the information on my table. I have no clue why. I have tried different types of loops, different variable combination's, and all sorts of stuff. the SQL validity check runs true, so I don't think the SQL is wrong, plus it returns the first row correctly. I really have no clue why this doesn't work at all.

 

Can anyone else make any sense of my problem? Thanks a lot in advance if anyone can help me or lead me in the right direction.

[mikesta707]

nevermind i fixed it

[fenway]

nevermind i fixed it

Please share the details of your solution before marking it "solved".