display last uploads

[jd57]

Hi Everyone

I would like to change this script to display the last uploads, presently it works fine in text format, but want to change to display images.
Can you help me change this code from " . $row['Bloom_Name']." to something like this:

http://www.mysite/myfolder/<?php echo $result['Bloom_Name'];?>.jpg in a table of 5 cells.

mysql_connect("localhost", "internb7_xxxx", "xxxx") or die(mysql_error());

mysql_select_db("xxxx_xxx") or die(mysql_error());

$sql = "SELECT * FROM `ihsreg` ORDER BY `id` DESC LIMIT 40";

$results = mysql_query($sql);
while(($row = mysql_fetch_assoc($results)) !== false){	

echo $row['id'] . " " . $row['Bloom_Name']."<br>";

}

?></font></b>

[etully]

$sql = "SELECT * FROM `ihsreg` ORDER BY `id` DESC LIMIT 40";
$results = mysql_query($sql);

print "<table>";
$column = 1;
while(($row = mysql_fetch_assoc($results)) !== false) {    

	if ($column==1) { print "<tr>"; }
	print "<td>";
	print "<img src=\"http://www.mysite/myfolder/"; 
	echo $row['Bloom_Name']; 
	print ".jpg\">";
	print "</td>";
	if ($column==5) { print "</tr>"; $column=0; }
$column++;
} 
print "</table>";

[jd57]

Hi

Thank you, it's working fine, two more things I would like to add that is if I'm not asking to much.
How can I display the image to a fixed size 150 x 150.
can the name of the image be displayed underneath the image without the extension.

[etully]

Very easy:

 $sql = "SELECT * FROM `ihsreg` ORDER BY `id` DESC LIMIT 40";
$results = mysql_query($sql);

print "<table>";
$column = 1;
while(($row = mysql_fetch_assoc($results)) !== false) {    

    if ($column==1) { print "<tr>"; }
    print "<td>";
    print "<img src=\"http://www.mysite/myfolder/";
    echo $row['Bloom_Name'];
    print ".jpg\" width=150 height=150><br>";
    echo $row['Bloom_Name'];
    print "</td>";
    if ($column==5) { print "</tr>"; $column=0; }
$column++;
}
print "</table>"; 

[jd57]

Hi 🙂

It's working great, I would like to add a link to the individual image using javascript, to open a window to cvdata1.php

is this ok for the script?

<script type="text/javascript">
function open_win(img){
window.open("cvdata1.php?search="+img);
</script>

and a link:

http://www.mysite/myfolder/cvdata1.php?search=Bloom_Name

<?PHP

mysql_connect("localhost", "xxxx_xxx", "xxxxx") or die(mysql_error());

mysql_select_db("xxxx_xxxxx") or die(mysql_error());

$sql = "SELECT * FROM `seedling` ORDER BY `id` DESC LIMIT 40";
$results = mysql_query($sql);

print "<table>";
$column = 1;
while(($row = mysql_fetch_assoc($results)) !== false) {    

if ($column==1) { print "<tr>"; }
print "<td>";
print "<img src=\"http://www.mysite/myfoòder/"; 
echo $row['Bloom_Name']; 
    print ".jpg\" width=150 height=150><br>";
    echo $row['Bloom_Name']; 
    print "</td>";
if ($column==5) { print "</tr>"; $column=0; }
$column++;
} 
print "</table>";

?>