lol, the AND shoudl have been a WHERE (oops)
PHP Code:
if ($_GET['contenttypeid'])
{
$querycontents = $db->query_read("
SELECT erc_content.*, erc_contenttype.contenttype
FROM erc_content
LEFT JOIN erc_contenttype ON erc_content.contentid = erc_contenttype.contenttypeid
WHERE erc_content.contenttypeid = '".$_GET['contenttypeid']."'
ORDER BY erc_contenttype.displayorder, erc_content.displayorder
");
}
else
{
$querycontents = $db->query_read("
SELECT erc_content.*, erc_contenttype.contenttype
FROM erc_content
LEFT JOIN erc_contenttype ON erc_content.contentid = erc_contenttype.contenttypeid
ORDER BY erc_contenttype.displayorder, erc_content.displayorder
");
}
As far as cleaning the $_GET thing, and the table prefixes, that's my next thing to get working... will post completed when i finish it. Thanks Alan!
Paul, i am going to try to do what you said, but I am a little confused, didn't i already build the query as the variable $querycontents?
06-20-2006, 08:24 PM
Hybrid Mode
