Hi guys
I was hoping that someone can help me with this PHP script I have. At the moment the pictures and information array downwards I want it to show random images and information with jquery cycle. I have jquery cycle working and know how to implement it but cant seem to get my head around the PHP script below. I just want it to show one image/information at a time while cycling!
Thanks in advance.
<?php
// $mysql="select * from tbl_classified order by rand() limit 0,1 ";
// $mysql="select * from tbl_classified where classified_status!='Delete' order by classified_id DESC limit 0,9";
$mysql = 'SELECT tbl_classified.classified_id, tbl_classified.classified_title, tbl_classified_image.cls_img_file FROM tbl_classified'
.' LEFT JOIN tbl_classified_image ON tbl_classified.classified_id = tbl_classified_image.clsd_id'
." WHERE tbl_classified.classified_status='Active' AND tbl_classified.paid_status IN ('Free', 'Received') AND tbl_classified_image.img_status='Y'"
.' GROUP BY tbl_classified.classified_id ORDER BY tbl_classified.classified_id DESC limit 0,5';
//$mysql="select * from tbl_classified where classified_id=4 ";
$resultnav = mysql_query($mysql);
while($rownav = mysql_fetch_array($resultnav)) {
if($rownav['cls_img_file'] != '') {
$file_sm = UP_FILES_WS_PATH.'/classified_img/'.$rownav['cls_img_file'];
$file_path_sm = show_thumb($file_sm, '200', '300', 'width');
?>
| |
<?php
}
}
?>
thats the script! I just want it to show one image/information at a time. Thanks