Jump to content

Gem

Members
  • Posts

    129
  • Joined

  • Last visited

Everything posted by Gem

  1. Gem

    Hello All!

    Welcome to the freaks Lewis
  2. The class ($this) does not have the function isPost() ...
  3. Alternatively someone post all the logs where Alexi is rude and condescending to almost everyone who she talks to, people who are usually trying to help her. Frost is a very helpful and friendly member of the community, and a very good op in IRC, and to see him being "reported" is just not cool.
  4. var_dump($_POST['title']); you might want to add method="post" to your form tag though ...
  5. <?php $cnn = mysql_connect("localhost","root",""); mysql_select_db("hms",$cnn); $month=$_GET['q']; $html = "<strong>$month</strong> Month Report"; //$string="2004-12-28"; $result=mysql_query("SELECT monthname(date) As newd FROM stock_entries WHERE monthname(date)='".$month."' "); if(!$result) die(mysql_error()); $html .= "<table border='1'>"; while($row = mysql_fetch_array($result)) { $html.= "<tr>"; // echo "<td>" . date("m",strtotime($row['date'])) . "</td>"; $html .= "<td>" . $row['newd'] . "</td>"; //echo "<td>" . $row[''] . "</td>"; //echo "<td>" . $row[''] . "</td>"; //echo "<td>" . $row[''] . "</td>"; $html .= "</tr>"; } $html .= "</table>"; echo $html; ?>
  6. Gem

    Query help please?

    I forgot to say, I'm struggling because I need to paginate the comments. I need to page only at a parent, i.e not splitting child comments over seperate pages (planning to use js to show/hide the replies) so I'm wanting like say 5 parent comments, plus all their children per page. This is why I'm looking for a query to put them in the right order ...
  7. Hi guys, Was wondering if someone could help me with a query. Here is my table structure: commID int(11) postID int(4) replyto int(6) depth int(2) timestamp int(11) name varchar(100) email varchar(100) comment text So what I'm trying to get is the comments in order. The order I need is: comment 1 - parent comment 2 - parent comment 5 - reply to comment 2 comment 6 - another reply to comment 2 comment 7 - reply to comment 6 which is a reply to comment 2 comment 3 - parent comment 4 - reply to comment 3 and so on. There is no limit to how many levels of children there can be per parent. I'm hoping this makes sense :S Can you help? Many thanks Gem
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.