How to get value of row in mySQL with specific Value in PHP

Question

I am trying to get a value of row with a specific value of a mySQL DB.

This is how my row looks like

row | email     | uuid | device
 1  | [email protected] |xxxxxx|iPhone
 2  | [email protected]|yyyyyy|iPod

So for example I want to get the uuid in row 2, I have the email.

This is how my mysql_query looks like:

$result = mysql_query("SELECT * FROM users WHERE email = '{$email}'");
    echo(mysql_result($result, 0)); #0 is email, but I need uuid, so 1

but I only can get the email.

Does anyone know how to get the uuid?

Please, use PDO or mysqli_* functions mysql_* are deprecated — CappY
– CappY, Commented Jan 17, 2014 at 22:24

Kermit · Accepted Answer · 2014-01-17 22:24:33Z

1

look into switching over to pdo or mysqli_. but otherwise why not:

 $result = mysql_query("SELECT * FROM users WHERE email = '{$email}'");
 while($row = mysql_fetch_array($result))
 {

      echo $row['uuId'] . "," . $row['email'] . "," . $row['device'] . "<br>";
      //or whatever data you want.
 }

edited Jan 17, 2014 at 22:24

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

answered Jan 17, 2014 at 22:22

bart2puck

2,5203 gold badges33 silver badges61 bronze badges

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

Comments

Abhik Chakraborty · Accepted Answer · 2014-01-17 22:21:19Z

0

You can use

while ($row = mysql_fetch_assoc($result)) {
    echo $row['email'];
    echo $row['uuid'];
    echo $row['device'];

}

BTW start using mysqli_* functions mysql_* functions are deprecated.

answered Jan 17, 2014 at 22:21

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

Collectives™ on Stack Overflow

How to get value of row in mySQL with specific Value in PHP

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