Query for data in a field

[Anon]

Hi Guys,
If i had the following query:

$result = mysql_query("SELECT * FROM $table ORDER BY url ASC LIMIT " . $start . ", 20");

how could i change the code so that it only gets the values from the url field that have a value. I assume i use the WHERE statement but what code do i use to check the url field for data?

Cheers,
maccam

[khaine]

try using

$result = mysql_query("SELECT * FROM $table WHERE url not like '' ORDER BY url ASC LIMIT " . $start . ", 20");

That should return all the values where the url is not blank.

Mark.