String from mysql_query limit?

Anon

When I pull a result from my database, I don't want the text to exceed 20 characters. Is there a way to do this in the mysql_query statement? I'm guessing I'll have to cut the string after I do the query..

Anon

Sure, just use the MySQL-substring-function, lik this

SELECT subtring(name,0,20) as name FROM customers;

Greetz,

Vincent Driessen
Webmaster PHP Freakz.com
http://www.phpfreakz.com/

Anon

ok this is what i have::

SELECT recipeId, substring(recipeName, 0, 20) as recipeName FROM users_box

I'm getting no output now..
just .. nothing.. blank. nada
no errors.. but no result.

i tried
SELECT recipeId, (substring(recipeName, 0, 20) as recipeName) FROM users_box
and the many different variants, but to no avail..

something i'm missing obviously.
any ideas?

Anon

This works fine with me... Are you sure you're table is filled with data??

Greetz,

Vincent Driessen
Webmaster PHP Freakz.com
http://www.phpfreakz.com/

Anon

yeah.. it's definitely filled.

i went ahead and substring'ed the data after pulling the result, and it worked. but i could never get it to work in the SELECT statement.

very strange

Anon

In MySQL select statements the string does not start at position 0, it starts at position 1.

substring(field,1,2)

gets the first 2 chars from "field".

If you start at position 0, output will be nill.

Anon

hey thanks vincent.
that worked.

i knew it was something small like that. 😉