Webmaster Forum

Go Back   Webmaster Forum > Web Development > Coding Forum

Coding Forum Problems with your code? Discuss coding issues, including JavaScript, PHP & MySQL, HTML & CSS, Flash & ActionScript, and more.


Reply
 
Thread Tools Display Modes
Share |
  #1  
Old 06-16-2007, 04:58 PM
anarchoi anarchoi is offline
Junior Member
 
Join Date: 06-16-07
Posts: 1
iTrader: 0 / 0%
Showing data from a table based on infos from another table!

Ok let me explain:

i have 2 tables in my database : THREAD, and POST

THREAD's rows are: THREADID, TITLE + FORUMID + REPLYCOUNT + VIEWS
POST's rows are: THREADID, PAGETEXT and PARENTID

i'm a big php newbie... I want to display the LAST TWO messages (highest THREADID) of my forum number 99 (FORUMID=99).

I can probably do that, but the problem is that the text of the message is located in another table.. and it's getting too hard for my low-skilled brain lol

so basically I would like to check in "THREAD" for the highest THREADID where FORUMID=99, display the TITLE, REPLYCOUNT and VIEWS, and then check in POST for the same two THREADID's where PARENTID=0 (meaning it is the first message in the thread) and finally display the PAGETEXT !

Could anyone give me a PHP code that would display that?
thanks a lot and sorry for bothering you with my newbie questions!
 
Reply With Quote

Advertisement

Advertisement

Go Back   Webmaster Forum > Web Development > Coding Forum

Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
table help mtaylor314 Coding Forum 3 05-01-2007 10:37 AM
CSS Table-less madeinacari Coding Forum 4 04-19-2006 12:23 PM
Table Gap ?? Sketch Coding Forum 2 08-30-2005 04:11 PM
CSS on one table thepartydj Coding Forum 9 01-05-2005 08:03 AM
Table help Leader of Men Coding Forum 5 11-25-2003 10:53 AM


V7N Network
Get exposure! V7N I Love Photography V7N SEO Blog V7N Directory


All times are GMT -7. The time now is 05:02 AM.
Powered by vBulletin
Copyright 2000-2014 Jelsoft Enterprises Limited.
Copyright © 2003 - 2018 VIX-WomensForum LLC