[help on sql statement]

[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;";

[Need help with Cookies]

Why don't you set values to session variables?
$_SESSION["preuserID"] = $preuserid;
$_SESSION["prePassword"] = $password;

and add something like: ini_set("session.gc_maxlifetime", "18000");  before session_start()...

[Plz, give me some critique about...]

Plz, give me some critique about [url=http://www.topworst.com/]http://www.topworst.com/[/url].
I want to get everyone's feedback.
Thanks for taking the time