INSERT in a WHILE LOOP Not Inserting into Database

Question

I have a SELECT statement, WHILE statement and an INSERT:

$result = mysqli_query($con,"SELECT winner, time, course, market, twitter_pubstatus
FROM combo 
WHERE twitter_pubstatus = 0 AND market = '$win' GROUP BY winner");
while($row = mysqli_fetch_array($result))
{
$winner = $row['winner'];
$time = $row['time'];
$course = $row['course'];

$message = "$winner won the $time at $course.  You are a winner! #GetIn";

$query = "INSERT INTO messageTable (MESSAGE) VALUES($message)or die(mysql_error())";

}

It runs through with no errors. There should be 12 rows that get inserted into the database. What am I doing wrong?

Try changing $query = "INSERT INTO messageTable (MESSAGE) VALUES($message)or die(mysql_error())"; to $query = "INSERT INTO messageTable (MESSAGE) VALUES('$message')or die(mysql_error())"; Notice the single quotes in '$message' — Professor
– Professor, Commented Apr 8, 2014 at 11:46
in addition u are not executing the insert query .. and mixing mysql with mysqli mysql_error() — Abhik Chakraborty
– Abhik Chakraborty, Commented Apr 8, 2014 at 11:46

Professor · Accepted Answer · 2014-04-08 12:06:12Z

1

Try changing $query = "INSERT INTO messageTable (MESSAGE) VALUES($message)or die(mysql_error())"; to $query = "INSERT INTO messageTable (MESSAGE) VALUES('$message')or die(mysql_error())";

Notice the single quotes in '$message'

And $query is just a string so execute the query
$result=mysqli_query($query)

And then check if query executed by doing this if(!$result) die(mysqli_error());

edited Apr 8, 2014 at 12:06

answered Apr 8, 2014 at 11:50

Professor

6284 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

INSERT in a WHILE LOOP Not Inserting into Database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related