Getting the right amount of info

[Studebaker]

Is there a way to query a database field with type "text" in such a way that you only receive a certain amount of characters (such as the first 200 characters in a description)?

[Roger_Ramjet]

Yes use LEFT(column, length) in your select

[Studebaker]

Okay. I used the LEFT() directive in my query, but the entire contents of the field were displayed. Here's the code:

	$result = mysql_query("SELECT linkid, posid, jobname, imgsrc, LEFT(imgdescrib, 10)
						   FROM imagetest 
						   WHERE posid = '$posid'");

Let me know if I did this correctly.

[Roger_Ramjet]

Looks OK to me, although I would have used 'LEFT(imgdescrib, 10) AS ....' myself (old habit from access). Can't think why it did not work.