Jump to content

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


ljaii

Recommended Posts

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

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.

 

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";

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.