I tried that and got no errors but the information was not written to the database. I think the issue is a am querying and writing at the same time. I was hoping someone would be able to help. Time to hit the books I guess. Thanks anyway all.
yes all US zips are numeric
I tried to change $query_sname = "SELECT frm_shop.sname FROM frm_shop WHERE frm_shop.sassignzip = 'czip' ";
to
$query_sname = "SELECT frm_shop.sname FROM frm_shop WHERE frm_shop.sassignzip =" . $czip;
It throws an error
You have an error in your SQL syntax...
Ok the two tables are frm_cust and frm_shop there are several columns in each but the ones that are of inportance are frm_shop.sname, frm_shop.sassignzip the are the tables to be read and frm_cust.czip is where the dynamic data will be gathered and frm_shop.sname will be writen to frm_cust.refto...
Ok I am new to php and need some help.
I have created a form that rights to a customers table I have a second table that contains shop information. What I I am trying to do is have the customer fill out the form and based on the zip code he/she enters right the name of the shop contained in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.