|
|
Posted by Kim Andr Aker on 11/02/05 14:09
|-|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?
--
Kim André Akerø
- kimandre@NOSPAMbetadome.com
(remove NOSPAM to contact me directly)
Navigation:
[Reply to this message]
|