[Resolved] not showing anything. but i think its right code

[demosthenes705]

<?php 
include ('db.php');

$result = mysql_query ("SELECT * FROM `users` WHERE `grade` = '9'") or die(mysql_error()); 

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

$teacher = $row['teacher'];
$grade = $row['grade'];

$link = "<br><a href=\"notes.php?teacher=$teacher\">";
echo "$teacher - $link<br>";

}

?>

so i have that and all it shows is

-
that is a clickable link but it leads to

notes.php?teacher=

[tomhath]

Try printing what's in $row inside the while loop:

echo '<pre>';
print_r($row);
echo '</pre>';

[demosthenes705]

didn't work for me

it showed everything.

can you print the code for me. i just replaced the echo and it i got everything.

[tsinka]

Hi,

what exactly does print_r print ? The link is not complete, there's the closing (</a>) tag and some link text missing.

Thomas

[demosthenes705]

here is what it prints

Array
(
[0] => 7
[userid] => 7
[1] => guest
[first_name] => guest
[2] => guest
[last_name] => guest
[3] => 9
[grade] => 9
[4] => [e-mail]
[email_address] => [e-mail]
[5] => guest
[username] => guest
[6] => 084e0343a0486ff05530df6c705c8bb4
[password] => 084e0343a0486ff05530df6c705c8bb4
[7] => guest
[decrypted_password] => guest
[8] => this is a guest account
[info] => this is a guest account
[9] => 0
[user_level] => 0
[10] => 2005-02-25 21:44:54
[signup_date] => 2005-02-25 21:44:54
[11] => 0000-00-00 00:00:00
[last_login] => 0000-00-00 00:00:00
[12] => 1
[activated] => 1
)

[tsinka]

I can't see any key named teacher. Which value do you want to use as get parameter ?

Thomas

[demosthenes705]

haha thanks

i ment teachername

since that isn't there i am adding it lol myb