|
|
Posted by |-|erc on 11/02/05 23:55
"Kim Andrι Akerψ" <kimandre@NOSPAMbetadome.com> wrote in ...
: |-|erc wrote:
:
: > "Kim Andrι Akerψ" <kimandre@NOSPAMbetadome.com> wrote in
: > : |-|erc wrote:
: > :
: > : > Here's a test program that should output Members:0
: > : > but instead I get "I cannot get data from the database!".
: > : > Its as if the tables are not there but I have created them, does
: > : > anyone know why this would work on one server but not another?
: > : >
: > : > <?php
: > : > function sql_get_result($sql) {
: > : > global $link, $result;
: > : > if ( !($result = mysql_query($sql, $link))) { exit ("I cannot get
: > : > data from database!<br>"); } return $result;
: > : > }
: > : >
: > : > include('config.php');
: > : > $link = @mysql_connect ($DB_HOST, $DB_USER, $DB_PASS) or die
: > ('SQL : > Connection troubles'); mysql_select_db ($DB_DB);
: > : >
: > : >
: > : > $sql = "SELECT count(*) from `members` WHERE 1";
: > : > $result = sql_get_result($sql);
: > : > $counter = mysql_fetch_row($result);
: > : > echo "<br><b>Members: ". $counter[0];
: > : > ?>
: > :
: > : Does the table exist with the same columns in the database on both
: > : servers?
: > :
: > : Also, if you add the following line in the above function, what
: > comes : up?
: > : echo mysql_error();
: >
: > No database selected.
: >
: > in config I have $DB_DB = 'u4f';
: > and the database name is u4f
: > I also tried setting $DB_DB to upload4free_u4f
: > that's the account name.
: >
: > its a custom control panel with Globat but it looks like I set the
: > database up correctly, it logs in the user ok.
:
: What if you put that line right after the mysql_select_db() statement
: of yours? What error message comes up then?
:
Access denied for user 'u1'@'%' to database 'u4f'
OK I found the problem, I named the database uf4! :o)
Herc
Navigation:
[Reply to this message]
|