Re: pass text variables to next page
| From: | Chris Stinemetz | Date: | Tue, 09 Aug 2011 12:30:47 +0000 |
| Subject: | Re: pass text variables to next page | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-314441@lists.php.net to get a copy of this message | ||
Thank you Tamara.
Not sure if I am doing it right. It looks like the last single quote
is being escaped.
When I dump the query I get:
SELECT store_id, store_subject FROM stores WHERE store_subject =
'Bella Roe 4980 Roe Blvd\'
I am thinking maybe I have too many single quotes some where, but I
can't find it.
echo '<h4><a href="store.php?id=' . $storerow['store_subject'] .
'">'
. $storerow['store_subject'] . '</a></h4> at ' .
date('m-d-Y',
strtotime($storerow['store_date']));
The query:
$sql = "SELECT store_id, store_subject
FROM stores
WHERE store_subject = '" .
mysql_real_escape_string($_GET['id']."'");
Thank you,
Chris