1
I am having a tad bit of trouble with some code that I am working on. The problem is, is that when I array the data, it doesn't show all of the queried results. For example. If I have 3 links stored, it will only show two, but if I have 4 it will only show 3.
I need someone to look over the code and see what I could be doing wrong.
<?php function myxlinks(){ global $xoopsUser, $HTTP_COOKIE_VARS, $xoopsConfig,$xoopsTheme; global $xoopsDB; include_once(XOOPS_ROOT_PATH."/class/module.errorhandler.php"); include_once(XOOPS_ROOT_PATH."/include/xoopscodes.php"); $uid = $xoopsUser->getVar("uid"); $q = "SELECT lid, url, title, type FROM ".$xoopsDB->prefix("myxlinks_favorites")." WHERE uid = '$uid'"; $result = $xoopsDB->query($q) or die(""); $row_xoops_myxlinks_favs = mysql_fetch_assoc($result); $totalRows_xoops_myxlinks_favs = mysql_num_rows($result); if ($totalRows_xoops_myxlinks_favs > 0) { $block = array(); $block['title'] = "Personal Links"; $block['content'].= "<table width=100%>"; $block['content'].= "<tr>"; $block['content'].= "<td id=mainmenu>"; while ($myrow = $xoopsDB->fetchArray($result)){ $type = $myrow['type']; $url = $myrow['url']; $title = $myrow['title']; $block['content'].= "<a href=$type$url target=_blank>$title</a>"; } $block['content'].= "</td></tr></table>"; $block['content'].= "<hr><a href='".XOOPS_URL."/modules/myxlinks/showlinks.php'>Edit Links</a>"; }else{ $block['content'].= "You do not have any<br>"; $block['content'].= "links setup, would you<br>"; $block['content'].= "like to set up some<br>"; $block['content'].= "personal Links? <b>>><a href='".XOOPS_URL."/modules/myxlinks/showlinks.php'>Yes</a><<</b>"; } return $block; } ?>
It is throwing a curve ball at me.....
Thanks for the help,
