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 retr

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 (my

[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($resul