[SOLVED] Selecting only first couple of words from a field

[ljaii]

Just a quick query...

 

How do I retrieve only the first couple of words from a field?

 

I have made a news script but don't want to display the entire content of the news article just the first 10 words or so as a brief intro.

 

Many Thanks,

lj

[Wildbug]

SELECT LEFT(50,columnname);

[ljaii]

Got it to work with

 

SELECT LEFT(columnname,50);

 

Had to change it round but works great thanks

[Wildbug]

Oops  :-)

[ljaii]

It works for one query but not for my search query.

 

I currently have this code:

$query = "SELECT (LEFT(content,100)), title, date, id FROM news WHERE content LIKE \"%$variable%\" or title LIKE \"%$variable%\" ORDER BY title";

 

which throws up the error: "Notice: Undefined index: content in..."

 

Help!

 

Thanks,

lj

[Illusion]

Can u post the full error message.

[ljaii]

Notice: Undefined index: content in /public_html/****/search.php on line 107

[Illusion]

It seems there is nothing wrong with your query, try this

$query = "SELECT LEFT(content,100), title, date, id FROM news WHERE content LIKE '%".$variable."%' or title LIKE '%".$variable."%' ORDER BY title";

check ur php code first.

 

[ljaii]

Thanks, but didnt resolve it.

 

It seems it doesnt take the content variable when I add the (LEFT(content,100)) part. Don't know why it doesnt take this when it takes it without the added bit.

 

Confusion.

 

/quit ;p

[skali]

Notice: Undefined index, this notice appears when you are trying to access an index in an array that does not exists

Use this:

$query = "SELECT LEFT(content,100) as content, title, date, id FROM news WHERE content LIKE '%".$variable."%' or title LIKE '%".$variable."%' ORDER BY title";

[ljaii]

Awesome, cheers!