Member Avatar for begueradj

Hi people,

I get an error when performing the following request:

$query=" SELECT * FROM vessel,cargo,customer ORDER BY ladate DESC WHERE vessel.id=cargo.id AND vessel.id=customer.id LIMIT $eu, $limit";

it is about the ORDER BY ladate DESC

Can you you show me where I should write ORDER BY in the correct position ?

Begueradj

Recommended Answers

All 2 Replies

$query=" SELECT * FROM vessel,cargo,customer WHERE vessel.id=cargo.id AND vessel.id=customer.id ORDER BY ladate DESC LIMIT $eu, $limit";
Member Avatar for begueradj
$query=" SELECT * FROM vessel,cargo,customer WHERE vessel.id=cargo.id AND vessel.id=customer.id ORDER BY ladate DESC LIMIT $eu, $limit";

Thank you a lot, it works !!!!!

begueradj, Algeria

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.