i have just had to go into the backend of an old site to fix the mysql db as some had deleted the wrong db. i have got most of it working again now but did not know what this line of code is doing.
$sql = "SELECT id,thumb,image,designer,title,(total/freq) AS score FROM shirts ORDER BY score DESC";
i know it is telling it to select the information out of the table and from which table but i have not used the AS condition before and i cannot find an explanation of this anywhere.
if someone could point me in the direction of a good explanation of how this condition effects the sql statement that would be great