At 23:08 -0500 3/4/03, Stitchin' wrote:
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!!!
This is not surprising, because you haven't fetched any results. You've
only executed the query.
while (list ($catcode, $catdesc, $count) = mysql_fetch_row ($result))
{
# do something with your variables
}
mysql_free_result ($result);
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
