array

[skyloon]

why cannot show the picture using this method?
got another way to do it?
thanks...

<? 
mysql_select_db($dbname, $link);
$result=mysql_query("select * from user_detail where nickname = '$name'") ;
$number_of_array = mysql_num_rows($result);
while ($number_of_array = mysql_fetch_array($result)){
echo"<img src=\"./image/$number_of_array[image_name]\">";
}				
?>

[Mordecai]

What doesn't work about that?

I'd advise concatenating the variable with the string, but the result should be the same (just faster).

[skyloon]

this can work:
echo"$number_of_array[image_name]";

this can't work:
echo"<img src=\"./image/$number_of_array[image_name]\">";

don't know why???😕

[TheDefender]

This is what Mordecai was referring to... (I would also recommend you single-quote your array index name too) Keep in mind, this will only work if your path is correct.......

<?  

mysql_select_db($dbname, $link); 
$result=mysql_query("select * from user_detail where nickname = '$name'") ; 
$number_of_array = mysql_num_rows($result); 
while ($number_of_array = mysql_fetch_array($result)){ 
echo"<img src=\"./image/".$number_of_array['image_name']."\">"; 
}                 

?> 

[skyloon]

i've tried all the possible ways to do that, but can't....

it just shows this when i check the properties of the picture, without the "william.jpg"

http://localhost/image/

[TheDefender]

Sorry, don't know what I was thinking when I missed where you used the same variable name for the num_rows and the while loop... Try this instead.

<?   

mysql_select_db($dbname, $link);  

$result=mysql_query("select * from user_detail where nickname = '$name'") ;  

$count_of_array = mysql_num_rows($result);  

while ($number_of_array = mysql_fetch_array($result)){  

echo"<img src=\"./image/".$number_of_array['image_name']."\">";  

}                  

?>