phpretard
asked on
How can I select the highest number from a list of fields?
$result = mysql_query("SELECT * FROM 4Sale ");
while($row = mysql_fetch_array($result)
{
$highbid=$row['bid']; // THERE ARE SEVERAL DIFFERENT ENTRIES FOR BID
}
// I am trying to validate with this
if($bid < $highBid) {
ECHO"BID HIGHER";
}
of course the form field is name=bid AND THE db FIELD NAME IS BID.
while($row = mysql_fetch_array($result)
{
$highbid=$row['bid']; // THERE ARE SEVERAL DIFFERENT ENTRIES FOR BID
}
// I am trying to validate with this
if($bid < $highBid) {
ECHO"BID HIGHER";
}
of course the form field is name=bid AND THE db FIELD NAME IS BID.
Last Comment
$result = mysql_query("SELECT max(bid) maxBid FROM 4Sale ");
ASKER
$result = mysql_query("SELECT max(bid) maxBid FROM 4Sale ");
while($row = mysql_fetch_array($result)
{
How do I show the highest number?
}
while($row = mysql_fetch_array($result)
{
How do I show the highest number?
}
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Got it!
Thank you!
Thank you!
Web Development
Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.
78K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
