This just doesnt work wtf??

intrigue

<?php
require('header.php');
?>
<link href="style.css" rel="stylesheet" type="text/css">
<center>
<h2>Friends</h2>
</center>

<?php 
require('db_fns.php'); 

if(isset($_GET['friend'])) 
{ 
// Connect to the database server and select database
$db = connectdb();
// Run query to get all inforation
	$result = @mysql_query("SELECT id, name, age, friendship, picture FROM friends where name = '$friend'"); 
	if (!$result) { 
	     echo("<p>Error performing query: " . mysql_error() . "</p>"); 
	     exit(); 
		      }
// Display info in a table
   while ( $row = mysql_fetch_array($result) ) { 
    	$id = $row["id"];
	$name = $row["name"];
	$age = $row["age"];
	$friendship = $row["friendship"];
	$picture = $row["picture"];
	echo
	(
	"<center>$friendship </A>"
	);
   };  

}

else

{

// Connect to the database server and select database
$db = connectdb();
// Run query to get all inforation
   	$result = @mysql_query("SELECT id, name, age, friendship, picture FROM friends Order By name"); 
   	if (!$result) { 
     		echo("<p>Error performing query: " . mysql_error() . "</p>"); 
     		exit(); 
   		} 
// Display info in a table 
   while ( $row = mysql_fetch_array($result) ) { 
    	$id = $row["id"];
	$name = $row["name"];
	$age = $row["age"];
	$friendship = $row["friendship"];
	$picture = $row["picture"];
	echo
	(
	"<center> <a href='friends.php?friend=$name'>$name - $age</A>"
	);
   };  

}
?>


<?php
require('footer.php');
?>

Ok i have the second part of the if statement pass the variable to itself by reloading the page and the variable is then declared using $_GET but it doesnt work.

Can anyone see a problem ?
/Matt

Pig

You don't have any database connection information. You cannot connect to the database unless you specify the server, user and password. Also, it appears the second set is doing the exact same thing the first set is doing. If it doesn't work the first time, you can be guarenteed it will not work the second time. Also, saying "it does't work" is not very helpful. Tell us what exactly happens. Does it produce an error? Does it give you 404? You mention using $_GET, but it does appear in your code at all. Finally, make sure you connect to the database AND select the database within the server. Always add: or die("blah blah blah"); to your connection commands so you know if you didn't connect properly.

intrigue

Originally posted by Pig
You don't have any database connection information. You cannot connect to the database unless you specify the server, user and password. Also, it appears the second set is doing the exact same thing the first set is doing. If it doesn't work the first time, you can be guarenteed it will not work the second time. Also, saying "it does't work" is not very helpful. Tell us what exactly happens. Does it produce an error? Does it give you 404? You mention using $_GET, but it does appear in your code at all. Finally, make sure you connect to the database AND select the database within the server. Always add: or die("blah blah blah"); to your connection commands so you know if you didn't connect properly.

Are you not seeing what im seeing.
Ok when i say it doesnt work i mean i have tested it by explicitly saying id = 1 and it works its just the variable it isnt getting.

database connection is provided via
require('db_fns.php');

The second set doesnt do excactly the same, basically the second one is the general page which shows the person and their age, if they have clicked the link of that person it reloads the page and displays the top info which is the persons name age friendship and picture and more when i get it working.
if(isset($_GET['friend']))

That is used there.

OhLordy

Could you say the exactly what is happening that is unexpected? I'm assuming that it's echoing the link when it should just be echoing the friendship. Try doing a print_r($_GET) before the if to see exactly what is in the array.
HTH
Rob

Pig

OK, I understand what you are saying now. I'll second what Oh Lordy said.

intrigue

Ok well whats happening is the bottom parts working where it gets the link of the persons name and age, however the top part which is just getting the friendship info isnt working.
It just comes up empty like the query has not ran and i know its not ran because it has no info from "friendid" but cant understand why its not getting the info as i have passed it across in the url like i have before. So therfore there must be some simple explination that i am missing
/matt

Pig

2 things to try.
1st, use the same syntax in your query as you do in your test (ie: $GET['var'] instead of $var)
$result = @("SELECT id, name, age, friendship, picture FROM friends where name = '" . $GET['friend'] . "'");

2nd, go through each level of curly brackets and have it echo a statement to see where it is dying.

Honestly, it sounds like you just have register globals off.

intrigue

no register globals is on its my webserver so i checked that but i will give ya ideas a go
thanks
/matt