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.
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.
Jump to Post$sql = "SELECT * FROM $tableName WHERE cata <> 'abc' ORDER BY times DESC LIMIT $start, $limit";
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.
$sql = "SELECT * FROM $tableName WHERE cata <> 'abc' ORDER BY times DESC LIMIT $start, $limit";
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.