Php & Db Update

[infin]

Hi,

I'm having a problem with some code, everything seems to work, but when I do the update it doesn't effect the database. What could be causing this, have I made a mistake in my code or with my SQL syntax? Please help..


<?PHP
session_start();
?>

<?php

$ud_ref=$_POST['ud_ref'];
$ud_name=$_POST['ud_name'];
$ud_number=$_POST['ud_number'];
$ud_email=$_POST['ud_email'];
$ud_descr=$_POST['ud_descr'];


if ($ud_ref == "") echo "! No identifier retrieved";
else
echo "Amending record $ud_ref";

//clean up any carriage returns etc

$ud_name = preg_replace("/[\n\r]*/","",$ud_name);
$ud_number = preg_replace("/[\n\r]*/","",$ud_number);
$ud_email = preg_replace("/[\n\r]*/","",$ud_email);
$ud_descr = preg_replace("/[\n\r]*/","",$ud_descr);

$server = "mysql5.xxxx.com";
$login_name = "xxxx";
$password = "xxxx";

//Connecting to MYSQL
$db = MySQL_connect("$server","$login_name","$password");

//Select the database we want to use
mysql_select_db("staticdream") or die("Could not select database");
echo $ud_name;
$q = "UPDATE tblrrrequests SET name = '****you', number = '$ud_number', email = '$ud_email', descr = '$ud_descr' WHERE reference = {$ud_ref};";

$result = mysql_query($q);
if ($result) {
echo "it worked!"
} else {
echo "it failed!"
}
echo "$result<br /><br />";

echo "<BR>Record $ud_ref <-- Updated<BR><BR>";

//if you want to check it's ok, display new data

echo "Search on $ud_ref<BR>";

$q="SELECT * FROM tblrrrequests WHERE reference = {$ud_ref}";

$result = mysql_query( $q, $db )
or die(" - Failed More Information:<br><pre>$q</pre><br>Error: " . mysql_error());

$num_rows = mysql_num_rows($result);
if ($myrow = mysql_fetch_array($result)) {

echo "<table border=0>\n";
echo "<tr><td></td><td></td><td></td><td></td></tr>\n";


do {
printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td>
</tr>\n", $myrow["reference"], $myrow["name"], $myrow["number"], $myrow["email"], $myrow["descr"] );

} while ($myrow = mysql_fetch_array($result));
echo "</table>\n";
} else {
echo "Sorry, no records were found";
}

mysql_free_result($result);
mysql_close($db);
session_destroy();

?>

[infin]

i fixed the problem it had to do with the database not being set to InnoDB.

thanks anyway