[RESOLVED] Determine number of columns in first row of table

kiwibrit

I need to know the number of columns in a table.

I had thought that something along these lines would do it:

$i=0;

$dbh = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
mysql_select_db("mydatabase") or die ("Unable to select database!");



        $query = "SELECT * FROM aDatabaseTable";
        $result = mysql_query($query) or die ("Error in query: $query. " .
        mysql_error());
        while ($row = mysql_fetch_row($result))
        {
        foreach ($row[0] as $item)
        $counter=++$i;
        }
        echo $counter;

 mysql_close($dbh);

But it doesn't. I'd be grateful for help on this.

laserlight

Change to:
foreach ($row as $item)

kiwibrit

Thanks for looking at this.

Unfortunately,

foreach ($row as $item)

gives me the total number of fields in the table.

Effectively, what I need is the number of fields in the first row - ie row[0].

So if I could find a way of stopping the loop after the first row, I would have what I need.

laserlight

So if I could find a way of stopping the loop after the first row, I would have what I need.

Then dont loop, just call mysql_fetch_row() once.

kiwibrit

Yabbut - I can't figure a way of iterating through the row[0] fields, and so be able to count them. For that matter I can only display the first field in the row with this code, which I thought would have listed the entire row:

$row = mysql_fetch_row($result);
            echo '<li>' . $row[0]. '</li>';

thegoldenchild

Might be:

<?
$row = mysql_fetch_row($result);
extract($row);

echo '<li>' . $Variable1. '</li>'; 
echo '<li>' . $Variable2. '</li>'; 
echo '<li>' . $Variable3. '</li>'; 
echo '<li>' . $Variable4. '</li>'; 
echo '<li>' . $Variable5. '</li>'; 

?>

Depending on the fact if u used ASSOC or BOTH with the query.
EDIT: ur using BOTH nm 🙂

Another way might be like:

<?
$row = mysql_fetch_row($result);
extract($row);

echo '<li>' . $Row[1]. '</li>'; 
echo '<li>' . $Row[2]. '</li>'; 
echo '<li>' . $Row[3]. '</li>'; 
echo '<li>' . $Row[4]. '</li>'; 
echo '<li>' . $Row[5]. '</li>'; 

?>

In this way u can repeat it as many times as u like without a function()

jc94062

Hmmm

Number of columns in first row of table...

Well get the first row of the table using where id='1' or limit 1 etc.. and then use mysql_num_fields from here

kiwibrit

I got a bit desperate and went to another forum (webamsterworld)

This cracks it:

$result = mysql_query($query) or die ("Error in query: $query. " .
mysql_error());
$row = mysql_fetch_row($result);
$columnCount = count($row);
echo $columnCount;

Thanks to all for your interest.