#1064 - You have an error in your SQL syntax
Posted: Thu Jan 26, 2012 1:36 pm
Hello All, I Recently tried to Host to a new hosting service for an old database, but i am having some trouble and errors.
Some Pages Come up with an error saying "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"
Here is one of the pages that get this error.
Any Idea's on how to fix this?
Thanks
Some Pages Come up with an error saying "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"
Here is one of the pages that get this error.
Code: Select all
<?php
$GalleryID=$_GET['ID'];
// $sql_rsGallery = "SELECT * FROM tGallery WHERE GalleryID=1";
$sql_rsGallery = "SELECT * FROM tGallery WHERE GalleryID=$GalleryID";
$rsGallery = mysql_query($sql_rsGallery, $conDB) or die(mysql_error());
$totalRows_rsGallery = mysql_num_rows($rsGallery);
if ($totalRows_rsGallery > 0) {
$row_rsGallery = mysql_fetch_assoc($rsGallery);
echo $row_rsGallery['GalleryTitle3'];
echo "<br /><br /><br />";
$GalleryFolder = $row_rsGallery['GalleryFolder'];
foreach (new DirectoryIterator('gallery/'.$GalleryFolder.'/small/') as $file) {
// if the file is not this file, and does not start with a '.' or '..',
// then store it for later display
$FirstChar = $file->getFilename();
$FirstChar = $FirstChar[0];
if ( ($FirstChar != ".") && (pathinfo($file, PATHINFO_EXTENSION) == "jpg") && (!$file->isDot()) && ($file->getFilename() != basename($_SERVER['PHP_SELF'])) ) {
// if the element is a directory -> dont use it
$arrFiles[] = ($file->isDir()) ? $file="" : $file->getFilename();
}
}
//print_r($arrFiles);
asort($arrFiles);
foreach ($arrFiles as $PictureName) {
if ($GalleryFolder == "dancing") { // Gallery dancing are Portrait, so width and height are different
?>
<a href="gallery/<?php echo $row_rsGallery['GalleryFolder']; ?>/big/<?php echo $PictureName; ?>" rel="lightbox[salsa1]" title=""><img src="gallery/<?php echo $row_rsGallery['GalleryFolder']; ?>/small/<?php echo $PictureName; ?>" title="Click to enlarge" alt="" width="100" height="150" /></a>
<?php
}
else {
?>
<a href="gallery/<?php echo $row_rsGallery['GalleryFolder']; ?>/big/<?php echo $PictureName; ?>" rel="lightbox[salsa1]" title="<a href="gallery/<?php echo $row_rsGallery['GalleryFolder']; ?>/download/<?php echo $PictureName; ?>" target="_blank">Download this picture »</a>"><img src="gallery/<?php echo $row_rsGallery['GalleryFolder']; ?>/small/<?php echo $PictureName; ?>" title="Click to enlarge" alt="" width="133" height="100" /></a>
<?php
}
}
}
mysql_free_result($rsGallery);
?> Thanks