Got the hard copy.

How do i get the hard copy please ?

tundewoods:


I actually need a chapter that touches how to write a mysql query statement for limiting character output or result.

Is that all you need?One could just type that out here-and that would solve the problems.

smartsoft:

How do i get the hard copy please ?

Let's wait and see if someone's got the pdf-that would be easier to transfer.
But if u really want the hard copy-you can order from their site,sitepoint.com.
Dont know if you can get in Nigeria.Mine was bought from a bookshop in London.

If I got you right,I think what you want is a query that will pull out
the first few words of a particular field(joketext) from the database
and then you provide the reader/user a "read more" link that will
pull out the full story.If that is the case,you'll use the LEFT function
on the field(e.g joketext) you want to limit in the SELECT query.
Something like this:

"SELECT joke_id,joke_title,LEFT(joke_text,75) FROM JOKES WHERE date > '2007-12-01'";

This will select among other things the first(leftmost) 75 characters of joke_text from the JOKES table satisfying the stated date condition.

Hope that helps.