Hi Hugh,

Hugh Bothwell wrote:

> "Mike Gifford" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 
>>The problem is that I am only getting one response from this query rather
>>
> than
> 
>>5.  I can't figure this out.  What did I do to only get one response?
> Try removing the ORDER BY and LIMIT and run the query by
> hand - how many responses do you get?  The search may only
> return one article.


I tried removing these and I got a similarly disappoinging response (one reply), 
so I decided to look again for code that is actually working and copy it from 
scratch.  I hit upon this and it is working now.

Thanks for your help.


function latest_articles() {
        global $id,$main_file,$front_end_url,$alt, $articlestable, $categorytable;
        $alt_var="";
                $contentquery4 = mysql_query("SELECT a.*,s.URLname FROM $articlestable 
a, 
$categorytable s WHERE a.articleSectionID = s.articleSectionID ORDER BY a.date 
DESC") or mysql_die();
        if ($result = mysql_num_rows($contentquery4)) {
                while ($contentarray4 = mysql_fetch_array($contentquery4)) {
                        $category = $contentarray4["URLname"];
                                if ($alt) {
                                        if ($contentarray4["alt_title"]) {
                                                $link_name = 
$contentarray4["alt_title"];
                                                $alt_var = "?alt=french";
                                        } else {
                                                $link_name = $contentarray4["title"];
                                                $alt_var = "?alt=french";
                                        }
                                } else {
                                        $link_name = $contentarray4["title"];
                                        $alt_var = "";
                                }
                                $content .= "\n<li><a 
href=\"".$front_end_url."/".$main_file."/".urlencode($category)."/".$contentarray4["articleID"]."/"
 
. $alt_var ."\"  class=\"articleslink\">".stripslashes($link_name)."</a>";
                                $i++;
                                if ($i==5) {
                                        break;
                                }
                }
        }
        return $content;
}

-- 
Mike Gifford, OpenConcept Consulting, http://openconcept.ca
Offering everything your organization needs for an effective web site.
Abolish Nuclear Weapons Now!: http://pgs.ca/petition/
It is a miracle that curiosity survives formal education. - A Einstein


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to