I am trying to pass text strings from on page to a next to populate the queries on the passed to page.
The only way I can get the query to work is if I am able to put single ticks around the string to make it literal, but I can't seem to figure out how to do it for the following line of code. echo '<h3><a href="store.php?id=' . $row['store_name'] . '">' . $row['store_name'] . '</a><br /><h3>' . $row['store_type']; When i do a dump the query and print("<pre>".print_r($_GET,true)."</pre>"); I get the following respectively: SELECT store_id, store_subject FROM stores WHERE store_subject = Loma Vista 8712 Blue Ridge BlvdThe topic could not be displayed, please try again later.You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Vista 8712 Blue Ridge Blvd' at line 3 The PHP code for the query is: Array ( [id] => Loma Vista 8712 Blue Ridge Blvd ) $sql = "SELECT store_id, store_subject FROM stores WHERE store_subject = " . mysql_real_escape_string($_GET['id']); The query works fine When I run the command in console and place '' around Loma Vista 8712 Blue Ridge Blvd Thank you, Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php