Grazie per la risposta, ti posto tutto lo script:
Codice PHP:
<?
include("config.php");
include("image.php");
//header
echo "<html>\n"
."<head>\n"
."<title>$site_name</title>\n"
."<meta http-equiv=\"Content-Type\" content=\"text/html;\">\n"
."<link rel=\"stylesheet\" href=\"style.css\" type=\"text/css\">\n"
."</head>\n"
."<body>\n"
."<table align=\"center\" width =\"500\" cellpadding=\"5\" cellspacing=\"0\" border=\"0\"><tr><td align=\"center\">\n";
//connessione al database
mysql_connect($mysql_host, $mysql_user, $mysql_password);
@mysql_select_db($mysql_db_name) or die ("Unable to select database");
$table_name = "prodotti";
$action_scheda= "scheda.php";
switch($_REQUEST['op']) {
}
list_schede();
//footer
/////////////////////
///// functions /////
/////////////////////
function list_schede() {
global $admin_vol_schedefilms_per_page, $img_path, $img_width, $img_height, $table_name, $form_action_page, $action_scheda, $action_move;
echo "
";
echo "<div align=\"center\" class=\"gendefault\">[b]";
$result_main = mysql_query("SELECT count(*) AS Total FROM ".$table_name);
if (!$result_main) {Errors("Errore durante la ricerca: ".mysql_error(), 1);}
list($total_rows) = mysql_fetch_row($result_main);
if ($total_rows == 0) echo "[/b]</div>
Nessun record trovato
";
else {
$result = mysql_query("SELECT ".$table_name.".* "
."FROM ".$table_name." "
."WHERE cat = 'Cosmetici';");
"<tr>\n"
."</tr>\n";
$count = 0;
while ($record = mysql_fetch_array($result)) {
if ($count % 2 == 0) $rowclass = "row1";
else $rowclass = "row2";
echo "<tr class=\"".$rowclass."\">\n"
." <td align=\"center\"><a href=\"".$action_scheda."?ID_Scheda=".$record['ID_Scheda']."\">".($record['Immagine'] != "" ? "<img src=\"".$img_path.$record['Immagine']."\" width=\"".($img_width / 4)."\" height=\"".($img_height / 7)."\" border=\"0\">" : "")."</td> <tr>
</tr>"
." <td align=\"center\" class = \"gendefault2\" > ".stripslashes($record['Titolo'])."</td><tr>
</tr>"
." <td align=\"center\">".stripslashes($record['Testo'])."</td><tr>
</tr>"
." <td align=\"center\">".stripslashes($record['confezione'])."</td><tr>
</tr>";
echo "<td align=\"center\"><a href=\"".$action_scheda."?ID_Scheda=".$record['ID_Scheda']."\"><img src=\"includes/languages/english/images/buttons/button_details.gif\" border = 0 /></td>\n";
"</tr>\n";
$count++;
}
echo "</table>";
}
}
?>