Why doesn't my short piece of code work??? :(
| From: | Sandeep Hundal | Date: | Thu, 07 Dec 2000 18:56:14 +0000 |
| Subject: | Why doesn't my short piece of code work??? :( | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-29187@lists.php.net to get a copy of this message | ||
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/