[SOLVED] is there a way...

[paulman888888]

Is there a way to echo out all the data in a mysql table?

 

Thankyou

[dezkit]

yes

[paulman888888]

and can you tell me please?

[dezkit]

<?php
mysql_connect("localhost", "", "") or die(mysql_error());
$query = "SELECT * FROM example"; 

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
echo $row['table_name'];
echo "<br>";
}
?>

 

 

lol

[discomatt]

$q = 'SELECT * FROM `table`';
$r = mysql_query($q);

while ( $row = mysql_fetch_assoc( $r ) )
    echo implode( ', ', $row ) . '<br />';

 

Check manual next time please. Plenty of basic questions are answered with examples shown.

[rhodesa]

as an html table:

 

$result = mysql_query("SELECT * FROM tablename");
print '<table>';
while($row = mysql_fetch_assoc($result)){
  print '<tr><td>'.implode('</td><td>',$row).'</td></tr>';
}
print '</table>';

[paulman888888]

thankyou