[Resolved] MYSQL Statements

[8mycsh]

I have a question about a query I need to do.
Can I have a double AND statement? Or is there a better way to do this query?

$query5="SELECT catname,catdir,subcat_id from #__gallery where catid=$row4->catid AND published=1 AND subcat_id=2";
$database->setQuery($query5);
$row5=$database->loadObjectList();
$row5=$row5[0];

[LordShryku]

You can have as many AND statements as you need in the query.

[TheDefender]

Sure, why not? How else would you plan on narrowing down your search criteria? Multiple ANDs and multiple ORs are fine in an SQL statement...