ADODB

[tn_prasad]

Hi
i'm using adodb in my code to connect to mysql.Its workingfine for the queries which get the values from DB.

1) But When i use the Query
$avg=$conn->Execute("select avg(fieldname) from tabname
& then i say
print $avg
it prints ""OBJECT""
when i try print $avg->fields[fieldname]
it doesn't print anything.
what shall i do?
how do i print the value of avg in my php code.

2)$duration=$conn->Execute("select sum(UnixTimeStamp(F1) - UnixTimeStamp(F2)) from tabname
print $duration
how do i print the result?

plz help me.Mail to [e-mail]
Thanks
prasad

[Anon]

Maybe you should use [\"fieldname\"] instead of [fieldname].

[Anon]

see Reference http://www.mysql.org/doc/S/E/SELECT.html
as far as I understand your query, it is in the sql-statement that you should include an AS-Statement
select avg(fieldname)AS average from tabname ...
the resulting table should bear "average" as header, so you should be able to adress it as a field
beware, I did not test that yet

[pnoeric]

Dude,

Have you looked at the ADODB docs? They have some excellent, clear, simple examples that will do exactly what you want.

...

I started to type out the answers to your questions, but the ADODB docs are clear and easy; just go check them out.

http://php.weblogs.com/ADOdb_manual

Here's a hint, the meat of "Example 1: Select", which might tell you why your stuff isn't working:

$recordSet = &$conn->Execute('select * from products');
if (!$recordSet)
print $conn->ErrorMsg();
else
while (!$recordSet->EOF) {
print $recordSet->fields[0].' '.$recordSet->fields[1].'<BR>';
$recordSet->MoveNext();
}

Sorry to sound impatient or frustrated, but c'mon, the docs couldn't be clearer and this is like basic "how to use this product" info, not even an obscure or hard question. You should at least pretend to TRY to scan the instructions...

good luck
Eric

[tn_prasad]

Yeah,
tnx.
after ur response
i tried it.
but it was giving sopme parse error.
plz let me know how do i do it.
tnx
prasad

Joao Marcus wrote:

Maybe you should use [\"fieldname\"] instead of [fieldname].

[tn_prasad]

yeah,
tnx for ur response.
i used the query this way.

$avg=$conn->Execute("select avg(fieldname) AS avgvalue from tabname

i tried to
print $avgvalue;
print $avg;
print $avg->fields[avgvalue]
these things print nothing.
plz help me.
what shall i do.
tnx
prasad

sydonne wrote:

see Reference http://www.mysql.org/doc/S/E/SELECT.html
as far as I understand your query, it is in the sql-statement that you should include an AS-Statement
select avg(fieldname)AS average from tabname ...
the resulting table should bear "average" as header, so you should be able to adress it as a field
beware, I did not test that yet

[tn_prasad]

hi,
tnx for ur response.Never mind ,its ok
BUt i think u didn't get me ,i need something else.
let me be more clear.
normal select statements works fine
like
$name = $conn->Execute("Select name from tabname
while (!$name->EOF)
{
print "<td>";
print "Name:";
print $name->fields[name];
$name->MoveNext();
print "<td>";
}
This works fine
But what i need is something else
Just look at my query
$avg=$conn->Execute("select avg(fieldname) as avgvalue from tabname

now how do i print the value of $avg.
i tried
print $avgvalue;
print $avg;
Print $avg->fields[fieldname]
Print $avg->fields[avgvalue]
but everything prints nothing.
let me know if u have any solution
prasad

Eric Mueller wrote:

Dude,

Have you looked at the ADODB docs? They have some excellent, clear, simple examples that will do exactly what you want.

...

I started to type out the answers to your questions, but the ADODB docs are clear and easy; just go check them out.

http://php.weblogs.com/ADOdb_manual

Here's a hint, the meat of "Example 1: Select", which might tell you why your stuff isn't working:

$recordSet = &$conn->Execute('select * from products');
if (!$recordSet)
print $conn->ErrorMsg();
else
while (!$recordSet->EOF) {
print $recordSet->fields[0].' '.$recordSet->fields[1].'';
$recordSet->MoveNext();
}

Sorry to sound impatient or frustrated, but c'mon, the docs couldn't be clearer and this is like basic "how to use this product" info, not even an obscure or hard question. You should at least pretend to TRY to scan the instructions...

good luck
Eric

[Anon]

Hello,

I gave it some research, and have tested out the next things.

First, as says Eric Mueller, the documentation of adodb is quiet clear, esp. the tutorial.
quote:
Retrieving the Data

while (!$result->EOF) {
for ($i=0, $max=$result->FieldCount(); $i < $max; $i++)
print $result->fields[$i].' ';
$result->MoveNext();
print "<br>\n";
}The paradigm for getting the data is that it's like reading a file. For every line, we check first whether we have reached the end-of-file (EOF). While not end-of-file, loop through each field in the row. Then move to the next line (MoveNext) and repeat.

The $result->fields[] array is generated by the PHP database extension. Some database extensions do not index the array by field name. To force indexing by name - that is associative arrays - use the $ADODB_FETCH_MODE global variable.

$ADODB_FETCH_MODE = ADODB_FETCH_NUM;
$rs1 = $db->Execute('select * from table');
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$rs2 = $db->Execute('select * from table');
print_r($rs1->fields); // shows array([0]=>'v0',[1] =>'v1')
print_r($rs2->fields); // shows array(['col1']=>'v0',['col2'] =>'v1')

As you can see in the above example, both recordsets store and use different fetch modes based on the $ADODB_FETCH_MODE setting when the recordset was created by Execute().

unquote (sorry for the formatting
as to your example, you had to correct the sql-statement (1), then (2) the following would work correctly:
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$result = $db->Execute("SELECT avg(number) as average from table");
print $result->fields['average'];

seems it's not being any shorter than this.