Beer Belly Blobs

JakesSA

I've got about 40 rows of large amounts of text stored as blobs in my db. What I'm trying to achieve is that, when a visitor searches the blobs, it will only bring up the first 4 or 5 line of the article and then have a read more link to the rest .

if anyone can help 🙂

Thanx

chaosdivine

Hi, I am not even remotely qualified to help you very much but I do know that you can limit your MySQL queries using a function- here is a snippit of a tutorial I downloaded. It might provide some insight into part 1 of your question:

One function, called LEFT, lets us tell MySQL to display up to a maximum of some specific number of characters when displaying a column. For example, let's say we wanted to see only the first 20 characters of the JokeText column:

mysql> SELECT ID, LEFT(JokeText,20), JokeDate FROM Jokes;

|+----+----------------------+------------+|
ID | LEFT(JokeText,20) | JokeDate

|+----+----------------------+------------+
|1 | Why did the chicken | 2000-04-01
|+----+----------------------+------------+
1 row in set (0.05 sec)

the original JokeText column said" Why did the chicken cross the road?" and using the LEFT function you can limit your queries. Now getting that into PHP...I can not help you with. 🙁

JakesSA

Thanks, but I need more the PHP side of things, rather than SQL

barand

Try [man]substr[/man]

raymie

I replied to this question on another forum.

You do not really help yourself by posting the same question twice, it just wastes other peoples time.

cdbsi

Yeah, that wasn't very nice. 🙁