It's probably something obvious...

[rulinus]

Hi
I'm having trouble editing mysql DB and it's probably something really simple. I'm just hoping that more eyes could be the difference. Heres the code:

<? 
mysql_connect("localhost", "myusid", "mypsw") or die ("Problem connecting to DataBase"); 
$query = "UPDATE starjet2 SET dataID='',ata='$ata', description='$desc', model='$model', pn='$pn', sn='$sn', remove_by='$remove', remdate='$date', observations='$observ', manufac='$manufac' WHERE dataID='$dataID'"; 
$result = mysql_db_query("virginia_inventario", $query); 
 if ($result){
 echo "<font color=navy face=arial>Data updated. new table:</font><br><p></p>"; 
 }
 else {
 echo "<font color=red face=arial>No edditing was possible! Please try again later.</font><br><p></p>";
 }
$query = "SELECT * FROM starjet2";  

$result = mysql_db_query("virginia_inventario", $query);

//here's the array showing the data in the table

else{
echo "<font color=red face=arial>No data found.</font>";
} 

When executed i get the "no edditing Possible..." warnig i placed, and the other weird thing i get the "no data found." warnig afterwards.
Any observation or samaritan help would be most appreciated.
thanks
rulo

[_SuperString]

if(!mysql_query($query)) {
    echo "ok, there was an error:<br>".mysql_error();
} else {
    echo "it worked perfectly fine.";
}