TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Violeta Popa
NA
137
164k
Warning: mysql_num_rows() expects parameter 1 to be resource
May 1 2013 1:25 AM
Hi..i'm trying to make a login form, but i get the warning on the bolded line:
"
Warning
: mysql_num_rows() expects parameter 1 to be resource, boolean given in
C:\xampp\htdocs\Asigurari\login.php
on line
15
Datele introduse sunt incorecte
"
I suppose it's sth wrong with the query text, but i can't understand what. i need a join between 2, one to one relationship tables. if i use only the colored text it works.
session_start();
include("conectare.php");
$username = $_POST['login_username'];
$password = $_POST['login_password'];
$tip=1;
$result=mysql_query(
'
SELECT * FROM utilizator
INNER JOIN client ON utilizator.id_client=client.id_client AND utilizator.id_utilizator=client.id_utilizator
WHERE id_utilizator="'.$username.'" AND parola="'.$password
.
'"
AND tip_asigurat="'.$tip.'"');
if (mysql_num_rows($result)==0)
{
echo "Datele introduse sunt incorecte<br>";
}
else
{
$_SESSION['username'] = $username;
$_SESSION['password'] = $password;
$url = 'asigurator/index.html';
echo '<META HTTP-EQUIV=Refresh CONTENT="0; URL='.$url.'">';
}
?>
Thank you!
Reply
Answers (
1
)
Matrix Table format
change messagebox caption