Specalized MySQL fetch with PHP

[GlovesQ]

I have a table in MySQL looks like this:

 

SiteName  |  SiteAddress  |  Category  |  Description.

 

Currently I'm using this script to print everything in it:

 

$Query = "SELECT * from $TableName";
$Result = mysql_db_query ($DBName, $Query, $Link);

while ($Row = mysql_fetch_array ($Result)) {
if ($Row[category]) {  // Declare section here
	print ("<tr>\n");
	print ("<td><b><a href=\"$Row[website_address]\" target=\"_blank\">$Row[site_name]</a></b></td>\n");
	print ("<td>$Row[description]</td>\n");
	print ("<td>$Row[cust_phone]</td>\n");
	print ("</tr>\n");
 }

mysql_close ($Link);

 

I only want to print the rows that are of a certain category.

 

Example: Print only rows that are Art

or

Print only rows that are Math

 

 

How can i do that?  I tried to use an if statement but I'm too much of a PHP n00b and it still listed all the rows.

[Jeremysr]

You can do that in the MySQL query like this:

 

$Query = "SELECT * FROM $TableName WHERE Category = 'Art'";

 

Then it'll only select the rows of that category.

[GlovesQ]

1. Jeremysr you rule.

 

2. PHP Freaks reule

 

3. Thanks!  Worked like a charm! 

 

I think I'll invest more time into SQL.  Seems like it may save me a lot of headaches.  :D

 

-GlovesQ