> > $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