List users with / without information - help!

smad

Hello everyone. I hope someone can help me, I am a beginner in PHP.

I don't have any code right now to post, so please help me based on what I write.
I have two tables, computers and users. Each computer can have a user assigned to it. I want to display all users in the table and if the have a computer assigned to them, display that one too, if not leave blank. Ex:

user1 | pc1

user2 | blank

user3 | pc2

I have tried doing this via two loops. The first one (for) loops through the users db, the second one (inside the first one), loops through the computer db and checks if the userid in the user table matches the userid in the computer table.

It doesn't work right. It works only for the first row, it doesn't want to display the information. It seems that the inner loop works only once, for one single value passed from the outer loop and spews out all the results. Ex:

user1 | pc1 blank pc2

user2 | nothing

user3 | nothing

Can you please give me ANY SUGGESTIONS on how this can be done? I will try to post my code later this afternoon.

Thank you.

Shrike

If tables look something like this

user_id
username

computer_id
user_id
computername

The following query should select all computers which a given user uses, and present them in one record.

"SELECT users.username FROM users INNER JOIN computers.computername ON users.user_id = computers.user_id";

(assuming that only one user can be assigned to a computer).

I'm not at home right now though so can't test this 🙂

laserlight

What is the relationship between users and computers?

smad

The database is like you wrote it. The relationship is one to one. I am trying to display all users and if they have a computer assigned to them, print it too, if not, leave it alone.

Shrike

For MySQL:

$qry = "SELECT users.username FROM users INNER JOIN computers.computername ON users.user_id = computers.user_id";
$res = mysql_query($qry);
while($data = mysql_fetch_assoc($res)){
  echo implode(" ", $data) . "<br>";
}

You might need to do some manipulation of the array to add any specific string formatting.