Re: Len in mysql [XOOPS general usage questions]

Len in mysql

2006/11/7 14:00
slyss
Quite a regular
Posts: 343
Since: 2006/1/26

i need to know where i mistake...

i have do a query:


$sql = "SELECT s.*, t.* FROM prefix_".$directory."_photos s, prefix_".$directory."_text t WHERE s.lid=t.lid AND (t.description LIKE '%Stefano%') AND [color=FF0000]((LEN(t.description)) > 900)[/color] ORDER BY rand() LIMIT 1";

The red text is mistake...

how i can solve it?

thanks a lot

[size=x-large]2008 Xoops Book[/size]

Re: Len in mysql

2006/11/7 14:11
christian
Just can't stay away
Posts: 401
Since: 2002/2/24

Look string functions in this official documentation.

Conversion script
Professional Xoops

Re: Len in mysql

2006/11/7 18:02
slyss
Quite a regular
Posts: 343
Since: 2006/1/26

mmmmm i haven't understand my error....

[size=x-large]2008 Xoops Book[/size]

Re: Len in mysql

2006/11/7 18:09
Bender
Home away from home
Posts: 1899
Since: 2003/3/10

Just guessing:

Use Length instead of Len ?

Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...

Re: Len in mysql

2006/11/7 21:30
slyss
Quite a regular
Posts: 343
Since: 2006/1/26

Quote:

Bender wrote:
Just guessing:

Use Length instead of Len ?

yesssss


AND (LENGTH(t.description) > 100)

thanksssssssss

[size=x-large]2008 Xoops Book[/size]

Stats
Goal:	$100.00
Due Date:	Apr 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Len in mysql

Re: Len in mysql

Re: Len in mysql

Re: Len in mysql

Re: Len in mysql

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}