So i have a site that im developing on my local machine (win98 with PWS, mySQL, PHP 4.0.4) and it all works great, but when i moved it on to the live server (FreeBSD with Apache, mySQL, PHP 4.0.4) i get this error.
Warning: Supplied argument is not a valid MySQL result resource in /usr/local/etc/httpd/htdocs/perlead/login.php on line 15
so this is the code with line numbers.
10 mysql_connect("localhost", "root", "?????????");
11 mysql_select_db("perlead");
12
13 $result = mysql_query("SELECT UserID, Name, UserLevelID, UserTypeID FROM Users WHERE UserName = '$UserName' AND Password = '$Password'");
14
15 If ($row = mysql_fetch_array($result)) {
16 session_register("CUserID");
17 $CUserID = $row[0];
-Shea