[PHP-DB] newbie question on PHP Mysql...

Hi all! I'm taking my first steps with PHP MySQL. Can anyone give me a hint on why this would not work? * $result = mysql_query('SELECT SUM(AcctInputOctets), SUM(AcctOutputOctets) FROM radacct WHERE username = $argv[1] '); echo mysql_result($result,0), \n; echo

[PHP-DB] Re: newbie question on PHP Mysql...

Hi ! Could you do a print_r($result) after your mysql_query ? Or you sure of your argv[1] ? Sylvain Gourvil Evert Meulie wrote: Hi all! I'm taking my first steps with PHP MySQL. Can anyone give me a hint on why this would not work? * $result = mysql_query('SELECT

Re: [PHP-DB] Re: newbie question on PHP Mysql...

Hi, I guess you used a single quote over the query so the text, $argv[1], was entered into the query rather than the value inside it. try: $result = mysql_query('SELECT SUM(AcctInputOctets), SUM(AcctOutputOctets) FROM radacct WHERE username = ' .$argv[1] ); OR $result = mysql_query(SELECT

[PHP-DB] Re: newbie question on PHP Mysql...

Hi Evert, try: echo mysql_result($result,0,0), \n; echo mysql_result($result,0,1); You forgot a zero... Regards, Sigrid Evert Meulie [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED] Hi all! I'm taking my first steps with PHP MySQL. Can anyone give me a hint on why this

[PHP-DB] Re: newbie question on PHP Mysql...

Evert Meulie wrote: Hi! I've tried your suggestions, but still get the same error message. The 'print_r($result);' that I added does not print anything, so that would explain why I get the errors. My idea is to call this script with a value, like: script.php value Doesn't that put the

Re: [PHP-DB] Re: newbie question on PHP Mysql...

Try This $result = mysql_query(SELECT SUM(AcctInputOctets),SUM(AcctOutputOctets) FROM radacct WHERE username = '$argv[1]' ); this will make sure that even if $arg[1] is empty it still get '' (empty) as part of the query - Original Message - From: Sylvain Gourvil [EMAIL PROTECTED]

[PHP-DB] A question with php.ini

Hi, How does the php.ini need to be setup for SMTP or how do I find it out? Thank-You very much Daryl Booth

Re: [PHP-DB] A question with php.ini

At 03:31 PM 9/21/2005, Daryl Booth wrote: Hi, How does the php.ini need to be setup for SMTP or how do I find it out? Thank-You very much Daryl Booth Google didn't take long . http://www.phplivesupport.com/documentation/viewarticle.php?uid=1aid=70pid=3 and that's pretty clear.

[PHP-DB] Repetitive Result

I have a table created from two mysql tables which shows all Members of Congress with related data. The Representative's name is pulled from one sql table and the data from another sql table. When the php table comes up on the web page, the name of the Representative for Maryland's 2nd

RE: [PHP-DB] Repetitive Result

depends on your query, some joins might make for duplicate results...show your code bastien From: [EMAIL PROTECTED] To: php-db@lists.php.net php-db@lists.php.net Subject: [PHP-DB] Repetitive Result Date: Wed, 21 Sep 2005 16:02:48 -0400 I have a table created from two mysql tables which

Re: [PHP-DB] Repetitive Result

Here's the query (actually pulled from 3 sql tables; no joins): select 109fh4.rep, veteransdata04.state, veteransdata04.cd, 109fh4.party, 1091vote224.vote1091224, veteransdata04.vetpop, veteransdata04.totalexpend*1000, veteransdata04.totalpatients, veteransdata04.medexpend*1000,

Re: [PHP-DB] Repetitive Result

um, that is a join, just uses the older syntax. try selecting with the distinct clause select distinct(109fh4.rep), veteransdata04.state bastien From: [EMAIL PROTECTED] To: php-db@lists.php.net php-db@lists.php.net Subject: Re: [PHP-DB] Repetitive Result Date: Wed, 21 Sep 2005 16:17:53

Re: [PHP-DB] Repetitive Result

That didn't do it. I tried with parentheses around the 109fh4.rep and without the parentheses. The really curious thing is that the repetition only happens within Maryland and starts with the second Maryland entry. The next state is Maine (alphabetical by the abbreviation ME) and there is

[PHP-DB] antiword error for popen

I have an error showing;I can't find the name of your HOME directory when I upload word doc and retrieve text by antiword. I do not know why I will get kind like error! code--- $handle = popen(/usr/bin/antiword \$original_tmp\ -t 21, 'r');