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

No, that's okay...without the {} the IF will only run one statement and should work as intended. -Szii ----- Original Message ----- From: R. Phillips <kre8rx@swbell.net> To: Chris Lee <lee@mediawaveonline.com>; <php-general@lists.php.net> Sent: Thursday, December 07, 2000 11:09 AM Subject: Re: [PHP] Why doesn't my short piece of code work??? :( > You left the if statement open.... > > > if ( mysql_errno() ) > > echo "Error: " . mysql_errno() . ':' . mysql_error() . > > "<br>\n"; > > > > should be ..... > > if ( mysql_errno() ) { > echo "Error: " . mysql_errno() . ':' . mysql_error() . > "<br>\n"; > } > > ----- Original Message ----- > From: "Chris Lee" <lee@mediawaveonline.com> > To: <php-general@lists.php.net> > Sent: Thursday, December 07, 2000 2:01 PM > Subject: Re: [PHP] 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/ > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net