m3rajk — Thu, 01 Jan 2004 01:50:10 +0000

as of now, it's 8:53 pm 12/31/2003 for me..... how's the weather tomorrow?

Busy — Wed, 31 Dec 2003 22:41:56 +0000

I think I'm missing something here, either that or I am still in last year

Give me a couple of days (have to recover from 2003 and have gallery display tomorrow), I'll try upload a few things, a working, or semi working example might help.

Thanks all, happy new year

[edit extra] I got it working, used a combination of stuff I'd posted (in different order) and it works, probably not the best way to do it or the cleaniest but it works

Thanks to all that helped[/edit]

[edit] Tomorrow was hot, so hot i got a case of sunstroke, we live and learn [/edit]

Mark Hensler — Wed, 31 Dec 2003 15:31:37 +0000

Semi-similarly, I was thinking about joining them....

Using m3rajk's tables:

SELECT qna.*,
    comments.cid, comments.comment, comments.commauth, comments.commpostdate
FROM qna
LEFT JOIN comments ON qna.qid=comments.qid

<?php
// table
// tr td table header /td /tr

$last_qid = NULL;
while ($q=mysql_fetch_array($result)) {
    // new question?
    if ($q!=$last_qid) {
        // tr td $q[question] /td /tr
        // tr td $q[answer] /td /tr
        
        if ($q['comment']!=='') {
            // tr td comment /td /tr
        }
    }
    // or comments for previous question?
    else {
        // tr td comment /td /tr
    }
}
?>

m3rajk — Wed, 31 Dec 2003 12:55:31 +0000

for pagination, how about these tables:

table q&a

qid
question
answer
qauth
aauth
qpostdate
apostdate

table comments
cid
qid
comment
commauth
commpostdate

and the script has this basic outline:

connect to sql
find the start point for the page
while you get the questions for the page
split qid to a variable
format question and possible answer
start new table cell that scroll the overflow for the comments
using the qid, find all comments with the qid
while retrieveing the comments (in order by cid)
put the comments in the comment cell
end inner for loop
close out question table
end outer for loop
display data

only possible issue is that each question is a table in that senario, possibly with an inner table for the comments.

Busy — Wed, 31 Dec 2003 07:38:47 +0000

I looked at 2 tables, slightly differently thou, table1 questions and table 2 answers and comments.
But the same problem exists.
It's hard to explain it seems, but anyway I try this I'm always left with an array being printed (echo'd) to the screen in some sort of loop, to which I can't compare to the results of the 2 arrays loop.

this has been driving me crazy so if it makes no sense its just me going nuts

what I need is impossible I am beginning to think.
my latest angle is I need the results of the above mentioned (first few posts) loop sorted into seperate variables (not in an array) and compared to the array in the second loop but then it would entail a whole heap of checks.

if a value in loop 2 equals a value in loop 1 variable equals true - sounds pretty easy, BUT then if there are more than one for each value it should only display one but count the amount - confused? I am.

m3rajk — Wed, 31 Dec 2003 01:42:17 +0000

i'm in agreement with mark. i was hoping it was me faling outta touch since i had been recovering for a little more than two weeks and did no scripting for about 3 and a half while diagnosing and restoring the comp to a point i could recover data.

if i have it correct you have an easy way to break up the data to two tables and then to display what you want
table1: q&a
table2: comments

each q has a id number. using the id number you look up the comments.

two calls.

call one gets the informationon the q&a table. call two is part of the display fuformating function, it queries for associated comments and then adds that to the question and possible answer.

then again, i might be completely off in what i think you're asking for.

Mark Hensler — Tue, 30 Dec 2003 22:24:58 +0000

I'm having a hard time wrapping my head around this.

I'm also wondering if this project may be easier with multiple tables.

Busy — Tue, 30 Dec 2003 21:54:36 +0000

one answer per question and the comments are just thrown in there, not directly related (via code or numbers) to any questions or answers.

Q. what colour is the sky?
A. the sky is blue
C. there are also clouds in the sky
Q. are there clouds in the sky?
A. I just said that, read the comment
Q. Is it raining
...

can't answer if no question is there, so use comments instead.

Mark Hensler — Tue, 30 Dec 2003 18:20:31 +0000

can a question have more than one comment?

This is what I'm thinking right now:

CREATE TABLE `tmp` (
  `req_item` int(10) unsigned NOT NULL auto_increment,
  `req_owner` mediumint(8) unsigned NOT NULL default '0',
  `req_user` mediumint(8) unsigned NOT NULL default '0',
  `req_text` blob NOT NULL,
  `req_date` int(10) unsigned NOT NULL default '0',
  `req_num` smallint(5) unsigned NOT NULL default '0',
  `req_type` char(1) NOT NULL default '',
  PRIMARY KEY  (`req_item`,`req_owner`,`req_user`,`req_type`),,
  KEY `req_item` (`req_item`)
  KEY `req_type` (`req_type`)
) TYPE=MyISAM

SELECT 
	q.req_item AS q_item,
	q.req_owner AS q_owner,
	q.req_user AS q_user,
	q.req_text AS q_text,
	q.req_date AS q_date,
	q.req_num AS q_num,
	a.req_text AS a_text,
	a.req_date AS a_date
	c.req_text AS c_text,
	c.req_date AS c_date
FROM item_request AS q
	LEFT JOIN item_request AS a ON (p.req_item=a.req_item AND a.req_type='a')
	LEFT JOIN item_request AS c ON (p.req_item=a.req_item AND a.req_type='c')
WHERE q.req_type='q'
ORDER BY q.req_item DESC

m3rajk — Sun, 28 Dec 2003 21:56:19 +0000

unfortunately the hd crash i had has had me recovering from that for the better part of a month, so i'm not quite back to form