mysql_connect($hostname,$username,$password) OR DIE( "Не могу создать соединение " );

mysql_select_db($dbName) or die(mysql_error());

$image_id = max( 0 , intval($_GET['image_id']));
$res = mysql_query('SELECT $foto FROM '.$userstable.' WHERE user_id = '.$image_id);
if (!$res || mysql_num_rows($res) ==  0 ) exit;
$row = mysql_fetch_row($res);
header( "Content-Type: image/jpeg" );
echo $row[ 0 ];

mysql_close();

mysql_connect($hostname,$username,$password) OR DIE( "Не могу создать соединение " );

mysql_select_db($dbName) or die(mysql_error());
$query =  "SELECT * FROM $userstable" ;
$res = mysql_query($query) or die(mysql_error());
$number = mysql_num_rows($res);

if ($number ==  0 ) {
 echo  "No records" ;
} else {
 while ($row=mysql_fetch_array($res)) {
 header ( "Content-type: image/gif" );
 echo  "А это его фото: <img src=\" image.php?image_id= ".$row['user_id']." \ ">" ;
 echo  "<BR><BR>" ;
 }
  echo  "<CENTER><P>Всего в нашей базе $number человек.<BR><BR>" ;
  echo  "</CENTER>" ;
}

mysql_close();

mysql_connect($hostname,$username,$password) OR DIE( "Не могу создать соединение " );
mysql_select_db($dbName) or die(mysql_error());
error_reporting(E_ALL);
ini_set('display_errors', 'On');
$query =  "SELECT * FROM $userstable" ;
$res = mysql_query($query) or die(mysql_error());
$number = mysql_num_rows($res);

if ($number ==  0 ) {
 echo  "No records" ;
} else {
 while ($row=mysql_fetch_array($res)) {
 echo  "А это его фото: <img src=\" image.php?image_id= ".$row['user_id']." \ ">" ;
 echo  "<BR><BR>" ;
 }
  echo  "<CENTER><P>Всего в нашей базе $number человек.<BR><BR>" ;
  echo  "</CENTER>" ;
}
mysql_close();

$res = mysql_query( "SELECT $foto FROM " .$userstable. " WHERE user_id = " .$image_id);

<?
include_once("db.php");

$res=mysql_query("SELECT * FROM $userstable")
         or die("SQL ERROR in line ".__LINE__.", function mysql_query");
  $image=mysql_result($res,  0 ,  1 ); 
  header("Content-type: image/gif");
  echo $image;

mysql_close();
?>

<?php
include_once("db/db.php");

$query = "SELECT * FROM $userstable";
$res = mysql_query($query) or die(mysql_error());
$number = mysql_num_rows($res);
if ($number ==  0 ) {
 echo "No records";
} else {
 while ($row=mysql_fetch_array($res)) {
 echo "Au-Pair ".$row['name']." aus ".$row['country'].".<BR>";
 echo "<BR><BR>";
 }
}

$res=mysql_query("SELECT * FROM $userstable")
         or die("SQL ERROR in line ".__LINE__.", function mysql_query");
  $image=mysql_result($res,  0 ,  29 ); 
  header("Content-type: image/gif");
  echo $image;

echo "<CENTER><P>Es sind insgesamt $number Au-Pair in unserer Datenbank.<BR><BR>";
echo "</CENTER>";

mysql_close();
?>

$image=mysql_result($res, $row['user_id'],  29 ); 

echo "Au-Pair ".$row['name']." aus ".$row['country'].".<BR>";

<img src="">

<?php
include_once("db/db.php");

$res=mysql_query("SELECT * FROM $userstable")
         or die("SQL ERROR in line ".__LINE__.", function mysql_query");
  $image=mysql_result($res,  0 ,  29 ); 
  header("Content-type: image/gif");
  echo $image;

mysql_close();
?>

echo "<img src="list.php">";

$res=mysql_query("SELECT * FROM $userstable")
         or die("SQL ERROR in line ".__LINE__.", function mysql_query");
  $image=mysql_result($res,  [b]0 ,  29 ); < -- вот это мешает как я понимаю, ведь так и берётся 0, 29 :( чё с ним делать? убрал - вообще не выводит.[/b]
 
  header("Content-type: image/gif");
  echo $image;
exit;

<?php
include_once("db/db.php");
$res=mysql_query("SELECT * FROM $userstable")
         or die("SQL ERROR in line ".__LINE__.", function mysql_query");
for ($image_id =  0 ; $image_id <= $user_id; $image_id++) {
  $image=mysql_result($res, $image_id,  29 );
  header("Content-type: image/gif");
  echo $image;
exit;
}
mysql_close();
?>

for ($image_id =  0 ; $image_id <= 'user_id'; $image_id++) {

$res=mysql_query("SELECT * FROM $userstable WHERE $image_id='user_id'");

$image=mysql_result($res, $image_id,  29 );