php mysql add * to SELECT statement

Question

How can I make something like this (add something to a SELECT command):

 $query = "SELECT a.name,a.surname,b.email,c.phone 
           FROM users as a 
           inner join users_email as b 
           inner join users_phone as c
           WHERE a.id=b.id AND a.id=c.id";

 $query .= "ORDER BY a.surname";  

 $result = mysql_query($query,$con);

The result should be:

$query = "SELECT a.name,a.surname,b.email,c.phone 
          FROM users as a 
          inner join users_email as b 
          inner join users_phone as c
          WHERE a.id=b.id AND a.id=c.id
          ORDER BY a.name";   

$result = mysql_query($query,$con);
$row=mysql_num_fields($result)

...but it gives an error: mysql_num_fields() expects parameter 1 to be resource, boolean given in C:\xampp-portable\htdocs\db\file.php on line 32...

Why does it say `mysql_num_fields()` when you are using `mysql_query` in your code? — Derk Arts, Mar 07 '13 at 13:14

score 4 · Accepted Answer · edited May 25 '19 at 14:27

4

Always give a space when you concate your query.

 $query = "SELECT a.name,a.surname,b.email,c.phone 
           FROM users as a 
           inner join users_email as b 
           inner join users_telefon as c
           WHERE a.id=b.id AND a.id=c.id ";

 $query .= " ORDER BY a.prenume";
            ^

Also have a practice of mysql_error().

$result = mysql_query($query,$con) or die(mysql_error());

Note: Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO, or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

edited May 25 '19 at 14:27

Zoe

27,060
21
118
148

answered Mar 07 '13 at 13:12

Rikesh

26,156
14
79
87

And if I want to do something more dynamic like: `$query .= " ORDER BY " . $_GET['orderby'] . ;` ??? – wwwglro Mar 07 '13 at 13:58
@wwwglro - Yes you can do that. `$query .= " ORDER BY " . $_GET['orderby'];`. – Rikesh Mar 07 '13 at 14:00

score 2 · Answer 2 · answered Mar 07 '13 at 13:12

2

Add space after

WHERE a.id=b.id AND a.id=c.id";

so it should be:

WHERE a.id=b.id AND a.id=c.id ";

answered Mar 07 '13 at 13:12

Aleks

4,866
3
38
69

score 2 · Answer 3 · answered Mar 07 '13 at 13:12

try this:

$query = "SELECT a.name,a.surname,b.email,c.phone 
           FROM users as a 
           inner join users_email as b 
           inner join users_telefon as c
           WHERE a.id=b.id AND a.id=c.id";

 $query .= " ORDER BY a.prenume";  

 $result = mysql_query($query,$con);

a 'space' is required before Order By

score 1 · Answer 4 · answered Mar 07 '13 at 13:15

1

$query = "SELECT a.name,a.surname,b.email,c.phone 
          FROM users as a 
          inner join users_email as b ON a.id=b.id
          inner join users_telefon as c ON a.id=c.id
          ORDER BY a.name";

answered Mar 07 '13 at 13:15

gabrielbuzzi

343
1
3
15

score 0 · Answer 5 · answered Mar 07 '13 at 13:11

0

It shold be

 $query .= " ORDER BY a.prenume order(asc/desc)";

insetad of

 $query .= "ORDER BY a.prenume";

and you need to give space before ORDER BY

answered Mar 07 '13 at 13:11

GautamD31

28,552
10
64
85

That does not make any sense, mysql defaults to ASC. Furthermore, the error corresponds to something else (mysql_num_fields) – Derk Arts Mar 07 '13 at 13:12
And I wrote it giving space also....?? – GautamD31 Mar 07 '13 at 13:17

php mysql add * to SELECT statement

5 Answers5