If I put the following into a sql query on phpmyadmin it works:
Code: Select all
SELECT * FROM `destinations` WHERE `Destination_ID` = 'Domestic'Code: Select all
$query = "SELECT * FROM destinations WHERE DestinationID='Domestic'";Thanks
Scott
Moderator: General Moderators
Code: Select all
SELECT * FROM `destinations` WHERE `Destination_ID` = 'Domestic'Code: Select all
$query = "SELECT * FROM destinations WHERE DestinationID='Domestic'";the second query is missing a _ between Destination and ID.tazdog wrote:
If I put the following into a sql query on phpmyadmin it works:But when I try to add this to php it breaks.Code: Select all
SELECT * FROM `destinations` WHERE `Destination_ID` = 'Domestic'
Code: Select all
$query = "SELECT * FROM destinations WHERE DestinationID='Domestic'";