Another problem. Sorry

Encenta.com · 10-22-2005, 11:06 AM

Sorry, I know I've asked a lot of questions but this SHOULD be the last.. for now. lol, just kidding.

Right, When a user submits a new thread on my forum, the thread is inserted into my "threads" table in the database and the post is submitted into the "posts" table at the same time. The thread is represented in the "threads" column of the "posts" table as a number (the id of the thread).

But the post is submitted at the same time as the thread so how will I be able to assign the post to the correct thread?

I hope that makes sense. Sorry if i wasn't very clear

iNod · 10-22-2005, 11:15 AM

Hello,

It is kinda confusing but I kinda get it. You can have a table in Posts called tid which carries thread id.

iNod

Encenta.com · 10-22-2005, 11:30 AM

Thanks for the reply. I have a threadID column in the posts table but I'm unsure how to insert the new thread ID into it the same time it is being created. I'll try and illustrate the tables:

Posts:
ID, category, threadid, author, content, time, date

Threads:
ID, title, author, starttime, startdate

Then as you can imagine, as the user submits a new thread, I want the post inserted into the "posts" table as well as the thread into the "threads" table

iNod · 10-22-2005, 11:33 AM

Hello,

First create the thread than use mysql_insert_id and set threadid and insert post.

iNod

Encenta.com · 10-22-2005, 11:50 AM

Thanks iNod. That's definately the correct method but I think I'm going wrong somewhere. it's inserting into the database the actual text "mysql_insert_id". Here's my code:

PHP Code:

  $lastid = mysql_insert_id();

 
$query2 = "INSERT INTO posts VALUES ('id', '$category', $lastid, '$author', '$msg', '$starttime', '$startdate')";

$results2 = mysql_query($query2); 

????: NamePros.com http://www.namepros.com/programming/133998-another-problem-sorry.html

EDIT: Also, I get a very frustrating repetition:

http://www.darkfx.co.uk/darkfx/threads.php?category=1

iNod · 10-22-2005, 12:20 PM

Ouch.. I suggest deleting that script from ftp right away.. Thats a major BW hog.

Now.. Lets fix it up.
First thing put ' (quotes) around $lastid

The rest seems to be correct can you post rest of php.

iNod

Encenta.com · 10-22-2005, 12:54 PM

lol. removed script for now

