Jquery Cycle for PHP Script

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

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]<?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
	}
}

?>[/php]

Sponsor our Newsletter | Privacy Policy | Terms of Service