filename in HTML/PHP

Paragon

I have an image name in the database I want to use it to show sorta a poster image.
I have a database connection and all that just wondering if this will work. Actualy another way because I know this doesnt work.

$image = $row["image"];
echo "<img border=0 src=images/$image>";

would that work?

_e_r_k

$image = $row["image"]; 
echo "<img border=\"0\" src=\"images/".$image."\"/>";

This is how I would do it..

// [e]r!k

Paragon

That didnt seem to work thanks though I didnt notice those back slashs did that.

http://myurl.com/images/

thats all I get.

tekky

oke so show us your query and the db code....
and maybe try doing

echo '<pre>'.print_r($row).'</pre>'; //bet your query isnt returning what you think ;)

Paragon

   mysql_connect("$dbhost", "$dbusername", "$dbpassword") or
       die("could not connect");
   mysql_select_db("$dbname");
   $result = mysql_query("SELECT id, image, news, event FROM newscontent ORDER BY id DESC LIMIT 1");


   while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
   $id = $row["id"];
   $image = $row["image"];
   $username = "Shanksta";
   $news = $row['news'];
   $date = date("n-j-Y g:i A", strtotime($row["event"]));

echo "Poster : $username<BR>";
echo "<img border=\"0\" src=\"images/".$image."\"/>";
echo "$news<BR>";
echo "Date Posted : $date<BR>";
echo "<BR>";

echo "		<a href=\"newscontent.php?id=$id&action=edit\"><img border=\"0\" src=\"edit.gif\" width=\"15\" height=\"15\" alt=\"Modify news\"></a>&nbsp;";
   }
   mysql_free_result($result);

 echo "<BR>";

tekky

I'm sure this aint it but I never liked < /> tags 🙂

try doing this

echo "img border=0 src='images/$image'>";

note: I only removed the opening tag so it gets treated as a text line and not a tag to trouble shoot, obviously its returning a result... cause its doing the while() but for some reason the echo isnt working right.... is image in the dbase populated? 🙂

also, may want go through and do all the $row[" "]'s the same... you have atleast one $row[' '] I would suggest doing em all with single ticks like $row['news'] (not that this will fix anything but it is better to do it all one way and the best way is with the ' not " if using static text

Paragon

DOH!

I put the picture file name in the wrong row. I put it in the first row instead of the newest. Thanks for your help I got it.