sql php insert in to table via if statement

Question

simply put my code doesn't seem to be working probably the variables work and echo out its simply the code for insert im doing wrong no error just doesnt insert into the table.. the idea is that it inserts in to a table and replaces the data already in the id selected

if(($_REQUEST['questionbox']=="" )||($_REQUEST['boxA']=="")|| ($_REQUEST['boxB']=="")|| ($_REQUEST['boxC']=="")|| ($_REQUEST['boxD']=="")|| ($_REQUEST['correctbox']==""))
{
echo "must enter data";
}else{
 $sql2 = "INSERT INTO `tblas`(`id`, `question`, `A`, `B`, `C`, `D`, `correct`) VALUES ([".$idbox."],[".$questionbox."],[".$boxA."],[".$boxB."],[".$boxC."],[".$boxD."],[".$correctbox."])";
$editquery= mysql_query($sql2, $db);
echo $editquery;

u need to write query for UPDATE if u want to replace contents from old ID — user2663434
– user2663434, Commented Oct 19, 2013 at 10:08
You can use the UPDATE action as already mentioned. You can also use the REPLACE INTO action dev.mysql.com/doc/refman/5.0/en/replace.html — user2417483
– user2417483, Commented Oct 19, 2013 at 10:16
well that would make a difference, looking over examples how would I do this with my code? dont have to write it out just if you could show an example with my code so far I am thinking something like "UPDATE tblas SET question =$questionbox, A=$boxA WHERE id=$idbox"; would that be it? or am i far off? — Jordan Ryan
– Jordan Ryan, Commented Oct 19, 2013 at 10:21
Thank you guys for the help and yeah update worked perfectly, can't believe i didnt stumble upon that earlier!!! Thanks again!!! — Jordan Ryan
– Jordan Ryan, Commented Oct 19, 2013 at 10:25

Daniel Kreiseder · Accepted Answer · 2014-09-05 11:56:11Z

2

try this query instead of insert query

if(($_REQUEST['questionbox']=="" )||($_REQUEST['boxA']=="")|| ($_REQUEST['boxB']=="")|| ($_REQUEST['boxC']=="")|| ($_REQUEST['boxD']=="")|| ($_REQUEST['correctbox']==""))
{   
    echo "must enter data";
}else{
    $sql2 = "UPDATE tblas SET id='".$idbox."', question = '".$questionbox."', A = '".$boxA."', B = '".$boxB."' ,C = '".$boxC."', D= '".$boxD."' , correct= '".$correctbox."'";
}

echo $editquery;

edited Sep 5, 2014 at 11:56

Daniel Kreiseder

12.5k9 gold badges42 silver badges59 bronze badges

answered Oct 19, 2013 at 10:21

Prafulla

5987 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jordan Ryan Over a year ago

added where id=$idbox and it worked perfectly thank you so much!!

Collectives™ on Stack Overflow

sql php insert in to table via if statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related