mysql_num_rows returning zero

Question

<?php 
session_start();
$con=mysql_connect("localhost","root","samy");
mysql_select_db("project");
if($con)
{
    echo "Connected Successfully "; 
}
else
{
    echo "Error" . $sql . "<br>" . mysql_connect_error();
}
$name=$_SESSION['name'];
echo $name;
$sql1 = mysql_query("select cust_id from registered_user where name ='.$name.' ");
$r = mysql_num_rows($sql1);      
echo $r;
$row1 = mysql_fetch_array($sql1);
$cid = $row1['cust_id'];
echo $cid;
?>

Since num_rows is returning zero therefore $cid is also not printing. Don't know what's the error;

MH2K9 · Accepted Answer · 2015-01-01 15:52:43Z

1

You should remove the dot(.).

$sql1 = mysql_query("select cust_id from registered_user where name ='$name'");
                                                                     ^     ^

Also suggest to add error reporting like this

$sql1 = mysql_query("select cust_id from registered_user where name ='$name'") 
        or die(mysql_error());

answered Jan 1, 2015 at 15:52

MH2K9

12.1k7 gold badges34 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Funk Forty Niner Over a year ago

That, or keep the dots but add quotes name ='".$name."'

Funk Forty Niner Over a year ago

This though $r = mysql_num_rows($sql1); echo $r; may throw an error when OP adds error reporting. Is not using mysql_num_rows() correctly. I think that will throw a "convert to string" error, if I do recall. If OP wants to check if there is a row, then would need to use something like if(mysql_num_rows($sql1) > 0){...}

Collectives™ on Stack Overflow

mysql_num_rows returning zero

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related