LIMIT DATA AFTER SELECTION

[kiwi2]

CODE:
$query = "SELECT * FROM name ORDER BY RAND() LIMIT 0, 4";
$result = mysql_query($query);
while ($row = mysql_fetch object($query) )
{
$image = $row->image;
?>
<img src='<?php echo "$image"; ?>' />
<?php
}
I need to select all 8 values but only echo the first 4, the next 4 values must be availiable to the code but must not show in the echo statement how can this be achieved.

[Roger_Ramjet]

1. Read Sxooter's sticky on why ORDER BY RAND() is a bad thing.

2. Change your query to LIMIT 0,8

3. To only display 4 of the 8 then use a loop counter

   $i = 0;
   for ( $i=0; $i<4; $i++ ) {
      $row = mysql_fetch object($query);
      echo;
   }
   

[kiwi2]

I am building a virtual card game, once the data is randomly selected 4 images: ie players cards, these are displayed, the next 4 cards are the "Computer's" hand, The balance of the random array must also figure into the equation, since further cards may be drawn to improve an initial hand.

I have structured it by using two tables A- To store card image name/value pairs and B- To capture the data from table A so that the hand dealt to player and computer can be manipulated, ie an update would be performed when new cards are drawn, and old cards are deleted from the shuffle. I am not sure that this is the right way to go about it. Initially I wanted to use an assoc array of image name/value pairs then once randomised these values would be stored in said table B. B's columns are id, game_id, yourcards, yourscore, computercards, computersscore, extracards, ip. ip deatails are only used to access previous scores, game _id will be used to track the game, no SESSIONS can be used since the cache has to be cleared using a header to insure that a new game is displayed by the browser when "START OVER" is selected.

Any tips would be much *&^%$#@ thanks!!!