fetch mysql information based on column value

Question

Is there a way to run a mysql $query and specify and order by the value within a column. so if you have a table with column:name, and there are 2 people with the name 'john' but the first john has 'id':10 and the second john has 'id':20. I want to echo the first john(10) first. so something like:

  $sql = mysql_query("SELECT firstname FROM users 
                   WHERE email='$email' 
                   AND id='(*smallest value*)'");

  while($info = mysql_fetch_assoc($sql))
  echo $info['firstname']

I believe you need to use the order by clause

reggie
– reggie

2012-07-31 13:11:59 +00:00
Commented Jul 31, 2012 at 13:11 — reggie
– reggie, Commented Jul 31, 2012 at 13:11

Fluffeh · Accepted Answer · 2012-07-31 13:10:59Z

1

SELECT firstname FROM users WHERE email='$email' order by id asc limit 1

answered Jul 31, 2012 at 13:10

Fluffeh

33.6k16 gold badges69 silver badges80 bronze badges

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

Comments

Bhuvan Rikka · Accepted Answer · 2012-07-31 13:12:02Z

1

Try

SELECT firstname FROM users WHERE email='$email' order by id asc limit 1

answered Jul 31, 2012 at 13:12

Bhuvan Rikka

2,7031 gold badge19 silver badges28 bronze badges

Comments

Jerska · Accepted Answer · 2012-07-31 13:13:48Z

0

 $sql = mysql_query("SELECT firstname FROM users 
               WHERE email='$email' 
               ORDER BY id ASC");

will give you the John(10) before the John(20).

 $sql = mysql_query("SELECT firstname FROM users 
               WHERE email='$email' 
               ORDER BY id ASC
               LIMIT 1");

will give you only John(10).

answered Jul 31, 2012 at 13:13

Jerska

12.1k4 gold badges38 silver badges54 bronze badges

Collectives™ on Stack Overflow

fetch mysql information based on column value

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related