problem in query

can anybody give me query of current version of my sql of

$sql = "SELECT entries.*, catagories.cat FROM entries, catagories
WHERE entries.cat_id = catagories.id
ORDER BY dateposted DESC
LIMIT 1;";

i will be thankful.

Light Poster

48 posts since Nov 2011

Reputation Points: 5

Solved Threads: 2

INNER JOIN is what you looking for.

SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2
ON table_name1.column_name=table_name2.column_name

The Link below will give you a better understanding. http://www.w3schools.com/sql/sql_join_inner.asp

Light Poster

41 posts since Jan 2011

Reputation Points: 10

Solved Threads: 4

This question has already been solved

You