PHP & DWMX go to detail page

[maxxtraxx]

hi all,

i have a results page that lists several items, i have a column that has a
text link that i added the server behavior " Go to detail page". When
testing this page locally it works just fine. the DWMX window returns my
expected results. however the problem i am running into is i notice in the
URL it passes the line:

www.mydomain.com/calendar.php?did=2003-05-01&ti=15

now these variables are correct, however when testing on my remote, the
column returns NULL. so, i queried the remote server:

SELECT sum(NumRiders) as totalRiders
FROM rides
WHERE `Date` = '2003-05-01' AND `TimeID` = '15'

and my column totalRiders returns a correct value.

so, (i think) i have determined that the server behavior is not passing the
necessary single quotes to properly query the database.

how do i include the single quotes when passing my parameters?

thanks

[mat]

Hello, welcome to WebmasterWorld. Far from an expert, but single quotes often need 'escaping' with a \ character if your PHP/Apache setup doesn't have a setting called 'magic quotes' turned on.

[maxxtraxx]

thanks, that did the trick!