How to sorting in descending and ascending in sql?

Sorting in descending order in SQL

Descending

"select * from $dealtable where user_id='$uid' AND status='$status' ORDER BY ID DESC"

Ascending

"select * from $dealtable where user_id='$uid' AND status='$status' ORDER BY ID ASC"

Comments

How to use inner html value or data in php from javascript(innerHTML)?

use inner html value or data in php from javascript(innerHTML)? <html> <body> <p id="demo">use inner html value in php(innerhtml)</p> <script> var jassi = document.getElementById("demo").innerHTML; //document.write(jassi); </script> <?php $jassi = '<script>document.write(jassi);</script>'; echo $jassi; ?> </body> </html>

How to check date format in PHP?

Check date format in PHP function isCorrectDateFromat($date){ if(!empty($date)){ $dateString = $date; // Replace this with your date string $format = "Y-m-d"; // Replace this with your expected date format $dateTime = DateTime::createFromFormat($format, $dateString); if ($dateTime === false) { /* echo "The date is not in the correct format."; */ } else { $errors = DateTime::getLastErrors(); if (empty($errors)) { /* echo "The date is in the correct format."; */ return true; } else { /* echo "...

How to get all table names from database in wordpress?

Get all table names from database in wordpress. global $wpdb; $mytables=$wpdb->get_results("SHOW TABLES"); foreach ($mytables as $mytable) { foreach ($mytable as $t) { echo $t . "<br>"; } }

Php Tutorials

Search This Blog