nathan1

Hi Guys, i want to echo titles from the database and have a limit of 6, but when i click next i want to be able to go through extra titles in the database - is that possible ? appreciate any help, cheers

nope, no go - but thanks for the imput

thanks, but i want to have it ajax, the example is php only - sorry but im not fluent in ajax enough to translate it.

Hi Guys, im trying to get this pagination scrip to work - - - i have the pagination script, it all works but i want only 6 titles to show, if 6 are shown and you can click next and show more titles...does this make sense ? Currently i have the button next, and just goes to the next title..... appreciate ANY help !! THANKS The J.S code is; document.write('<style type="text/css">' //write out CSS for class ".hidepeice" that hides pieces of contents within pages +'.hidepiece{display:none}\n' +'@media print{.hidepiece{display:block !important;}}\n' +'</style>') function virtualpaginate(config){ //config: {piececlass:, piececontainer:, pieces_per_page:, defaultpage:, persist} this.piececlass=config.piececlass var elementType=(typeof config.piececontainer=="undefined")? "div" : config.piececontainer //The type of element used to divide up content into pieces. Defaults to "div" this.pieces=virtualpaginate.collectElementbyClass(config.piececlass, elementType) //get total number of divs matching class name //Set this.chunksize: 1 if "chunksize" param is undefined, "chunksize" if it's less than total pieces available, or simply total pieces avail (show all) this.chunksize=(typeof config.pieces_per_page=="undefined")? 1 : (config.pieces_per_page>0 && config.pieces_per_page<this.pieces.length)? config.pieces_per_page : this.pieces.length this.pagecount=Math.ceil(this.pieces.length/this.chunksize) //calculate number of "pages" needed to show the divs this.paginatediv=[], this.flatviewlinks=[], this.cpspan=[], this.selectmenu=[] this.persist=config.persist var persistedpage=virtualpaginate.getCookie("dd_"+this.piececlass) || 0 var urlselectedpage=virtualpaginate.urlparamselect(this.piececlass) //returns null or index from: mypage.htm?piececlass=index this.currentpage=(typeof urlselectedpage=="number")? urlselectedpage : ((this.persist)? persistedpage : config.defaultpage) this.currentpage=(this.currentpage<this.pagecount)? parseInt(this.currentpage) : 0 //ensure currentpage is within range of available pages this.showpage(this.currentpage) //Show selected page } // ------------------------------------------------------------------- // PUBLIC: navigate(keyword)- Calls this.showpage() based on parameter passed (0=page1, 1=page2 etc, "next", "first", or "last") // ------------------------------------------------------------------- virtualpaginate.prototype.navigate=function(keyword){ var prevlinkindex=this.currentpage //Get index of last clicked on page if (keyword=="previous") this.currentpage=(this.currentpage>0)? this.currentpage-1 : (this.currentpage==0)? this.pagecount-1 : 0 else if (keyword=="next") this.currentpage=(this.currentpage<this.pagecount-1)? this.currentpage+1 : 0 else if (keyword=="first") this.currentpage=0 else if (keyword=="last") this.currentpage=this.pagecount-1 //last page number else this.currentpage=parseInt(keyword) this.currentpage=(this.currentpage<this.pagecount)? this.currentpage : 0 //ensure pagenumber is within range of available pages this.showpage(this.currentpage) for (var p=0; p<this.paginatediv.length; p++){ //loop through all pagination DIVs if (this.flatviewpresent) this.flatviewlinks[p][prevlinkindex].className="" //"Unhighlight" previous page (before this.currentpage increments) if (this.selectmenupresent) this.selectmenu[p].selectedIndex=this.currentpage if (this.flatviewpresent) this.flatviewlinks[p][this.currentpage].className="selected" //"Highlight" current page } } // ------------------------------------------------------------------- // PUBLIC: buildpagination()- Create pagination interface by calling one or more of the paginate_build_() functions // ------------------------------------------------------------------- virtualpaginate.prototype.buildpagination=function(divids, optnavtext){ var divids=(typeof divids=="string")? [divids] : divids //force divids to be an array of ids var primarypaginatediv=divids.shift() //get first id within divids[] var paginaterawHTML=document.getElementById(primarypaginatediv).innerHTML this.paginate_build(primarypaginatediv, 0, optnavtext) for (var i=0; i<divids.length; i++){ document.getElementById(divids[i]).innerHTML=paginaterawHTML this.paginate_build(divids[i], i+1, optnavtext) } } // ------------------------------------------------------------------- // PRIVATE utility functions // ------------------------------------------------------------------- virtualpaginate.collectElementbyClass=function(classname, element){ //Returns an array containing DIVs with specified classname if (document.querySelectorAll){ var pieces=document.querySelectorAll(element+"."+classname) //return pieces as HTMLCollection } else{ var classnameRE=new RegExp("(^|\\s+)"+classname+"($|\\s+)", "i") //regular expression to screen for classname within element var pieces=[] var alltags=document.getElementsByTagName(element) for (var i=0; i<alltags.length; i++){ if (typeof alltags[i].className=="string" && alltags[i].className.search(classnameRE)!=-1) pieces[pieces.length]=alltags[i] //return pieces as array } } return pieces } virtualpaginate.urlparamselect=function(vpclass){ var result=window.location.search.match(new RegExp(vpclass+"=(\\d+)", "i")) //check for "?piececlass=2" in URL return (result==null)? null : parseInt(RegExp.$1) //returns null or index, where index (int) is the selected virtual page's index } virtualpaginate.getCookie=function(Name){ var re=new RegExp(Name+"=[^;]+", "i"); //construct RE to search for target name/value pair if (document.cookie.match(re)) //if cookie found return document.cookie.match(re)[0].split("=")[1] //return its value return null } virtualpaginate.setCookie=function(name, value){ document.cookie = name+"="+value } // ------------------------------------------------------------------- // PRIVATE: showpage(pagenumber)- Shows a page based on parameter passed (0=page1, 1=page2 etc) // ------------------------------------------------------------------- virtualpaginate.prototype.showpage=function(pagenumber){ var totalitems=this.pieces.length //total number of broken up divs var showstartindex=pagenumber*this.chunksize //array index of div to start showing per pagenumber setting var showendindex=showstartindex+this.chunksize-1 //array index of div to stop showing after per pagenumber setting for (var i=0; i<totalitems; i++){ if (i>=showstartindex && i<=showendindex) this.pieces[i].style.display="block" else this.pieces[i].style.display="none" } if (this.persist){ //if persistence enabled virtualpaginate.setCookie("dd_"+this.piececlass, this.currentpage) } if (this.cpspan.length>0){ //if <span class="paginateinfo> element is present, update it with the most current info (ie: Page 3/4) for (var p=0; p<this.cpspan.length; p++) this.cpspan[p].innerHTML='Page '+(this.currentpage+1)+'/'+this.pagecount } } // ------------------------------------------------------------------- // PRIVATE: build() methods- Various methods to create pagination interfaces // paginate_paginate_build()- Main build() paginate function // paginate_output_flatview()- Accepts <span class="flatview"> element and populates it with sequential pagination links // paginate_paginate_build_flatview()- Parses the modified <span class="flatview"> element and assigns click behavior to the pagination links // paginate_build_selectmenu(paginatedropdown)- Accepts an empty SELECT element and turns it into pagination menu // paginate_build_regularlinks(paginatelinks)- Accepts a collection of links and screens out/ creates pagination out of ones with specific "rel" attr // paginate_build_cpinfo(cpspan)- Accepts <span class="paginateinfo"> element and displays current page info (ie: Page 1/4) // ------------------------------------------------------------------- virtualpaginate.prototype.paginate_build=function(divid, divpos, optnavtext){ var instanceOfBox=this var paginatediv=document.getElementById(divid) if (this.chunksize==this.pieces.length){ //if user has set to display all pieces at once, no point in creating pagination div paginatediv.style.display="none" return } var paginationcode=paginatediv.innerHTML //Get user defined, "unprocessed" HTML within paginate div if (paginatediv.getElementsByTagName("select").length>0) //if there's a select menu in div this.paginate_build_selectmenu(paginatediv.getElementsByTagName("select")[0], divpos, optnavtext) if (paginatediv.getElementsByTagName("a").length>0) //if there are links defined in div this.paginate_build_regularlinks(paginatediv.getElementsByTagName("a")) var allspans=paginatediv.getElementsByTagName("span") //Look for span tags within passed div for (var i=0; i<allspans.length; i++){ if (allspans[i].className=="flatview") this.paginate_output_flatview(allspans[i], divpos, optnavtext) else if (allspans[i].className=="paginateinfo") this.paginate_build_cpinfo(allspans[i], divpos) } this.paginatediv[divpos]=paginatediv } virtualpaginate.prototype.paginate_output_flatview=function(flatviewcontainer, divpos, anchortext){ var flatviewhtml="" var anchortext=anchortext || new Array() for (var i=0; i<this.pagecount; i++){ if (typeof anchortext[i]!="undefined") //if custom anchor text for this link exists flatviewhtml+='<a href="#flatview" rel="'+i+'">'+anchortext[i]+'</a> ' //build pagination link using custom anchor text else flatviewhtml+='<a href="#flatview" rel="'+i+'">'+(i+1)+'</a> ' //build pagination link using auto incremented sequential number instead } flatviewcontainer.innerHTML=flatviewhtml this.paginate_build_flatview(flatviewcontainer, divpos, anchortext) } virtualpaginate.prototype.paginate_build_flatview=function(flatviewcontainer, divpos, anchortext){ var instanceOfBox=this var flatviewhtml="" this.flatviewlinks[divpos]=flatviewcontainer.getElementsByTagName("a") for (var i=0; i<this.flatviewlinks[divpos].length; i++){ this.flatviewlinks[divpos][i].onclick=function(){ var prevlinkindex=instanceOfBox.currentpage //Get index of last clicked on flatview link var curlinkindex=parseInt(this.getAttribute("rel")) instanceOfBox.navigate(curlinkindex) return false } } this.flatviewlinks[divpos][this.currentpage].className="selected" //"Highlight" current flatview link this.flatviewpresent=true //indicate flat view links are present } virtualpaginate.prototype.paginate_build_selectmenu=function(paginatedropdown, divpos, anchortext){ var instanceOfBox=this var anchortext=anchortext || new Array() this.selectmenupresent=1 for (var i=0; i<this.pagecount; i++){ if (typeof anchortext[i]!="undefined") //if custom anchor text for this link exists, use anchor text as each OPTION's text paginatedropdown.options[i]=new Option(anchortext[i], i) else //else, use auto incremented, sequential numbers paginatedropdown.options[i]=new Option("Page "+(i+1)+" of "+this.pagecount, i) } paginatedropdown.selectedIndex=this.currentpage setTimeout(function(){paginatedropdown.selectedIndex=instanceOfBox.currentpage}, 500) //refresh currently selected option (for IE's sake) paginatedropdown.onchange=function(){ instanceOfBox.navigate(this.selectedIndex) } this.selectmenu[divpos]=paginatedropdown this.selectmenu[divpos].selectedIndex=this.currentpage //"Select" current page's corresponding option } virtualpaginate.prototype.paginate_build_regularlinks=function(paginatelinks){ var instanceOfBox=this for (var i=0; i<paginatelinks.length; i++){ var currentpagerel=paginatelinks[i].getAttribute("rel") if (currentpagerel=="previous" || currentpagerel=="next" || currentpagerel=="first" || currentpagerel=="last"){ //screen for these "rel" values paginatelinks[i].onclick=function(){ instanceOfBox.navigate(this.getAttribute("rel")) return false } } } } virtualpaginate.prototype.paginate_build_cpinfo=function(cpspan, divpos){ this.cpspan[divpos]=cpspan cpspan.innerHTML='Page '+(this.currentpage+1)+'/'+this.pagecount } The HTML code is; <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Matt</title> <script type="text/javascript" src="virtualpaginate.js"> </script> <style type="text/css"> .paginationstyle{ width: 600px; text-align: center; padding: 2px 0; margin: 10px 0; } .paginationstyle select{ border: 1px solid navy; margin: 0 15px; } .paginationstyle a{ /*Pagination links style*/ padding: 0 5px; text-decoration: none; border: 1px solid black; color: navy; background-color: white; } .paginationstyle a:hover, .paginationstyle a.selected{ color: #000; background-color: #FEE496; } .paginationstyle a.imglinks{ /*Pagination Image links style (class="imglinks") */ border: 0; padding: 0; } .paginationstyle a.imglinks img{ vertical-align: bottom; border: 0; } .paginationstyle a.imglinks a:hover{ background: none; } .paginationstyle .flatview a:hover, .paginationstyle .flatview a.selected{ /*Pagination div "flatview" links style*/ color: #000; background-color: yellow; } </style> </head> <body> <h3>TITLE</h3> <!-- Pagination DIV for Demo 4 --> <div id="galleryalt" class="paginationstyle" style="width: 800px; text-align: left"> <a href="#" rel="previous"><</a> <span class="flatview"></span> <a href="#" rel="next">></a> </div> <div style="width: 600px; height: 230px;"> <div class="virtualpage4 hidepiece"> Monash</div> <div class="virtualpage4 hidepiece"> Peter</div> <div class="virtualpage4 hidepiece"> Qantas</div> <div class="virtualpage4 hidepiece"> Another</div> <div class="virtualpage4 hidepiece"> New</div> <div class="virtualpage4 hidepiece"> Under Dev</div> </div> <script type="text/javascript"> var gallery4=new virtualpaginate({ piececlass: "virtualpage4", piececontainer: 'div', pieces_per_page: 1, defaultpage: 0, persist: true }) gallery4.buildpagination(["galleryalt"], ["Monash University", "Peter Mac", "Qantas Planes", "Another Project", "New Project", "Under Dev"]) </script> </body> </html>

Hi Guys, really need help with this, getting desperate ! ! would actually pay someone to help me with this! I have a event calender and trying to get recurring events working, i have the following code.... I have a field in the database for the frequency of the event if its recurring or not, just need to add it in, to have it automatically come up on the calender if its every two weeks, for example - If the event is every week, the start date and end date could be a year and the event would show every week for the day specified, does that make sense, i have the following, but don't have a clue how to get it done, appreciate any help, cheers! <table cellpadding='0' cellspacing='0' class='profile_events'> {* SHOW DAYS OF MONTH *} {assign var='daycount' value=1} {section name=calendar loop=$total_cells} {* START A NEW ROW *} {cycle name="startrow" values="<tr>,,,,,,"} {* SHOW EMPTY CELLS BEFORE THE MONTH STARTS *} {if $smarty.section.calendar.index+1 < $first_day_of_month OR $smarty.section.calendar.index+1 > $last_day_of_month} <td class='profile_events_cellblank'> </td> {* SHOW A DAY *} {else} {assign value=$events.$daycount var=day_events} <td class='profile_events_cell{if $today_day == $daycount AND $today_month == $date_current}3{elseif $day_events|@count != 0}2{else}1{/if}' align='center'> {if $day_events|@count == 0} {$daycount} {else} <a href='javascript:void(0)' onClick="parent.se_popup('day{$daycount}')">{$daycount}</a> <table id='day{$daycount}' cellpadding='0' cellspacing='0' class='profile_event_popup'> <tr> <td class='profile_event_transparent' colspan='3' style='height: 20px;'> </td> </tr> <tr> <td class='profile_event_transparent' style='width: 20px;'> </td> <td class='profile_event_popup2'> <table cellpadding='0' cellspacing='0' width='100%'> <tr> <td class='profile_event_popup_title'>{$month} {$daycount}</td> <td class='profile_event_popup_title' align='right'>[ <a href='javascript:void(0)' onClick="se_popup_close()">close</a> ]</td> </tr> </table> {section name=event_loop loop=$day_events} <div class='profile_event_spacer'></div> <table cellpadding='0' cellspacing='0' width='100%'> <tr> <td valign='top' width='20' style='padding-right: 10px;'> <a href='event.php?event_id={$day_events[event_loop].event->event_info.event_id}'><img src="{$day_events[event_loop].event->event_photo('./images/nophoto.gif')}" class='photo' width="{$misc->photo_size($day_events[event_loop].event->event_photo('./images/nophoto.gif'),'100','100','w')}" border='0'></a> </td> <td valign='top' align='left'> <div><font class='big'><img src='./images/icons/event16.gif' border='0' class='icon'><a href='event.php?event_id={$day_events[event_loop].event->event_info.event_id}'>{$day_events[event_loop].event->event_info.event_title}</a></font></div> <div style='padding-top: 5px;'>{$day_events[event_loop].event->event_info.event_desc|replace:'<br>':' '|truncate:300:"..."}</div> <br> <table cellpadding='0' cellspacing='0'> {assign var=event_date_start value=$datetime->timezone($day_events[event_loop].event->event_info.event_date_start, $global_timezone)} {assign var=event_date_end value=$datetime->timezone($day_events[event_loop].event->event_info.event_date_end, $global_timezone)} {if $datetime->cdate("F j, Y", $event_date_start) == $datetime->cdate("F j, Y", $event_date_end)} {assign var=start_dateformat value="`$setting.setting_dateformat` `$profile_event_calendar13` `$setting.setting_timeformat`"} {assign var=end_dateformat value=$setting.setting_timeformat} {else} {assign var=start_dateformat value="`$setting.setting_dateformat`, `$setting.setting_timeformat`"} {assign var=end_dateformat value="`$setting.setting_dateformat`, `$setting.setting_timeformat`"} {/if} <tr><td valign='top'>{$profile_event_calendar3} </td><td valign='top'>{$datetime->cdate("`$start_dateformat`", $event_date_start)} {$profile_event_calendar4} {$datetime->cdate("`$end_dateformat`", $event_date_end)}</td></tr> {if $day_events[event_loop].event->event_info.event_host != ""}<tr><td valign='top'>{$profile_event_calendar6} </td><td valign='top'>{$day_events[event_loop].event->event_info.event_host}</td></tr>{/if} <tr><td valign='top'>{$profile_event_calendar12} </td><td valign='top'> {if $day_events[event_loop].event_status == 0}{$profile_event_calendar8} {elseif $day_events[event_loop].event_status == 1}{$profile_event_calendar9} {elseif $day_events[event_loop].event_status == 2}{$profile_event_calendar10} {elseif $day_events[event_loop].event_status == 3}{$profile_event_calendar11} {/if} </td></tr> </table> </td> <td valign='top' align='right' nowrap='nowrap'> <a href='event.php?event_id={$day_events[event_loop].event->event_info.event_id}'>{$profile_event_calendar5}</a><br> </td> </tr> </table> {/section} </td> <td class='profile_event_transparent' style='width: 20px;'> </td> </tr> <tr> <td colspan='3' class='profile_event_transparent' style='height: 20px;'> </td> </tr> </table> {/if} </td> {assign var='daycount' value=$daycount+1} {/if} {* END THIS ROW *} {cycle name="endrow" values=",,,,,,</tr>"} {/section} </table> Thanks all for reading!

Hi Guys, I have a general question on how i would go about setting php with time recurrence. I have a event type of setup and i want to be able to add in recurrence, for example instead of setting the start and finish time of the event, i want to add in the option "every week", or once a week etc... just wondering how i would tackle this problem, appreciate any ideas, cheers

Thanks so much, ill give that a go - didnt know you could do SUMs with MYSQL, thanks so much!!

Hi, The structure for the payment table is this; -id, user_id, payment, date and for. The stucture for the debit table is this; -id, user_id, debit, date and for. The structure for the event is; -id, name, price, description Thanks

Hi, thanks for replying - i just have the numbers/values stored as a double, with a similar structure as; id, user_id, payment, date and for. Thanks

Hi everyone, I have two tables orders and payments, i want to know the balance, i have done the following; <?php $c = $ro['user_id']; //total payments $p_result = mysql_query("SELECT * FROM payment WHERE user_id=$id") or die(mysql_error()); $ptotal = 0; while ($p_ro = mysql_fetch_assoc($p_result)) { $ptotal += $p_ro['payment']; } //total debit $debit_result = mysql_query("SELECT * FROM hdebit WHERE user_id='$c' ") or die(mysql_error()); $total = 0; //going to use num row to use while loop $num_rows = mysql_num_rows($debit_result); while ($num_rows = mysql_fetch_array($debit_result)){ //got to get event details $event_id = $num_rows['event_desc']; $trans_fee = $num_rows['price_two']; if ($trans_fee == 'yes'){ $tq = mysql_query("SELECT * FROM events WHERE event_id=$event_id") or die("Error querying customer database1"); $dotq = mysql_fetch_array($tq); $qqq = $dotq['event_price']; } //lets get all the event details! $qq = mysql_query("SELECT * FROM events WHERE event_id=$event_id") or die("Error querying customer database1"); $doq = mysql_fetch_array($qq); $ep = $doq['event_price']; $total += $ep + $qqq; } $balance = $ptotal - $total; ?> I am wondering if there is a better way of doing this? It seams to work but when i have multiple entries sometimes i get different answers for 0 - for instance 0.0832783728347e etc Thanks Heaps!

thanks so much for the help, appreciate it - got it working now

event.php?event_id=23?user_id=1 //getting the first id $id = $_GET['event_id']; $result = mysql_query("SELECT * FROM events WHERE event_id=$id") or die("Error querying customer database1"); //getting the first id $user_id = $_GET['user_id']; i get a error querying database, but i didnt get this error before i added the other $....so im thinking it cant tell were one ended and another began ?

Hi, thanks, i have tried that and it is not working..

Hiya guys, I have a problem with trying to post multiple id's...i have a url and im using $_GET['the id']..and thats fine, but i want to get two.... page.php$id=1$otherid=42 i want to do something like that..... is that possible? how would i go about it? thanks

Yes that was it, thanks SooOO much !!!