[SOLVED] Infanite while Loop

[NArc0t1c]

Hello.

 

I'm trying to make a script that will show all rows and columns in the specific table.

It is actually sort of alike a tutorial, to test your mysql queries.

 

I have different about of column's in each table, as well as rows.

My question is, how can I Do this, phpMyAdmin has a perfect example of this, but how can I do this?

 

My current scripting for this is the following:

$c = mysql_pconnect('localhost','root','');
while($qr = mysql_fetch_assoc(mysql_query($cmd,$c))) {
foreach($qr as $q => $r) {
		echo '[' . $q . '] => ' . $r . '<br>';
}
        echo "\n";
}

 

The problem with that is, it shows the first row, but repeats in for an infinity.

Also please note that it should not use any html elements, because I would like it to be run trough the php executable.

The output should be similar to:

[id] => 1
[name] => John
[last] => Doe

[id] => 2
[name] => Jane
[last] => Doe

 

Thanks!

[NArc0t1c]

Bah..

 

$query = mysql_query($cmd,$c);
while($qr = mysql_fetch_assoc($query)) {
foreach($qr as $q => $r) {
		echo "[" . $q . "] => " . $r . "\n";
}
        echo "\n";
}

 

 

[aschk]

I was about to ask what $cmd was....