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 Mar 21 '14 at 09:46 — Pramod, Mar 21 '14 at 09:46

Shankar Narayana Damodaran · Answer 1 · 2014-03-21T10:14:05.327

1

The INSERT statement does not support WHERE clause.

Syntax on how to write an INSERT statement.

edited Mar 21 '14 at 10:14

answered Mar 21 '14 at 09:44

Shankar Narayana Damodaran

68,075
43
96
126

this is weired,this is second time I am facing this – Abhishek Mar 21 '14 at 10:05
@ Shankar Damodaran but its not letting me do urs,but why this is happening?is it by some moderators? – Abhishek Mar 21 '14 at 10:09
@Abhishek, Doesn't matter. – Shankar Narayana Damodaran Mar 21 '14 at 10:10
Why did you delete this answer: http://stackoverflow.com/questions/22556648/php-regexp-extract-last-part-of-string#22556740 – Casimir et Hippolyte Mar 21 '14 at 11:13
@CasimiretHippolyte, Because it didn't get any attention ..moreover that solution was not `regex` based. – Shankar Narayana Damodaran Mar 21 '14 at 11:15
@ShankarDamodaran: I was about to upvote it! The fact that it is not a regex based solution is not really a problem. Most people believes that a regex based solution is always the fastest way. – Casimir et Hippolyte Mar 21 '14 at 11:18
@CasimiretHippolyte, Undeleted it mate. – Shankar Narayana Damodaran Mar 21 '14 at 11:20

score 1 · Answer 2 · answered Mar 21 '14 at 09:46

1

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

answered Mar 21 '14 at 09:46

Abhishek

517
3
18

Execute Mysql query in php

2 Answers2