query problems

[yguyjosh]

So for some, probably very obvious reason, this is only giving me the first result from the database even though there are more that meet the criteria.  Could someone please tell me what I'm doing wrong.  I know it must be something simple but I'm totally stumped. 

Code: [Select]

[php]
$query1 = "SELECT interest
FROM interests
WHERE profileid = '{$profileid}'
";
$result1 = mysql_query($query1, $connection) or die(mysql_error());
$savedinterests = mysql_fetch_assoc($result1);
print_r($savedinterests);
[/php]

[jj-dr]

Try removing the curly brackets in this query:

PHP Code: [Select]

WHERE profileid = '{$profileid}'

It should be

PHP Code: [Select]

 WHERE profileid = '$profileid'


If that doesn't do the trick I would add a WHILE loop.

PHP Code: [Select]


$query1 =    "SELECT interest
         FROM interests
         WHERE profileid = '{$profileid}'
         ";
$result1 = mysql_query($query1, $connection) or die(mysql_error());

WHILE ($savedinterests = mysql_fetch_assoc($result1)){
print $savedinterests;
}