Hi all,
If i have the following query:
$result = mysql_query ("SELECT * FROM $table WHERE url != '' GROUP BY url HAVING COUNT(url) > 1");
...at the moment it is getting duplicate url values from the url field in the db and displaying those that are. This all works fine but what i want to do is get the [scheme] and [host] part of the url value only? (ie http://url.com)
Any ideas?
Cheers,
micmac
