从图像上传器显示图像

Question

im trying to display image from database by calling filename of the image. here's my code.

$fname=$row['user'];
$query1=mysql_query("select * from user where username = '$fname'");

$q_pix =mysql_fetch_array($query1);
$id=$row['id'];
$date=$row['date'];
$message=$row['message'];
$lugar=$row['location'];

<img src=".$row['location']." height=\"120\" width=\"120\">

Undefined index: location.

Answer 1

First of all print both the variables $row and $q_pix and check in which you have your location field.

Try to use $q_pix variable in img src if it has -

<img src=".$q_pix['location']." height=\"120\" width=\"120\">