Valentina PHP 2.1 sql select sum()

[Damon Pillinger]

Hi Guys,

Since I know you are all up.

I have a sql query in PHP 2.1win (using 2.1 win for everything:)

$res = valentina_query("Select cCalled, sum(cDion),count(*) FROM Person
where cCustomer='42000' GROUP BY cCalled");
  
and wish to display the results but cannot figure out how it works.

echo $obj->cCalled."  ".$obj[1]."  ".$obj[2]."  ".$obj[3];

returns the field field fine and does not error but does not deplay the
required information.


the equivalent in RB is fine.

  i=0
  do
    ListBox1.AddRow v.Field("cCalled").Value
    ListBox1.cell(i,1)= v.Field(2).Value
    ListBox1.cell(i,2)= v.Field(3).Value
    i=i+1
  loop Until v.NextRecord =false


Also since I have just deleted all my Val folders I have also deleted
the manuals. Which Manual will this be in, as this is what I am doing
today? Don't tell me the VPHP Reference (wiki) manual as it is off line
on the WEB.

Thanks

Best regards

Damon L. Pillinger
Director Daisychain EDi
Suite 3
4 Winston Court
Moorabbin 3189
Phone : +61 3 9532 1220
Fax : +61 3 9532 1280