Getting information out of the url

mdowling

I want to put information into the url of a php page. From that page I want to be able to get the information out of the url address. Right now I send this url to my viewinfo.php file:

http://www.sigmanu-etazeta.com/viewinfo.php?pnum=1019

From viewinfo.php I use $_GET['pnum'] and it doesn't actually give me a value.
Here is the actual code (used to sort data in a mysql)

$sql = "SELECT * FROM Registered WHERE UserPIN = '" . $_GET['pnum'] . "'";

this doesn't work for some reason. Anybody know how to fix this?

BIOSTALL

I cant see any reason that wouldnt work :-S i've run a query using a session variable in exactly that format and it works fine.

Perhaps you could do store the gotten 'pnum' value in a variable and then include the variable name in the query, eg:

$pnum = $_GET['pnum'];
$sql = "SELECT * FROM Registered WHERE UserPIN = '$pnum'";

BIOSTALL

Rodney_H_

mdowling wrote:
$sql = "SELECT * FROM Registered WHERE UserPIN = '" . $_GET['pnum'] . "'";

You have quotes mix-up. That's the problem.

$sql = "SELECT * FROM Registered WHERE UserPIN = (DOUBLE-QUOTE) . $_GET['pnum'] . (DOUBLE-QUOTE);

But I totally recommend what BIOSTALL says:

$pnum = $_GET['pnum'];

$sql = "SELECT * FROM Registered WHERE UserPIN = '$pnum'";

😃

LoganK

How about make it really simple and include the array variable right in the query?

$sql = "SELECT * FROM Registered WHERE UserPIN='{$_GET['pnum']}'";