I have an ASP site that I am moving to PHP. There is a query that I am using, but it does not work correctly. The ASP page query is:
SELECT *
FROM directory
WHERE (place = 'delivery' OR place = 'Both') AND topic = true
ORDER BY Organization ASC
Dim rsDirectorydelivery
rsDirectorydelivery = "1"
if (Request.QueryString("delivery") <> "") then rsDirectorydelivery = Request.QueryString("delivery")
Dim rsDirectoryplace
rsDirectoryplace = "1"
if (Request.QueryString("jurisdiction") <> "") then rsDirectoryplace = Request.QueryString("jurisdiction")
Dim rsDirectorytopic
rsACEProviderstopic = "1"
if (Request.QueryString("topic") <> "") then rsDirectory__topic = Request.QueryString("topic")
The PHP page has the following:
SELECT *
FROM directory
WHERE (place = 'delivery' OR place = 'Both') AND topic = 1
ORDER BY Organization ASC
$deliveryrsDirectory = '1';
if (isset($delivery)) {
$deliveryrsDirectory = $delivery;
}
$placersDirectory = '1';
if (isset($jurisdiction)) {
$placersDirectory = $jurisdiction;
}
$topicrsDirectory = '1';
if (isset($topic)) {
$topicrsDirectory = $topic;
Can someone please help and tell me why it won't work?
Thanks