How to sort data mysql in php syntax

Question

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\techponya\index.php on line x

<?php 
$sql2 = "SELECT * FROM artikel WHERE kategori='technews' DESC() LIMIT 5";
$hasil2 = mysql_query($sql2,$dbconn);
while ($techponya = mysql_fetch_array($hasil2)){ 
?>

Your SQL query is wrong. just try to get the query alone working in something like PHPmyAdmin and then insert it into your code. First question you should ask yourself: How should the database know by which column to sort ... — Sirko
– Sirko, Commented Jun 22, 2016 at 7:56
Are you forced to work with mysql_* functions ? Because you should consider using latest secure mysql driver such as PDO or MySQLi. — Anwar
– Anwar, Commented Jun 22, 2016 at 7:58
Please head to the manual page for mysql_query() and scroll down the do not use this extension warning to "Example #1". There's a simple usage example. — Álvaro González
– Álvaro González, Commented Jun 22, 2016 at 8:11
What Alex said :) But best to avoid using [mysql_fetch_array ](php.net/manual/en/function.mysql-fetch-array.php) as it is deprecated, use mysqli_fetch_array instead. — Ali
– Ali, Commented Jun 22, 2016 at 14:19

Alex · Accepted Answer · 2016-06-22 07:57:20Z

2

your mysql_query is returning an error, to order just use ORDER BY your_field_name DESC instead of DESC()

answered Jun 22, 2016 at 7:57

Alex

5663 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Death-is-the-real-truth · Accepted Answer · 2016-06-22 08:14:06Z

0

1.Stop using deprecated (From php 5 version onwards)+removed(From php 7) mysql_*. Use mysqli_* OR PDO

2.Use ORDER BY along with DESC:-

<?php 
  $sql2 = "SELECT * FROM artikel WHERE kategori='technews' ORDER BY <write your column name here> DESC LIMIT 5";
  $hasil2 = mysql_query($sql2,$dbconn);
  while ($techponya = mysql_fetch_array($hasil2)){
    // do some stuff 
  }
?>

3.Also always do error checking code stuff too.

reference:-

http://www.w3schools.com/php/php_ref_mysqli.asp

edited Jun 22, 2016 at 8:14

answered Jun 22, 2016 at 8:00

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

Collectives™ on Stack Overflow

How to sort data mysql in php syntax

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related