Ok.....I have it working half-way now.....here is what I have so far:

===================
PHP FORM ("add_jobs.php" - submits to the script below):

<FORM METHOD="post" ACTION="do_addjobs.php">
<TEXTAREA NAME="duties" COLS="30" ROWS="10"     WRAP="virtual"></TEXTAREA>
<INPUT TYPE="submit" VALUE="Add Job">
</FORM>
===================


===================
PHP SCRIPT ("do_addjobs.php" - inserts into db)

<?
if ((!$duties))
{
header("Location: add_jobs.php");
exit;
}

$sql = "INSERT INTO jobs (duties) values ('$duties')";
$connection = mysql_connect("localhost", "????", "????") or die ("Couldn't 
connect to the server.");
$db = mysql_select_db("????", $connection) or die ("Couldn't select the 
database.");
$sql_result = mysql_query($sql) or die ("Couldn't execute query.");

echo "<B>Duties:";
echo nl2br ($duties);
echo "</B>";

?>
===================



With the way I have this above, when it does "echo nl2br ($duties);" it 
displays fine now -- thanks for that help so far -- but the problem now 
(this may be normal, but I am not sure) is when I connect to the db and 
"select * from jobs;" the db is writing the entries like this:


===================
mysql> select * from jobs;
+----+----------+----------+--------+---------+---------------------------------+----------+----------+--------+----------+
| id | position | opendate | salary | appdate | 
duties                          | examples | training | skills | benefits |
+----+----------+----------+--------+---------+---------------------------------+----------+----------+--------+----------+
|  1 | test     | test     | test   | test    | 1
2
3

4
5
6


7
8
9 | test     | test     | test   | test     |
+----+----------+----------+--------+---------+---------------------------------+----------+----------+--------+----------+
===================


is this in fact normal?


Jay


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to