Current location: Hot Scripts Forums » Programming Languages » PHP » MYSQL PHP Greatest Help

MYSQL PHP Greatest Help

#1 (permalink)

02-16-04, 05:55 AM

Darren884

Newbie Coder

Join Date: Feb 2004

Posts: 8

Thanks: 0

Thanked 0 Times in 0 Posts

MYSQL PHP Greatest Help

What is the query for the greatest of something like the greatest time something is used and the greatest number of times an item occures?

#2 (permalink)

02-18-04, 09:47 AM

NeverMind

Community VIP

Join Date: Aug 2003

Location: K.S.A

Posts: 2,257

Thanks: 0

Thanked 2 Times in 1 Post

max() is the one

Code:

SELECT max(time) AS time FROM table_1;

__________________
PHPSimplicity
We don't need a reason to help people - Zidane [FF9]

Last edited by NeverMind; 02-18-04 at 09:54 AM.

Bookmarks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PHP and MySQL ?	rob2132	Hot Scripts Forum Questions, Suggestions and Feedback	4	08-29-08 02:22 AM
question about updating a page or database for an, php and mysql updating	mikewooten	PHP	1	02-12-04 12:11 AM
Generating PHP code for MySQL	ptesone	General Advertisements	1	02-03-04 08:26 AM
Need Epinions-lite system in PHP & MYSQL	wali001	Job Offers & Assistance	4	01-12-04 06:02 AM
MySQL with PHP question. HELP for a newbie	kenfused	PHP	3	08-02-03 12:53 AM