Some one please help me :(

venradio

Hi,
I have a question,
I have downloaded a script at Free Image Hosting script. I tried to email them but no responds.

I am trying to list the last 5 uploaded images on my index page.
I can't figure out how to do the script for that (php coding) lol
Can some one please help me.

Thanks

1042

venradio wrote:
Hi,
I have a question,
I have downloaded a script at Free Image Hosting script. I tried to email them but no responds.

I am trying to list the last 5 uploaded images on my index page.
I can't figure out how to do the script for that (php coding) lol
Can some one please help me.

Thanks

Here is how;

mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database name") or die(mysql_error());


$query = "SELECT * FROM image_list ORDER BY  mk_date DESC LIMIT 5"; 

$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){
	echo $row['image_name']. " - ". $row['mk_date'];
	echo "<br />";
}

venradio

🆒 thanks for your help 🙂
ok now how do i tell it to display the images ?
right now it only displays image id and the date :o

1042 wrote:

Here is how;

mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database name") or die(mysql_error());


$query = "SELECT * FROM image_list ORDER BY  mk_date DESC LIMIT 5"; 

$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){
	echo $row['image_name']. " - ". $row['mk_date'];
	echo "<br />";
}

mcdsoftware

ok now how do i tell it to display the images ?
right now it only displays image id and the date :o[/QUOTE]

Well, no offense, but the people here are here to help you. Not do it for you. His example displays how to do it pretty well.

Just so you know, the php i added in there is kind of just a direction in what you need to do, I've never actually used that script but I'm sure it works somewhat similar to that.

1042 wrote:

mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database name") or die(mysql_error());


$query = "SELECT * FROM image_list ORDER BY  mk_date DESC LIMIT 5"; 

$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){
	echo $row['image_name']. " - ". $row['mk_date'];
        //modified by me....
        //add in echo '<img src="' . $row['image_path'] . '">';  

	echo "<br />";
}

venradio

No offense taken 🙂 And i know and i thank all who has helped me .

Ok this is what i got so far

$siteurl = "localhost/imagehost/";

mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database name") or die(mysql_error());


$query = "SELECT * FROM image_list ORDER BY  mk_date DESC LIMIT 5";

$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){
    echo $row['image_name']. " - ". $row['mk_date'];
    echo "<br />";
	echo '<td width="100%"><center><img src="' . $scripturl . 'thumbs/' . image_id . '" border="0"></a></center>';

}

I know i did something wrong lol
php and mysql are new to me.

again thanks for your help

venradio

Ok i fixed some of it

$siteurl = "localhost/imagehost/";

mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database name") or die(mysql_error());


$query = "SELECT * FROM image_list ORDER BY  mk_date DESC LIMIT 5";

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
	echo '<td width="100"><center><img src="' . $scripturl . 'thumbs/' . $row['image_name_is'] . '" border="0"></a></center>';
	}
 ?>

now how do i get it to display in a row ?