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

  • 2 Contributors
  • 2 Replies
  • 111 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by begueradj
Member Avatar for paulrajj 
$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.