Hello,
I've got a pretty basic query which I am trying to run within a function.
The query looks like this:
SELECT
a.title,a.alt_title,a.articleID,a.articleSectionID,sect.URLname
FROM
$articlestable a, $categorytable sect
WHERE
a.articleSectionID = sect.articleSectionID
ORDER BY
a.date
DESC
limit 5
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?
The function is here:
function latest_articles() {
global $id,$main_file,$front_end_url,$alt, $articlestable, $categorytable;
$alt_var="";
$contentquery4 = mysql_query("SELECT
a.title,a.alt_title,a.articleID,a.articleSectionID,sect.URLname FROM
$articlestable a, $categorytable sect WHERE a.articleSectionID =
sect.articleSectionID ORDER BY a.date DESC limit 5") 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"];
}
$content .= "\n<li><a
href=\"".$front_end_url."/".$main_file."/".urlencode($category)."/".$contentarray4["articleID"]."/"
. $alt_var ."\" class=\"articleslink\">".stripslashes($link_name)."</a>";
}
}
return $content;
}
And Table below:
CREATE TABLE articles (
articleID bigint(21) unsigned NOT NULL auto_increment,
articleSectionID bigint(21),
uid bigint(21),
title varchar(255),
content mediumtext,
image_suffix varchar(4),
date date,
alt_title varchar(255),
alt_content BLOB,
meta_keywords varchar(255),
meta_description varchar(255),
blerb TEXT,
alt_blerb TEXT,
PRIMARY KEY (articleID)
);
The missing results can (not) be seen here (under new postings):
http://airdiv.cupe.ca/union.php/Division/
Mike
--
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]
