Re: Re: question about columns in a table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



In message <ctUV$LAfAuLHFwfR@xxxxxxxxxxxx>, Pete <cgrp@xxxxxxxxxxxx>
writes
>In message <30186.40440.qm@xxxxxxxxxxxxxxxxxxxxxxxxxxx>, sudhakar
><finals27@xxxxxxxxx> writes
>>I tried with the + sign following was the message=
>>"Resource id #3"
>>
>>The page does not show the numeric figure. please
>>advice how to go about with this.
>
>You previously posted
>$count="SELECT aboutus + contactus FROM visits";
>mysql_query($count);
>
>It sounds like you have "echo mysql_query($count)"

Just realised that I missed a step out...

>
>$count="SELECT aboutus + contactus FROM visits";
>$res=mysql_query($count);
- - > $row = mysql_fetch_array( $res );
which means the last line should be 
echo $row[0];

Or perhaps a little easier to understand:
$count="SELECT aboutus + contactus as totalvisits FROM visits";
$result=mysql_query($count);
$row=mysql_fetch_array( $result );
echo $row['totalvisits'];


-- 
Pete Clark

Sunny Andalucia
http://hotcosta.com/Andalucia.Spain

[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Soap]     [Kernel Newbies]     [Yosemite]     [Yosemite Campsites]

  Powered by Linux