Converting to uppercase

jimz · #1 Apr 29th, 2006, 09:40

Hi,

I'm trying to get the article_id field to be returned in uppercase...

SELECT article_id, article_title, article_content FROM articles ORDER BY article_id DESC LIMIT 3

I thought this would work...

Code: Select all

SELECT article_id, UPPER ('article_title'), article_content FROM articles ORDER BY article_id DESC LIMIT 3

but no luck

Thanks for your help!
Jim.

ukgeoff · #2 May 1st, 2006, 14:43

A little clarification required.

You start by saying you want the 'article_id' in uppercase but your code shows you using the 'UPPER' command on the 'article_title' field.

Also you have the 'article_title' inside quotes whereas what you want is just the field name, e.g.,

select article_id, upper(article_title)...

jimz · #3 May 1st, 2006, 23:15

Hi ukgeoff,

Ah sorry, article_title is the field I want returned in uppercase.

If I write it with or without quotes, I get no error and no text is displayed

Code: Select all

 SELECT article_id, UPPER (article_title), article_content FROM articles ORDER BY article_id DESC LIMIT 3

I found a solution with css --- text-transform: uppercase;
But I would still like to know what I'm doing wrong...

Cheers,

Jim.

ukgeoff · #4 May 2nd, 2006, 10:30

Hi Jim,

If you were showing error messages you should be seeing a syntax error.

SQL doesn't like the space between upper and the opening bracket, i.e., you need

upper(art... and not upper (art...

Kind Regards
Geoff

jimz · #5 May 2nd, 2006, 12:35

Thanks for your help, but it still dosen't work...

I turned on all error reporting in php.ini

I did a var_dump on the variable and it dumped out the string, but as soon as I put UPPER anywhere it says the variable is equal to NULL...

Tried a million different ways, and did it just like the mysql manual said...

Too hard basket...

Thanks anyway. I'll just use the CSS.

ukgeoff · #6 May 2nd, 2006, 14:38

Ok. So assuming you got rid of the space, the syntax is now correct so its more of a puzzle.

I use a tool called SQLyog for setting up and managing my MySQL databases. It's absolutely superb.

I use a paid for version but they do a free version as well.

http://www.webyog.com/

Give it a try. it might give you more of an insite into what is going on and what your database actually looks like.

You can at least satisfy yourself that there is nothing wrong with the syntax which may help point you in the right direction.

sypher · #7 May 2nd, 2006, 21:50

Why dont you just use:

PHP: Select all


$string  = "hello my friend";
strtoupper($string);
echo $string;

Would make HELLO MY FRIEND

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting this to css.....	jahphill	Web Page Design	3	Jun 9th, 2008 11:19
Converting UTF-8 characters to ISO	darkling235	JavaScript Forum	2	Mar 23rd, 2008 22:40
converting an swf into an fla	danny322	Flash & Multimedia Forum	5	Feb 2nd, 2008 08:32
converting to css	sliz	Web Page Design	5	Aug 28th, 2007 14:30
Converting Time	Michaeln	Databases	1	Jun 3rd, 2007 13:34

		Webforumz.com > Main Forums > Program Your Website > Databases
Converting to uppercase