update mySQL with prepopulated data in a called form

[smelsco]

Ok, here is the looooong story for what is hopefully an easy fix.

All of the files listed here are included in the zip file and a live TEST version of all this can be found at http://www.on-sitetechsupport.com/test/
Feel free to add and change anything here, this is a test db.

I schedule customers through my website and i want current customers to be able to login and have all their information populated in an editable form in addition to the scheduling fields.

I am able to call the data based on email address and have it populated in the form:

If the user DOES NOT change any of the prepopulated information, the data is submitted into the proper tables in the database and the correct information is sent via email.

If the user CHANGES any of the prepopulated data,(address, phone #, etc ) the updated data is entered into the appointments table and emailed, but the data is not updated in the customers table.

i have a file called custlist.php (which is in the zip file) that calls all the customers in the db and each of them is editable. The update functon here (custupdated.php)works fine, when i call the update_and_schedule_cust.php it works fine.

When get_cust.php (this is the page that displays the called info based on them entering their email address) calls either custupdated.php or update_and_schedule_cust.php it does not work. This makes me think there is a problem with get_cust.php however i can't find it.

Whew, that wasn't as bad as i thought it would be.

Any help is greatly apreciated.

[coreyp_1]

1. You are not checking to see whether or not an email is actually on file. I entered a random e-mail address, and the page get_cust.php returned 15 MySQL errors.

2. I receive an error after pressing the "U" button on the custlist.php page. This is cause by the three characters "" which appear before the PHP code in the custupdated.php page.

3. These same three characters appear at the beginning of update_and_schedule_current_cust.php. Do they serve some purpose?

4. I cannot tell what is (or is not) happening. Please be more specific in describing your error so that we can reproduce it. (i.e., do this, do this, then do this. This should happen, but instead this is happening.)

5. I tried to register as a new customer, but I didn't know the right zip code!

[smelsco]

I took the form validation off, (thuoght i did that earlier)

As far as checking to see if they are in the database, i know. I haven't figured out how to do that yet so i figured i would leave it out of this problem.

No the three characters mean nothing, not sure where they come from.

There are 2 email addresses you can play with [e-mail] and [e-mail] or you can enter your own.

on the first page, enter [e-mail] for the email address,
this will bring up the prepopulated page. Make any changes you want to the info, and click submit.

From here, the updated info should update in the database table 'customers' and enter the appointment info(as well as name and phone# (i know this is the wrong wat to do this and that i should join the two tables etc. . . but i'm lazy)) into the 'appointments' table, then it sends me an email with all the updated info.

Now, here's what actually happens, the prepopulated info DOES NOT get updated in the 'customers table', but it DOES get entered into the 'appointments' table and also gets emailed.

You can go to http://www.on-sitetechsupport.com/test/cust2/custlist.php and make any changes there and they stick. I am using the same code (slightly modified) for both forms and both update scripts.

[coreyp_1]

This problem will be an interesting one to track down. on the update_and_schedule_current_cust.php, we need to see what information is getting passed, as well as what the mysql query looks like.

echo '<pre>' . print_r($_POST, true) . '</pre>';

Also echo the $queryUpdateCust string.

We'll go from there. (I must be gone for the afternoon, but will look at this when I get back home tonight.

[smelsco]

I had to run out of town for a week so i will try this when i get back. Thanks for your help so far and please don't give up on me, i will be back on Friday with this change.

[smelsco]

Thanks for trying to help corey. You are the only one in 6 different forums that even attempted to help me, so for that i want to say thanks.

On the topic of

1. You are not checking to see whether or not an email is actually on file. I entered a random e-mail address, and the page get_cust.php returned 15 MySQL errors. <<

I know and i don't know enough php to do it. Any thoughts or help is greatly appreciated.

The rest of the errors you found have all been fixed.