passing url parameters 1

[manicleek]

I am trying to pass a url parameter, the url looks like this:

http://localhost/details.php?marina=128

I have tried using

$detailsquery = "SELECT * FROM marinas WHERE marina=$_GET['marina']";

to get the details but this came up with the error

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in udetails.php on line 9

Should I be using something else in my sql?

 

[Vragabond]

PHP doesn't like referencing arrays inside double quotes. Just move the $_GET array out of the quotes and it should work.

$detailsquery = "SELECT * FROM marinas WHERE marina=" . $_GET['marina'];

Hope this helps.