Ho delle immagini in una cartella memorizzate in una tabella sql; passandogli la variabile $id=1 dovrebbe visualizzare 6 immagini ma come potete vedere se cliccate http://www.saitem.com/Copy of home.php?id=1 ne visualizza solo 4. Qualcuno mi sa dire per quale motivo me ne salta 2!?!?... sto diventando matto!!! hELP! :boxing:
p.s. alcuni pezzi della pagina mancano perchè se la copiavo tutta il post veniva lungo un kilometro.. e nn fate caso a quella variabile $c... l'avevo usata solo per contare quante volte si incrementava cioè quante volte veniva eseguito il WHILE! tnx!
Questo è il codice:
p.s. alcuni pezzi della pagina mancano perchè se la copiavo tutta il post veniva lungo un kilometro.. e nn fate caso a quella variabile $c... l'avevo usata solo per contare quante volte si incrementava cioè quante volte veniva eseguito il WHILE! tnx!
Questo è il codice:
Codice:
$colname_content = "-1";
if (isset($_GET['id'])) {
$colname_content = $_GET['id'];
}
mysql_select_db($database_saitem, $saitem);
$query_content = sprintf("SELECT structure_name, structure_content, structure_keywords, structure_description FROM `structure` WHERE id = %s", GetSQLValueString($colname_content, "int"));
$content = mysql_query($query_content, $saitem) or die(mysql_error());
$row_content = mysql_fetch_assoc($content);
$totalRows_content = mysql_num_rows($content);
$colname_query_images = "-1";
if (isset($_GET['id'])) {
$colname_query_images = $_GET['id'];
}
mysql_select_db($database_saitem, $saitem);
$query_query_images = sprintf("SELECT * FROM structure_images WHERE structure_id = %s ORDER BY RAND() LIMIT 6", GetSQLValueString($colname_query_images, "int"));
$query_images = mysql_query($query_query_images, $saitem) or die(mysql_error());
$row_query_images = mysql_fetch_assoc($query_images);
$totalRows_query_images = mysql_num_rows($query_images);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="keywords" content="<?php echo $row_content['structure_keywords']; ?>" />
<meta name="description" content="<?php echo $row_content['structure_description']; ?>" />
<title>Saitem S.p.a</title>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="thickbox.js"></script>
<link rel="shortcut icon" href="favicon.png" />
<link rel="icon" href="favicon.png" type="image/png" />
<link rel="stylesheet" href="thickbox.css" type="text/css" media="screen" />
<link href="style.css" rel="stylesheet" type="text/css" />
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
</head>
<body>
<div id="container">
<div id="header">
<div> </div>
<div><img src="img/horizontal_rule.jpg" alt="horizontal rule"/></div>
<div>
<script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','790','height','329','title','Flash Header','src','header/header','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','header/header' ); //end AC code
</script>
<noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="790" height="329" title="Flash Header">
<param name="movie" value="header/header.swf" />
<param name="quality" value="high" />
<embed src="header/header.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="790" height="329"></embed>
</object>
</noscript></div>
</div>
<div id="divbody">
<div id="right">
<div id="imgbox">
<?php $t=400; $i=50; $x=1; $c=1;
do {
if ($x<=2)
{
if ($i<100)
{
?>
<div style="position:absolute;left:<? echo $i;?>%;top:<? echo $t;?>px;width:180px;height:100px;spacing:5px;">
<a href="admin/img/<?php echo $row_query_images['structure_images_name']; ?>" class="thickbox">
<img src="imgsize.php?img=admin/img/<?php echo $row_query_images['structure_images_name']; ?>&w=180&h=100" alt="" border="0" />
</a>
<?php //echo "<!--".$c.$totalRows_query_images."-->"; $c++; ?>
</div>
<?php $i=$i+15; $x++; ?>
<?php
}
//else
//{
//$i=50;
//$t=$t+105;
//}
}
else
{
$x=1;
$i=50;
$t=$t+105;
}
}
while ($row_query_images = mysql_fetch_assoc($query_images));
?>
</div>
</div>
<?php
mysql_free_result($content);
mysql_free_result($query_images);
?>