<?php
if (file_exists(INFUSIONS."random_photo_panel/locale/".$settings['locale'].".php")) {
include INFUSIONS."random_photo_panel/locale/".$settings['locale'].".php";
} else {
include INFUSIONS."random_photo_panel/locale/English.php";
}

$result=dbquery(
"SELECT ta.album_id,album_title,photo_id,photo_thumb2,photo_filename,photo_title FROM ".$db_prefix."photo_albums ta ".
"INNER JOIN ".$db_prefix."photos USING (album_id) ORDER BY RAND() LIMIT 1"
);

if (dbrows($result) == 1) {
@openside($locale['FOT_001']);
$data=dbarray($result);

if ($data['photo_thumb2'] == ""){
echo "<div style='text-align:center'>
<a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."' class='gallery'>
<img src='".BASEDIR."images/photoalbum/".$data['photo_filename']."' width='100' height='75'
title='".$data['photo_title']."' alt='".$data['photo_title']."'>
</a><br /><a href='".BASEDIR."photogallery.php?album=".$data['album_id']."'>".$data['photo_title']."</a>
<br />
".$data['album_title']."
</div>";
}
else{
echo "<div style='text-align:center'>
<a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."' class='gallery'>
<img src='".BASEDIR."images/photoalbum/".$data['photo_thumb2']."' width='100' height='75'
title='".$data['photo_title']."' alt='".$data['photo_title']."'>
</a><br /><a href='".BASEDIR."photogallery.php?album=".$data['album_id']."'>".$data['photo_title']."</a>
<br />
".$data['album_title']."
</div>";
}
@closeside();
}
?>

Klaida

SQL užklausa:

CREATE TABLE `photos` (
$result = dbquery(
"DROP TABLE IF EXISTS ".$db_prefix. "photos"
);

MySQL atsakymas: ?
#1064 - 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 '= dbquery("DROP TABLE IF EXISTS ".$db_prefix."photos")' at line 2

<?php
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."photos");
$result = dbquery("CREATE TABLE ".$db_prefix."photos (
photo_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
album_id SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_title VARCHAR(100) NOT NULL DEFAULT '',
photo_description TEXT NOT NULL,
photo_filename VARCHAR(100) NOT NULL DEFAULT '',
photo_thumb1 VARCHAR(100) NOT NULL DEFAULT '',
photo_thumb2 VARCHAR(100) NOT NULL DEFAULT '',
photo_datestamp INT(10) UNSIGNED NOT NULL DEFAULT '0',
photo_user SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_views SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_order SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
photo_allow_comments tinyint(1) unsigned NOT NULL default '1',
photo_allow_ratings tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (photo_id)
) TYPE=MyISAM;");
?>

Minzee parašė:
Ar tipo taip?



Bet as nesuprantu kur wisa tai kelt