Member Avatar

Hello guys!

"SELECT * FROM $tableName WHERE cata != 'abc' AND ORDER BY times desc LIMIT $start, $limit";

Is there any reason as to why this block is not working? What is the rule for formating such queries?

Thanks.

  • 2 Contributors
  • forum 2 Replies
  • 49 Views
  • 14 Hours Discussion Span
  • comment Latest Post Latest Post by pritaeas

Recommended Answers

Answered by pritaeas 2,045 in a post from 
$sql = "SELECT * FROM $tableName WHERE cata <> 'abc' ORDER BY times DESC LIMIT $start, $limit";
Jump to Post

All 2 Replies

Member Avatar

Hello guys!

"SELECT * FROM $tableName WHERE cata != 'abc' AND ORDER BY times desc LIMIT $start, $limit";

Is there any reason as to why this block is not working? What is the rule for formatting such queries?

Thanks.

Edit: Should inform that I want to retrieve all the items of a database, 'cept for those who has 'abc' in their cata(catagory) item. Then order it after date.

All that work, 'cept for the "Where cata != 'abc'" implementation.

Member Avatar 
$sql = "SELECT * FROM $tableName WHERE cata <> 'abc' ORDER BY times DESC LIMIT $start, $limit";
Be a part of the DaniWeb community

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

Sign Up — It's Free!