RE: [PHP] Why doesn't my short piece of code work??? :(
| From: | Jason Cox | Date: | Thu, 07 Dec 2000 19:35:43 +0000 |
| Subject: | RE: [PHP] Why doesn't my short piece of code work??? :( | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-29199@lists.php.net to get a copy of this message | ||
That doesn't matter. Without curly braces, an if() statement will just
execute the next line until it hits a semi-colon.
Jason
-----Original Message-----
From: R. Phillips [mailto:kre8rx@swbell.net]
Sent: Thursday, December 07, 2000 12:10 PM
To: Chris Lee; php-general@lists.php.net
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
_______________________________________________________
Site Design, Hosting, and E-Commerce at www.webpipe.net