Проблем с кода !

marioawp

Registered
Здравейте,искам да ви попитам,понеже не съм много опитам,как да оправя този проблем
-> Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a6850846/public_html/add_driver.php on line 141

A ето това е кодът на 141 ред - > if (mysql_num_rows($result1)>0)

Моля ви се помогнете ми да го разреша,много ще съм ви благодарен :)
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head></head><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Шофьорът - избери своят път!</title>
<style type="text/css">

</style>
</head>
<div id="bgup" style="background-image:url(images/bgup.png); background-repeat:repeat-x;">
<div id="logo"><img src="images/header.pn" alt="" width="65" height="216" border="0" title="driv3r"/></div>
<div align="center"><img src="images/header.png" width="600" height="100" /></div><br />
<br />
<div align="center"; style="background-image:url(images/bar-line.png); background-position:center; background-repeat:no-repeat; margin-top:-45px;"><br />
<span class="style1"><span class="style4"><a href="index.php">Начало</a>       <a href="add_driver.php">Регистрация</a>        <a href="all_driver.php">Класация</a>       <a href="sms.php">СМС услуга</a>       <a href="rules.php">Правила</a>       <a href="lost.php">Забравен линк</a></span></span><br />
<br /></div>
<br /><br />
</head>
<body>
<div align="center"; style="background-image:url(images/headline2.png); background-position:center; background-repeat:no-repeat; margin-top:-40px;"><br />
<p><a href="index.php">Driv3r - Добави шофьор</a></p><p> </p></div>
<div align="center">
<div style="background-position:center; width:540px;" class="body">
<p align="center"> </p>
<form action="" method="post">
<center>
<h3><span class="style8">Име на Шофъорът:<span class="style9">...........</span> </span>
<input name="gora" type="text" size="40" />
</h3>
<br />
<center>
<h3><span class="style8">Скайп:</span><span class="style9">................................
</span>
<input name="mail" type="text" size="40" />
</h3>
</center>
<br />
<center>
<h3><span class="style8">И-мейл:</span><span class="style9">..............................
</span>
<input name="skype" type="text" size="40" />
</h3>
</center>
<br />
<center>
<input type="submit" name="buton" value="Създай състезателя" />
</center>
</form>
</center>
<?php
include("config.php");
function selfURL() {
$s = empty($_SERVER["HTTPS"]) ? ''
: ($_SERVER["HTTPS"] == "on") ? "s"
: "";
preg_match_all('/(.*)\//',$_SERVER['SCRIPT_NAME'],$lq);
$protocol = strleft(strtolower($_SERVER["SERVER_PROTOCOL"]), "/").$s;
$port = ($_SERVER["SERVER_PORT"] == "80") ? ""
: (":".$_SERVER["SERVER_PORT"]);
return $protocol."://".$_SERVER['SERVER_NAME'].$port.$lq[0][0];
}
function strleft($s1, $s2) {
return substr($s1, 0, strpos($s1, $s2));
}
$url = selfURL();
$vote = "vote.php?l=vote&id";
$path = $url.$vote;
if($_POST['buton'])
{
$gora=htmlspecialchars($_POST['gora']);
$mail=htmlspecialchars($_POST['mail']);
$ip=$_SERVER["REMOTE_ADDR"];
$query1="SELECT * from gora where name like '$gora' ";
$result1=mysql_query($query1);

if ($_POST['gora'] == NULL)
{
echo "<b>Моля въведете някакво име!</b>";
}
else if ($_POST['mail'] == NULL)
{
echo "<b>Моля въведете И-мейл!</b>";
}
else
{
if (mysql_num_rows($result1)>0)

{
echo "Шофьор с име <b>$gora</b> вече същестува!<br>Моля изберете друго име за вашата регистрация.";
}
else
{

$sql = "INSERT INTO `gora` VALUES('', '$gora', '1', '$mail');";
if(mysql_query($sql) != "")
{
$query = mysql_query("SELECT * FROM `gora` WHERE name='$gora' LIMIT 1;");
$row=mysql_fetch_array($query);
$goraid=$row[id];
$gora=$row[name];
$sql2 = "INSERT INTO `gradip` VALUES('', '$goraid', '$ip' );";
$q=mysql_query($sql2);
echo "Шофьор <b>$gora</b> беше създаден успешно!";
echo "<br>";
echo "Вашият уникален линк е <a href=\"$path=$goraid\">$path=$goraid</a><br>";
echo "Шорьорът е добавен от IP: <b>$ip</b>";
}else
{
echo "Шофьорът не беше създаден! Има грешка с mysql-a!";
}
}
}
}
?>
<br />
<br />
<br />
</div>
</div>
<div align="center"></div>
<div align="center"><img src="images/headlinedown2.png" width="800" height="24" />
</div>
</body>
</html>
 
