if else

[Anon]

Hi i've got a table thats populated by a mysql database and what i want to happen is if you click save and the table row is empty then it inserts the new details, but if there is something in the table row then when you click save it updates the information thats there. The problem i'm having is it either replaces the whole lot or if always adds a new one and not over rights the old, heres the code that i'm using if thats any help.

<?
$db = mysql_connect ("localhost", "root", "orange");
mysql_select_db ("camco", $db);
$query = "SELECT lambitem,custno FROM workdetail";
$res = mysql_query ($query, $db);
$row = mysql_fetch_row ($res);

if ($idno == '$row[7]')

 {

$sql = "UPDATE workdetail SET lambitem='$lams',staff='$staff',hours='$hours',cost='$cost',datecomp='$donedate' WHERE idno=$idno";
$res = mysql_query ($sql, $db);

 }

else

 {

$query = "INSERT INTO workdetail (servicetype,lambitem,staff,hours,cost,datecomp,custno,aircraftreg) VALUES ('$Servicetype','$lams','$staff','$hours','$cost','$donedate','$jobid','$aircraftreg')";
$res = mysql_query ($query, $db);
}
mysql_close ($db);
header ("Location: work_carried_out.php?jobno=$jobid");
?>

thanks.

[Anon]

I've changed the code so that instead of matching a number as the idno is an auto-incrementing number it's going to be above 0 so i did if ($idno > 0) { then it runs the update statements } else { insert into} which appears to have worked. You were right i was trying to call $row[7] when i'd only selected two of the columns from the query and i'd forgot to put in a where statement for the update command. Thanks for your help, Your'll have to excuse my stupidity i've only been using php for about 4 weeks now. Thanks again, Martin

[Anon]

thanks for the help 🙂