Funky Script

Kor_Ikron

Hi everyone.
I am working on a selling/auction site for a RPG. There is a listing_current table in the DB.

Basically, what i need is a script that goes through the listing_current table, and for each unique 'item_id' it catalogues the price that particular listing was sold at. Perhaps this could be in an array?

Then, when it's gathered all the data, I need it to analyse it, displaying average price, increase per month, and 10 listings of that type that are in teh listing_current table.

How would I go about accomplishing this?

Thank so much.

eriksmoen

what are the field names of that table?

Kor_Ikron

listing_id
has_ended

was_sold

listing_section

listing_type

post_date

end_date

seller_id

buyer_id

item_id

item_class

item_section

price_current

price_reserve

price_increment

user_bids

seller_rated

buyer_rated

early_end_reason

early_end_date

quantity

title

description

eriksmoen

$db = mysql_connect($host, $username, $password);
mysql_select_db($dbname);

$avrg_tmp = 0;
$count = 0;
while($result1 = mysql_fetch_array(mysql_query("select * from listing_current where `was_sold` = 'true' and `price_current` = max(`price_current`) group by item_id"))){
  echo $result1['title']." {".$result1['item_id']."} <BR> Sold At: ".$result1['price_current'];
  $count++;
  $avrg_tmp += $result1['price_current'];
}
echo "<BR><BR>Average Price: $".number_format(($avrg_tmp/$count),2);

mysql_close($db);

Not quite sure, however, how (or why) you want MONTHLY increases, or understand what you mean by "10 listings of that type".

hope what's there can help you get started... however it's not been tested so may prove to be a little buggy.

Kor_Ikron

Hehe, sorry about not being very clear.

It is a Star Wars RPG- and it is an informal website to sell ships and vehicles. So, when "Listing of Type" i mean like 10 of the make of ship, or vehicle.

Thanks a lot 🙂