Returning column names from a mySQL table using PHP

Bowser23

New Member
Can't figure this out for the life of me. Trying to return the column names from the clients securities table, then return the result as an array. Can anybody point out where I'm getting off track?\[code\]mysql_select_db("HandlerProject", $con); //Selects database $selectcols = "SELECT * FROM ".$clientname."securitiestable"; //selects all columns from clients security table $tempcols = mysql_query($selectcols) or die(mysql_error()); $returnedcols = $mysql_fetch_array($tempcols); $tempsymbol = mysql_query("SHOW COLUMNS FROM".$clientname."securitiestable"); $symbol = $mysql_fetch_array($tempsymbol);\[/code\]
 
Back
Top