Picking the highest number from a Mysql Database

espostal

Hi,

I am developing in PHP using a MySql Database. in the database I may have the same user that has three seperate transactions. each transaction has a different price. I want to ba able to look at a user and pick the highest price of that user from the database.

Below is an example of what I mean.

I want to be able to get the value $15.00 from PHP and make that a variable. Can you tell me how to write that? _ already know how to connect to the database, just need to know how to write that.

Thanks

statrat

max()
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#example-Maximum-column

try:
select max(price) from table where user='whomever'

also, you have primary key's/id's for your user column right, not just names?

espostal

Hi,

Sorry I am new at this. I have attatched a sample database of what I am trying to do. Each bid does have a unique number. I am paying attention to the "biditem" field.

Here is what I wanted to do. Take "biditem" number "8" from the attatched file, search all bids on bid item nubmer "8" and come back with the value of "$6.00" since it is the highest. I appreciate your input so far, but I am not sure how to write that out in the code? Maybe this is really simple?

Please see the attatchment for my sample... 🙂

sgoku01

owkey...

$query = mysql_query("SELECT MAX(bidprice) FROM tablename WHERE biditem='8'");
$result = mysql_fetch_array($query);
$highest = $result[0];
echo $highest;

You have to change tablename into the name of your table (duh..) and you can make 8 a variable...

espostal

I appreciate it - That makes sense to me. Will let yah know the outcome - but that's very clear. Hope I can return the favor someday!!!