FUDforum: comp.lang.php » cause of error is what?

Home » Imported messages » comp.lang.php » cause of error is what?

Show: Today's Messages :: Polls :: Message Navigator

cause of error is what? [message #181567]

Wed, 22 May 2013 01:44

richard

Messages: 213
Registered: June 2013

Karma:

Senior Member

Can't get past the error message.
Could not run query: 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 '' at line 1
www.mroldies.net/menu2.php

<?php

$year=$_GET["year"];
if (empty($year)) {$year=1900;}
$year=(int)$year;

/* connect to the db */
$con = mysql_connect('localhost','user','pass');

if (!$con){die("can not connect: " . mysql_error());}

mysql_select_db('richbull_top100',$con);

echo "<div style='clear:left;'>";

if ($year==1900){echo '<iframe width="1000" height="500" src="test2.php"
frameborder="0"></iframe>';}
else {echo $year."\n";

$result = mysql_query("SELECT atitle,artist,avid FROM A$year WHERE id =
$number");
if (!$result) { echo 'Could not run query: ' . mysql_error(); exit; }
$vid = mysql_fetch_row($result);

echo $vid[0];

}

echo "</div>";

?>

Report message to a moderator

[Message index]

		cause of error is what? By: richard on Wed, 22 May 2013 01:44
		Re: cause of error is what? By: richard on Wed, 22 May 2013 01:54
		Re: cause of error is what? By: David Robley on Wed, 22 May 2013 02:35
		Re: cause of error is what? By: Scott Johnson on Wed, 22 May 2013 04:35
		Re: cause of error is what? By: Thomas 'PointedEars' on Wed, 22 May 2013 10:25
		Re: cause of error is what? By: Scott Johnson on Wed, 22 May 2013 12:34
		Re: cause of error is what? By: Scott Johnson on Wed, 22 May 2013 12:48
		Re: cause of error is what? By: Thomas 'PointedEars' on Wed, 22 May 2013 21:05
		Re: cause of error is what? By: richard on Wed, 22 May 2013 17:03
		Re: cause of error is what? By: Scott Johnson on Wed, 22 May 2013 23:42
		Re: cause of error is what? By: Beauregard T. Shagnas on Thu, 23 May 2013 00:21
		Re: cause of error is what? By: Scott Johnson on Thu, 23 May 2013 12:42
		Re: cause of error is what? By: Denis McMahon on Thu, 23 May 2013 16:02
		Re: cause of error is what? By: Scott Johnson on Thu, 23 May 2013 22:33

Previous Topic:	Google Voice App Comes To iPhone
Next Topic:	use a value form a manu list in a form on the same page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 08:22:32 GMT 2024

Total time taken to generate the page: 0.05714 seconds