[mahmoud82]

hi,

PHP Code:

 $article_query=$mysql_conn->query("select `articles_tbl`.`ArticleID`,`articles_tbl`.`Title`,`articles_tbl`.`Date`,`articles_tbl`.`Thumb`,`articles_tbl`.`Author`,`articles_tbl`.`Views`,LEFT(articles_tbl.Text, 1200) TEXT,`categories_tbl`.`Private` from `categories_tbl` INNER JOIN `articles_tbl` ON(`articles_tbl`.`CatID`=`categories_tbl`.`CatID`) where `articles_tbl`.`Active`='1' order by `articles_tbl`.`Date` DESC LIMIT 5") or die(mysql_error()); 

this select statment return a 1200 char but i want to be more dynamic by select the character until the select fount ? at the Text so the user insert the article and he will decided how many character he want to display at the home page when he put the ? at the article so the select statment will stop when it found this (?)
can anyone help me.

[UnrealEd]

SELECT 
  articles_tbl.ArticleID, 
  articles_tbl.Title, 
  articles_tbl.Date, 
  articles_tbl.Thumb, 
  articles_tbl.Author, 
  articles_tbl.Views, 
  SUBSTRING_INDEX(articles_tbl.Text, '?', 1) TEXT, 
  categories_tbl.Private 
FROM 
  categories_tbl
INNER JOIN 
  articles_tbl
ON (
  articles_tbl.CatID=categories_tbl.CatID
) 
WHERE 
  articles_tbl.Active=1 
ORDER BY 
  articles_tbl.Date
DESC LIMIT 5 

this should do. For more information about SUBSTRING_INDEX, have a look at this page:
http://dev.mysql.com/doc/refman/5.0/...ubstring-index

PS: you don't have to wrap the tablenames and fieldnames in `, you only have to do so when the names are reserved keywords (but you should avoid using such names)

[mahmoud82]

thanx man this is just fine.