Sql syntax; check the manual that corresponds to your mariadb server version for the right syntax to use near '''' at line 1

Question

1.00/5 (1 vote)

See more:

this is my code

PHP

<p>PLEASE ENTER YOUR MOVIE NAME :
        
      </p><br><br>
        
      
       0 );
        {
        while ($row =mysqli_fetch_assoc($result)) {
          echo 'Name :'.$row['name'].'<br>'.'Gener :'.
          $row['gener'].'<br>'.'Year of prodction :'.
          $row['yearofprodction'].'<br>'.'Your opinion :'
          .$row['opinion'];
          break;
         }
       }
      }
      else{
       header("Location:page2form.php");
      }

       ?>

What I have tried:

i tride to delet the ; $NAME ....................

Posted 17-Feb-23 6:42am

renad1423

Updated 19-Feb-23 6:41am

CHill60

v2

Add a Solution

Comments

CHill60 17-Feb-23 12:48pm

You haven't shared your sql statement - that is where the error is

Richard Deeming 20-Feb-23 6:15am

REPOST
You have already posted this question:
Sql syntax; check the manual that corresponds to your mariadb server version for the right syntax to use near '''' at line 1[^]

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andre Oosthuizen · Answer 1 · 2023-02-19T06:41:00

Solution 1

With no sql statement posted, it is almost impossible to guess where the error occurred. Seems you are working with movies so genre pops to mind, you have it spelled as gener, might be your problem.

Posted 19-Feb-23 6:41am

Andre Oosthuizen

Sql syntax; check the manual that corresponds to your mariadb server version for the right syntax to use near '''' at line 1

1 solution

Solution 1

Add your solution here

Preview 0

Sql syntax; check the manual that corresponds to your mariadb server version for the right syntax to use near '''' at line 1

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us