include('include/conn.php'); $sql = "select * from config "; $printcon = mysql_query($sql,$connect) or die("Query failed".mysql_error()); $rowp = mysql_fetch_row($printcon); $pagetitle = $rowp[1]; $pagekey = $rowp[2]; $description = $rowp[3]; $footer = $rowp[4]; $logou = $rowp[5]; $ad = $rowp[6]; $sql = "select * from upcproduct order by upc desc limit 7"; $printcon = mysql_query($sql,$connect) or die("Query failed".mysql_error()); $i=1; while($rowp = mysql_fetch_row($printcon)){ if($i==6){ break; } if($i==1){ $name1 = $rowp[2]; $photo1 = $rowp[4]; $disc1 = $rowp[5]; } if($i==2){ $name2 = $rowp[2]; $photo2 = $rowp[4]; $disc2 = $rowp[5]; } if($i==3){ $name3 = $rowp[2]; $photo3 = $rowp[4]; $disc3 = $rowp[5]; } if($i==4){ $name4 = $rowp[2]; $photo4 = $rowp[4]; $disc4 = $rowp[5]; } if($i==5){ $name5 = $rowp[2]; $photo5 = $rowp[4]; $disc5 = $rowp[5]; } $i++; } mysql_close($connect); ?>