How to get column data from mysql db?

[vinaysnarayan]

Hi

 

I have 17 fields (columns) in a mysql table. I have 6 text boxes. I want to populate the text boxes with the column data after I click the submit button.

 

What query should I use?

 

If I use the query - "select `column_name` from `table_name`", its returning empty values.

How to do this? Please correct where i'm going wrong.

 

Thanks,

Vinay

[bloodgoat]

I've never worked with SQL before but I've learned a bit from threads... Wouldn't it make use of the asterisk as a wildcard? Something like:

SELECT * from COLUMNNAME

[fenway]

Say what?

[jkewlo]

<?
$sql="SELECT column_name, column_name, column_name, column_name, column_name, column_name FROM Table_name";
$result=mysql_query($sql);

while( $rows = mysql_fetch_array($result)){
echo "". $rows['column_name'] ."";
}
?>

that should do the trick, replace column_name with your column names you are trying to call, also the table name