I've done much more complicated thing than this, what am I missing?

matthewst

I'm working on a super simple database and php script. The problem is I can't get it to work!
I keep getting this error "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /Library/Tenon/WebServer/WebSites/www.ABCAdvertising.net/abcadmin/dcloset.php on line 28", line 28 is "while ($row_shorts = mysql_fetch_assoc($result_shorts))".

Here is the php page(just trying to get the shorts column to work right now).

<?PHP
include('include/user_check.php');
include('include/db_con.php');	
?>

 <html>
 <head>
 <title>D Closet</title>
 </head>
 <body>
 <table>
 <tr>
 <th colspan="2">SHORTS</th><th colspan="2">JEANS</th><th colspan="2">POLOS</th><th colspan="2">T-Shirts</th>
 </tr>
 <tr>
 <th>Amount</th><th>Color</th><th>Amount</th><th>Color</th><th>Amount</th><th>Color</th><th>Amount</th><th>Color</th>
 </tr>

<?PHP
$query = "SELECT type FROM dc";
 	$result_query = mysql_query($query);
* 	while ($row_query = mysql_fetch_assoc($result_query))
 	{
 	$type = $row_query['type'];
	}
	$shorts = "SELECT color, number FROM dc WHERE '$type' = shorts";
		$result_shorts = mysql_query($shorts);
		while ($row_shorts = mysql_fetch_assoc($result_shorts))
		{
		$number_shorts = $row_shorts['number'];
		$color_shorts = $row_shorts['color'];	
	?>
 <tr>
 <td><?=$number_shorts; ?></td><td><?=$color_shorts; ?></td><td><?=$number_jeans; ?></td><td><?=$color_jeans; ?></td><td><?=$number_polos; ?></td><td><?=$color_polos; ?></td><td><?=$number_tshirts; ?></td><td><?=$color_tshirts; ?></td>
 </tr>
 <?PHP
 }
 ?>
 </table>
 </body>
 </html>

Here is what the entire database table looks like

type_colornumber
shortsblue2
jeansblack3
poloswhite4
tshirtsgreen___1

abc123

Is it my eyes or do you have an "*" at the begining of that while line?

Maybe I need some sleep.

Actually you are probably just marking the line for idiots like me. Doh!

devinemke

what does [man]mysql_error[/man] have to say about your queries?

matthewst

I have no idea where the * came from, it's not in the code.

Anyway, I changed it to this

<?PHP
$query = "SELECT * FROM dc";
 	$result_query = mysql_query($query) or die(mysql_error());
  	while ($row_query = mysql_fetch_array($result_query))
 	{
 	$type = $row_query['type'];

$shorts = "SELECT * FROM dc WHERE '$type' = type";
	$result_shorts = mysql_query($shorts) or die(mysql_error());
	while ($row_shorts = mysql_fetch_assoc($result_shorts))
	{
	$number_shorts = $row_shorts['number'];
	$color_shorts = $row_shorts['color'];
	}	
?>
 <tr>
 <td><?=$number_shorts; ?></td><td><?=$color_shorts; ?></td><td><?=$number_jeans; ?></td><td><?=$color_jeans; ?></td><td><?=$number_polos; ?></td><td><?=$color_polos; ?></td><td><?=$number_tshirts; ?></td><td><?=$color_tshirts; ?></td>
 </tr>
 <?PHP
 }
 ?>

Now my page displays without any errors but it displays everything not just the shorts data.

matthewst

i should have explained my pic
2 blue shorts----1 black jeans----3 white polos----4 green tshirts

matthewst

this

<?PHP
$query = "SELECT type FROM dc";
 	$result_query = mysql_query($query) or die(mysql_error());
* 	while ($row_query = mysql_fetch_array($result_query))
 	{
 	$type = $row_query['type'];
/////////////////////////////just for show	
	echo $type;
////////////////////////////end just for show	
	if( $type == "shorts" )
	{
		$shorts = "SELECT * FROM dc WHERE '$type' = type GROUP BY type";
			$result_shorts = mysql_query($shorts) or die(mysql_error());
			while ($row_shorts = mysql_fetch_assoc($result_shorts))
			{
			$number_shorts = $row_shorts['number'];
			$color_shorts = $row_shorts['color'];
			}
	}
?>
 <tr>
 <td><?=$number_shorts; ?></td><td><?=$color_shorts; ?></td>

gets me pic 2

what i want is this

_SHORTS____JEANS____POLOS___T-SHIRTS
numbScolorSnumbJcolorJ_numbPcolorP_numbTcolorT

matthewst

myguess (codewalkers) solved it
thanks everyone for the help

<?PHP
include('include/user_check.php');
include('include/db_con.php');	
?>

 <html>
 <head>
 <title>D Closet</title>
 </head>
 <body>
 <table>
 <tr>
 <th colspan="2">SHORTS</th><th colspan="2">JEANS</th><th colspan="2">POLOS</th><th colspan="2">T-Shirts</th>
 </tr>
 <tr>
 <th>Amount</th><th>Color</th><th>Amount</th><th>Color</th><th>Amount</th><th>Color</th><th>Amount</th><th>Color</th>
 </tr>
 <tr>
<?PHP
$query = "SELECT type FROM dc";
 	$result_query = mysql_query($query);



while ($row_query = mysql_fetch_assoc($result_query))
{
         $type = $row_query['type']; 	

        $shorts = "SELECT color, number FROM dc WHERE type = '$type'";
	$result_shorts = mysql_query($shorts);
	while ($row_shorts = mysql_fetch_assoc($result_shorts))
	{

	$number = $row_shorts['number'];
	$color = $row_shorts['color'];			

	print "<td>$number </td><td>$color</td>";
	}
}
 ?>
 </tr>
 </table>
 </body>
 </html>