why does mysql_fetch_array() storing an empty result?

Question

I am successfully selecting the data from database table, when ever I am trying to fetch that data in to an array with the help of mysql_fetch_array() it's not storing anything into the array.

@session.start();
$name=$_SESSION['umailid'];
$chkname1 = "select * from ".USREG." where email='.$name.'";

echo $chkname1;
// it is printing like this:
// " select * from users_temp where email='[email protected].' "
// which means query was successful, above email is there in database table

$res1 = mysql_query($chkname1, $con) or die(mysql_error());

$chkresult1 = mysql_fetch_array($res1);
echo $chresult1['name']; //its not printing anything
if ($chkresult1) //it is storing null and entering into else block
{
    echo "query successful";
}
else {
    echo "query was not successful";
}

And the result is "query was not successful". I think everything is fine with my select query. Then why this mysql_fetch_array() is not fetching the data?

Is the email value you are searching for really supposed to have periods in front and behind it? [email protected]. is what you say the query is printing out, however do you mean [email protected]? Just curious. — Michael Lea Crawford
– Michael Lea Crawford, Commented Jan 29, 2015 at 18:16
really? I think not because if I miss } before else means i'll get another error saying something like "if without braces" its just my typing mistake @A L — subramanyemm
– subramanyemm, Commented Jan 29, 2015 at 18:22
@subramanyemm If you look at your code above, when you start if($chkresult1){ you have an opening brace but not a closing brace before else. This can cause unexpected results if this is really how you are executing your code. @A.L was just trying to point that out. — Michael Lea Crawford
– Michael Lea Crawford, Commented Jan 29, 2015 at 18:24
WARNING: mysql_query is an obsolete interface and should not be used in new applications as it's being removed in future versions of PHP. A modern replacement like PDO is not hard to learn. If you're new to PHP, a guide like PHP The Right Way can help explain best practices. — tadman
– tadman, Commented Jan 29, 2015 at 18:47

frunkad · Accepted Answer · 2015-01-29 18:15:42Z

3

In $chkname change to email = $name (remove dot) or email = '$name'

And you are using mysql ,rather use mysqli or pdo sql

answered Jan 29, 2015 at 18:15

frunkad

2,5522 gold badges25 silver badges38 bronze badges

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

5 Comments

Tamás Szabó Over a year ago

Add a single quote ( ' ) near $name

subramanyemm Over a year ago

I did same operation with mysql() only for another database table its worked fine without any error, I think mysqli() is not a problem

Tamás Szabó Over a year ago

But mysql is deprecated. @Darshan Jain just gave an advice for you.

subramanyemm Over a year ago

yeah its just deprecated not completely deleted we can use it right? @Darshan

frunkad Over a year ago

Suppose you are driving your boss's car , he says dont start the music bcoz it is not pleasant . Would you start it ? Its the same situation php says dont use . So dont use !

Collectives™ on Stack Overflow

why does mysql_fetch_array() storing an empty result?

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related