Well when i run this file called edit.php I get following errors:(
mysql_num_rows(): supplied argument is not a valid MySQL result resource
heres the code for the file
--------------code begins--------------
<?php
require "config.php";
function login() {
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"2\"><form action=\"edit.php\" method=\"POST\">
<tr><td>Username: </td><td><input type=\"text\" name=\"l_user\" class=box></td></tr><tr>
<td>Password: </td><td><input type=\"password\" name=\"l_pass\" class=box></td></tr><tr>
<tr><td></td><td><input type=\"Submit\" value=\"Log In!\" class=box></td></tr></form></table>";
}
function head() {
echo "<html>\n<head>\n<title>Submissionz.com - Link Exchange</title></head>
<style type=\"text/css\">
A:link {color: #FFffff; text-decoration:none; font-size:8pt; font-family:Verdana}
A:visited {color: #FFffff; text-decoration:none; font-size:8pt; font-family:Verdana}
A:hover {color: #ff0000; text-decoration:underline; font-size:8pt; font-family:Verdana}
.text {color: #ff0000; text-decoration:none; font-size:8pt; font-family:Verdana}
.box {color: #ffffff; border: 1px solid #ff0000; background-color: #991717; font-family:Verdana; font-size:8pt}
table {color: #ffffff; text-decoration:none; font-size:8pt; font-family:Verdana}
</style><body bgcolor=#000000>";
}
function foot() {
echo "\n</body></html>";
}
function form($err, $val) {
global $l_user, $l_pass;
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"2\">
<form name=\"le\" action=\"edit.php\" method=\"POST\">
<tr><td><b>Username: </b></td><td>$l_user</td></tr>
<tr><td><b>Password: </b></td><td><input class=box type=\"text\" name=\"le[pass]\" max=\"30\" size=\"30\" maxlength=\"15\" value=\"$val[pass]\"> $err[pass]</td></tr>
<tr><td><b>Email: </b></td><td><input class=box type=\"text\" name=\"le[email]\" max=\"30\" size=\"30\" value=\"$val[email]\" maxlength=\"80\"> $err[email]</td></tr>
<tr><td><b>Site Name: </b></td><td><input class=box type=\"text\" name=\"le[name]\" max=\"30\" size=\"30\" value=\"$val[name]\" maxlength=\"13\"> $err[name]</td></tr>
<tr><td><b>Site Url: </b></td><td><input class=box type=\"text\" name=\"le[url]\" max=\"30\" size=\"30\" value=\"$val[url]\" maxlength=\"80\"> $err[url]</td></tr>
<tr><td></td><td><input class=box type=\"Submit\" value=\"Update!\"></td></tr>
<input type=\"Hidden\" name=\"l_user\" value=\"".$l_user."\">
<input type=\"Hidden\" name=\"l_pass\" value=\"".$l_pass."\"></form></table>";
}
if (!$l_pass || !$l_user) {
head();
login();
foot();
} else {
$err = array();
$get = mysql_query("SELECT * FROM linker WHERE id = '$l_user' && passord = '$l_pass'");
if (!mysql_num_rows($get)) {
head();
echo "<big><b>Wrong Username or Password!</b></big><br>";
login();
foot();
} else {
$val = mysql_fetch_array($get);
$val[pass] = $val[passord];
$val[name] = $val[navn];
if ($le) {
if (!$le[pass] || !$le[email] || !$le[name] || !$le[url]) {
if (!$le[pass])
$err[pass] = "you must enter a password!";
if (!$le[email])
$err[email] = "you must enter your email!";
if (!$le[name])
$err[name] = "you must enter your sites title!";
if (!$le[url])
$err[url] = "what is your sites url?";
head();
form ($err, $val);
foot();
} else {
mysql_query("UPDATE linker SET passord='$le[pass]',navn='$le[name]',url='$le[url]',email='$le[email]' WHERE id = '$l_user'");
head();
echo "<big><b>Updated!</b></big><br>";
$l_pass = $le[pass];
form($err, $le);
foot();
}
} else {
head();
form($err, $val);
foot();
}
}
}
?>
--------------code ends--------------
Ps: A small note. I am very new to php but i know few things like how do i edit a code so that i don't recieve an error message
like putting '@' sign for variables and all that. Also this is not my script. I got it from the net somewhere.
i think the line mysql_num_rows($get) is creating errors. please help me to sort out this error. I don't know any technical things bout php but a thing or two and similar is the case with mysql. So please please make sure that when u answer my query, u answer in a lame manner.
Thanx a buch in advance
Hoping to get replies
Cybot:)
mysql_num_rows() => Giving Error?
