> > $sql = 'SELECT id,ST FROM ccl.ccl_main';
> > ...
> > $news = mysql_query($sql);
> >  while ($mydata = mysql_fetch_object($news))
> >       {
> > if ???????$mydata->ST?????????
> >   echo "$mydata->id  -  $mydata->ST<hr>";
> >  }
> 
> Use strstr() with "\n" as the needle. Check out the "String functions" 
> chapter, lots more goodies there.

Or, try the following:

$sql = "SELECT id,ST FROM ccl.ccl_main where ST like '%s\n%s' ";

I am not 100% sure it will work with 'text' field, but it should.

Vincent Vandemeulebrouck


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to