Hi, I received a long bit of code from a PHP programmer that I am trying to get my head around. I'd like to understand what, for example, SELECT m.url, sc.name, sc.title FROM menu m means. Why is it not just SELECT url, name, title FROM menu. What is .sc and m?
SELECT m.url, sc.name, sc.title
FROM menu m
INNER JOIN static_content sc
ON m.name = sc.menu_name
WHERE m.name = "' . $pageid . '"
ORDER BY order_no ASC;
Many, many thanks,