while() not working

[Ukoku]

Told you I'd be back. Here's what I'm trying to set up: Click the link (or a button) and view only the rows with the corresponding information. It's going to be used to view author profiles. It should display the information of the author who was clicked.

I copy and pasted a similar script I made before, but it doesn't work now. Is it my code, or something in my database, do you think?

The link would have the url /author.php?profile=ukoku

<?php
//get the click
if(isset($_GET['profile'])) {

$fic = $_GET['profile'];

//connect to database $db snipped

$result = mysql_query("SELECT * FROM login WHERE user='$profile'",$db);

while ($myrow = mysql_fetch_array($result)) {

printf("%s %s", $myrow["user"], $myrow["handle"]);

}

//endif
} else {
echo "Please click an author's name to view their profile.";
}

?>

[Ukoku]

Err, just a note.... if I change $GET to $POST, I get no errors, but I receive the "Please click an author's name to view their profile." Hmm.

[LordShryku]

It's this

$fic = $_GET['profile'];

//connect to database $db snipped

$result = mysql_query("SELECT * FROM login WHERE user='$profile'",$db);

You set it to $fic, then reference it with $profile.

[mattsinclair]

hmm
you use $profile here:

$result = mysql_query("SELECT * FROM login WHERE user='$profile'",$db);

would it be:

$result = mysql_query("SELECT * FROM login WHERE user='$fic'",$db);

just a guess, it would probably work if that code isn't inside a function but if it is $profile wouldn't be set to the GET vars

[Ukoku]

Oh god, that was stupid. X.X Well.

Okay, that's fixed. It's now actually displaying things within the while() {}. However, it's still now showing the table information that I'm calling for....

Here's an updated version of the code:

<?php

if(isset($_GET['profile'])) {

$profile = $_GET['profile'];

//connect to database

$result = mysql_query("SELECT * FROM login WHERE user='$profile'",$db);

while ($myrow = mysql_fetch_row($result)) {

echo "This line will show, but the following printf will not.";

printf("%s %s", $myrow["user"], $myrow["handle"]);

}

} else {
echo "Please click an author's name to view their profile.";
}

?>

[Ukoku]

Never mind. I got it. Bugger.

The working code, FYI:

<?php
//get the click
if(isset($_GET['profile'])) {

//set the fic name
$profile = $_GET['profile'];

//connect to database

$result = mysql_query("SELECT * FROM login WHERE user='$profile'",$db);

while ($myrow = mysql_fetch_array($result)) {

printf("%s %s", $myrow["user"], $myrow["handle"]);

}

//endif
} else {
echo "Please click an author's name to view their profile.";
}

?>

[mattsinclair]

try

print "{$myrow["user"]} {$myrow["handle"]}"; // printf() might not work, im not entirely sure but i think if it doesn't match the format it will return nothing, like a regex

or

print_r($myrow); // to see if it's outputting anything at all

[rheroux]

mysql_fetch_row does not store data in associative indices.

You could either change mysql_fetch_row to mysql_fetch_array or use the numeric indices for your data.

{edit: Bit of bad grammar. 🙂 Seems I was a bit too slow in replying as well. 😉}

[Ukoku]

That's what it was, rheroux. I was mixing and matching rows and arrays.

Ah well. Thank you.