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