Note that registered members see fewer ads, and Content Link is completely disabled once you log in. Visit the following links: Site Howto | Site FAQ | Sitemap | Register Now If you have any problems with the registration process or your account login, please contact us. This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter. Please visit this page to clear all LQ-related cookies.
Try printing out the post values and make sure you're actually getting values where you should be and for the record that is seriously insecure code.$query="UPDATE client_info SET first='$ud_first', last='$ud_last', phone='$ud_phone', mob='$ud_mob', fax='$ud_fax', email='$ud_email', web='$ud_web', com='$ud_com', add='$ud_add', city='$ud_city', state='$ud_state', zip='$ud_zip', zone='$ud_zone', office='$ud_office', office_num='$ud_office_num', ext_mob='$ud_ext_mob', ext_phone='$ud_ext_phone', ext_office='$ud_ext_office', password='$ud_password' WHERE id=$ud_id;"; mysql_query($query) or die(mysql_error()); something out of the range of this question byt why assign each of the result values separately?
- ), My SQL server has updated its value too, changing it with the current date and time when the update was performed.
Hi Everyone, I have a real noob question please, I am trying to update a mysql database using the code below, I know the invoice number variable is correct, But for some reason the database is not updating, Can someone point me in the right direction please, I have tried using quotes arounf the var, but still the database is not updating - If you manually run the query, does it works?
I want to install My ODBC 2.50.28 which it need a more recent version of the My SQL server.
- The WHERE clause is important in a UPDATE query, it tells My SQL which record or records should be updated.
Search for updating mysql:
No Packages marked for Update $ sudo yum info mysql-server Loaded plugins: fastestmirror, presto Loading mirror speeds from cached hostfile * base: * extras: com * updates: centos.mirror.Installed Packages Name : My SQL-server Arch : x86_64 Version : 5.6.13 Release : 1.el6 Size : 235 M Repo : installed Summary : My SQL: a very fast and reliable SQL database server …