[SOLVED] Mysql_query question

[jacko_162]

can i use the WHERE function twice in a query??

 

for emaple;

 

"select * from $table13 WHERE parent = '0' ORDER BY name ASC"

 

i want to execute the above query WHERE parent ='0' and i want it to alo only be WHERE view='Yes'

 

what do i need to put down?

[trq]

SELECT * FROM $table13 WHERE parent = '0' AND view = 'yes' ORDER BY name ASC

[jacko_162]

thats what i though, but it still shows those with View= 'No'

 

here is full code i am working with;

 

<?php

$categories = mysql_query("SELECT * FROM $table13 WHERE parent = '0' AND view = 'yes' ORDER BY name ASC") or die(mysql_error()); // Select all the root categories and order them alphabetically

while($category = mysql_fetch_array($categories)) // Start the loop for root categories
{
echo '<img src="images/arrow.gif"> <a href="catagory.php?name=' . $category['name'] . '">' . $category['name'] . '</a>'; // Display category name

$subcategories = mysql_query("SELECT * FROM $table13 WHERE parent = '" . $category['id'] . "' AN view = 'yes' ORDER BY name ASC") or die(mysql_error()); // Same as the query above but this time the parent is the root category that has just been echoed

echo '<br>';

while($subcategory = mysql_fetch_array($subcategories)) // Start the loop for subcategories
{
echo '  <img src="images/bluearrow.gif"> <a href="catagory.php?name=' . $subcategory['name'] . '"><em>' . $subcategory['name'] . '</em></a><br>'; // Display subcategory name
}
}
?>

 

brain is pickled

[jacko_162]

found the problem, forgot a letter at end of AND. and now it throws an error