Jump to content

selecting a column


Ph0enix

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
Link to comment
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.
Link to comment
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?
Link to comment
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'";
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.