SQL Extract table field

Marty · **SQL Extract table field -** 06-05-2005, 02:01 PM

Hi guys iam looking for a sql command/line of text, to print a certain field's content from a database table, results back in the query box etc.. ?

Any ideas much appreciated
Marty

Mighty_Y · 06-05-2005, 02:15 PM

first you select the value from the database, then you can add it in the textarea by using this

Code:

<textarea>$variable_containing_the_value_to_be_printed_in_the_box</textarea>

I hope this is what you meant, and I hope it helps you

Marty · 06-05-2005, 02:35 PM

Well firstly thanks for the reply, but no its not actually what I was looking for, my fault probably, didnt explain enough.

What I have a is Database with various tables, one of the tables has various fields the usually kinds, as they all do etc..

The table is just under 4mb, theres no problem exporting it as a text.sql file however iam only looking for one field within that table "User_ID"

Theres 6000+ lines along with all the other entries so I dont really want to start manually editing the file, just to get the User_Id's I was hoping there would be a SQl command that could be used within phpMyadmin , something that would extract the field data ?

Mighty_Y · 06-05-2005, 02:47 PM

Ah you want an sql file that only has the USer_ID information??
I don't think that is possible, but I can check it out.
You can always get all the user_id's out of the table with a php script and then output it on your screen.

Mighty_Y · 06-05-2005, 02:51 PM

Nope, you can only export a table in a whole not the fields seperatly (which is actually really logic).
So if you want a list from all your user_id's I suggest printing them with a php script.

Marty · 06-05-2005, 03:06 PM

Ok thanks for looking into it...

Marty · 06-05-2005, 04:27 PM

Oh I have been so stupid, here we go

Quote:

SELECT USER_ID
FROM table_name

Thats it, so simple :wink: