TalkPHP - View Single Post - MySQL

Acrylic · 10-24-2007, 03:33 PM

Thanks Karl, but how would I separate each type (which only goto 4 btw) into their own table with only one select statement? Like I would have 5 tables each with a while loop for the $result*.

PHP Code:


			
while($row = mysql_fetch_array($result1, MYSQL_BOTH)){

OR am I just missing the picture and being a hard head? :)

Thanks though I will look into doing sprintf

10-24-2007, 03:33 PM	#3 (permalink)
Acrylic The Wanderer Join Date: Sep 2007 Location: Rochester, NY Posts: 6 Thanks: 1	Thanks Karl, but how would I separate each type (which only goto 4 btw) into their own table with only one select statement? Like I would have 5 tables each with a while loop for the $result*. PHP Code: `while($row = mysql_fetch_array($result1, MYSQL_BOTH)){` OR am I just missing the picture and being a hard head? :) Thanks though I will look into doing sprintf