I'm using MySql for the dbase and the record
has been arranged in this way..
ARIES (March 21-April 19): You're on the receiving end of power today, perhaps even of punishment. You may undergo a change in thinking about the use and misuse of power and the effects it has on those on the wrong end of it.
TAURUS (April 20-May 20): Mature friends help you stabilize your life. They can help you with good advice or by putting in a good word. Let your contacts carry word of your responsibility and reliability. The rest is up to you.
Say that, I want it to be display in this way
ARIES (a link to the record)
TAURUS (a link to the record)
and when user click ARIES it will link to the record itself...
I have use explode and successfully split the star but I've no idea on how to make the result to be display as below...
ARIES
You're on the receiving end of power today, perhaps even of punishment. You may undergo a change in thinking about the use and misuse of power and the effects it has on those on the wrong end of it.
This is my coding that i've made.. please change or add if you think that it's doesnt make sense...
------------Start Codes----------------
$result = myquery("SELECT * FROM ".$program['table_name']." WHERE TO_DAYS(docdate) <
= TO_DAYS(NOW()) ORDER BY docdate DESC LIMIT 0,1;", 'dbase_name');
$row = mysql_fetch_array($result);
if (isset($row)) {
$result2 = myquery("SELECT * FROM ".$program['table_name']." WHERE id=".$row['id'].";", 'dbase_name');
}
while ($article = mysql_fetch_array($result2)) {
clean_slashes($article);
$line = split("[\n\r]", $article['body']);
while (list($key, $val) = each($line)) {
$val = trim($val);
if (!empty($val)) {
$regs = explode(' ',$val);
$star = $regs[0];
echo "<tr><td><a href=\"$PHP_SELF?star=$star&article=".$article['id']."\">$star</a></td></tr>\n";
}
}
---------------End Codes--------------------
Please if someone could help me .Thank you.
