How to Update one column (point) in php sql [duplicate]

by

It is very easy…

$con = mysql_connect("servername","username","password");
mysql_select_db("databasename");
$command = "UPDATE tuser SET point="your value" where id=whatever";
//replace 'your value' with the new value and "whatever" with the user id
mysql_query($command);
mysql_close_connection($con);

Next time don’t ask so stupid questions here… use Google

More Related Contents:

  1. Save the data into a database and return another value from database using PHP
  2. Problame with files on SQL
  3. Im trying to create some temporary tables in mysql using php
  4. How can I prevent SQL injection in PHP?
  5. SQL injection that gets around mysql_real_escape_string()
  6. How to include a PHP variable inside a MySQL statement
  7. How can I do ‘insert if not exists’ in MySQL?
  8. How to apply bindValue method in LIMIT clause?
  9. Can I parameterize the table name in a prepared statement?
  10. Use global variables in a class
  11. How do I get the query builder to output its raw SQL query as a string?
  12. Examples of SQL Injections through addslashes()?
  13. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  14. PDO with INSERT INTO through prepared statements [closed]
  15. Insert query on page load, inserts twice?
  16. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 [closed]
  17. Comma separated values in MySQL “IN” clause
  18. Doing a while / loop to get 10 random results
  19. Using value of a column as index in results using PDO
  20. MYSQL Select from tables based on multiple rows
  21. How to pass custom type array to Postgres function
  22. How to print SQL statement in codeigniter model
  23. How to execute raw queries with Laravel 5.1?
  24. How to populate HTML dropdown list with values from database
  25. How do you do multiple SQL statements in one mysql_query?
  26. MySQL/SQL retrieve first 40 characters of a text field?
  27. how do I get month from date in mysql
  28. Php & Sql Injection – UTF8 POC
  29. Updating column so that it contains the row position
  30. Aggregated query without GROUP BY

Leave a Comment