variable in a url

Can anyone help with a problem i having with the sql not being able to read the variable.

The variable is set on a previous page in a url

<a href=\"oldemailfriend.php?op=Friend&qID=$qID\"><img src=../images/friend.gif border=0 Alt=\"Email Page\"></a>";

When the link is clicked, it shows the qID value in the url

This goes to page with a function & within that is a sql query that tries to read the qID, but it does not read it

$sql = "SELECT Que from qna where qID=$qID";

// echo "$sql";

The sql print shows no values

Any suggestions.

Thanks

You need to either pass $qID into your function in your call statement like this:

your_function($qID);

Or declare $qID as a global within your function like this:

function your_function(){
global $qID;
// the rest of your function stuff
}

Either way should get your sql statement working.

Steve, below is part of the function & that i am trying to get it to work with

function FriendSend($qID) {

$connection = mysql_connect("$connectdb","$uname","$pass")

or die ("Couldn't connect to server.");

$db = mysql_select_db("qna", $connection) or die ("Unable to select database.");

//create sql statement

$sql = "SELECT Que from qna where qID=$qID";

// echo "$sql";

//execute sql query and get results

$sql_result = mysql_query($sql) or die("Couldn't execute query.");

// $row = mysql_num_rows($sql_result);

list($Que) = mysql_fetch_row($sql_result);

Are you passing a variable into the function when you execute it? You should have something like:

FriendSend($id_variable);

$id_variable is what you are passing into the function. $qID is what is used within the function.

Sorry to sound thick, but i dont follow

These pages in the manual probably explain it better than I have......