viewing members profiles

[Nathan__02]

i have made a script which when you click on the member it takes you to viewmember.php?$member but when i go there NONE of the query shows up...heres my script

<?php

include("config.php");
include("style.css");

$query=mysql_query("SELECT * FROM users WHERE username = '$username'");
$row=mysql_fetch_array($query);

$username=$row["username"];
$realname=$row["realname"];
$location=$row["location"];
$email=$row["email"];
$msn=$row["msn"];
$sig=$row["signature"];

echo("<div style='position:absolute; top:100; left:100; width:800'>");
echo("<h5>$username</h5>");
echo("Real Name: $realname<BR>");
echo("Location: $location<BR>");
echo("Email: $email<BR>");
echo("Msn: $msn<br><HR width='100%'>");
echo("$sig");
echo("</div>");

?>

[WinterDragon]

and you of course connect to the db, and select a table right? Also, do you get the $_GET['member'] since you go through the GET method in your member section. So...

the address is: members.php?Jonathan

so I want to do this...

$query = $QUERY_STRING;

$query=mysql_query("SELECT * FROM users WHERE username = '$query'");
$row=mysql_fetch_array($query);

$username=$row["username"];
$realname=$row["realname"];
$location=$row["location"];
$email=$row["email"];
$msn=$row["msn"];
$sig=$row["signature"];

hrm, That should work...

[Nathan__02]

im not sure what you mean when you said $GET...

heres the code i just tried and it didnt work...

<?php

include("config.php");
include("style.css");

$query = $QUERY_STRING;
$query=mysql_query("SELECT * FROM users WHERE username = '$username'");
$row=mysql_fetch_array($query);

$username=$row["username"];
$realname=$row["realname"];
$location=$row["location"];
$email=$row["email"];
$msn=$row["msn"];
$sig=$row["signature"];

echo("<div style='position:absolute; top:100; left:100; width:800'>");
echo("<h5>$username</h5>");
echo("Real Name: $realname<BR>");
echo("Location: $location<BR>");
echo("Email: $email<BR>");
echo("Msn: $msn<br><HR width='100%'>");
echo("$sig");
echo("</div>");

?>

config.php has all my database connections...would it help you if u had members.php...here it is

<?php

include("config.php");
include("style.css");

$query=mysql_query("SELECT * FROM users");



echo("<div style='position:absolute; top:100; left:100; width:800'>");

while($row=mysql_fetch_array($query))
{
$username=$row["username"];
echo("<a href='/shelta/viewmember.php?$username'>$username</a><BR>");
}

echo("</div>");

?>

[WinterDragon]

change this line...

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

to:

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

THAT should work.

If not, just post again.

[Nathan__02]

that worked how i wanted it to...just for future reference let me see if i understand this...

$query= $QUERY_STRING;
$query=mysql_query("SELECT * FROM users WHERE username = '$query'");
$row=mysql_fetch_array($query);

the $query is everything after viewmember.php?

[WinterDragon]

YUP! You got it! $QUERY_STRING (or the alias $query that we created) will be everything after index.php? (or after the question mark). So any other questions just ask here 🙂

[Nathan__02]

nope thats all 🙂 Thanks!