select question

[techker]

hey guys can i select all in a databases?

 

i want to show all tables created..

[gevans]

<?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>");
  }
?>

 

Never used this before but looks like what you need

[techker]

it dosnt work it gives me an access denied all the time..i have changed all the info to my server.

 

i removed to test $mysql_access and still nothing

 

 

 

[gevans]

<?
$showtablequery = "SHOW TABLES FROM [your database name here]";

$showtablequery_result  = mysql_query($showtablequery);
while($showtablerow = mysql_fetch_array($showtablequery_result))
{
        echo $showtablerow[0]."<br />";
}

?>

 

try it like that if you like, that may you dont have to worry about assigning your connection, just put your database name in the right place

[techker]

<?
$showtablequery = "SHOW TABLES FROM [your database name here]";

$showtablequery_result  = mysql_query($showtablequery);
while($showtablerow = mysql_fetch_array($showtablequery_result))
{
        echo $showtablerow[0]."<br />";
}

?>

 

try it like that if you like, that may you dont have to worry about assigning your connection, just put your database name in the right place

 

Warning: mysql_query() [function.mysql-query]: Access denied for user 'soul3438'@'localhost' (using password: NO) in /home/soul3438/public_html/Gymgraph/show.php on line 4

 

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/soul3438/public_html/Gymgraph/show.php on line 4

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/soul3438/public_html/Gymgraph/show.php on line 5

[gevans]

have you connected to your database yet?? post all your code

[techker]

 

 

<? mysql_connect("localhost", "user_techker", "pass");
mysql_select_db("soul3438_gymgraphtrainers");
$showtablequery = "SHOW TABLES FROM [soul3438_gymgraphtrainers]";

$showtablequery_result  = mysql_query($showtablequery);
while($showtablerow = mysql_fetch_array($showtablequery_result))
{
        echo $showtablerow[0]."<br />";
}

?>

[gevans]

<?php
mysql_connect("localhost", "user_techker", "pass");
mysql_select_db("soul3438_gymgraphtrainers");
$showtablequery = "SHOW TABLES FROM soul3438_gymgraphtrainers";

$showtablequery_result  = mysql_query($showtablequery);
while($showtablerow = mysql_fetch_array($showtablequery_result))
{
        echo $showtablerow[0]."<br />";
}

?>

[techker]

<?php
mysql_connect("localhost", "user_techker", "pass");
mysql_select_db("soul3438_gymgraphtrainers");
$showtablequery = "SHOW TABLES FROM soul3438_gymgraphtrainers";

$showtablequery_result  = mysql_query($showtablequery);
while($showtablerow = mysql_fetch_array($showtablequery_result))
{
        echo $showtablerow[0]."<br />";
}

?>

 

All good thx!!