Code:
$query = "select filename from gallery where user_id=2 and djp_id > 0 ";
$result = mysql_query($query) or die("Unable to process mysql statement. See below for details.
".mysql_error());
if ($row=mysql_fetch_array($result)) {
echo $row ["filename"] . "
";
}
else {
echo "No pics set from profile" . "
";
}
Now when I run the query in mysql admin I get more than one result.
Yet the php part on my website only displays one result and I cant figure out why :-?
any help?