Jump to content

Archived

This topic is now archived and is closed to further replies.

Ph0enix

selecting a column

Recommended Posts

Hi, i know how to select a row of data by using this: $sql = "SELECT * FROM table ORDER BY id DESC";
But how do i select a whole column, so i would have the users name and their information.
And i would like for it to be displayed just simple like this:

Ph0enix England 14/03/1990 Male.

Could anyone help me to do this please?
Thanks

Share this post


Link to post
Share on other sites
Click on the [a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=31047&view=findpost&p=153359\" target=\"_blank\"]PHP F.A.Q.[/a] link. Find and read the [b]MySQL Data Retrieval[/b] section for example code of getting data from MySQL with error checking.

Share this post


Link to post
Share on other sites
wow theres a lot of stuff there. Thanks
But i find things easier to take in if you could tell me and give me an example cause im a noob.
[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]PHP Newbie Help[/quote]
Could you explain it please?

Share this post


Link to post
Share on other sites
a row goes this way <--------- -------------->

a column goes this way

/\
|
|

|
|
\/

this query:
$sql = "SELECT * FROM table ORDER BY id DESC";

will select everything both ways in your table, in reverse numerical order, ordered by id.

if you want to select just one row, based on the user's id, then do this:

select * from table where userid = '1'

this will, for instance, select all the information where the user's id is 1. the idea is to put a variable in place of the 1, in order to dynamically retrieve data from the database. for instance:

$id = 1;
$sql = "select * from table where userid = '$id'";

the "*" is a wildcard that selects all the column data in the row you are selecting. you can select individual colums by naming them instead of the * like so (assuming you have a column named username):

$sql = "select username from table where userid = '$id'";

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.