Home > php_mysql > Get Data From MySQL Database

Get Data From MySQL Database


< ?php
include 'config.php';
include 'opendb.php';

$query = 'SELECT * FROM news WHERE id="'.mysql_real_escape_string($_GET['id']).'"';
$result = mysql_query($query);

echo mysql_result($result, 2); // outputs third employee's name

while($row = mysql_fetch_assoc($result))
{
    echo "Name :{$row['name']} <br>" .
         "Subject : {$row['subject']} <br />" .
         "Message : {$row['message']} <br /><br />";
}

UPDATE table_name
SET column_name = new_value
WHERE column_name = some_value

include 'closedb.php';
?>
Categories: php_mysql Tags:
  1. No comments yet.
  1. No trackbacks yet.

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