Stuck with my variables

phpgirl

I have hit another snag 😕

I have a list of users which come from a database, together with other information about them such as username, real name and so on. I have managed to display them all on one page with their real name as a list and they all have a hyperlink to click on to view additional information. I pass the userid through the URL to the next page, but I can't figure out how to display the additional information about this user. I can display the UserID on the next page, but not their username, real name and so on.

Can someone point me in the right direction?

Many thanks.

LordShryku

Query the database against the user id...

phpgirl

OK, so I have the variable passing through the URL as so:

http://www.domain.com.au/out/MngrViewUsr.php?currUser=4

On the following page, I have the code like so:

<? $query = "SELECT * FROM tblUsers WHERE id = $currUser";
$result = mysql_query($query);

while ($row = mysql_fetch_array($query))
{
$user_login=$row["0"];
$password["1"];
$confirm_pwd["2"];

<?printMLText("user_login");?>
<?printMLText("password");?>
<?printMLText("confirm_pwd");?>

I DO have all the database connecting code included too in a class file, so I haven't missed that out.

But it still isn't happening....... 😕

bad76

Originally posted by phpgirl
while ($row = mysql_fetch_array($query))
{
$user_login=$row["0"];
$password["1"];
$confirm_pwd["2"];

Hi,
i think you need to write some "=$row"

$user_login=$row["0"];
$password=$row["1"];
$confirm_pwd=$row["2"];

GreyBoy

Yeah, for mysql_fetch_array(), your array is $row, so the example bad76 gave is how you have to do it.

phpgirl

I was fiddling with it so much I left out the row=

I put them in, but it still doesn't work 🙁

bad76

...the quote...

you can write $row["name_of_field"] or $row[0], but $row["0"] maybe a problem....

tekky

Originally posted by bad76
...the quote...

you can write $row["name_of_field"] or $row[0], but $row["0"] maybe a problem....

bad's right... if its a non associative array (ie using words intead of numbers in the [ ]) $row["0"] would be considered unset and return a "" or NULL value... change your numerical row references to just $row[X] X being a number without quotes 🙂

also if register globals is OFF, you will need to do $currUser = $_GET['currUser']; to get your variable from the GET array

phpgirl

Thanks for all your replies. I have tried all your suggestions..still no luck.

I did try the following also:

function getUser($id)
{

$queryStr = "SELECT * FROM tblUsers WHERE $currUser = '4'";
$result = mysql_query($queryStr);
echo "row(s) affected : ".mysql_num_rows($result);

}

The row(s) affected result was zero, but I know the database connection works in the class files, because the rest of the code works! I am soooo confused. 😕 😕 😕

I have doublechecked and my register globals is on.

tekky

replace WHERE $currUser = '4'

with WHERE [insert your userid field name here]='$currUser'

(I assume $currUser is a numerical value to reference against your ID field....

2cents

making sure $curruser is of the type you want is also important. Don't leave any flaws 🙂

phpgirl

Thanks to everyone for your replies. I just don't understand why this isn't working and this is supposed to be the simple part. :eek:

I've tried to output how many rows are affected by changing the code thus:

function getUser($id)
{

$queryStr = "SELECT * FROM tblUsers WHERE id = '$currUser'";
$result = mysql_query($queryStr);
echo "row(s) affected : ".mysql_num_rows($result);

}

and the result I get is still: row(s) affected : 0

bad76

Originally posted by phpgirl

function getUser($id)
{
$queryStr = "SELECT * FROM tblUsers WHERE id = '$currUser'";
[/B]

You are in a function... this means you have to change variable scope

Maybe this work fine:

function getUser($id)
{
global $currUser;
$queryStr = "SELECT * FROM tblUsers WHERE id = '$currUser'";
...
...

( Else, for more debug info add an "echo $queryStr;" and "echo mysql_error();" )

see you

phpgirl

bad76 - you're the man 😃

Something is happening...and at least I'm getting some results and rows affected.

Thanks for the tip on the debugging info and variable scope too - it is very helpful. I won't have to jump off the bridge tonight.:p

Thanks again for all the replies

tekky

hehe, funny how something so simple can cause so much trouble 🙂 (too bad I was busy searching for what YAG stood for 😛)

good luck phpgirl and if you are going to jump... I could recommend a nice bridge in near Saledo Creek, around Holland, Texas.... its about 20 feet above a 6-8ft deep section of water.... really fun to jump from 😃 (or say push your brother over when he aint paying attention cackle)

oke... back to the EL 🙂

tekky wonders how many people he just scared