Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
MySQL multi Table access
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- MySQL multi Table access
MySQL multi Table access
25-04-2008 8:47 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I have created two tables using PHPmyAdmin the First I can access using PHP scripts.
The second Table I am unable to access using PHP scripts. To confirm this I have used the Print mysql_tablename ($db_Address, 0)
Which prints the name of the first Table
Print mysql_tablename ($db_Address, 1)
Does not prints the name of the Second Table and an error message is displayed.
Has any other user been able to access a second table created on the PHPmyAdmin site.
Note I can read the second table in PHPmyAdmin.
Also Is it just me who spends hours on the PHPmyAdmin site just to do one or two admin changes?
one of the slowest admin sites I have used
The second Table I am unable to access using PHP scripts. To confirm this I have used the Print mysql_tablename ($db_Address, 0)
Which prints the name of the first Table
Print mysql_tablename ($db_Address, 1)
Does not prints the name of the Second Table and an error message is displayed.
Has any other user been able to access a second table created on the PHPmyAdmin site.
Note I can read the second table in PHPmyAdmin.
Also Is it just me who spends hours on the PHPmyAdmin site just to do one or two admin changes?
one of the slowest admin sites I have used

Message 1 of 4
(1,249 Views)
3 REPLIES 3
Re: MySQL multi Table access
25-04-2008 8:54 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
<?php
mysql_connect("localhost", "mysql_user", "mysql_password");
$result = mysql_list_tables("mydb");
$num_rows = mysql_num_rows($result);
for ($i = 0; $i < $num_rows; $i++) {
echo "Table: ", mysql_tablename($result, $i), "\n";
}
mysql_free_result($result);
?>
What does the above give you?
Message 2 of 4
(388 Views)
Re: MySQL multi Table access
26-04-2008 1:12 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Yes the PHPMyAdmin page has got much slower recently.
Although humbug has been down due to some faults,
so it maybe related to that? or that it's overloaded by so many handels, connections and so forth.
That's also why I've spent more time writing an Admin backed to my site,
so that I don't have to wait for PHPMyAdmin as much,
in fairness PHPMyAdmin is fairly heavy on some things even on a local webserver on the same machine.
I think just depends which server you use, but I'm glad it's not just me that is having this!
with reguards to the actual topic point, I'm not certain but,
I do know that Peter's code there will help.
I have had errors in the past using MySQL Functions,
on one handel twice, and it's not worked, so I had to re-query the server
(copy the line and put it after the first request function).
Hope something here helps to solve it! xD
Jim,
Although humbug has been down due to some faults,
so it maybe related to that? or that it's overloaded by so many handels, connections and so forth.
That's also why I've spent more time writing an Admin backed to my site,
so that I don't have to wait for PHPMyAdmin as much,
in fairness PHPMyAdmin is fairly heavy on some things even on a local webserver on the same machine.
I think just depends which server you use, but I'm glad it's not just me that is having this!
with reguards to the actual topic point, I'm not certain but,
I do know that Peter's code there will help.
I have had errors in the past using MySQL Functions,
on one handel twice, and it's not worked, so I had to re-query the server
(copy the line and put it after the first request function).
Hope something here helps to solve it! xD
Jim,
Message 3 of 4
(388 Views)
Re: MySQL multi Table access
27-04-2008 12:22 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
bootfairs
Have you tried MySQL Administrator 1.2 running on your local machine? I have found that I can do most things that I need to and it is much faster than phpMyAdmin.
It can be downloaded from:
http://dev.mysql.com/downloads/gui-tools/5.0.html
Have you tried MySQL Administrator 1.2 running on your local machine? I have found that I can do most things that I need to and it is much faster than phpMyAdmin.
It can be downloaded from:
http://dev.mysql.com/downloads/gui-tools/5.0.html
Message 4 of 4
(388 Views)
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- MySQL multi Table access