Page 1 of 1

(should be) simple sql help needed

Posted: Fri Feb 29, 2008 5:47 pm
by trilbyfish
i am doing a booking system, and currently trying to code a page where the user clicks on a row to edit, and the relevent row comes up on another page so that it can be edited.

at the moment i am trying to do the sql which selects the relevent row from the mysql database.

this code:

Code: Select all

$query = "SELECT * FROM bookingtable WHERE id = 1";
works but only selects the first row where the id is 1, but i want it so that it selects the id of the row that was clicked on in the previous page.

the page this is on allready is http://*******.com/********/**********/editbay.php?id=9, so the page knows which id link was clicked on in the previous page.

the code i am thinking of is something along the lines of

Code: Select all

$query = "SELECT * FROM bookingtable WHERE id =' . $row['id'] . '";
, but this gives the error

Code: Select all

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING
Please help me, i know this might be a bit incoherent but i would be very greatful if someone could help me to get this working, and then i could move on to the next thing.

Thanks in advance.

Re: (should be) simple sql help needed

Posted: Thu Mar 06, 2008 2:19 pm
by francisjeffy
Hi,

Try the line below, it should work

Code: Select all

$query = "SELECT * FROM bookingtable WHERE id ='$row[id]'";
Kind Regards,

jeF

Re: (should be) simple sql help needed

Posted: Thu Mar 06, 2008 2:35 pm
by Zoxive

Code: Select all

$ID = (int)$_GET['id']; // Convert to Integer so we know exactly what it is
$query = "SELECT * FROM `bookingtable` WHERE `id` = {$ID} ";