Dream.In.Code > Programming Help > Databases

Welcome to Dream.In.Code
	Become an Expert! Join 149,494 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,358 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a Expert

MySQL: Force SELECT to return a default value

Reply to this topic

Start new topic

MySQL: Force SELECT to return a default value

girasquid	26 Mar, 2007 - 12:50 PM Post #1
Barbarbar Joined: 3 Oct, 2006 Posts: 1,294 Thanked: 18 times Dream Kudos: 725 My Contributions	Hello, all. I have been expanding on some of my MySQL code, which generates user rankings based on the size of their armies. This is the code: CODE SELECT COUNT(*)+1 AS COUNT FROM user_armies GROUP BY commander HAVING (SUM(amount) > (SELECT SUM(amount) FROM user_armies WHERE commander = ?)) LIMIT 1 And it works fine and retrieves a user's rank, but if a user is at the very top of the rankings it doesn't return anything. Does anyone know of a way that I can force the query to return a 1 instead of no rows? Thanks, Girasquid
	This Post Was Helpful!


Register for Free to Make These Ads Go Away!

Trogdor	RE: MySQL: Force SELECT To Return A Default Value 27 Mar, 2007 - 03:59 AM Post #2
D.I.C Addict Joined: 6 Oct, 2006 Posts: 549 Thanked: 4 times Dream Kudos: 125 My Contributions	For that you can use UNION. <your query> UNION <alternative> the alternative would be something like SELECT 1 AS count
	This Post Was Helpful!

girasquid	RE: MySQL: Force SELECT To Return A Default Value 27 Mar, 2007 - 07:17 AM Post #3
Barbarbar Joined: 3 Oct, 2006 Posts: 1,294 Thanked: 18 times Dream Kudos: 725 My Contributions	That did the trick, thanks!
	This Post Was Helpful!

Fast Reply

Reply to this topic

Start new topic

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Time is now: 1/7/09 05:54PM

Invision Power Board v2.1.7 © 2009 IPS, Inc.

Licensed to: MediaGroup1

Advertising | Terms of Use | Privacy Policy | About Us | Site Map

Forum Index: Programming Help | C and C++ | Visual Basic | Java | VB.NET | C# | ASP.NET | PHP | ColdFusion | Perl and Python | Ruby | Databases | Other Languages | Game Programming | Software Development | Computer Science | Industry News | Programming Tutorials | C++ Tutorials | Visual Basic Tutorials | Java Tutorials | VB.NET Tutorials | C# Tutorials | Linux Tutorials | PHP Tutorials | ColdFusion Tutorials | Windows Tutorials | HTML/JavaScript Tutorials | CSS Tutorials | Flash Tutorials | Web Promotion Tutorials | Photoshop Tutorials | Software Development Tutorials | Database Tutorials | Other Language Tutorials | ASP.NET Tutorials |

Copyright 2001-2008 MediaGroup1 LLC, All Rights Reserved
A MediaGroup1 LLC Production - Version 6.0.2.1.36
Server: secure2

Search^Updated!w00t

Over 509,000 Pages! Advanced Forum Search

Be Social

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Join our IRC Chat

Bye Bye Ads

Monthly Drawing

Top Contributors

Top 10 Kudos This Month