Calling data from MySQL to echo images

Anon

I've been trying to use data from a database to echo images.
I thought that if I used the PHP page to connect to the database I could then do something like the below

if ($user == "user") {echo "<img src=\"http://www.whatever/images/whatever.gif\">"; }

But it doesn't work, any ideas on why, and how to solve it would be very welcoem as its driving me crazy!

Thanks!

Anon

the following should work to compare username input to a table of usernames. when a match is found your picture is displayed. Hope it helps.
josh

mysql_connect(localhost,root,root);
$que=mysql_query("select username from database.table");
$row=mysql_fetch_row($que);
$n=mysql_num_rows($que);

for($i=0;$i<$n;$i++)
{
if($username == $row[0]) {
echo("<img src=\"dir/photo.jpg\">");
}
$row=mysql_fetch_row($que);
}

Anon

Nope, its doesn't work at all, I fiddled about with it to get it working, but it doesn't display any images.

Going back to the code I was using.

What I'm actually trying to do is eventually have a pull down menu on an admin page, and depending on what is selected from that, display a different image, so I was mucking about with my news file to try and get this to work...

<?php

$db = mysql_connect("mysqlhost", "username", "password");

mysql_select_db("database_name",$db);

$result = mysql_query("SELECT * FROM table_name",$db);

<?php

do {

printf ("

<tr><td>%s   %s</td></tr>
<tr><td><font size=4>%s</font></td></tr>\n",

$myrow["dati"], $myrow["user"], $myrow["news"]);

if ($user == "James") {echo "<img src=\"http://www.site.co.uk/war/images/testpic.gif\">"; }

} while ($myrow = mysql_fetch_array($result));

echo "</table>\n";

</body>

But, it doesn't work!
I've tried stripping it down to
<?php
{ echo ($user); }
?>

but it still doesn't work, any ideas?

Thanks

Anon

Nowhere in your code did you set the variable $user to any value.

Anon

Thats because its meant to be reading from the MySQL db...
Where I set $user.

This whole thing is for a roster.

I want to have have three columns, name, e-mail, and a picture in the other. The picture I want to be able to set using a pull down menu. To get anywhere close to this goal I need to be able to create images as a result of differing user names.

Thanks

Anon

I just figured it out after two weeks!

I'm just going to echo (this works) the SQL as a %c, but the %c entered will be <img src = "">

Not, just got to work out how to autoset this from an option pull down!