note 75013 deleted from function.mysqli-fetch-fields by tularis
| From: | tularis@php.net | Date: | Tue, 08 May 2007 17:10:38 +0000 |
| Subject: | note 75013 deleted from function.mysqli-fetch-fields by tularis | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-126334@lists.php.net to get a copy of this message | ||
Note Submitter: jcwebb at dicoe dot com
----
Need your columns as a string?
<?php
$q="SELECT * FROM SomeTable LIMIT 0,1";
$r=mysqli_query($DBlink,$q) or die(mysqli_error($DBlink)." Q=".$q);
$fieldlist=mysqli_fetch_fields($r);
$titles=''; foreach ($fieldlist as $v): $titles.=($v->name).','; endforeach;
$titles=substr($titles,0,-1);
echo $titles;
?>
Hope it helps, Jon