php loop?

[pouncer]

i have a table called 'dvds'

 

can someone show me a loop to echo all the field names and their data type (like INT, VARCHAR etc)?

[Daleeburg]

untested code, but this may work

 

<?php

Require('connect.db');

$query = "SELECT * FROM dvds ";
$results = mysql_query($query) OR DIE("Error In DataBase");
$num = mysql_num_fields($results);
$i = 0;
while ($i < $num) {

$type  = mysql_field_type($result, $i);
$name  = mysql_field_name($result, $i);

echo $name;
echo $type;

$i++;
};
?>

[utexas_pjm]

<?php
$sql = 'DESCRIBE dvds';
?>

 

Then use `Field` and `Type` as the column names.

 

Patrick

[pouncer]

<?php
$sql = 'DESCRIBE dvds';
?>

 

Then use `Field` and `Type` as the column names.

 

Patrick

 

hmm mate, do i need a loop or anything? what about the mysql_query ?

[utexas_pjm]

hmm mate, do i need a loop or anything? what about the mysql_query ?

 

Of course:

 

<?php
$link = mysql_connect('localhost', 'username', 'password') or die('Could not connect: ' . mysql_error());
mysql_select_db('database') or die('Could not select database');

$query = 'DESCRIBE pm_imps';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   echo $line['Field'] . ' '.$line['Type'].'<br />' ;
}

mysql_free_result($result);
mysql_close($link);
?> 

 

Best,

 

Patrick