Home > php_mysql > Get Data From MySQL Database

Get Data From MySQL Database

October 8th, 2007 Leave a comment Go to comments
PLAIN TEXT
PHP:
  1. <?php
  2. include 'config.php';
  3. include 'opendb.php';
  4.  
  5. $query = 'SELECT * FROM news WHERE id="'.mysql_real_escape_string($_GET['id']).'"';
  6. $result = mysql_query($query);
  7.  
  8. echo mysql_result($result, 2); // outputs third employee's name
  9.  
  10. while($row = mysql_fetch_assoc($result))
  11. {
  12.     echo "Name :{$row['name']} <br>" .
  13.          "Subject : {$row['subject']} <br />" .
  14.          "Message : {$row['message']} <br /><br />";
  15. }
  16.  
  17. UPDATE table_name
  18. SET column_name = new_value
  19. WHERE column_name = some_value
  20.  
  21. include 'closedb.php';
  22. ?>

Categories: php_mysql Tags:
  1. No comments yet.
  1. No trackbacks yet.

0 pages viewed, 0 today
0 visits, 0 today
FireStats icon Powered by FireStats