user system help

[Lee501]

i have very nearly coded a user system but it says
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/civsea.freehostia.com/config.php on line 28

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/civsea.freehostia.com/memberlist.php on line 15

Can Anybody Help? Pm me please and you get a managment job for fixing mysql problem


bomb-head (forum moderator) - Moved from 'Website Designing' to 'Coding', please post in the correct forum.

[RNelson]

Post the lines of the error :s

[adm]

Have you set up a MySQL db?

[Lee501]

http://civsea.freehostia.com/memberlist.php there is the link

[Lee501]

$db_username = 'civsea_calenda';
# database username
$db_password = 'writer1';
# database password
$db_host = mysql2.freehostia.com;
# database host (usually localhost);
$db_database = 'http://www.freehostia.com ';
# database

yes i have setup a database

sorry for double posting, didnt mean it

[adm]

use database host as localhost.

idk otherwise.

[Lee501]

nope, sorry +rep for trying :D

[Kymux]

On topic: Cant help sorry ):
Off topic: 8 posts and VIP?

Your very certain!

[AudioBook]

Lmao Piano.

Wish I could help but I'm not a PHP kinda guy.

[Lee501]

thanks anyway guys

[dp_124]

that error is most likely down to the query you are running against the database, care to post it?

[Lee501]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/civsea.freehostia.com/config.php on line 28


<?php
ob_start();
# allows you to use cookies
$db_username = '*****';
# database username
$db_password = '*****';
# database password
$db_host = localhost;
# database host (usually localhost);
$db_database = 'localhost';
# database
$connect = mysql_connect("mysql2.freehostia.com","*****","***");
# connect to the database
mysql_select_db("$db_database",$connect);
# select the database
$uname = addslashes($_COOKIE['username']);
# get the username cookie
$pword = addslashes($_COOKIE['password']);
# get the password cookie
$query = "SELECT * FROM `users` WHERE username = '".$uname."' AND password = '".$pword."'";
# set a query
28 $online = mysql_fetch_array(mysql_query($query));
# set an array to get any stored information we want about the browsing user
include ("functions.php");
# include the functions
?>