Hi,
I KNOW this has been asked many times before, but usually not fully answered here that I can find, please help me. I am trying to post images shown as a result of a users' search. I have the MySQL DB done, but cannot manage to show images. This is what I have to date, modified from a couple of tutorials.
<html>
<body>
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("picturec_caught",$db);
$result = mysql_query("SELECT * FROM Images1",$db);
echo "<table border=1>\n";
echo "<tr><td>ID</td><td>Title</tr></td><td>Date</td><td>Keywords</td><td>Notes</td><td>Image\n";
while ($myrow = mysql_fetch_row($result)) {
printf("<tr>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
</tr>\n",
$myrow[0], $myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5]);}
echo "</table>\n";
?>
</body>
</html>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This makes the table I want, except for image in final column.
[url]http://www.picturechaser.com/Search/index.php[/url]
Once I get the darn images to show, I am hoping to link them to other pages with full-sized images. I know there are many scripts that attempt this, but most seem not right for my needs, so I decided to learn how to do it myself. Any ideas?
