Supplied argument is not a valid MySQL result resource

It's not difficult to install myLounge Redirection, but sometimes it's quite tricky. Post your questions in here.

Moderator: Scooby

Supplied argument is not a valid MySQL result resource

Postby killerkai1 » Mon Feb 24, 2003 2:22 pm

Hi!

I have a problem with your script.
Everything is installed and when I wo to http://www.hot-sub.de/myred/admin.php

I get the following error message:

PHP Warning: Supplied argument is not a valid MySQL result resource in /web/myred/include/vars.php on line 36

Can you help me?

You find my vars.php and the content of the mysql in the end of this mail.

Kai Rieke


_____________________________________

vars.php:

<?php
// hostname of the server
$mysql_host = 'db.hot-sub.de';

// mysql-username
$mysql_username = 'XXXXXXX'; // hidden :-)

// mysql-password
$mysql_passwd = 'XXXXXXX'; // hidden :-)

// the name of the database (will be created during setup)
$mysql_dbase = 'XXXXXXX'; // hidden :-)

// table names which will be used to save the data
$redir_table = "redir";
$options_table = "options";
$domain_table = "tld";
$category_table = "categories";
$advertiser_table = "advertiser";
$adverts_table = "adverts";
$adclicks_table = "adclicks";
$adviews_table = "adviews";

// You may change the following value
$dateformat = "d. M. Y H:i ";

// Don't change anything below!

// Disable magic_quotes_runtime
set_magic_quotes_runtime(0);

mysql_connect("$mysql_host","$mysql_username","$mysql_passwd");
mysql_select_db("$mysql_dbase");

$result = mysql_query("SELECT * FROM $options_table");
$row = mysql_fetch_array($result);

$adminmail = $row[adminemail];
$adminpasswd = $row[password];
$adminusername = $row[username];
$startpage = $row[home];
$pagetitle = $row[sitetitle];
$domainip = $row[domainip];
$maindomain = $row[maindomain];
$ads = $row[ads];
$standardad = $row[standardad];

?>


_____________________________________

Content of options auf db.hot-sub.de
home sitetitle adminemail username password domainip maindomain ads standardad
index.html test killerkai@freenet.de killerkai pass hot-sub.de ad-free banner
killerkai1
Newbie
Newbie
 
Posts: 2
Joined: Mon Feb 24, 2003 2:20 pm

http://www.mylounge.com/phpbb/viewtopic.php?t=15

Postby killerkai1 » Mon Feb 24, 2003 2:25 pm

I think it is nearly the same problem like:
http://www.mylounge.com/phpbb/viewtopic.php?t=15

Can you post a correct var.php file?

Kai
killerkai1
Newbie
Newbie
 
Posts: 2
Joined: Mon Feb 24, 2003 2:20 pm

Postby Scooby » Mon Feb 24, 2003 3:47 pm

you would be better waiting for new version
User avatar
Scooby
helpful guy
helpful guy
 
Posts: 252
Joined: Fri Jan 24, 2003 2:04 pm
Location: UK

Postby andelal » Tue Feb 25, 2003 7:12 am

I already mailed release 1.4 to killerkai1

Alex
User avatar
andelal
Site Admin
Site Admin
 
Posts: 479
Joined: Tue Jan 07, 2003 8:53 pm
Location: Vienna/Austria/Europe


Return to Support

Who is online

Users browsing this forum: No registered users and 36 guests

cron