error message impossible to fix :(

so im connecting my netbeans php to phpmyadmin (database)… now in this i am trying to create a php code statement which will take the inserted data into the html fields and insert them into my database successful… anybody know what im doing wrong here is the error message:

Warning: mysql_query() expects parameter 1 to be string, resource given in C:\xampp\htdocs\PhpProject1\New Review.php on line 27
error inserting new record

[php]<?php
if (isset($_REQUEST[‘submitted’])) {

include('connect database.php');


$showtitle = $_POST['SHOWTITLE'];
$showreview =$_POST['SHOWREVIEW'];
$sqlinsert = "INSERT INTO reviews (SHOWTITLE,SHOWREVIEW) VALUES('$showtitle', '$showreview')";

if (!mysql_query($dbConn,$sqlinsert)) {
    die('error inserting new record'); 
    
    
    
}[/php]

here is my html coding with it

New Reviews Enter show title: Enter Review:

Are you sure it should be mysql_query and not mysqli_query?

With mysql_query it would be

[php]mysql_query($sqlinsert,$dbConn)[/php]

But with mysqli_query it would be

[php]mysqli_query($dbConn,$sqlinsert)[/php]

Sponsor our Newsletter | Privacy Policy | Terms of Service