Problems with WHERE

[cmccomas]

$query = "SELECT number, lastname, firstname FROM roster WHERE pid=".$pid;

Tried to change it to WHERE pid='.$pid'";

What am I doing wrong?

[HalfaBee]

Try this

$query = "SELECT number, lastname, firstname FROM roster WHERE pid='$pid' ";

HalfaBee

[cmccomas]

Thanks, but no.

This is a player's personal page, it's getting his name and number from the database, then should display it with an <? echo

[HalfaBee]

Are you doing this ?

if( $result=mysql_query( $sql ) !== FALSE )
{
$d = mysql_fetch_array( $result );
echo "Player $d['firstname] $d['lastname'] got $d['number']";

}

HalfaBee

[cmccomas]

Fixed it.