UPDATE not updating db

[iBuddy]

if (isset($submit_notes)) {
mysql_connect("localhost", "db_data", "xxxx"); 
mysql_select_db("data"); 

$update_result = mysql_query("UPDATE cfo SET notes = '$update_notes' WHERE ordernumber = '$upd_id' ");
echo "updated<br>$result";
}

Whats wrong with this? its not updating the database i have no idea why its not

[iBuddy]

Here is the full code:

                    <?
## Update notes ####
####################
if (isset($submit_notes)) {
mysql_connect("localhost", "xxx", "xxx"); 
mysql_select_db("xxxx"); 
$update_result = mysql_query("UPDATE cfo SET notes = '$update_notes' WHERE ordernumber = '$upd_id' ");
echo "updated<br><br>$update_result";
}
## end 

?>				  

//here is the form for updating 
<form name="form1" method="post" action=""><strong>Record notes:</strong><br>
                        <textarea name="update_notes" cols="85" rows="6" id="update_notes"><? echo $show[notes]; ?></textarea>
                        <br>
                        <input name="submit_notes" type="submit" id="submit_notes" value="Add / Edit notes">
                        </p>
                        <input name="upd_id" type="text" disabled="true" id="upd_id" value="<? echo $show[ordernumber]; ?>" size="4">
                        <br>
                        <br>
                        Last updated on <? echo $show[lastupdated]; ?>
                  </form>

[njm]

what does mysql_error() say about the query, if anything?

njm

[iBuddy]

okay i changed it to

     $uresults = mysql_query("UPDATE cfo SET notes = 'testt3443ttttt' WHERE ordernumber = '3651' ");
mysql_error($uresults);     

*I changed the variables to see simplify my errors and narrow down whats going on here.

The error I get is this:

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/dmovers/public_html/admin/cfo.php on line 253

[iBuddy]

I changed that again to:

    $uresults = mysql_query("UPDATE cfo SET notes = 'testt3443ttttt' WHERE ordernumber = '3651' ");
mysql_error();  

and no errors are displayd. very strange

[iBuddy]

GReat nevermind guys i got it!

[Weedpacket]

Would be able to tell us how, so that anyone else in the same position will have some pointers?

[iBuddy]

lots of trial and error...I really didnt know what the heck the main problem was however I got it somehow...just kept trying several different things.