|
|
Posted by |-|erc on 11/02/05 11:32
"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.
Herc
Navigation:
[Reply to this message]
|