Here what I have: dual layer SQL, works perfectly fine on local server, but when i uploade file to the web server nothing is working... grrr i alredy spend 3 days trying all possible things that i could and couldnt think of... and the worthest thing is that id doesnt return the error... well the problem is w. sendond SQL statement when i type select ID manually like "27" it works fine but not dinamocaly
So here is the code:
Code: Select all
<?
include("db_conn.php");
$db = mysql_connect($db_server, $db_user, $db_pass);
mysql_select_db($db_name, $db);
$i = "0";
$img_dir = "img_banners/";
$sql_banner = "select * from uc_front_banner WHERE active='Yes'";
$result_banner = mysql_query($sql_banner);
while ($row_banner = mysql_fetch_array($result_banner)) {
$ddelay = $row_banner['rotate_time'];
$banner_id = $row_banner['id'];
echo "$banner_id<br>";
$sql = "select * from uc_front_banner_file WHERE event='$banner_id'";
$result = mysql_query($sql);
while ($row_news = mysql_fetch_array($result)) {
?>
fadeimages[<? echo $i; ?>]=["<? echo "$img_dir". $row_news['file'] .""; ?>", "", ""] //plain image syntax
<?
$i = $i+1;
}
}
$ddelay = $ddelay * 666;
echo "var ddelay = '$ddelay'";
?>Code: Select all
27
fadeimages[0]=["img_banners/index-zzz_19.jpg", "", ""] //plain image syntax fadeimages[1]=["img_banners/bg_pink.jpg", "", ""] //plain image syntax var ddelay = '666'Code: Select all
var ddelay = '0'Apresiate any help, I wont survive 4th day w/ this! Please help!
Thanks!