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

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

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

stephen_sweenstephen_sween Posts: 4Member
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:

[code]

<?
$q4 = "SELECT * FROM tblnewgameitem WHERE game_id = $row2[game_id] ORDER BY 'game_number' ";
$r4 = mysql_query($q4);

while($row3 = mysql_fetch_array($r4))
{

?>

<?
}

?>


<?
if($row3['user_email'] == "")
{
?>



">
">
" name="submit">





<?
}
else
{
echo " ".$row3['game_number']." ";
}


?>
[/code]

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
Sign In or Register to comment.