jck

for my jokes site when i click next button i want to make only the text of the joke reload rather than the whole page like header and footer how do i do it

oops i got it

SELECT ItemID from dd_items WHERE ItemCategory = '$a1[itemCategory]' AND ItemID < '$ItemID' AND ItemStatus = 'approved' LIMIT 1 this is always taking me to the last item of a category.... i dont understand how

yes it worked thanks

$rnextcat = mysql_query("SELECT CategoryID from dd_categories WHERE CategoryID > '$a1[itemCategory]' ORDER by CategoryID DESC LIMIT 1"); $rnc = mysql_fetch_array($rnextcat); $rncid = mysql_query("SELECT ItemID from dd_items WHERE ItemCategory = '$rnc['CategoryID']' AND ItemStatus = 'approved' ORDER by ItemID DESC LIMIT 1"); $rowncid = mysql_fetch_array($rncid); $next = $rowncid['ItemID']; to fetch the first item of the next category....... it seems ok but its not worrking

stored as float

there is no field for rating in the table ecause it is not storing decimals so on the pages its dynamically calculated so i need to order by ratesum divided by ratecount

what is sum(ratesum/ratecount)

suppose in a table there are ratesum and ratecount and rating is ratesum/ratecount how do i sort them in descending order of rating

So people call that leeching; some call it bandwidth theft. since the free host im using has bandwidth limit i want to store some images in google pages

i need it to get an image from another site not the same one

i want the image to be one in a link stored in a variable like http://www.site.com/pic.gif stored in $var how do i do it echo "<td align=center valign=top width=100><center><img src=\"../items_images/$NewImageName\" width=100></center></td>\n\t<td>";

im planning to use rate sum if two jokes have same rate avg..... but how do i transfer from old table......

thanks for the reply xyn but that had already been solved please read the further ones to see the new problem

i guess i can write a while loop and run it once..... but the problem in that is some ItemID's in the jokes database dont exist