Valentina PHP 2.1 sql select sum()

[Ruslan Zasukhin]

On 2/10/06 12:02 AM, "Damon Pillinger" <daisychain at iinet.net.au> wrote:

Hi Damon,
 
> 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.

Please check our VPHP examples.

NOTE: you can get results as:
    - array
    - associated array
    - objects

NOTE2:  VPHP API is 99% the same as mySQL PHP module.

Again our VPHP examples show all 3 ways to access results
        
 
> 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.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]