I've got the following code in my php file:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
/* Select all categories from designcatagories table */
$query = "SELECT designcatagories.catcode, designcatagories.catdesc,
count(*) FROM
designs,designcatagories where designs.catcode =
designcatagories.catcode
GROUP BY catcode";
$result = mysql_query($query)
or die ("Couldn't execute query.");
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
I tested it in phpMyAdmin and I'm getting the correct results .... here's my
dilemma ... I want to spit out a list of my catcodes, # designs found,
catdesc
and I'm not sure how to reference the count(*) object??? What I have below
doesn't work, it just prints the () and I can't find any reference to this
in my books??? HELP!!!
echo "><b>$catcode</b></font>
</td>
<td>$count()</td>
<td>$catdesc</td>
</tr>";
Renee Toth
Stitchin' Up A Storm
www.stitchinupastorm.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
