[SOLVED] picture from mysql text

[tml]

hi i cant get my picture from my database,

my picture are uploaded at billed/1.jpg

and my database have the text in it as billed/1.jpg under id 1

 

its connected

 

 

here's my code

 

$query = mysql_query("SELECT * FROM billed");

while($row = mysql_fetch_assoc($query))

{

    echo <img scr="$row["id"]" . " class="foto"/>"<br/>";

}

?>

 

 

can u tell me whats wrong?

[JasonLewis]

You're echo is incorrect. Take a look.

 

Firstly, you are not opening with any quotes.

 

echo "<img scr="$row["id"]" . " class="foto"/>"";

 

Second, you have scr not src.

 

echo "<img src="$row["id"]" . " class="foto"/>"";

 

Third, you use double quotes again after the =. You cannot do this, because PHP will get confused. You can do it if you escape the quotes with a backslash or you can use single quotes. Or you can break out, which is what it looks like you tried to do. So we'll break out.

 

echo "<img src='" . $row["id"] . "' class="foto"/>"";

 

Notice how I've used single quotes, then broken out with the double quotes so we can use the array variable.

Then I've gone back into the echo and we come to class. Again Instead of double quotes use single quotes.

 

echo "<img src='" . $row["id"] . "' class='foto' />"";

 

Then at the end you have two double quotes, not needed. Simply remove one.

 

echo "<img src='" . $row["id"] . "' class='foto' />";

 

Lastly, ensure that the $row['id'] is actually the proper address to the image and that you do not need to add anything.

[waynew]

Anyway, you should really be uploading them to the filesystem and keeping track of them with the db.

[tml]

thx alot for that explanation did help alot