MySQL - mysql_fetch_assoc() doesn't give one column

Question

My column type is SMALLINT and name is user_level. Here is the code I am using:

<?php
mysql_connect("localhost", "root", "*********");
mysql_select_db("3591_other");
$result = mysql_query("SELECT * FROM rivase_f_users WHERE user_name = '$email' AND    user_pass=sha1('$passwd')");
if (!$result) {
    echo mysql_error();
}
//snip
else if (mysql_fetch_assoc($result)) {
    $row=mysql_fetch_assoc($result);
    $_SESSION['username']=$email;
    if ($row['user_level']==1) {$_SESSION['usertype']='leader';}
    header("Location: index.php");
    die();
}
?>

$row['user_level'] looks like to be null, but phpmyadmin says it is 1. I tried echoing it with commenting the header-location row, it did not say anything. What am I doing wrong?

Again someone who use mysql_* functions. Btw WHERE user_name = '$email' Did you read this???? — Ron van der Heijden
– Ron van der Heijden, Commented Sep 13, 2012 at 7:37

Tarun · Accepted Answer · 2012-09-13 07:34:31Z

2

try this,

else if ($row = mysql_fetch_assoc($result)) {
    $_SESSION['username']=$email;
    if ($row['user_level']==1) {$_SESSION['usertype']='leader';}
    header("Location: index.php");
    die();
}

answered Sep 13, 2012 at 7:34

Tarun

3,1754 gold badges33 silver badges52 bronze badges

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

Comments

Álvaro González · Accepted Answer · 2012-09-13 07:35:02Z

2

What you're trying to accomplish is unclear to me but you are discarding the first result:

else if (mysql_fetch_assoc($result)) {
    //   ^^^^^^^^^^^^^^^^^ Read and discard
    $row=mysql_fetch_assoc($result);
    //   ^^^^^^^^^^^^^^^^^ Read next row

answered Sep 13, 2012 at 7:35

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

Comments

mtk · Accepted Answer · 2012-09-13 07:41:05Z

1

You are experiencing a logical if-else bug.

You are reading the value of next mysql_fetch_assoc() after testing the output result of the first call in the else condition, but you wanted to read the value from first returned result.

answered Sep 13, 2012 at 7:41

mtk

13.8k16 gold badges75 silver badges117 bronze badges

Comments

Daniel Luca CleanUnicorn · Accepted Answer · 2012-09-13 07:48:49Z

1

Based on your code try this

<?php
mysql_connect("localhost", "root", "*********");
mysql_select_db("3591_other");
$result = mysql_query("SELECT * FROM rivase_f_users WHERE user_name = '$email' AND    user_pass=sha1('$passwd')");
if (!$result) {
    echo mysql_error();
}
//snip
else if ($row=mysql_fetch_assoc($result)) {
    $_SESSION['username']=$email;
    if ($row['user_level']==1) {$_SESSION['usertype']='leader';}
    header("Location: index.php");
    die();
}
?>

I've changed the else if check to save the row when doing the comparison.

answered Sep 13, 2012 at 7:48

Daniel Luca CleanUnicorn

1,0971 gold badge12 silver badges31 bronze badges

Collectives™ on Stack Overflow

MySQL - mysql_fetch_assoc() doesn't give one column

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related