Updating multiple fields in access Random chat rooms

Try to print the query with echo $query_string_variable Then execute the query in the database by itself [not from PHP You can also try the other way...to write a query by providing static values and run the query into the database. Why are you using single quotes around the variables in your queries?if the query runs take it and use variables to provide the values. Also, print these query and execute in the backend database Well, i tried running the query using the My SQL GUI (Navi CAT) wioth static data. The query runs perfectly well for 'dod' and 'yod', but when i run it for 'mod', it shows the error, You have an error in your SQL syntax, check the manuala that corresponds to your My SQL server version for the right syntax to use near 'mod = '12' where ID = '1" at line 1 PS... If the fields are integers, they don't require string indicators. That could very well be the other part of your problem.

Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site. You can use the combo box Column property to access it's column data. Column(0) would return the first column in the currently selected row of combo box [Combo Box Name]. Column(1) would return the second column on the currently selected row, which you could assign a field to equal this value. Column(2) More information on the Column property can be found in the help files.You can specify 2 numbers for this property, which the second number would then be the row index to return a column that is not the currently selected row, but this defaults to the List Index value so that it will be selecting from the current row if you don't specify. On -0700, bo****@(Bobbak) wrote: Hello All, I was wondering if it is at all possible to have a single combo boxupdate multiple fields in a single record.I'm running an update query that's based on a select query (that runs some calculations).

The update query is updating ALL the rows that should be updated with the information in the select query with data from the final row in the select query, and not on a per ID basis as I think I have it set-up to do.

when i use a single UPDATE-SET command(using commas/AND etc etc.... only the first field gets updated, the other 2 remaining as they are.

I tries using 3 diff commands, and this , somehow, causes col 1 and 3 to update, leaving col 2 unchanged. it shows:- update client set dod='10', mod='4',yod='2008' where id='120'.... I think the update commands with three column update should work fine.

THE CODE $qur= "update `users` set `username`='".$_POST['username']."', `password`='".$_POST['password']."', `name`='".$_POST['name']."', `email`='".$_POST['emailid']."', `phone`='".$_POST['phoneno']."', `country`='".$_POST['country']."', `county`='".$_POST['county']."', `city`='".$_POST['city']."', `pincode`='".$_POST['zip']."', `shipping`='".$_POST['shipping']."', `billing`='".$_POST['billing']."', `organisation`='".$_POST['org']."', `fax`='".$_POST['fax']."' where id=".$_GET['id']; mysql_query( $qur) ; i tried using a common update command, but when i use it with mysql_error(), it reports the following error: You have an error in your SQL syntax, check the manual that corresponds to your My SQL server version for the right syntax to use near 'mod = '77' ,yod='8899' where ID =56 at line 1. and then the table (with the 'date' and 'year' column updated, but the 'month' column as it is...).. But you can check what are the values you are supplying, what are the table column data type, check are you sending null values or not, you may need to convert data to the right type.

Try to print the query with echo $query_string_variable Then execute the query in the database by itself [not from PHP You can also try the other way...to write a query by providing static values and run the query into the database.

I know I have figured this out before - so I know it is doable - but the way to do it escapes me right now. In the Criteria row put 1 In the Update To row put Yes Welcome to the forum Ya - the form I am using restates the same info 4 times for 4 different peoples information - I know it should just have the same info once and the info should be submitted 4 times - but it is a form for a school with users that area not very computer savy and I want all the info on one continuous form.