PHP SQL Select From Where

Question

I am having some difficulty running some SQL code.

What I am trying to do is, find a row that contains the correct username, and then get a value from that correct row.

This is my SQL in the php:

mysql_query("SELECT * FROM users WHERE joined='$username' GET name")

As you can see, it looks for a username in users and then once found, it must GET a value from the correct row.

How do I do that?

It's just a sample, as I am saying I want to GET the value of name. — Christopher
– Christopher, Commented Aug 16, 2012 at 9:00

mimicocotopus · Accepted Answer · 2012-08-16 08:58:33Z

18

You need some additional PHP code (a call to mysql_fetch_array) to process the result resource returned by MySQL.

$result = mysql_query("SELECT name FROM users WHERE joined='$username'");

$row = mysql_fetch_array($result);

echo $row['name'];

answered Aug 16, 2012 at 8:58

mimicocotopus

5,6804 gold badges24 silver badges24 bronze badges

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

Comments

Fluffeh · Accepted Answer · 2012-08-16 08:56:51Z

3

mysql_query("SELECT `name` FROM users WHERE joined='$username' ")

Just select the right column in your 'select clause' like above.

Edit: If you are just starting out though, you might want to follow a tutorial like this one which should take you through a nice step by step (and more importantly up to date functions) that will get you started.

answered Aug 16, 2012 at 8:56

Fluffeh

33.6k16 gold badges69 silver badges80 bronze badges

4 Comments

codeling Over a year ago

a hint for avoiding sql injection would be nice ;)

asprin Over a year ago

@nyarlathotep that would be too overwhelming for OP. He/She is not yet familiar with mysql syntax.

Fluffeh Over a year ago

@nyarlathotep Good point. Answer edited with a link to a nice step by step and in depth tutorial.

codeling Over a year ago

@aspirin: the concept can never be mentioned early enough - i would say as soon as DB access is involved it should be a topic ;) I agree, though, that solving the problem with syntax is more important. that's why I wrote "a hint [...] would be nice" ;)

Nico Haase · Accepted Answer · 2018-10-10 12:59:53Z

2

mysql_query("SELECT name FROM users WHERE joined='$username'")

edited Oct 10, 2018 at 12:59

Nico Haase

12.1k38 gold badges48 silver badges96 bronze badges

answered Aug 16, 2012 at 8:57

IEnumerable

3,85015 gold badges52 silver badges80 bronze badges

Comments

asprin · Accepted Answer · 2012-08-16 08:59:33Z

1

$q = mysql_query("SELECT * FROM users WHERE joined='$username'");

$r = mysql_fetch_array($q);

$name = $r['user_name']; // replace user_name with the column name of your table

answered Aug 16, 2012 at 8:59

asprin

9,85312 gold badges72 silver badges127 bronze badges

Comments

elo · Accepted Answer · 2012-08-16 08:59:59Z

1

mysql_query("SELECT name FROM users WHERE joined='$username' ")

Read documentation : http://dev.mysql.com/doc/refman/5.0/en/select.html

answered Aug 16, 2012 at 8:59

elo

6154 silver badges11 bronze badges

Collectives™ on Stack Overflow

PHP SQL Select From Where

5 Answers 5

Comments

4 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

4 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related