thank u haseeb, i think i can get the point TQ --- Haseeb Iqbal <webjunck@xxxxxxxxxxx> wrote: > > select min(art) as art from artwork; this query will > return MIN of col 'art' as a variable art > when you run this query without AS then the returned > col will have no name. its always good idea to > return the values of aggrigate functions as > variable. > > lets suppose you re running a query like select > subject,count(*) FROM tablewhatever then change to > something like > select subject,count(*) AS Total from tablewhatever > > and when you want to get the values from mysql use > this $row['subject'] to get subject and > $row['Total'] to get count(*).. > > HTH > > __________________________________________________________________ > > > Haseeb Iqbal > > Work Tel#: 923004258030 > __________________________________________________________________ > > p.s TIP : set error_reporting to maximum... this > will help you track down errors easily > > ----- Original Message ----- > From: saad hamid > To: php > Sent: Thursday, March 10, 2005 8:16 AM > Subject: problem with asterisk > > > > when i run this code : > echo "$row[subject],$row['count(*)']"; > > i get errror , but when i change it to: > > echo "$row[subject],".$row['count(*)']; > > then it work, > can anyone tell me why, i'm still new with php. > > > get my key here > http://geocities.com/vearn2000/key.txt > > ************* > *********** > ********* > ******* > ***** > *** > * > > > > __________________________________ > Do you Yahoo!? > Yahoo! Small Business - Try our new resources > site! > http://smallbusiness.yahoo.com/resources/ > > > > > > PHP Data object relational mapping generator - > http://www.meta-language.net/ > > > Yahoo! Groups Sponsor > ADVERTISEMENT > > > > > > ------------------------------------------------------------------------------ > Yahoo! Groups Links > > a.. To visit your group on the web, go to: > http://groups.yahoo.com/group/php-objects/ > > b.. To unsubscribe from this group, send an > email to: > php-objects-unsubscribe@xxxxxxxxxxxxxxx > > c.. Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service. > > > > [Non-text portions of this message have been > removed] > > > > > get my key here http://geocities.com/vearn2000/key.txt ************* *********** ********* ******* ***** *** * __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ PHP Data object relational mapping generator - http://www.meta-language.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@xxxxxxxxxxxxxxx <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
