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

theses are all VALID :) <? if ( $num ) echo "a<br>\n"; else echo "b<br>\n"; if ( $num ) { echo "a<br>\n"; } else { echo "b<br>\n"; } if ( $num ) { echo "a<br>\n"; } else { echo "b<br>\n"; } if ( $num ) { echo "a<br>\n"; } else echo "b<br>\n"; if ( $num ) echo "a<br>\n"; else { echo "b<br>\n"; } ?> There are hundreds of ways of writing if statements, try em, they all work. If yout IF() statment is not going to have more then one line then yout dont need { }, and IMHO reduced readability. Chris Lee Mediawaveonline.com On Thu, 7 Dec 2000, R. Phillips wrote: > 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 > > >