Selecting one field

admin

Administrator
Staff member
i AM SELECTING IMAGES FROM A DATA BASE AND HERES MY CODE
//image path
$the_path=\"images\";
$sql =\"SELECT * FROM $db_table ORDER BY imgid\";

$handler=@mysql_connect($db_server,$db_username,$db_passwort);
@mysql_select_db($db_database,$handler);

$result=@mysql_query($sql,$handler);

while(($row=mysql_fetch_array($result)))
{
$v=$row[\"imgid\"];
$name= $row[\"imgname\"];
$filename=\"$the_path/$name\";
}
//Displaying the image...
echo \"<img src=http://www.phpbuilder.com/board/archive/index.php/$filename><br>\";

?>

i WOULD LIKE TO BE ABLE TO JUST DISPLAY ONE IMAGE AT A TIME. HOW WOULD I DO THAT?
 
Back
Top