При like се слагат %$promenliva%
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head></head><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Шофьорът - избери своят път!</title>
<style type="text/css">

</style>
</head>
<div id="bgup" style="background-image:url(images/bgup.png); background-repeat:repeat-x;">
<div id="logo"><img src="images/header.pn" alt="" width="65" height="216" border="0" title="driv3r"/></div>
<div align="center"><img src="images/header.png" width="600" height="100" /></div><br />
<br />
<div align="center"; style="background-image:url(images/bar-line.png); background-position:center; background-repeat:no-repeat; margin-top:-45px;"><br />
<span class="style1"><span class="style4"><a href="index.php">Начало</a>       <a href="add_driver.php">Регистрация</a>        <a href="all_driver.php">Класация</a>       <a href="sms.php">СМС услуга</a>       <a href="rules.php">Правила</a>       <a href="lost.php">Забравен линк</a></span></span><br />
<br /></div>
<br /><br />
</head>
<body>
<div align="center"; style="background-image:url(images/headline2.png); background-position:center; background-repeat:no-repeat; margin-top:-40px;"><br />
<p><a href="index.php">Driv3r - Добави шофьор</a></p><p> </p></div>
<div align="center">
<div style="background-position:center; width:540px;" class="body">
<p align="center"> </p>
<form action="" method="post">
<center>
<h3><span class="style8">Име на Шофъорът:<span class="style9">...........</span> </span>
<input name="gora" type="text" size="40" />
</h3>
<br />
<center>
<h3><span class="style8">Скайп:</span><span class="style9">................................
</span>
<input name="mail" type="text" size="40" />
</h3>
</center>
<br />
<center>
<h3><span class="style8">И-мейл:</span><span class="style9">..............................
</span>
<input name="skype" type="text" size="40" />
</h3>
</center>
<br />
<center>
<input type="submit" name="buton" value="Създай състезателя" />
</center>
</form>
</center>
<?php
include("config.php");
function selfURL() {
$s = empty($_SERVER["HTTPS"]) ? ''
: ($_SERVER["HTTPS"] == "on") ? "s"
: "";
preg_match_all('/(.*)\//',$_SERVER['SCRIPT_NAME'],$lq);
$protocol = strleft(strtolower($_SERVER["SERVER_PROTOCOL"]), "/").$s;
$port = ($_SERVER["SERVER_PORT"] == "80") ? ""
: (":".$_SERVER["SERVER_PORT"]);
return $protocol."://".$_SERVER['SERVER_NAME'].$port.$lq[0][0];
}
function strleft($s1, $s2) {
return substr($s1, 0, strpos($s1, $s2));
}
$url = selfURL();
$vote = "vote.php?l=vote&id";
$path = $url.$vote;
if($_POST['buton'])
{
$gora=htmlspecialchars($_POST['gora']);
$mail=htmlspecialchars($_POST['mail']);
$ip=$_SERVER["REMOTE_ADDR"];
$query1="SELECT * from gora where name like '%$gora%' ";
$result1=mysql_query($query1) or die(mysql_error());

if ($_POST['gora'] == NULL)
{
echo "<b>Моля въведете някакво име!</b>";
}
else if ($_POST['mail'] == NULL)
{
echo "<b>Моля въведете И-мейл!</b>";
}
else
{
if (mysql_num_rows($result1)>0)

{
echo "Шофьор с име <b>$gora</b> вече същестува!<br>Моля изберете друго име за вашата регистрация.";
}
else
{

$sql = "INSERT INTO `gora` VALUES('', '$gora', '1', '$mail');";
if(mysql_query($sql) != "")
{
$query = mysql_query("SELECT * FROM `gora` WHERE name='$gora' LIMIT 1;");
$row=mysql_fetch_array($query);
$goraid=$row[id];
$gora=$row[name];
$sql2 = "INSERT INTO `gradip` VALUES('', '$goraid', '$ip' );";
$q=mysql_query($sql2);
echo "Шофьор <b>$gora</b> беше създаден успешно!";
echo "<br>";
echo "Вашият уникален линк е <a href=\"$path=$goraid\">$path=$goraid</a><br>";
echo "Шорьорът е добавен от IP: <b>$ip</b>";
}else
{
echo "Шофьорът не беше създаден! Има грешка с mysql-a!";
}
}
}
}
?>
<br />
<br />
<br />
</div>
</div>
<div align="center"></div>
<div align="center"><img src="images/headlinedown2.png" width="800" height="24" />
</div>
</body>
</html>
 

Back
Горе