the name of the database -- I do not know how to setup a database -- will of course need to be changed:
Code: Select all
<table width="28%" height="254" border="4" cellpadding="0" cellspacing="0" bordercolor="#006699">
<tr>
<td> <form name="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<h2><b>Add News Story</b></h2>
</td>
<tr>
<td>Author: </td>
</tr>
<tr>
<td><input type=text name="auth" size=40> </td>
</tr>
<tr>
<td>Headline:</td>
</tr>
<tr>
<td><input type=text name="title" size=40></td>
</tr>
<tr>
<td>News Story: </td>
</tr>
<tr>
<td><textarea name="news" rows=5 cols=30></textarea></td>
</tr>
<tr>
<td><input name="submit" type=submit value="ADD"></td>
</tr>
</table>
</form>
<?
$date=date("F j, Y");
if(!$auth||!title||!news||!$date)
{
echo "ERROR: Not all fields have been entered please try again!";
exit;
}
else
{
@ $db=mysql_pconnect($host,$user,$pass)or die("Could not connect to host\n");
mysql_select_db("tribals_joe")or die("Could not connect to databse\n");
$query_insert="INSERT into news (auth,title,news,date)Values("$auth","$title","$news","$date")";
mysql_query("$query_insert") or die("query_insert failed");
}
$query_count = "SELECT count(id) from slhnews";
$query_select = "SELECT id FROM news ORDER BY id LIMIT 1;";
$result3 = mysql_query($query_count) or die("query_count failed");
while ($count = mysql_fetch_array($result3))
{
$num=$count['count(id)'];
}
?>