[PHP] Text into a url

2003-09-13 Thread Tom Wollaston
Hi I am havening a problem retrieving url from a mysql database. I have the url's stored as text and am using the following code to retrieve them $query = SELECT name,url FROM clubs WHERE url'' ORDER BY name; $result = @mysql_query($query) or die (Query failed); if (mysql_num_rows($result)

Re: [PHP] Text into a url

2003-09-13 Thread John W. Holmes
Tom Wollaston wrote: Hi I am havening a problem retrieving url from a mysql database. I have the url's stored as text and am using the following code to retrieve them $query = SELECT name,url FROM clubs WHERE url'' ORDER BY name; $result = @mysql_query($query) or die (Query failed); if

Re: [PHP] Text into a url

2003-09-13 Thread daniel
$query = SELECT name,url FROM clubs WHERE url'' ORDER BY name; ?? could it not be $query = SELECT name,url FROM clubs WHERE url != ORDER BY name; Hi I am havening a problem retrieving url from a mysql database. I have the url's stored as text and am using the following code to retrieve