selecting from coulmns...

brcolow

Ok, i know how to select from tables like..

select * from users WHERE id='$id'

BUT, how do i make it so after it chooses that table, it chooses a coulmn too?

And when i saw this i am not using that line, i just dont know how to make it where like... WHERE coulmn equals itself??? its kind of hard to explain but mabye you know what Im getting at, i just want a varible to be defined as that coulmn name, so i need to know how to make it so WHERE id ????

sfhc

Your question makes no sense, try again...

brcolow

in a query, i want to select a coulmn called user_posts. Then, i want to call upon it later in my script so, $posts="connecting and stuff, then i need to sleect the coulmn so that will be the posts varible, get it?

crickettdt

To select a colum/field in your database, SELECT table_name.column_name FROM table_name

Be advised, if you are only querying 1 table, you don't need to specify the table_name before each column.

brcolow

Im not sure i understand why you select the tablename and the coulmnname, and then select it in the FROM again, could u please write a little thing so I can see how it is, because I dont understand why you select it twice...

crickettdt

When you query a database, you can query multiple tables. So if you had a table called Table_1 and Table_2, to get colum1 from Table_1, you would write a query like:

SELECT Table_1.colum1 FROM Table_1

If you wanted to select columnq from both tables, you would write:

SELECT Table_1.column1, Table_2.column1 FROM Table_1, Table_2

You only need to specify the table if you are selecting from more than 1 table.

The sql syntax is:

SELECT table.column FROM table WHERE table.column = table.column

where you substitute your table and column names.

I hope this has helped.

Feel free to email me directly with the problem, as i am always willing to help.

philipolson

Please bookmark and read these: