Simple query cant get it to work

[payney]

Hi all.

I cannot understand why this is not working, I will first show you the code:

 

$username = $_SESSION["authenticatedUser"];

echo $username;

 

  if (!empty($username))

  {

    require ('db.php');

 

    if (!($connection = @ mysql_pconnect($hostname, $username, $password)))

    die("Could not connect to database");

 

    if (!mysql_select_db($databaseName, $connection))

    showerror();

 

    $query = "SELECT * FROM users WHERE username = $username";

 

    if (!($result = @ mysql_query ($query, $connection)))

    echo "Query error";

 

    while($row = mysql_fetch_assoc($result)) { 

    echo  $row['email'];

    echo  $row['username'];

    echo $row['password']; 

 

  }

 

With this I get the following error:

 

payneyQuery error

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

 

Now, if I hardcode the username, which is 'payney', it works.

 

   

[rajivgonsalves]

this

 

$query = "SELECT * FROM users WHERE username = $username";

 

should be

$query = "SELECT * FROM users WHERE username = '$username'";

 

you forgot the quotes

[payney]

But for some reason its not falling into the while loop thing.

 

while($row = mysql_fetch_assoc($result)) {

 

    echo  $row['email'];

    echo  $row['username'];

    echo $row['password']; 

 

  }

 

Its just ignoring all this?   

[jitesh]

Check by this :

 

if (!(mysql_query($query, $connection))){

   

  while($row = mysql_fetch_assoc($result)) {

 

    echo  $row['email'];

    echo  $row['username'];

    echo $row['password']; 

   

    } 

 

}else{

        echo "Query Fail";

 

}

[payney]

"Query fail"

 

Now I am confused, why is the query not working  haha!

[jitesh]

Query Will be

 

$query = "SELECT * FROM users WHERE username = '".$username."'";

 

[payney]

Still query fail

[jitesh]

(1) Check DB is connected Sucessfully.

(2) Check DB is selected Successfully.

(3) Echo  query and dynamically run in mysql.

[rajivgonsalves]

your code should be something like...

 

<?php
$username = $_SESSION["authenticatedUser"];      
echo $username;

  if (!empty($username))
  {
    require ('db.php');
   
    if (!($connection = @ mysql_pconnect($hostname, $username, $password)))
    die("Could not connect to database");

    if (!mysql_select_db($databaseName, $connection))
    showerror();
       
    $query = "SELECT * FROM users WHERE username = '$username'";
$result = mysql_query ($query, $connection);
$intNumRows = mysql_num_rows($result);


    if ($intNumRows > 0)
{
    while($row = mysql_fetch_assoc($result)) { 
     echo  $row['email'];
     echo  $row['username'];
     echo $row['password'];   
   
     }
}
else 
 {
		    echo "No records fetched";
 }

?>

[payney]

I get no records returned. this does not make sense to me.

 

 

If I hard code the id, username or password it works, but if i assign the variable before the query like:

$username = 'payney';

 

This dosnt work neither.

[jitesh]

Check :

 

if (!(mysql_pconnect($hostname, $username, $password)))

      die("Can not connect");

[rajivgonsalves]

try

 

$query = "SELECT * FROM users WHERE username = '$username'";
echo $query;

 

and tell me what you get

[PFMaBiSmAd]

Uhmmm.

 

$usename is being used by the main code and by the database mysql_connect() function.

 

The value it had from the session is replaced when the 'db.php' file is required/included.

[payney]

Uhmmm.

 

$usename is being used by the main code and by the database mysql_connect() function.

 

The value it had from the session is replaced when the 'db.php' file is required/included.

 

That is correct, just realised that when returning the query. Whoopsy daisy. Problem solved by changing the name of username to username2.

 

Cheers for all the help and effort guys