webvars.inc.php
$hostname = "localhost"; // your MySQL server address
$user = "####"; // your MySQL username
$password = "####"; // your MySQL password
$database = "####"; // your MySQL database
// $db = Connection... if dead, then kill whole page
$db = mysql_connect("$hostname","$user","$password") or die ("Host, User or Pass is wrong"); // make $DB
mysql_select_db("$database", $db) or die("UserName or Password is wrong for the Database"); // Connect to Table or Die
Sign-up script
$srchuser = "SELECT * FROM nfUsr WHERE uUserName = '$frmUsername'";
$ResFindUsr = mysql_query($srchuser, $db) or die ("<u>Error</u><BR><B>MySQL Error</B>: ".mysql_error()."<BR><B>SQL</B> $srchuser<BR><BR>");
Warning: 1 is not a valid MySQL-Link resource in /home/web/Nic0060101/u-muppet.co.uk/client/online/add_user.php on line 16
Error
MySQL Error:
SQL SELECT * FROM nfUsr WHERE uUserName = 's9psilver'
- the bold bit being the var passed in.
This should work, the actual SQL is correct.... and works fine for www.AwwBless.co.uk , so that's really odd.
Any help would be apprechated.
EDIT:
Above the sign-up page is include ('head.php'); and in that I have
include("webvars.inc.php");
include("addonline.inc.php");
