I have a set of mysql results I want to create a new table row with!

Wed, 02 Feb 2011 12:50:38 -0700

This is probely a realy easy answer but i have been serching for a few days for an answer but unsucessfuly so I have posted for an answer! The quicker the better and thanks for any reading!

Problem! I have a while loop that loops through mysql database table and i have a list of numbers and for every say 5 or so results I want to put them on a new line on a table!

Code so far:

<table>
<tr>
<?
  $q4 = "SELECT * FROM tblnewgameitem WHERE game_id = $row2[game_id] ORDER BY 'game_number' ";
       $r4 = mysql_query($q4);
	
         while($row3 = mysql_fetch_array($r4))
	   {
	      
	   ?>
	     <td>
	     <?
	       if($row3['user_email'] == "")
	       { 
	       ?> 
	        
	          
	           <form action="" method="POST">
	          <input type="hidden" name="game_id" value="<?echo $row2['game_id'];?>">
	          <input type="hidden" name="num" value="<? echo $row3['game_number']; ?>">
                    <input type="submit" value="<?echo $row3['game_number'];?>" name="submit">
		</form>
	        
	      
	      
                   		      
	       <?
	  }
	       else
	       {
	      echo " ".$row3['game_number']." ";
	       }
	
	
	       ?>
	       </td>
	       <?
	   }
	
	   ?>
	   </tr>
	   </table>

It prints out in one row but i want ever so many rows to print out on a new row!

I have tryed for loops etc and nothing works I came close onece but the top line the last number was put on the next line which is no good for me!

Example print out:

1 2 3 4 5 6 7 8 9 10

Example of what I want it to do:

1 2 3 4 5
6 7 8 9 10

Like i say its probly somthing realy simple iam missing but please help me!

Thank You!

Stephen

'I have a set of mysql results I want to create a new table row with!' Thread RSS Feed

I have a set of mysql results I want to create a new table row with!