500 internal server error???

[joecooper]

this is a script that connects to a mysql database, and updates an entry in the prices table where ID = 1

 

i cant seem to work out why its getting a 500 error.

 

the script is here: http://doom4files.com/update.php

 

<?php
session_start();
include("db.php"); //include database file

    $sql="SELECT price FROM price WHERE id=1 LIMIT 1";
    $result=mysql_query($sql);
    $row = mysql_fetch_assoc($result); 
    $price = $row['price']
    $newprice = $price / 100 * 101
mysql_query("UPDATE price SET price = $newprice WHERE id = '1'");
echo "old price is $price, new price is $newprice";

?>

[dezkit]

<?php
session_start();
include("db.php"); //include database file

    $sql="SELECT price FROM price WHERE id=1 LIMIT 1";
    $result=mysql_query($sql);
    $row = mysql_fetch_assoc($result); 
    $price = $row['price'];
    $newprice = $price / 100 * 101;
mysql_query("UPDATE price SET price = $newprice WHERE id = '1'");
echo "old price is $price, new price is $newprice";

?>

[joecooper]

oh... it would usually not give a 500 error