First I build my select list:
    <SELECT NAME="Cid" size="1">
    <OPTION Selected VALUE="">All Customers</OPTION>

 While ($Site = mysql_fetch_array($S)) 
  $Sid = $Site["CID"];
  $SName = htmlspecialchars($Site["Customer"]);
  echo("<option value='$SName'>$SName</options>\n");

The optional value displays the ['] correctly when I look at the source.

When the submit button is clicked, it passes this form value Cid to the
Result.php page.

First I convert the posted value

$FF = $_POST ['Cid'];

then I use it in a select statement

$Info = mysql_query(select * FROM customer WHERE customer.customer LIKE
'$FF' );

When the customer name is all text, it works fine, but when the customer has
the [']
In it like St Mary's, the value I get on the Result.php page is St Mary


-----Original Message-----
From: ma [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 05, 2003 1:18 PM
Subject: Re: [PHP-DB] Select Value with 's


do not quite understand your problem.. pls post some code?
heres a small snippet that should work well...

$qry = 'SELECT `customer` FROM `customerList` ORDER BY `customer`'; $res =
mysql_query($qry); while($customer = mysql_fetch_object($res)) {
    echo stripslashes($res->customer).'<br>'."\n";



# life would be easier if i knew the source code...

> Von: "Aleks @ USA.net" <[EMAIL PROTECTED]>
> Datum: Wed, 5 Nov 2003 13:12:45 -0500
> Betreff: [PHP-DB] Select Value with 's
> This is a basic question but I am all messed up and need to be 
> straightened out..
> Have a select field called customer that works great except when there 
> is a '  in the customer name.
> Have tried addslash and stripslashes but I think I might be using them 
> wrong.
> If I addslash to the select value, the value received but the result 
> page is truncated up to the point of
> the '   .....
> Can someone refresh me on the correct use of add and strip slashes...
> please??
> Thanks
> Aleks

PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to