Re: Why doesn't my short piece of code work??? :(

I saw a few funny things. try this. <? $column = "country"; $table = "product"; $result = mysql_db_query($store_db, "SELECT $column, count(*) FROM $table GROUP BY $column"); while( $r = mysql_fetch_array($result) ) { if ( mysql_errno() ) echo "Error: " . mysql_errno() . ':' . mysql_error() . "<br>\n"; echo "{$r["country"]} <br>\n"; } ?> more info at http://php.net/manual/function.mysql-db-query.php http://php.net/manual/function.mysql-fetch-array.php Chris Lee Mediawaveonline.com In article <20001207185614.19730.qmail@web3903.mail.yahoo.com>, "=?iso-8859-1?q?Sandeep=20Hundal?=" <sandeep_wde@yahoo.com> wrote: > Hi all, I've got this short stripped down basic code to get some results > from a table, but I can't get it to work. Any ideas why?? > > > $column = "country"; > > $result = mysql_query("SELECT $column, count(*) AS numbers FROM > $tablename GROUP BY $column"); > > for($i =0; $i < mysql_num_rows($result); $i++) { > > echo mysql_result($result, $i, $column) mysql_result($result, $i, > "numbers") "; > echo "<br>"; > > } > echo "<font color=red>".mysql_error()."</font>"; > > mysql_free_result($result); > > TIA!!! > > Sandeep Hundal > > __________________________________________________ > Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of > Products. http://shopping.yahoo.com/ > >