Jump to content

Warning: mysqli_query() [function.mysqli-query]: Empty query in /home/a3165211/p

I2aTe

By I2aTe
in MySQL Help

Recommended Posts

I2aTe Newbie

I2aTe

Posted
Posted

i need help fixing this please here is the file......  iv put where the error is in red.                                                                                                                                                              <?php

 

include("ch21_include.php");

doDB();

 

if ((!$_POST["topic_owner"]) || (!$_POST["topic_title"]) ||

(!$_POST["post_text"])) {

    header ("location: addtopic.html");

    exit;

   

    }

   

    $add_topic = "INSERT INTO forum_topics (topic_title, topic_create_time, topic_owner)

    VALUES ('".$_POST["topic_title"]."' ,now(),

    '".$_POST["topic_owner"]."')";

 

  $add_topic_res = mysqli_query($mysqli, $add_topic_sql)

    or die(mysqli_error($mysqli));

 

$topic_id = mysqli_insert_id($mysqli);

 

$add_post_sql = "INSERT INTO forum_posts (topic_id,post_text,

post_create_time, post_owner) VALUES ('".$topic_id."',

'".$_POST["post_text"]."', now(),

'".$_POST["topic_owner"]."')";

$add_post_res = mysqli_query($mysqli, $add_post_sql)

or die(mysqli_error($mysqli));

 

mysqli_close($mysqli);

 

$display_block = "<p>The<strong>" .$_POST["topic_title"]."</strong>

topic has been created.</p>";

?>

<html>

<head>

<title>New Topic Added</title>

</head>

<body>

<h1>New Topic Added</h1>

<?php echo $display_block; ?>

</body>

</html>

AyKay47 Member

AyKay47

Posted
Posted

you have assigned your query to the variable $add_topic, whereas in your mysqli_query() function, you have used $add_topic_sql...change to

 

<?php
$add_topic_res = mysqli_query($mysqli, $add_topic)
    or die(mysqli_error($mysqli));
?>

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.