PHP Code:

  if ($_POST['submitthread']) {

$msg=$_POST['msg'];

????: NamePros.com http://www.namepros.com/showthread.php?t=133998
$title=$_POST['title'];

$starttime=date("H:i"); 

????: NamePros.com http://www.namepros.com/showthread.php?t=133998
$startdate=date("d/m/y");

 
 
 
 
 
$query = "INSERT INTO forum_threads VALUES ('id', '$title', '$author', '$category', '$starttime', '$startdate')";

$results = mysql_query($query);

 
 
$lastid = mysql_insert_id();

 
$query2 = "INSERT INTO forum VALUES ('id', '$category', '$lastid', '$author', '$msg', '$starttime', '$startdate')";

$results2 = mysql_query($query2);

 
if (!$result) {

include("head.php");

echo("<h1>Success</h1> <p>Post added successfully. <a href='thread.php?category=$category&thread=$lastid'>Return to forum</a></p>

");

include("foot.php");

exit;

}}

iNod · 10-22-2005, 01:16 PM

PHP Code:

  if($_POST['submitthread']) {

$msg=$_POST['msg'];

$title=$_POST['title'];

$starttime=date("H:i");

$startdate=date("d/m/y");

 
 
 
 
 
$query = "INSERT INTO forum_threads VALUES ('$title', '$author', '$category', '$starttime', '$startdate')";

$results = mysql_query($query);

 
 
$lastid = mysql_insert_id();

 
$query2 = "INSERT INTO forum VALUES ('$category', '$lastid', '$author', '$msg', '$starttime', '$startdate')";

$results2 = mysql_query($query2);

 
if (!$result) {

include("head.php");

echo("<h1>Success</h1> <p>Post added successfully. <a href='thread.php?category=$category&thread=$lastid'>Return to forum</a></p>

????: NamePros.com http://www.namepros.com/showthread.php?t=133998
????: NamePros.com http://www.namepros.com/showthread.php?t=133998
");

include("foot.php");

exit;

}

}

Is there any code about that like while or foreach?

I am wondering why it is looping.

iNod

Encenta.com · 10-22-2005, 01:27 PM

Well, the page which displays the threads is:

PHP Code:

  <?

include("config.php");

$category = $_GET['category'];

$newthread = $_GET['newthread'];

session_start();

$author = $_SESSION['username'];

 
// DISPLAY THREADS

if (isset($_GET['category'])) {

 
 
$result = mysql_query("SELECT * FROM categories WHERE id='$category'") 

or die("SELECT Error1: " .mysql_error());

$num=mysql_numrows($result);

while ($row = mysql_fetch_array($result)) 

{ 

$title = $row['title'];

}

$pagetitle = "$title threads";

include("head.php");

 
echo "<h1>$title forum</h1>

<table width='100%' border='0'>

<tr><td align='left'><p><a href='forum.php'>&lt; Back to categories</a></p></td>

<td align='right'><p><a href='forumhandle.php?newthread=true&category=$category'>Start new thread</a></p></td></tr></table>";

echo "<table width='100%' border='0' cellspacing=0 cellpadding=2>

<tr class='threadhead'>

    <td width='40%'>Thread</td>

    <td width='25%'>Thread Started</td>

    <td width='25%'>Last Post</td>

    <td width='10%'>Posts</td>

</tr>";

// END OF HEADINGS

 
 
 
 
 
$result = mysql_query("SELECT * FROM forum_threads WHERE category='$category' ORDER BY id DESC") 

????: NamePros.com http://www.namepros.com/showthread.php?t=133998
or die("SELECT Error1: " .mysql_error());

$num=mysql_numrows($result);

 
 
$i=0;

while ($i < $num) {

if ($i % 2) {

$bgcolor = "threadtable";

            }

else {

$bgcolor = "threadtable2";

     }

 
 
 
$id=mysql_result($result,$i,"id");

$title=mysql_result($result,$i,"title");

$author=mysql_result($result,$i,"author");

$category=mysql_result($result,$i,"category");

$startdate=mysql_result($result,$i,"startdate");

????: NamePros.com http://www.namepros.com/showthread.php?t=133998
$starttime=mysql_result($result,$i,"starttime");

 
 
$query = mysql_query( "SELECT * FROM forum WHERE threadid='$id' AND category='$category'" ) or die("SELECT Error2: " .mysql_error());

$numero=mysql_numrows($query);

$query = mysql_query( "SELECT id FROM users WHERE username='$author'" ) or die("SELECT Error3: " .mysql_error());

$authorid=mysql_result($query,0,"id");

 
 
$query = mysql_query( "SELECT * FROM forum WHERE threadid='$id' AND category='$category' ORDER BY 'datetime' ASC LIMIT 1" ) or die("SELECT Error4: " .mysql_error());

$num1=mysql_numrows($query);

$i=0;

while ($i < $num1) {

$author=mysql_result($query,$i,"author");

$time=mysql_result($query,$i,"time");

$date=mysql_result($query,$i,"date");

$today = date("d/m/y");

 
if ($date == $today) {$date = "Today"; }

{$date = "Today";}

$i++;

}

 
 
 
 
 
 
 
echo "

  <tr class='$bgcolor'>

    <td valign='top'><a href='showthread.php?category=$category&thread=$id'>$title</a></td>

    <td valign='top'>$startdate at $starttime <br />by <a href='viewprofile?profile_id=$authorid'>$author</a></td>

    <td valign='top'>$date at $time</td>

    <td valign='top'>$numero</td>

  </tr>";

     

$i++;

}

echo "</table>";

include("foot.php");

}

// END DISPLAY THREADS

 
?>

There are a few loops. But I think it's because of the database content which was the reason it was repeating

Encenta.com · 10-23-2005, 01:51 PM

I got the ThreadID thing orking. But the problem now is that when displaying the threads, it isn't looping. It only displays the last row in the database

iNod · 10-23-2005, 02:16 PM

Hello,

Get read of that while $i stuff. Use this format

PHP Code:

  $query = mysql_query("SELECT * FROM bob");

????: NamePros.com http://www.namepros.com/showthread.php?t=133998
 
while($row = mysql_fetch_array($query)) {

print "Bob eats $row['candy']";

}

Above says.
Select all from bob. (Table I made was candy)
While $row is equal to mysql_fetch_array do.
print "Bob eats candy or what not";
}

iNod

Encenta.com · 10-23-2005, 02:40 PM

Thank you so much once again! NP$ donated!!

10-22-2005, 11:06 AM	THREAD STARTER #1 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 579 Follow @MiseriaSK	Another problem. Sorry Sorry, I know I've asked a lot of questions but this SHOULD be the last.. for now. lol, just kidding. Right, When a user submits a new thread on my forum, the thread is inserted into my "threads" table in the database and the post is submitted into the "posts" table at the same time. The thread is represented in the "threads" column of the "posts" table as a number (the id of the thread). But the post is submitted at the same time as the thread so how will I be able to assign the post to the correct thread? I hope that makes sense. Sorry if i wasn't very clear __________________ SQL Dumpster - SQL Database Dumps and Resources

10-22-2005, 11:15 AM	#2 (permalink)
iNod Eating Pie Join Date: Nov 2004 Location: Canada Posts: 2,267	Hello, It is kinda confusing but I kinda get it. You can have a table in Posts called tid which carries thread id. iNod __________________ I feel old.

10-22-2005, 11:30 AM	THREAD STARTER #3 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 579 Follow @MiseriaSK	Thanks for the reply. I have a threadID column in the posts table but I'm unsure how to insert the new thread ID into it the same time it is being created. I'll try and illustrate the tables: Posts: ID, category, threadid, author, content, time, date Threads: ID, title, author, starttime, startdate Then as you can imagine, as the user submits a new thread, I want the post inserted into the "posts" table as well as the thread into the "threads" table __________________ SQL Dumpster - SQL Database Dumps and Resources

10-22-2005, 11:33 AM	#4 (permalink)
iNod Eating Pie Join Date: Nov 2004 Location: Canada Posts: 2,267	Hello, First create the thread than use mysql_insert_id and set threadid and insert post. iNod __________________ I feel old.

10-22-2005, 11:50 AM	THREAD STARTER #5 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 579 Follow @MiseriaSK	Thanks iNod. That's definately the correct method but I think I'm going wrong somewhere. it's inserting into the database the actual text "mysql_insert_id". Here's my code: PHP Code: `$lastid = mysql_insert_id(); $query2 = "INSERT INTO posts VALUES ('id', '$category', $lastid, '$author', '$msg', '$starttime', '$startdate')"; $results2 = mysql_query($query2); ????: NamePros.com http://www.namepros.com/programming/133998-another-problem-sorry.html` EDIT: Also, I get a very frustrating repetition: http://www.darkfx.co.uk/darkfx/threads.php?category=1 __________________ SQL Dumpster - SQL Database Dumps and Resources Last edited by Encenta.com; 10-22-2005 at 12:12 PM.

10-22-2005, 12:20 PM	#6 (permalink)
iNod Eating Pie Join Date: Nov 2004 Location: Canada Posts: 2,267	Ouch.. I suggest deleting that script from ftp right away.. Thats a major BW hog. Now.. Lets fix it up. First thing put ' (quotes) around $lastid The rest seems to be correct can you post rest of php. iNod __________________ I feel old.

10-22-2005, 12:54 PM	THREAD STARTER #7 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 579 Follow @MiseriaSK	lol. removed script for now PHP Code: if ($_POST['submitthread']) { $msg=$_POST['msg']; ????: NamePros.com http://www.namepros.com/showthread.php?t=133998 $title=$_POST['title']; $starttime=date("H:i"); ????: NamePros.com http://www.namepros.com/showthread.php?t=133998 $startdate=date("d/m/y"); $query = "INSERT INTO forum_threads VALUES ('id', '$title', '$author', '$category', '$starttime', '$startdate')"; $results = mysql_query($query); $lastid = mysql_insert_id(); $query2 = "INSERT INTO forum VALUES ('id', '$category', '$lastid', '$author', '$msg', '$starttime', '$startdate')"; $results2 = mysql_query($query2); if (!$result) { include("head.php"); echo("<h1>Success</h1> <p>Post added successfully. <a href='thread.php?category=$category&thread=$lastid'>Return to forum</a></p> "); include("foot.php"); exit; }} __________________ SQL Dumpster - SQL Database Dumps and Resources

10-22-2005, 01:16 PM	#8 (permalink)
iNod Eating Pie Join Date: Nov 2004 Location: Canada Posts: 2,267	PHP Code: if($_POST['submitthread']) { $msg=$_POST['msg']; $title=$_POST['title']; $starttime=date("H:i"); $startdate=date("d/m/y"); $query = "INSERT INTO forum_threads VALUES ('$title', '$author', '$category', '$starttime', '$startdate')"; $results = mysql_query($query); $lastid = mysql_insert_id(); $query2 = "INSERT INTO forum VALUES ('$category', '$lastid', '$author', '$msg', '$starttime', '$startdate')"; $results2 = mysql_query($query2); if (!$result) { include("head.php"); echo("<h1>Success</h1> <p>Post added successfully. <a href='thread.php?category=$category&thread=$lastid'>Return to forum</a></p> ????: NamePros.com http://www.namepros.com/showthread.php?t=133998 ????: NamePros.com http://www.namepros.com/showthread.php?t=133998 "); include("foot.php"); exit; } } Is there any code about that like while or foreach? I am wondering why it is looping. iNod __________________ I feel old.

10-22-2005, 01:27 PM	THREAD STARTER #9 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 579 Follow @MiseriaSK	Well, the page which displays the threads is: PHP Code: <? include("config.php"); $category = $_GET['category']; $newthread = $_GET['newthread']; session_start(); $author = $_SESSION['username']; // DISPLAY THREADS if (isset($_GET['category'])) { $result = mysql_query("SELECT * FROM categories WHERE id='$category'") or die("SELECT Error1: " .mysql_error()); $num=mysql_numrows($result); while ($row = mysql_fetch_array($result)) { $title = $row['title']; } $pagetitle = "$title threads"; include("head.php"); echo "<h1>$title forum</h1> <table width='100%' border='0'> <tr><td align='left'><p><a href='forum.php'>< Back to categories</a></p></td> <td align='right'><p><a href='forumhandle.php?newthread=true&category=$category'>Start new thread</a></p></td></tr></table>"; echo "<table width='100%' border='0' cellspacing=0 cellpadding=2> <tr class='threadhead'> <td width='40%'>Thread</td> <td width='25%'>Thread Started</td> <td width='25%'>Last Post</td> <td width='10%'>Posts</td> </tr>"; // END OF HEADINGS $result = mysql_query("SELECT * FROM forum_threads WHERE category='$category' ORDER BY id DESC") ????: NamePros.com http://www.namepros.com/showthread.php?t=133998 or die("SELECT Error1: " .mysql_error()); $num=mysql_numrows($result); $i=0; while ($i < $num) { if ($i % 2) { $bgcolor = "threadtable"; } else { $bgcolor = "threadtable2"; } $id=mysql_result($result,$i,"id"); $title=mysql_result($result,$i,"title"); $author=mysql_result($result,$i,"author"); $category=mysql_result($result,$i,"category"); $startdate=mysql_result($result,$i,"startdate"); ????: NamePros.com http://www.namepros.com/showthread.php?t=133998 $starttime=mysql_result($result,$i,"starttime"); $query = mysql_query( "SELECT * FROM forum WHERE threadid='$id' AND category='$category'" ) or die("SELECT Error2: " .mysql_error()); $numero=mysql_numrows($query); $query = mysql_query( "SELECT id FROM users WHERE username='$author'" ) or die("SELECT Error3: " .mysql_error()); $authorid=mysql_result($query,0,"id"); $query = mysql_query( "SELECT * FROM forum WHERE threadid='$id' AND category='$category' ORDER BY 'datetime' ASC LIMIT 1" ) or die("SELECT Error4: " .mysql_error()); $num1=mysql_numrows($query); $i=0; while ($i < $num1) { $author=mysql_result($query,$i,"author"); $time=mysql_result($query,$i,"time"); $date=mysql_result($query,$i,"date"); $today = date("d/m/y"); if ($date == $today) {$date = "Today"; } {$date = "Today";} $i++; } echo " <tr class='$bgcolor'> <td valign='top'><a href='showthread.php?category=$category&thread=$id'>$title</a></td> <td valign='top'>$startdate at $starttime <br />by <a href='viewprofile?profile_id=$authorid'>$author</a></td> <td valign='top'>$date at $time</td> <td valign='top'>$numero</td> </tr>"; $i++; } echo "</table>"; include("foot.php"); } // END DISPLAY THREADS ?> There are a few loops. But I think it's because of the database content which was the reason it was repeating __________________ SQL Dumpster - SQL Database Dumps and Resources

10-23-2005, 01:51 PM	THREAD STARTER #10 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 579 Follow @MiseriaSK	I got the ThreadID thing orking. But the problem now is that when displaying the threads, it isn't looping. It only displays the last row in the database __________________ SQL Dumpster - SQL Database Dumps and Resources

10-23-2005, 02:16 PM	#11 (permalink)
iNod Eating Pie Join Date: Nov 2004 Location: Canada Posts: 2,267	Hello, Get read of that while $i stuff. Use this format PHP Code: `$query = mysql_query("SELECT * FROM bob"); ????: NamePros.com http://www.namepros.com/showthread.php?t=133998 while($row = mysql_fetch_array($query)) { print "Bob eats $row['candy']"; }` Above says. Select all from bob. (Table I made was candy) While $row is equal to mysql_fetch_array do. print "Bob eats candy or what not"; } iNod __________________ I feel old.

10-23-2005, 02:40 PM	THREAD STARTER #12 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 579 Follow @MiseriaSK	Thank you so much once again! NP$ donated!! __________________ SQL Dumpster - SQL Database Dumps and Resources

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem With Prozilla Image Hosting Script	Maverick	Website Development	3	02-01-2006 03:32 PM
Very wierd Windows problem	Ravi_s	Web Design Discussion	0	08-12-2005 10:29 PM
MySQL or PHP problem	Wildchild22	Website Development	10	07-14-2005 05:24 AM
vBulletin Problem!!!!!!!!!!!!	domaino	Programming	11	06-23-2005 06:29 AM