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