أخي لو نظرت إلى المخطط(schema)
كود:
Table forum
============
forumid title description active displayorder replycount lastpost lastposter threadcount categoryid allowposting daysprune forumtemplate headertemplate useadvheader footertemplate useadvfooter forumbittemplate threadtemplate threadbittemplate replytemplate newthreadtemplate edittemplate rulestemplate titleimage replyimage newthreadimage closedthreadimage newpostemail newthreademail moderatenew allowbbcode allowimages allowhtml allowsmilies
Table post
==========
postid threadid username userid title dateline pagetext allowsmilie email signature ipaddress iconid visible
Table tread
============
threadid title lastpost forumid open replycount postusername lastposter dateline views iconid notes visible subjectindex threadindex userindex
وما أريد استخدامه هو
forumid وهو موجدود في Table forum و Table tread
أما pagetext فهو موجود في Table post
============
ولو نظرت في البرنامج:
كود:
<?
// The number of posts you want to see
$count = 5;
// url to the forum
$forum_url = 'http://localhost/vb/';
require("admin/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);
$db_conn = mysql_connect( $dbserver, $dbuser, $dbpass );
$result = mysql_db_query($dbname, "SELECT post.pagetext as pagetext,thread.threadid AS id,thread.title AS title,thread.replycount AS replycount,thread.forumid AS forumid,forum.title AS forumtitle FROM post,thread,forum WHERE forum.forumid = thread.forumid ORDER BY thread.lastpost DESC LIMIT $count" , $db_conn);
while ($thread = mysql_fetch_array( $result ) ) {
$text = $thread["title"] . " : " . $thread["threadindex"] ." : " . $post["pagetext"];
$text = strip_tags(substr( $text, 0, 160 ));
echo $text . " <a href='".$forum_url."showthread.php?threadid=".$thread["id"]."'>مزيد من التفاصيل</a><br>";
}
mysql_close( $db_conn );
?>
طيب ياليت تعدل لي البرنامج أعلاه وذلك بإضافة pagetext
ويشتغل
وشكراً
وأرجوك مراسلتي على إيميلي:
zalamah@yahoo.com