the get in't working

devil_online

I have this code, it seams that it is everything right, but somehow it won't print the information I want in info.php

here is the code in the first page:

 
while ($row1 = mysql_fetch_array($result1)) {

echo '<a href="info.php?p="' . $row1['players'] . '">' . $row1['players'] . '</a>';

}

and the info.php files is like this:

 
$player = mysql_real_escape_string($_GET['p']);
$sql = 'SELECT * FROM equipa WHERE jogadores = \'' . $player . '\'';
$query = mysql_query($sql);
$details = mysql_fetch_array($query);
echo $details['age'];

Can anybody help me?

thanks

gufmn

Have you tried echoing $player and doing print_r($details) to make sure your values are what you expect them to be?

devil_online

yes, i've echo player and theres nothing printed.

Thanks for any help I really need on this one.

Fernashes

When you get to the second page (info.php), if you look at the URL, can you see the variable which you've passed via the url? In this case it should be something like

info.php?p=passed_value

Is that showing up correctly?

devil_online

nop...it only shows info.php?p=

thanks

halojoy

devil_online wrote:
nop...it only shows info.php?p=
thanks

Which indicates $rows1[player] has got NO VALUE
from the database line

devil_online

stange..if I echo row1['player'] it display the name of the player.

harlowhair

Maybe thats the problem - in your original code you are using 'players' not player

devil_online

no!
my mistake...the variables are corrected typed...

Just one kestion: is this code correct?:
echo '<a href="info.php?p="' . $row1['players'] . '">' . $row1['players'] . '</a>';

thanks

harlowhair

I can see the problem -

echo '<a href="info.php?p="' . $row1['players'] . '">' . $row1['players'] . '</a>';

you have a " after info.php?p= which means that it is closing the href string. The resulting string will look like:

<a href="info.php?p="playername">etc...

Try:

echo "<a href=\"info.php?p=" . $row1['players'] . "\">" . $row1['players'] . "</a>";

it is easier to read the code when only using " and escape characters. Also, when passing a variable via the querystring, you never enclose it in speechmarks.

Hope this helps

devil_online

yes it work..many thanks... 😃