By frdesign on

I'm using the following query to save data to a table:

<?php
db_query("INSERT INTO {xmltrips_trafalgar_list} (trip_name, trafalgar_url, continentID) VALUES('%s', '%s', '%s')", $traf_trip_name, $traf_trip_url, $traf_trip_continent);
?>

If my trip name is called "Trinidad & Tobago" for example, what's saved to the db is "Trinidad & Tobago". So when I try to look for rows that match "Trinidad & Tobago" in another query there's no match.

Any suggestions?
Thanks