immagini random da tabella sql

  • Creatore Discussione Creatore Discussione KicKFLiP
  • Data di inizio Data di inizio

KicKFLiP

Nuovo Utente
4 Ott 2007
15
0
0
Pescara
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:
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>&nbsp;</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']; ?>&amp;w=180&amp;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);
?>
 
tutto ok ho risolto :mavieni:!! grazie lo stesso!!! se qualcuno nn ha nulla da fare e vuole vedere come... ho fatto così...

Codice:
<?php require_once('Connections/saitem.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$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>&nbsp;</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;
					do { 
						if (($x<=2) && ($i<65))	
							{
									
?>

<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']; ?>&amp;w=180&amp;h=100" alt="" border="0" />
    </a>
<?php //echo "<!--".$c.$totalRows_query_images."-->"; $c++; ?>

</div>
<?php $i=$i+15; $x++; ?>


<?php 				
							} 
						else
							{
							
?>
<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']; ?>&amp;w=180&amp;h=100" alt="" border="0" />
    </a>
<?php //echo "<!--".$c.$totalRows_query_images."-->"; $c++; ?>

</div>														
<?php
							
						$x=1;
							$i=50;
							$t=$t+105;	
							
							
							} 
										
						
						
						} 
					while ($row_query_images = mysql_fetch_assoc($query_images)); 
?>
          
          
          
          </div>
		</div>
		<div id="left">
			<div id="default">
                <?php if ($totalRows_content > 0) { // Show if recordset not empty ?>
                <?php echo nl2br($row_content['structure_content']); ?>
                <?php } // Show if recordset not empty ?>
</div>
		</div>
	</div>

	<div id="footer">
		<div><img src="img/horizontal_rule_2.jpg" alt="horizontal rule" /></div>
		<div>
			<div id="elem1"><img src="img/elem1.jpg" align="right" alt=""/></div>
			<div id="nav"><br />
		    <a href="<?php echo $_SERVER['PHP_SELF']."?id=1"; ?>">Index</a> <a href="<?php echo $_SERVER['PHP_SELF']."?id=2"; ?>">Storia</a> <a href="<?php echo $_SERVER['PHP_SELF']."?id=3"; ?>">Struttura organizzativa</a> <a href="opere.php">Opere</a> <a href="<?php echo $_SERVER['PHP_SELF']."?id=5"; ?>"> Certificazioni</a> <a href="<?php echo $_SERVER['PHP_SELF']."?id=6"; ?>">Contatti</a></div>
		</div>
		<div><img src="img/horizontal_rule.jpg" alt="horizontal rule" /></div>
	</div>

</div>
	

</body>
</html>
<?php
mysql_free_result($content);

mysql_free_result($query_images);
?>
 
Perfetto KicKFLiP, il contributo sarà sicuramente utile :byebye:
 

Discussioni simili