@JoeHoldcroftFeb 11.2007 — #Get rid of count(), so it's just SELECT * FROM, then put the whole query inside: [code=php]mysql_num_rows(mysql_query("SELECT * FROM tblcart WHERE...."));[/code]
@NightShift58Feb 11.2007 — #Get rid of count(), so it's just SELECT * FROM, then put the whole query inside: [code=php]mysql_num_rows(mysql_query("SELECT * FROM tblcart WHERE...."));[/code][/QUOTE] Don't get rid of count()! It's there for a purpose!!! And, if all you need is a count, there's not need to select and retrieve the entire content of a table... be kind to MySQL/PHP...
Leave everything as is and change:[code=php]echo $rsCartItems;[/code]to:[code=php]$r = mysql_fetch_row($rsCartItems); echo $r[0];[/code]