PHP selecting from db to display username?

Question

So I'm trying to select the username from the users table BASED ON if they are in a gang.

Vars used.:

$member_gang = mysql_fetch_assoc(mysql_query("SELECT level,gangid,rating FROM user_stats WHERE id = '" . $_SESSION['user']['id'] . "'"));
$gang_info = mysql_fetch_assoc(mysql_query("SELECT * FROM gangs WHERE id = '".$member_gang['gangid']."'"));

And here's when I want to display it.

$getmembers = mysql_fetch_assoc(mysql_query("SELECT * FROM user_stats WHERE gangid = '" . $gang_info['gangid'] . "'"));

$displaymembers = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE id = '" . $getmembers['id'] . "'"));

echo 'One Member of this gang is: <b>'.$displaymembers['username'].' </b>:)';

(I do have db connection etc..) It's not echoing the username?!

EDIT: I am not that good at PHP, i don't understand prepared statements?

Any MySQL errors? Have you checked the intermediate results? — Sirko
– Sirko, Commented May 7, 2012 at 13:01
Why are you querying id like it was a atring. Is your id and gangid fields are strings? — s.webbandit
– s.webbandit, Commented May 7, 2012 at 13:03

Thargor · Accepted Answer · 2012-05-07 13:03:08Z

1

$gang_info['id']

not

$gang_info['gangid']

because you wrote above

"SELECT * FROM gangs WHERE id...."

and not

"SELECT * FROM gangs WHERE gangid..."

?

And why did you set the Ids in ' '? Are they strings? When not, change them to integer, thats a better solution for primary keys.

answered May 7, 2012 at 13:03

Thargor

1,89214 silver badges24 bronze badges

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

4 Comments

Brooke Flame Over a year ago

The row "gangid" is inside user_stats

Thargor Over a year ago

Yeah, but have you testet the change to $gang_info['id']? What shows a var_dump() of member_gang and gang_info and the other 2 arrays?

Thargor Over a year ago

Thats what i wrote, you must change id to: $getmembers = mysql_fetch_assoc(mysql_query("SELECT * FROM user_stats WHERE gangid = '" . $gang_info['id'] . "'")); and $displaymembers = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE id = '" . $getmembers['gangid'] . "'")); Or change your table structure, so that you have the same names for the ids in every tabel, not one times gangid and some times id (what is a worse name for a primary key)

Brooke Flame Over a year ago

but wait, i want to fetch more than 1 user that is in the same gangid from the user_stats table.. ;3

Collectives™ on Stack Overflow

PHP selecting from db to display username?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related