Variable disappears?

[Arielladog]

Hey guys,

I've got another stupid question

I assign a variable in the URL part like this:

URL.html?WID=2

Then, I call it in PHP:

$WID

However, once I call it in a MySQL query (I can use it in PHP and re-use it), it seems to unset it's value for some reason. I've tried saying:

$WID=$WID

But that still doens't work. Here;s my first MySQL query and the first time a variable unsets.

$sqlW = mysql_query("SELECT ID, Name AS WName, MA AS WMA, City AS WCity, State AS WState, Zip AS WZip FROM work WHERE ID=$WID");
$result = mysql_fetch_array($sqlW);

aDog

[exbabylon]

try this:

$sqlW = "SELECT ... WHERE ID='$WID'";

[Arielladog]

Hey

Thanx for help. I got it figured out

aDog