removing parts of string

I have created a form that pulls off a list of contacts from a MySQL database.
They are then displayed inside of a form, using the select tag and a submit button. The method used is post

however, when the selection is posted, it is stripping off all text after a space.

for example

old house - then will send "old"
3I's - then it sends "3I\"

How can I get it to transfer across the whole string as displayed in my database?

Cheers

its ok, crisis averted, figured it out

when I was defining the table inside PHP tags, I was wrapping tab values in ' '

changed it to \" and all is ok now

What does your insert statement look like?

actually Dog, you could help with something else
What SQL query edits a record direct, because I only seem to have table structure examples at my disposal.

What I mean is, I can edit table columns, delete records etc...

But how do I tell a MySQL database that I want to edit a particular record and replace it with new properties

Example.
Table = Abdials

I need a command that tells that table to search for an entry using a WHERE clause and replace it with posted variables

Any ideas?

should do it

see below - does this look right!! the table I'm amending has 2 columns, contactName and abdialNumber: Would this then be right?

looks write now

contactName and abdialNumber (I know I left row2 in my last post )

I have now amended my page and all seems to go through ok, I get my message saying that I have successfully amended that record, however, to no avail, it has not actually amended anything

any thoughts

Do you not have a primary key row in your table? (an INT value)

I do confess that in my eagerness to learn, I didnt have an ID column.
Because I simply was trying things out, I created the table as told in previous posts.
I have exported all the data, recreated the database and imported the backed up data, but I amended the exported file so that it adds an ID column when importing.

So in summary, I now do have an auto incrementing INT column in every table

Cool so you still having the same problem?

not as such no, all seems to be working great
however, I do have one record, which appears in the database as

3I's - Newcastle

But when posted, it changes to

3I\

Any idea why this is??[/b]

strip the slashes from your output. You bviously have the magic runtime situation set to on.

So the DBMS escapes all special characters ie ' with \' so it doens't ready it as a single quote

well I'll have to take a look at that at some point.
I've worked round it for now however as what as I was doing initially, to get the users login name (which is always displayed when navigating the site), was to initially pull in the variable $AUTH_USER, which when printed, give me a result of something like domain\\\\username

but this method was crap because I couldnt delete records out of the database by username due to the problem with the slashes

I've recreated both databases with the ID column now anyways and the users now have choice to create own login name, works much simpler and more concise