[quote author=brown2005 link=topic=123062.msg508214#msg508214 date=1169162562] $sql = "SELECT LEFT(websites_url, 1) AS 'websites_url_letter', websites_url FROM websites [b] WHERE websites_url_letter='$letter' [/b] ORDER BY websites_url ASC;"; hi it says #1054 - Unknown column 'websites_url_letter' in 'where clause' is there any way round this please? [/quote] $sql = "SELECT LEFT(websites_url, 1) AS 'websites_url_letter', websites_url FROM websites [b] WHERE LEFT(websites_url, 1)='$letter' [/b] ORDER BY websites_url ASC;"; or something like: $sql = "SELECT LEFT(websites_url, 1) AS 'websites_url_letter', websites_url FROM websites [b] WHERE websites_url LIKE '$letter%' [/b] ORDER BY websites_url ASC;";