Quick question!

[aznjay]

What is the code or expression for displaying data from SQL...not the table

 

<?php

$dbhost = 'localhost';

$dbuser = '*******';

$dbpass = '*******';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = '*******';

mysql_select_db($dbname);

?>

 

 

how do you display the data under the main sql dbname???

[iShaun]

I'm not understanding the question? Are you talking about grabbing an entire table?

[redarrow]

 

Show database table..........

<?php
$mysql_access = mysql_connect("localhost", $user, $pw);
mysql_select_db($db, $mysql_access);

$result = mysql_query("SHOW tables", $mysql_access);
  while($row = mysql_fetch_row($result))
  {
      print("$row[0]<br>");
  }
?>

 

 

[Maq]

If redarraow didn't answer your question, could you be more specific than:

 

how do you display the data under the main sql dbname???

 

?

[aznjay]

 

Show database table..........

<?php
$mysql_access = mysql_connect("localhost", $user, $pw);
mysql_select_db($db, $mysql_access);

$result = mysql_query("SHOW tables", $mysql_access);
  while($row = mysql_fetch_row($result))
  {
      print("$row[0]<br>");
  }
?>

 

 

 

This is the question i'm asking =)

[Maq]

You mean, that's the answer you were looking for.  So this topic has been SOLVED.