|
|
Posted by Kim Andrι Akerψ on 11/02/05 10:07
|-|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();
--
Kim AndrΓ© AkerΓΈ
- kimandre@NOSPAMbetadome.com
(remove NOSPAM to contact me directly)
Navigation:
[Reply to this message]
|