NYCPHP Meetup

[Jeff]

I'm creating check boxes on the fly. Here's a sample of the output on
the form:

<input name="ALFA-ROMEO|1600 DUETTO SPIDER" type="checkbox" value="1">

Now here's the post data:
[ALFA-ROMEO|1600_DUETTO_SPIDER]

Jeff

-----Original Message-----
From: tom at supertom.com [mailto:tom at supertom.com] 
Sent: Thursday, June 19, 2003 9:58 AM
To: NYPHP Talk
Subject: RE: [nycphp-talk] MySQL and spaces in data


Jeff,

What does your insert query look like, and what type of column are you
inserting into?  I can't yet see why this would happen (spaces replaced
with
underscores).

Tom



-----Original Message-----
From: Jeff [mailto:jsiegel1 at optonline.net]
Sent: Thursday, June 19, 2003 10:50 AM
To: NYPHP Talk
Subject: [nycphp-talk] MySQL and spaces in data


How does MySQL handle the following?

I'm trying to save a car model called "1600 DUETTO SPIDER."
I noticed it saves it with underscores.

What happens when I retrieve that data in a query? Does it come back as
1600_DUETTO_SPIDER?
Or, if I need to retain the spaces, do I do something like %20 or
something like &nbsp; when I save the data?

Jeff








--- Unsubscribe at http://nyphp.org/list/ ---