hyperlinking mysql results

[porco]

Mmmm now this is either very simple or insanely icky (ICKY is a technical term used in university computer organisation and architecture courses to refer to something that is a bit complicated. A like term is nasty. The point at which something really ICKY becomes downright NASTY is not easy for me to understand. But I accept the terminology as sound computing advice).

Anyway, here is a doozey. I have returned selections of articles to be displayed from a mysql table. I mean their titles of the two most recent in each category is on the screen. So how do I make these dynamic titles hyperlinks??

I mean, of course the hyperlink will be dynamic, wont it? So how do I go about structuring this?

Any general advice would be appreciated at this stage. Thanks in advance if you have any input, too.

---

It never ceases to amaze me how something so simple can keep me entertained for so long simply by not working at all

[Frederick]

<?php
// Loop through all categories
$catSQL = mysql_query("SELECT * FROM category_table ORDER BY cat_name");
while ($cat = mysql_fetch_array($catSQL)) {
	// Loop through all articles grabbing artciles related to the categories and limiting to only 2 each
	$artSQL = mysql_query("SELECT * FROM article_table WHERE cat_id=".$cat["cat_id"]." ORDER BY id DESC LIMIT 2");
	while ($art = mysql_fetch_array($artSQL)) {
		echo "<a href=\"PageName.php?id=".$art["id"]."\">".$art["article_title"]."</a><br>\n";
	}
}
?>

[porco]

yes I think I see. Some lunch and I will see if I can get it working. Seems a simple enough concept 🙂

Thanx🆒

[porco]

Well I gave it a try. The trouble I seem to have falls into probably 2 places.

First, my link is in a for loop (and its a bit hard to catch the right $data[0], so it makes the last one in the loop the session variable.

The second is that I get this error --

Parents 'oblivious' to children's surfing You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'oblivious' to children's surfing'' at line 1
[code=php]
-- on my page for displaying the article.


Here is the code for the link page...

Top of the page is of couse 
[code=php]
session_start();
$_SESSION['temp_data'] = $data[0];
[code=php]
[code=php]
// for each row returned print the content
for ($i = 0; $i < $rows; $i++)
{ 
$data = mysql_fetch_row($result);


echo "<table>";
echo "<tr><td width=\"400\"><a href=\"news_article.php\">$data[0]</a></td><td width=\"200\" align=\"right\">$data[1]</td></tr><br>\n"; // print article titles and dates to screen with date right aligned 
$temp_data = $data[0];
echo "</table>";
}
[code=php]

-- And my code for the display an article page
[code=php]
// retrieve all in the TBArticle table
$result = mysql_query("select ArticleBody from TBArticle where ArticleSubject='$temp_data'") or die(mysql_error());

$displayrows = mysql_num_rows($result);

for($i = 0; $i < $displayrows; $i++)
{
$data = mysql_fetch_row($displayrows);
echo "$data[0]";
}
[code=php]