TechSpott - Computer and technology forums

Go Back   TechSpott - Computer and technology forums > Webmasters > Database Management > MySQL
MySQL Forum dedicated to the world's most popular open source database engine.

Reply
 
Thread Tools Display Modes
Old April 25th, 2010, 12:06 PM   #1 (permalink)
Louise
Guest
 
Posts: n/a
Default php/sql question: is the following possible to query a mysql database to echo

who has the max totalmark? $sqlquery2 = "SELECT fname, surname, max(exam + project + participation) AS totalmark FROM details";
$results2 = mysql_query($sqlquery2);

I can't store totalmark as an extra column in the database which would make it alot easier.
  Reply With Quote Share with Facebook
Reply

Bookmarks

Tags
database, echo, mysql, php or sql, query, question


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

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 On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP/SQL Question: I have 3 values entered into a database from a form, I am Louise PHP 0 April 23rd, 2010 09:16 AM
mySql database help. what should be my design? skateman07054 MySQL 0 April 16th, 2010 11:23 AM
How can I query a mySQL database for a table name using known data that Jamaal E MySQL 0 April 15th, 2010 06:28 PM
Oracle Announces MySQL Cluster 7.1 News Bot News 0 April 13th, 2010 09:47 PM
i don't have access to mysql database, any other alternatives? siekkwang_cin MySQL 1 April 4th, 2010 03:10 AM

 
Forum Stats
Members: 14,370
Threads: 20,379
Posts: 27,856
Total Online: 70

Newest Member: cointytob

Latest Threads

Advertisements

Support our advertisers!

Amazon
Sears
Macys
1800flowers.com
Drugstore.com


Carbonite Online-Backups
Tiger Direct
Tech Depot
Buy.com
Office Depot
Fatcow
HostGator


TripsNow.us
Marriott
Expedia
CheapTickets.com
OneTravel
Hotwire

Are you a Fan?

Share this on Facebook

Tag Cloud

Partner Links


Contact Us - Home - Archive - Privacy Statement - Top - Copyright © 2009-2010, TechSpott - All times are GMT -4. Time is 07:36 PM

Powered by vBulletin® Copyright © Jelsoft Enterprises Ltd. :: SEO by vBSEO