php

asim_pc · April 23rd, 2008, 01:33 AM

When I running this programme to retrieve the data from table,
its gives me this type of error in browser window, given below .

You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax
to use near '>1990 ORDER BY movie_type' at line 1.

Please tell me about its solution.

Thank You.

This is the programme given below.

<?php
$connect=mysql_connect("localhost","root","asimpc" )
or die("Hey loser,check your server connection.");
mysql_select_db("moviesite");

$query="SELECT movie_name,movie_type ".
       "FROM MOVIE".
       "WHERE movie_year>1990 ".
       "ORDER BY movie_type ";
$results=mysql_query($query)
or die(mysql_error());

while($row=mysql_fetch_array($results))
{
extract($row);
echo $movie_name;
echo " - ";
echo $movie_type;
echo "<br>";
}
?>

ciderpunx · May 13th, 2008, 09:16 AM

A quick hint on debugging sql problems is to print your sql statement. It would have helped here ;)

Code:

$query="SELECT  movie_name,movie_type ".
       "FROM MOVIE".
       "WHERE movie_year>1990 ".
       "ORDER BY movie_type ";
echo $query;

Gives us:

Code:

SELECT  movie_name,movie_type FROM MOVIEWHERE movie_year>1990 ORDER BY movie_type

See the missing space? So, try:

Code:

$query="SELECT  movie_name,movie_type ".
       "FROM MOVIE ". // <-- extra space here
       "WHERE movie_year>1990 ".
       "ORDER BY movie_type ";
echo $query;

And we get:

Code:

SELECT  movie_name,movie_type FROM MOVIE WHERE movie_year>1990 ORDER BY movie_type

HTH
Charlie

--
Charlie Harvey's website - linux, perl, java, anarchism and punk rock: http://charlieharvey.org.uk