[SOLVED] sql query getting no data ?

[runnerjp]

hey im using this

 

<?php $query="SELECT * FROM users WHERE Username = '$_GET[username]' LIMIT 1"; 
$result=mysql_query($query); 
while($array=mysql_fetch_assoc($result)){
$pID=$array['ID'];
$puser=$array['username'];
}


?>


<?php echo $puser . " " . $ID;  ?>

to get a users data by following a link like mywebsite.com/members/name

 

where in the members folder i have

.htaccess

<?php RewriteEngine on
RewriteBase /
RewriteRule ^i([^/\.]+)/?$ /images.php?username=$1 
RewriteRule ^([^/\.]+)/?$ members/profile.php?username=$1 [L] ?>

 

shouldent $_GET[username] get it either form fact im logged in or from the url itself and display there information?

[trq]

Your rule should look more like....

 

RewriteRule ^members/([A-Za-z0-9]+)$ members/profile.php?username=$1

 

Then your code...

 

<?php

  if (isset($_GET['username'])) {
    $username = mysql_real_escape_string($_GET['username']);
    $query = "SELECT * FROM users WHERE Username = '$username' LIMIT 1"; 
    if ($result = mysql_query($query)) {
      if (mysql_num-rows($result)) { 
        $array = mysql_fetch_assoc($result);
        $pID = $array['ID'];
        $puser = $array['Username'];
      }
    }
  }

  echo $puser . " " . $pID;

?>

[runnerjp]

the re-write rule u gave does not work... http 404 error

[runnerjp]

any ideas any1?

[runnerjp]

?

[adam291086]

have you tired echoing all your variables to make sure information is being passed across and that the query is working?

[runnerjp]

tried

 

<?php
if (isset($_GET['username'])) {
    $username = mysql_real_escape_string($_GET['username']);
    $query = "SELECT * FROM users WHERE Username = '$username' LIMIT 1"; 
    if ($result = mysql_query($query)) {
      if (mysql_num-rows($result)) { 
        $array = mysql_fetch_assoc($result);
        $pID = $array['ID'];
        $puser = $array['Username'];
     

  echo $puser . " " . $pID;
      
      } else {
        echo "No users found with id $id<br />";
      }
    } else {
      echo "Query failed<br />$sql<br />" . mysql_error();
    }
  } else {
    echo "No ID passed";
  }

  


?>

 

does this mean its not passing anyhting and if so why?

[kjtocool]

Try simplifying:

 

<?php
if (isset($_GET['username'])) 
{
    $username = $_GET['username'];
    $query = "SELECT * FROM users WHERE Username = '$username' LIMIT 1";
    $result = mysql_query($query)

    if ($result)
    {
      if (mysql_num_rows($result)) 
      { 
        $array = mysql_fetch_assoc($result);
        $pID = $array['ID'];
        $puser = $array['Username'];
        echo $puser . " " . $pID;
       } 
      else {
        echo "No users found with id $id<br />";
      }
    } 
    else {
      echo "Query failed<br />$sql<br />" . mysql_error();
    }
} 
else {
    echo "No ID passed";
}
?>

 

You had at least 1 syntax error in the last block of code you posted.

[xyn]

Mod-Rewrite:

 

#Rewrite
RewriteEngine On
RewriteBase /
RewriteRule ^/members/(.*)$ /members/index.php?username=$1[L]

[runnerjp]

i have messed around wiht code and finally got it...thanks guys