Inserer données MySQL dans un tableau

if (!empty($ligne[20])) {
     echo "<img src=\"photos/".$ligne[20]."\">"; 
}
else {
     echo "No Photo";
}

<?php

/* loading language file */
function get_translations($lngfile) {

  if (file_exists($lngfile)) {
    $lines = file($lngfile);
    while (list(,$line) = each($lines)) {
      list($key,$val)= explode("=",$line);
          $phrases[$key] = $val;
    }
    return $phrases;
  } else {
    return false;
  }
}
/* translate a string */
function translate($str,$vals="") {

  global $phrases;

  if ($phrases) {
    $p_str = $phrases[$str];
        if ($p_str == "") {
          $p_str = $str;
        }
  } else {
    $p_str = $str;
  }

  if (gettype($vals)=="array") {
    $p_str = sprintf($p_str,$vals[0],$vals[1],$vals[2],$vals[3],$vals[4],$vals[5],$vals[6]);
  }

  return (trim($p_str));
}

$my_max_file_size         = "102400"; # in bytes
$image_max_width        = "800";
$image_max_height        = "800";
$the_path                        = "image/";

$registered_types = array(
                                        "application/x-gzip-compressed"         => ".tar.gz, .tgz",
                                        "application/x-zip-compressed"          => ".zip",
                                        "application/x-tar"                     => ".tar",
                                        "text/plain"                            => ".html, .php, .txt, .inc (etc)",
                                        "image/bmp"                             => ".bmp, .ico",
                                        "image/gif"                             => ".gif",
                                        "image/pjpeg"                           => ".jpg, .jpeg",
                                        "image/jpeg"                            => ".jpg, .jpeg",
                                        "application/x-shockwave-flash"         => ".swf",
                                        "application/msword"                    => ".doc",
                                        "application/vnd.ms-excel"              => ".xls",
                                        "application/octet-stream"              => ".exe, .fla (etc)"
                                        ); 

$allowed_types = array("image/bmp","image/gif","image/pjpeg","image/jpeg");

# --

function form($error=false) {

global $PHP_SELF,$my_max_file_size,$lng;

        if ($error) print $error . "<br><br>";

        print "\n<form ENCTYPE=\"multipart/form-data\"  action=\"upload.php3\" method=\"post\">";
        print "\n<INPUT TYPE=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"" . $my_max_file_size . "\">";
        print "\n<INPUT TYPE=\"hidden\" name=\"task\" value=\"upload\">";
        print "\n<P>".translate("Upload images")."";
        print "\n<BR>NOTE: ".translate("Max file size is")." " . ($my_max_file_size / 1024) . "KB";
         print "\n<br><INPUT NAME=\"the_file\" TYPE=\"file\" SIZE=\"35\"><br>";
        print "\n<input type=\"submit\" Value=\"Upload\">";
        print "\n</form>";

} # END form

# --

if (!ereg("^4",phpversion())) {
        function in_array($needle,$haystack) { # we have this function in PHP4, so for you PHP3 people
                for ($i=0; $i < count($haystack); $i++) {
                        if ($haystack[$i] == $needle) {
                                return true;
                        }
                }
        }
}

# --

function validate_upload($the_file) {

global $my_max_file_size, $image_max_width, $image_max_height,$allowed_types,$the_file_type,$registered_types;

        $start_error = "\n<b>Error:</b>\n<ul>";

        if ($the_file == "none") { # do we even have a file?

                $error .= "\n<li>You did not upload anything!</li>";

        } else { # check if we are allowed to upload this file_type

                if (!in_array($the_file_type,$allowed_types)) {
                        $error .= "\n<li>The file that you uploaded was of a type that is not allowed, you are only
                                                allowed to upload files of the type:\n<ul>";
                        while ($type = current($allowed_types)) {
                                $error .= "\n<li>" . $registered_types[$type] . " (" . $type . ")</li>";
                                next($allowed_types);
                        }
                        $error .= "\n</ul>";
                }

                if (ereg("image",$the_file_type) && (in_array($the_file_type,$allowed_types))) {

                        $size = GetImageSize($the_file);
                        list($foo,$width,$bar,$height) = explode("\"",$size[3]);

                        if ($width > $image_max_width) {
                                $error .= "\n<li>Your image should be no wider than " . $image_max_width . " Pixels</li>";
                        }

                        if ($height > $image_max_height) {
                                $error .= "\n<li>Your image should be no higher than " . $image_max_height . " Pixels</li>";
                        }

                }

                if ($error) {
                        $error = $start_error . $error . "\n</ul>";
                        return $error;
                } else {
                        return false;
                }
        }
} # END validate_upload

# --


function list_files() {

global $the_path;

        $handle = dir($the_path);
        print "\n<b>Uploaded files:</b><br>";
        while ($file = $handle->read()) {
                if (($file != ".") && ($file != "..")) {
                        print "\n" . $file . "<br>";
           }
        }
        print "<hr>";
}

# --

function upload($the_file) {

global $the_path,$the_file_name;

        $error = validate_upload($the_file);
        if ($error) {
                form($error);
        } else { # cool, we can continue
                if (!@copy($the_file, $the_path . "/" . $the_file_name)) {
                        form("\n<b>Something barfed, check the path to and the permissions for the upload directory</b>");
                } else {
                        list_files();
                        form();
                }
        }
} # END upload

# --

############ Start page

print "<html>\n<head>\n<title>Upload example</title>\n</head>\n<body>";
echo("<table width=\"0%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">
  <tr align=\"left\"> 
    <td><font face=verdana size=2>");
switch($task) {
        case 'upload':
                upload($the_file);
        break;
        default:
                form();
}
echo("</font></td>
  </tr>
</table>");
print "\n</body>\n</html>";

?>

<?
// On commence par vérifier si les champs sont vides 
if(empty($prenom) OR empty($email))
   {
   echo '<font color="red">Attention, les champs emai et prénom doivent etre remplis!</font>';
   }
   
// Aucun champ n'est vide, on peut enregistrer dans la table 
else
   {
   $db = mysql_connect('mysqlbox', 'usk', 'password');
   mysql_select_db('usk',$db);

   $sql = "INSERT INTO infos_tbl VALUES('','$pseudo','$prenom','$age','$email','$icq','$location','$pays','$type','$provider','$processeur','$ram','$cg','$son','$souri','$moniteur','$favmap','$favweap','$os','$reso','$sensi','$photo')";

   mysql_query($sql) or die('erreur SQL!'.$sql.'<br>'.mysql_error());

   echo 'C est noté gamin!.';

   mysql_close();
   }
?>

<? 
   $db = mysql_connect('mysqlbox', 'usk', 'merci fearless');
   mysql_select_db('usk',$db);
   if (empty($id)) { 
     $sql = "SELECT id, pseudo FROM infos_tbl ORDER BY pseudo ASC"; 
     $result = mysql_query($sql); 
     $NbRep = mysql_num_rows($result); 
     if ($NbRep != 0) { 
          while ($ligne = mysql_fetch_array($result)) { 
               echo "<a href=\"membres.php?id=".$ligne[0]."\">".$ligne[1]."</a><br>"; 
          } 
     } 
     else { 
          echo "Il n'y a pas de membres dans la table."; 
	  mysql_close();
     } 
} 
?>