random image not found?

[benracer]

Hi,

On my site the homepage contains random items that are output through a loop. Every now and agen a couple of the images are not shown. Any ideas?

Thanks
Ben

[homer09001]

just a guess but do the images exist?

[benracer]

Yes all the images exist as they are also on a large list of all my items which display fine, it could be something to do with RAND?

[homer09001]

can you post your code and i will have a play on my server

[benracer]

 <?php 
$sql="SELECT * from items WHERE stock='instock' AND name LIKE '%OFFER%' ORDER BY rand() LIMIT 12"; 
$result=mysql_query($sql); 
echo "<table><tr>";

$i=13; 
while($rows=mysql_fetch_array($result)){ 
$i = $i - 1;
    if($i % 6 == 0) 
    { 
echo "</tr><tr>";
 } ?>
                  <td><table>
                  <tr>
                  <td><img src="<? echo $rows['image']; ?>" /></td>
                      </tr>
                  </table></td>
                  <td><?php } ?>
                  </td>
                </tr>
              </table>

took a lot out so sorry if there are any html errors 😃

[homer09001]

just a thought, but does your query need to contain Rand()?

also you do know when your outputing each row in the table your creating a new table?
so if you have 3 items the script is creating 3 tables?