Execute Mysql query in php

Question

I'm sure I'm getting the vaue of $bn and $answer on my page now I just want to insert the value in the column answer value $answer where qid is $bn.

<?php

$answer = $_POST['one'];
$an = $_POST['two'];
$bn = $an - 1;
echo "$bn";
$con = mysql_connect('localhost', 'root', 'pankaj') or die(mysql_error());
$db = mysql_select_db('quiz', $con) or die(mysql_error());
$q = "INSERT INTO question(uanswer) VALUE '" . $answer . "' where qid='" . $bn . "'";
$rq = mysql_query($q, $con);
if (!$rq) {
    echo " the sql query faiiled to work ";
} else {
    echo "the query executed sucessfully";
}
?>

Use Update Insert not support where condition.

Pramod
– Pramod

2014-03-21 09:46:16 +00:00
Commented Mar 21, 2014 at 9:46 — Pramod
– Pramod, Commented Mar 21, 2014 at 9:46

Abhishek · Accepted Answer · 2014-03-21 09:46:06Z

1

Do you want to update the database or insert? INSERT will not work with WHERE clause.

answered Mar 21, 2014 at 9:46

Abhishek

5674 silver badges19 bronze badges

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

Comments

Shankar Narayana Damodaran · Accepted Answer · 2014-03-21 10:14:05Z

1

The INSERT statement does not support WHERE clause.

Syntax on how to write an INSERT statement.

edited Mar 21, 2014 at 10:14

answered Mar 21, 2014 at 9:44

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

7 Comments

Abhishek Over a year ago

this is weired,this is second time I am facing this

Abhishek Over a year ago

@ Shankar Damodaran but its not letting me do urs,but why this is happening?is it by some moderators?

Shankar Narayana Damodaran Over a year ago

@Abhishek, Doesn't matter.

Casimir et Hippolyte Over a year ago

Why did you delete this answer: stackoverflow.com/questions/22556648/…

Shankar Narayana Damodaran Over a year ago

@CasimiretHippolyte, Because it didn't get any attention ..moreover that solution was not regex based.

|

Collectives™ on Stack Overflow

Execute Mysql query in php

2 Answers 2

Comments

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related