Need some SQL help

[Cliphead]

I'd be forever grateful and would love to buy a pint or two for anyone who can help me out with this. I know zip about SQL.

I have a web app using Postgres as the backend. I've installed phpPgAdmin on the web server so I can look but not touch anything in there.

I want to do a simple listing of all the users but I need to query two tables, one holds the username, first and last names, the other holds email and home address etc.

I know this is likely very simple to do but I haven't got a clue

 

[NickFitz]

I'd be forever grateful and would love to buy a pint or two for anyone who can help me out with this. I know zip about SQL.

I have a web app using Postgres as the backend. I've installed phpPgAdmin on the web server so I can look but not touch anything in there.

I want to do a simple listing of all the users but I need to query two tables, one holds the username, first and last names, the other holds email and home address etc.

I know this is likely very simple to do but I haven't got a clue

Presumably the username is used as a key in the table that holds the details? Or is there a numeric field, probably called "id", and a corresponding numeric field, probably called "user_id", in the second field?

As those questions might suggest you really need to explicitly state what the structure of the tables is (and indeed their names), but this might get you started:

SELECT user.username, user.first_name, user.last_name, user_info.email
FROM user, user_info
WHERE user.id = user_info.user_id

or, if the username is used as the key,

SELECT user.username, user.first_name, user.last_name, user_info.email
FROM user, user_info
WHERE user.username = user_info.username

 

[Cliphead]

Presumably the username is used as a key in the table that holds the details? Or is there a numeric field, probably called "id", and a corresponding numeric field, probably called "user_id", in the second field?

As those questions might suggest you really need to explicitly state what the structure of the tables is (and indeed their names), but this might get you started:

SELECT user.username, user.first_name, user.last_name, user_info.email
FROM user, user_info
WHERE user.id = user_info.user_id

or, if the username is used as the key,

SELECT user.username, user.first_name, user.last_name, user_info.email
FROM user, user_info
WHERE user.username = user_info.username

Yes, the first example was bang on and got it working for me.

You're a star Nick, I owe you for this one!

 

[NickFitz]

Yes, the first example was bang on and got it working for me.

You're a star Nick, I owe you for this one!

HTH

 

[Cliphead]

HTH

I sorta knew how the query should be structured but not the actual syntax. This stuff is a long way from Clipper

Thanks again!

 

[BrilloPad]

I'd be forever grateful and would love to buy a pint or two for anyone who can help me out with this. I know zip about SQL.

I have a web app using Postgres as the backend. I've installed phpPgAdmin on the web server so I can look but not touch anything in there.

I want to do a simple listing of all the users but I need to query two tables, one holds the username, first and last names, the other holds email and home address etc.

I know this is likely very simple to do but I haven't got a clue

try "drop table user"

HTH

 

[Cliphead]

try "drop table user"

HTH

I already did that, the backup script worked

 

[BrilloPad]

Have you allowed for this?

http://benajnim.com/index.php/php/sanitizing-user-input-in-php/

 

[Cliphead]

Have you allowed for this?

http://benajnim.com/index.php/php/sanitizing-user-input-in-php/

Excellent!

 

[BrilloPad]

Excellent!

I sent this to the dbas at clientco - they did not so much as laugh. either they have seen it several times before or are humourless ****s