Pulling Limited Characters

Dev Articles Community Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

March 11th, 2003, 04:09 PM

zigote

Contributing User

Join Date: Aug 2002

Location: Atlanta GA

Posts: 73

Time spent in forums: 1 h 55 m 11 sec
Reputation Power: 6

Pulling Limited Characters

I am trying to pull limited characters of contents stored in the DB.

this pulls the title and the full contents.

PHP Code:


		
			
 $query = "SELECT id, title, content, date FROM article ORDER BY date DESC LIMIT 0, 20";

this pulls the title and no contents.

PHP Code:


		
			
 $query = "SELECT id, title, left(content,30), date FROM article ORDER BY date DESC LIMIT 0, 20";

I have tried so many ways and I can't seem to nail it.
I would like to only pull around 30 characters of contents...

I hope someone can help, thanks

March 11th, 2003, 09:40 PM

mytch

Join Date: Apr 2002

Location: Sydney, Australia

Posts: 589

Time spent in forums: < 1 sec
Reputation Power: 7

Zig,
Try this:

PHP Code:


		
			
 $query = "SELECT id, title, left(content,30) as myContent, date FROM article ORDER BY date DESC LIMIT 0, 20";

Then reference the myContent field instead of the content field.

March 11th, 2003, 11:31 PM

zigote

Contributing User

Join Date: Aug 2002

Location: Atlanta GA

Posts: 73

Time spent in forums: 1 h 55 m 11 sec
Reputation Power: 6

Very cool, that did work.. and so simple,
I tried everything I could think of to get that to work. but that =)

Thanks again so much.

Viewing: Dev Articles Community Forums > Databases > General SQL Development > Pulling Limited Characters

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump