simple question (order by)

[markman641]

How do i make the following:

$get_name = mysql_query("SELECT `id`, `name`, `link`, `value`, `description` from `offers` WHERE `countries` like '%us%' LIMIT 0, 25");

How do i make that sort by ID from largest number to smallest number? idk where to put the order by

[Old Pedant]

ORDER BY is always the *last* thing other than LIMIT. (Well, except for some esoteric options you are not likely to ever need.)

To sort from low to high, you use ORDER BY fieldname ASC
To sort from high to low, you use ORDER BY fieldname DESC

Except that ASC is optional, and is the default if DESC is not coded.

Here, read the docs:
http://dev.mysql.com/doc/refman/5.5/en/select.html

[guelphdad]

SELECT
FROM
WHERE
GROUP BY
HAVING
LIMIT

as a quick reminder of the syntax order (for most uses)

[Old Pedant]

Ummm...and ORDER BY?

SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT

[guelphdad]

Well yeah i should have included that but you had specifically told the OP where Order By clause went OP.