[SOLVED] Retrieving SQL Field Names

[renj0806]

For example ive got a query:

SELECT * FROM userstable;

 

And my userstable have the ff fields:

-id

-username

-password

 

How can i retrieve the FIELD NAMES (id,username and password), not the data and put it in a php variable?

[skali]

You can use:

 

$query = 'SHOW COLUMNS FROM [table name]';

$rs = mysql_query($query);

 

which will list all the fields alongwith various details.

[renj0806]

What if i only want to show certain columns like when i do this query:

SELECT username, password FROM userstable;

[monk.e.boy]

I don't understand your question

 

$query = 'SHOW COLUMNS FROM [table name]';
$rs = mysql_query($query);

 

Did you run the above code and look at the results?

 

monk.e.boy

[renj0806]

Oh... im sorry. What i meant was if I only want the username and password to be retrieved. Not including the id.

 

Anyways, ive tried the query above and yes, i got all the fields and the details for each field. Now, how am i going to assign a variable to the field name only.

[ToonMariner]

'SHOW COLUMNS FROM [table name]'

 

will return a result set of info about the table to see the resulst do this...

<?php

$query = 'SHOW COLUMNS FROM [table name]';
$rs = mysql_query($query);

while ($row = mysql_fetch_assoc($rs))
{
print_r($row);
}

?>

[renj0806]

'SHOW COLUMNS FROM [table name]'

 

will return a result set of info about the table to see the resulst do this...

<?php

$query = 'SHOW COLUMNS FROM [table name]';
$rs = mysql_query($query);

while ($row = mysql_fetch_assoc($rs))
{
print_r($row);
}

?>

 

Yep, I saw the results. What i want now is how to assign a variable for the field name only, not including all those other stuff like the field type.

[ToonMariner]

just pick out the 'Field' element from the array...

 

<?php

$query = 'SHOW COLUMNS FROM [table name]';
$rs = mysql_query($query);

$field = array();
while ($row = mysql_fetch_assoc($rs))
{
$field[] = $row['Field'];
}

?>

 

that will give you an array of all the fields.

 

[renj0806]

That is what i wanted. Thanks!