forums program

[lukezweb]

in this bit of coding itonly submits the form if you refresh and says yes to resednign the data:

BTW : this is about a 1/10 of the overal code :)


} else if ($action == "post000") {
echo "<center>
<form name='shout' method='post'>";
?>
<table width='95%' cellspacing='2' bgcolor='black' cellpadding='1' border='0'>
<tr>
<td class='catbg'>
<table width='100%'>
<tr>
<td width='50%'>
<div align='left'>Welcome, Guest!</div>
</td>
<td width='50%'>
<div align='right'>3:51:30am , 13/12/2003</div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class='windowbg'>
<center>Lukezweb Forum - <a href='index.php?action=main'>Home</a> - <a href='index.php'>Portal</a> - <a href='index.php?action=help'>Help</a>
</center>
</td>
</tr>
<tr>
<td class='windowbg'><a href=index.php?action=general>Back to the General Board.....</a></td>
</tr>
<tr>
<td class='windowbg'>
<table width='100%' border='0' cellspacing='1' bgcolor='#000000'>
<tr>
<td class='windowbg2' height='20' align='center' width='20%' valign='middle'>Topic:</td>
<td width='70%' class='windowbg2' align='center' valign='middle' height='20'>Welcome, First Working Thread!</td>
<td width='10%' class='windowbg2' align='center' valign='middle' height='20'>11/12/03</td>
</tr>
<tr>
<td class='windowbg' align='center' valign='middle' height='20'>
<font size='+1'>Luke Dyson</font><BR>Administrator<BR><BR>NO AVATAR SELECTED<BR><BR>Posts: 1<BR><BR><a href=mailto:luke.dyson@blueyonder.co.uk>E-mail</a></td>
<td class='windowbg' align='center' valign='middle' height='20' colspan='2'>Welcome, First Working Thread!</td>
</tr>
</table>
</td>
</tr>
<?php
echo "<tr><td class=windowbg2 colspan=3>";
$query = "SELECT * FROM `post000`";
$result = mysql_query($query) or die ("Couldn't execute query.");
while ($row = mysql_fetch_array($result)) {
echo "
<table width='100%' border='0' cellspacing='1' bgcolor='#000000'>
<tr>
<td class='windowbg2' height='20' align='center' width='20%' valign='middle'>Replies:</td>
<td width='70%' class='windowbg2' align='center' valign='middle' height='20'>&nbsp;</td>
<td width='10%' class='windowbg2' align='center' valign='middle' height='20'>&nbsp;</td>
</tr>
<tr>
<td class='windowbg' align='center' valign='middle' height='20'>
<font size='+1'>".$row['username']."</font>
<BR>Guest
<BR>
<BR>NO AVATAR SELECTED
<BR><BR><BR><BR>
</td>
<td class='windowbg' align='center' valign='middle' height='20' colspan='2'>
".$row['message']."
</td>
</tr>
</table>";
}
if ($_POST['submit']) {
$dbh=mysql_connect ("localhost", "shoutbox_admin", "admin") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("shoutbox_forum");
$sql = "INSERT INTO `post000` (`username`, `message`) VALUES (' ".$_POST['username']." ', ' ".$_POST['message']." ')";
mysql_query($sql);
}

echo "<tr>
<td class=windowbg>
<HR width=90%>
</td>
</tr>
<tr>
<td class=catbg>
Post A Message:
</td>
</tr>
<tr>
<td class=windowbg>
<div align=center>
[<a href=javascript:add('TEXT')>B</a>]
[<a href=javascript:add('TEXT')>I</a>]
[<a href=javascript:add('TEXT')></a>]
[<a href=javascript:add('TEXT')><strike>S</strike></a>]
[<a href=javascript:add('TEXT')>G</a>]
[<a href=javascript:add('TEXT')>S</a>]
[<a href=javascript:add('TEXT')><-</a>]
[<a href=javascript:add('[hr]')>HR</a>]
[<a href=javascript:add('')>WWW</a>]
[<a href=javascript:add('')>IMG</a>]
[<a href=javascript:add('')>@</a>]
</td>
</tr>
<tr>
<td class=windowbg>
<div align=center>
<a href=javascript:add(':-/')><img src=annoyed.gif></a>
<a href=javascript:add(':-[')><img src=bad.gif></a>
<a href=javascript:add(':@')><img src=blush.gif></a>
<a href=javascript:add(':D')><img src=cheesy.gif></a>
<a href=javascript:add('8)')><img src=cool.gif></a>
<a href=javascript:add('???')><img src=huh.gif></a>
<a href=javascript:add(':-)')><img src=kiss.gif></a>
<a href=javascript:add('::)')><img src=rolleyes.gif></a>
<a href=javascript:add(':-?')><img src=sad.gif></a>
<a href=javascript:add(':O')><img src=shocked.gif></a>
<a href=javascript:add(':Z')><img src=smartass.gif></a>
<a href=javascript:add(':)')><img src=smiley.gif></a>
<a href=javascript:add(':P')><img src=tongue.gif></a>
<a href=javascript:add(';)')><img src=wink.gif></a>
</td>
</tr>
<tr>
<td class=windowbg>
<div align=center valign=middle>
Name: &nbsp;
<input type=text name=username width=200 tabindex=1>
</td>
</tr>
<tr>
<td class=windowbg>
<div align=center>
<textarea name=message rows=10 cols=80 wrap=soft tabindex='2'></text>
</td>
</tr>
<tr>
<td class=windowbg>
<div align=center>
<input type=submit name=submit value=Submit tabindex=3>
</td>
</tr>
</table>
</center>
</form>";

} else {



also if i wish to order the replies in order in the sql table i add a row of 'id' how do i get it to add one to its value everytime there is a reply?

any help ill be greatful

[pyro]

Did you have two questions? I only saw one, about the auto incrementing the id. What you want to do is set the id field to auto increment. :)

[lukezweb]

Originally posted by pyro
Did you have two questions? I only saw one, about the auto incrementing the id. What you want to do is set the id field to auto increment. :)

i tried adding an id TEXT auto_incremetn but no luck it said not a valid column identifier

[pyro]

What does you SQL for the CREATE TABLE look like?

[lukezweb]

Originally posted by pyro
What does you SQL for the CREATE TABLE look like?

it is this......

so far :)

obviouslt not just that but thats the details :)

TABLE `post000`
`username` `username` TEXT NOT NULL ,
`message` `message` TEXT NOT NULL ,
`ipaddress` `ipaddress` TEXT NOT NULL

[pyro]

I don't see any id, and I don't see any auto increment... :p

Maybe you should try something like this:

CREATE TABLE `post000` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(100) NOT NULL default '',
`message` text NOT NULL default '',
`ipaddress` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
)