PHP Auctions
I think you can find it on http://www.hotscripts.com
if not just search google
"Jaxon" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> hi,
>
> can anyone relay experience or recommend a php-based ebay-style auction
> script?
>
> tkx,
> jaxon
>
When trying to do this query:
$rsum =mysql_query("SELECT SUM(rating) FROM ratings where threadid = $ratevar")or
die (mysql_error());
This is the output:
Resource id #15
or some other seemingly arbitrary Resource ID number?
First of all what is a resource ID and second how do I get it to actually
; doing this will show you the sum of all the scores:
>
> select sum(score) from ratings;
>
> eg, if the scores were 5, 2, 5, 8, and 2 then this sql should return 22
> (unless I added it wrong... :/ )
>
> -Original Message-
> From: JohnP [mailto:[EMAIL PROTECTED]]
>
ot;>news:02d901c24fd5$aba46020$7800a8c0@idiom...
> What database are you using?
>
> MySQL has a SUM function which automatically selects the total of a
column.
>
> -VolVE
>
> - Original Message -
> From: "JohnP" <[EMAIL PROTECTED]>
> To: <[E
CTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> just sum them up and divide by the count - making sure to deal with a
count
> of zero
>
> -Original Message-
> From: JohnP [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 30, 2002 10:56
Ok I looked at all the math functions for PHP but saw no way of returning the average
of a set of numbers - I plan on using this for a rating system - any help?
--
John
Forgot to add one thing - I don't need to add the new number after detection
to the db but rather just print it out
"Johnp" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Ok I have a script done but it does not work - If there is
is completly empty??
Thanks - JohnP
Ok after being blasted for not looking on PHP.net first I have now returned none the
wiser! :D
Here is the post file:
-
Send this file:
Here is the post handler file:
And here is the error I get:
-
9 matches
Mail list logo
