Ok, here's what I got. I'm trying to create an entire site that grabs
all it's information (Page content, titles, link info, etc.) from a
MySQL database. In this site I would like to have sub pages of master
pages. For instance, Page 1 is a master page, Page 2 is a sub page of
Page 1, and Page 3 is a sub page of Page 2 which is a sub page of page
one. Now I would like to display this entire hierarchy if possible.
Here's what I have but either I get an infinite loop or it doesn't work
worth a damn....
<?
mysql_connect("127.0.0.1","webuser","");
$query="SELECT * FROM PageInfo WHERE PageID>'0' and PageID=$MasterPage
ORDER BY PageID";
$VARS="";
do {
$result=mysql_db_query("DynamicDB",$query);
$count=(mysql_num_rows($result));
if($count>0) {
while($r=mysql_fetch_array($result)) {
$LinkText=$r["LinkText"];
$FileName=$r["FileName"];
$LinkAlt=$r["LinkAlt"];
$MasterPage=$r["MasterPage"];
$PageID=$r["PageID"];
$VARS="$PageID ".$VARS;
echo "$PageID<br><br>";
// echo "$VARS";
}
} else {
}
$query="SELECT * FROM PageInfo WHERE PageID>'0' and
PageID=$MasterPage";
} while ($MasterPage>0);
//echo "$VARS";
$PageIDs=explode(" ",$VARS);
$i=0;
while(strlen($PageIDs["$i"])>0) {
$TheVar=$PageIDs["$i"];
$TheQuery="SELECT LinkText, FileName, LinkAlt FROM PageInfo where
PageID=$TheVar";
$TheResult=mysql_db_query("DynamicDB",$TheQuery);
$TR=mysql_fetch_array($TheResult);
$TheLinkText=$TR["LinkText"];
$TheFileName=$TR["FileName"];
$TheLinkAlt=$TR["LinkAlt"];
echo "<font color=\"#000000\"><b><a href=\"$TheFileName\"
alt=\"$TheLinkAlt\">$TheLinkText</a></b></font>";
$i++;
}
?>
My table structure looks like this....
+------------+------------------+------+-----+----------+---------------
-+
| Field | Type | Null | Key | Default | Extra
|
+------------+------------------+------+-----+----------+---------------
-+
| PageID | int(40) | | PRI | NULL |
auto_increment |
| PageType | varchar(6) | | | master |
|
| LinkText | varchar(20) | | | linktext |
|
| FileName | varchar(30) | | PRI | |
|
| LinkAlt | varchar(100) | YES | | alttext |
|
| Contents | longblob | | | |
|
| MasterPage | int(11) unsigned | YES | | 0 |
|
| Active | char(3) | | | yes |
|
| LinkOrder | mediumint(9) | YES | | 99 |
|
+------------+------------------+------+-----+----------+---------------
-+
9 rows in set (0.03 sec)
Thanks in advance...
Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
