I pruned it all down ti this:
<html>
<head><title>The Board Lady - Work Order Database 0.1a</title></head>
<body>
<?php
define ('DB_USER', '********');
define ('DB_PASSWORD', '********');
define ('DB_HOST', '********');
define ('DB_NAME', '********');
$dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not
connect to database: ' . mysql_error());
@mysql_select_db (DB_NAME) OR die ('Could not connect to database: ' .
mysql_error());
$page_req=$HTTP_GET_VARS['action'];
if ($page_req == "") {
echo "SWORD data entry<br>\n";
echo "<form action=\"add.php\" method=\"get\">";
echo "Work Order #: <input type=\"text\" name=\"wo_num\"><br>\n";
echo "Customer Name: <input type=\"text\" name=\"name\"> Phone: <input
type=\"text\" name=\"phone\"><br>\n";
echo "Email Addy: <input type=\"text\" name=\"email\"> Date In: <input
type=\"text\" name=\"date\"><br>\n";
echo "Board Type and SN: <input type=\"text\" name=\"board_type\"> Last 3 of
SN: <input type=\"text\" name=\"last_three\"><br>\n";
echo "Weight In: <input type=\"text\" name=\"weight_in\"> Weight Out: <input
type=\"text\" name=\"weight_out\"><br>\n";
echo "<input type=\"hidden\" name=\"action\" value=\"1\">\n";
echo "<INPUT type=\"submit\" value=\"Add Work Order\"> <INPUT
type=\"reset\"><br>\n";
}
if ($page_req == "1") {
$wo_num=$HTTP_GET_VARS['wo_num'];
$name=$HTTP_GET_VARS['name'];
$phone=$HTTP_GET_VARS['phone'];
$email=$HTTP_GET_VARS['email'];
$date=$HTTP_GET_VARS['date'];
$board_type=$HTTP_GET_VARS['board_type'];
$last_three=$HTTP_GET_VARS['last_three'];
$weight_in=$HTTP_GET_VARS['weight_in'];
$weight_out=$HTTP_GET_VARS['weight_out'];
$query_insert = "INSERT INTO boards (wo_num, name, phone, email, date,
board_type, last_three, weight_in, weight_out) VALUES ('$wo_num', '$name',
'$phone', '$email', '$date', '$board_type', '$last_three', '$weight_in',
'$weight_out');";
echo "$query_insert<br>\n$result_insert<br>\n";
$result_insert = @mysql_query ($query_insert) or die("you suck!
$mysql_error");
}
mysql_close();
?>
</body>
</html>
Which I figured would reduce the number of things that can pop an error to a
minimum. When I post something, it echoes a rather beautiful mysql insert
statement...then tells me that I suck. But it doesn't tell me why I
suck...$mysql_error is empty. And it's not sticking anything into my
database.
Arrrghhhh.
----- Original Message -----
From: "Dan Bowkley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 04, 2004 12:18 AM
Subject: Re: [PHP-DB] lamer noob with repeat question
> I've got it currently as method=get; I thought it had to be get in order
to
> manipulate variables in the URL, as I've got them...have I thought wrong?
>
>
> ----- Original Message -----
> From: "Ross Honniball" <[EMAIL PROTECTED]>
> To: "Dan Bowkley" <[EMAIL PROTECTED]>
> Sent: Monday, May 03, 2004 11:53 PM
> Subject: Re: [PHP-DB] lamer noob with repeat question
>
>
> > Have you tried putting in a
> >
> > <form method="post" action="script-name.php">
> >
> > in your html?
> >
> > I'm haven't read all of your email but this is what I use and your html
> > doesn't seem to have this. I think php needs the 'action=' to know what
> to
> > do when the user submits the form.
> >
> > At 04:37 PM 4/05/2004, you wrote:
> > >Anyone?
> > >----- Original Message -----
> > >From: "Dan Bowkley" <[EMAIL PROTECTED]>
> > >To: <[EMAIL PROTECTED]>
> > >Sent: Sunday, May 02, 2004 1:21 AM
> > >Subject: [PHP-DB] lamer noob with repeat question
> > >
> > >
> > > > Hello everyone,
> > > >
> > > > I've been working on (read:tearing my hair out over) my mom's
website
> for
> > > > some time now. Specifically, I'm trying to get her work order
> database up
> > > > and running.
> > > >
> > > > The basic idea is this: you start out adding a new record by going
to
> > > > add.php. It sees that you've not done anything yet and thus
presents
> you
> > > > with a form to fill out. That form gets submitted to add.php, which
> sees
> > > > that you're adding something. It checks for a duplicate work order
> number
> > > > (and eventually other errors) and then either adds the stuff you
> submitted
> > > > into the DB, or pops an error and presents the form again.
> > > >
> > > > Alas, it does nothing.
> > > >
> > > > When you initially load the page, it works okay, sensing that you've
> not
> > >yet
> > > > done anything and displaying the form. But when you submit data, it
> spits
> > > > out naught more than a blank page, and doesn't add anything to the
> > >database.
> > > >
> > > > Damned lazy script.
> > > >
> > > >
> > > > What I've got so far is this:
> > > >
> > > > <html>
> > > > <head><title>The Board Lady - Work Order Database
0.1a</title></head>
> > > > <body>
> > > > <?php
> > > > define ('DB_USER', 'user');
> > > > define ('DB_PASSWORD', '********');
> > > > define ('DB_HOST', 'localhost');
> > > > define ('DB_NAME', 'boardlady');
> > > > $dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could
> not
> > > > connect to database: ' . mysql_error());
> > > > @mysql_select_db (DB_NAME) OR die ('Could not connect to database: '
.
> > > > mysql_error());
> > > > $page_req=$HTTP_GET_VARS['action'];
> > > > if ($page_req == "") {$page_req="0";}
> > > > if ($page_req == "0") {
> > > > echo "SWORD data entry<br>\n";
> > > > echo "<form action=\"add.php\" method=\"get\">";
> > > > echo "Work Order #: <input type=\"text\" name=\"wo_num\"><br>\n";
> > > > echo "Customer Name: <input type=\"text\" name=\"name\"> Phone:
<input
> > > > type=\"text\" name=\"phone\"><br>\n";
> > > > echo "Email Addy: <input type=\"text\" name=\"email\"> Date In:
<input
> > > > type=\"text\" name=\"date\"><br>\n";
> > > > echo "Board Type and SN: <input type=\"text\" name=\"board_type\">
> Last 3
> > >of
> > > > SN: <input type=\"text\" name=\"last_three\"><br>\n";
> > > > echo "Weight In: <input type=\"text\" name=\"weight_in\"> Weight
Out:
> > ><input
> > > > type=\"text\" name=\"weight_out\"><br>\n";
> > > > echo "<input type=\"hidden\" name=\"action\" value=\"1\">\n";
> > > > echo "<INPUT type=\"submit\" value=\"Add Work Order\"> <INPUT
> > > > type=\"reset\"><br>\n";
> > > > }
> > > > if ($page_req == "1") {
> > > > $wo_num=$HTTP_GET_VARS['wo_num'];
> > > > $name=$HTTP_GET_VARS['name'];
> > > > $phone=$HTTP_GET_VARS['phone'];
> > > > $email=$HTTP_GET_VARS['email'];
> > > > $date=$HTTP_GET_VARS['date'];
> > > > $board_type=$HTTP_GET_VARS['board_type'];
> > > > $last_three=$HTTP_GET_VARS['last_three'];
> > > > $weight_in=$HTTP_GET_VARS['weight_in'];
> > > > $weight_out=$HTTP_GET_VARS['weight_out'];
> > > > $query_testingforadupe = "SELECT job_no FROM boards WHERE job_no ==
> > >$job_no
> > > > ORDER BY job_no ASC";
> > > > $result_testingforadupe = @mysql_query ($query_testingforadupe);
> > > > if ($result_testingforadupe) {
> > > > echo "That's a duplicate work order number, you ditz. Try again,
this
> time
> > > > without screwing it all up.<br><br>\n";
> > > > echo "<form action=\"add.php\" method=\"get\">";
> > > > echo "Work Order #: <input type=\"text\" name=\"wo_num\"><br>\n";
> > > > echo "Customer Name: <input type=\"text\" name=\"name\"> Phone:
<input
> > > > type=\"text\" name=\"phone\"><br>\n";
> > > > echo "Email Addy: <input type=\"text\" name=\"email\"> Date In:
<input
> > > > type=\"text\" name=\"date\"><br>\n";
> > > > echo "Board Type and SN: <input type=\"text\" name=\"board_type\">
> Last 3
> > >of
> > > > SN: <input type=\"text\" name=\"last_three\"><br>\n";
> > > > echo "Weight In: <input type=\"text\" name=\"weight_in\"> Weight
Out:
> > ><input
> > > > type=\"text\" name=\"weight_out\"><br>\n";
> > > > echo "<input type=\"hidden\" name=\"action\" value=\"1\">\n";
> > > > echo "<INPUT type=\"submit\" value=\"Add Work Order\"> <INPUT
> > > > type=\"reset\"><br>\n";
> > > > }
> > > > else {
> > > > $query_insert = "INSERT INTO boards (wo_num, name, phone, email,
date,
> > > > board_type, last_three, weight_in, weight_out) VALUES (\'$wo_num\',
> > > > \'$name\', \'$phone\', \'$email\', \'$date\', \'$board_type\',
> > > > \'$last_three\', \'$weight_in\', \'$weight_out\')";
> > > > $result_insert = @mysql_query ($query_insert);
> > > > if ($result_insert == "") {
> > > > echo "<input type=\"hidden\" name=\"action\" value=\"0\"\n";
> > > > echo "<INPUT type=\"submit\" value=\"Continue\">\n";
> > > > }
> > > > else {echo "OOPS! Your programmer is an idiot!\n";}
> > > > }}
> > > > mysql_close();
> > > > ?>
> > > > </body>
> > > > </html>
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > The database looks like this, in case you're curious:
> > > > CREATE TABLE boards (
> > > > name varchar(40) default NULL,
> > > > phone varchar(12) default NULL,
> > > > email varchar(40) default NULL,
> > > > purveyor varchar(40) default NULL,
> > > > job_no int(5) unsigned NOT NULL default '0',
> > > > date varchar(10) NOT NULL default '',
> > > > board_type varchar(100) NOT NULL default '',
> > > > weight_in decimal(4,2) default NULL,
> > > > weight_out decimal(4,2) default NULL,
> > > > last_three int(3) unsigned default NULL,
> > > > PRIMARY KEY (job_no),
> > > > KEY last-three (last_three)
> > > > ) TYPE=MyISAM;
> > > >
> > > >
> > > > Can anyone help me to get this thing working?
> > > >
> > > > TIA
> > > > Dan
> > > >
> > > > --
> > > > PHP Database Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > > >
> > > >
> > >
> > >--
> > >PHP Database Mailing List (http://www.php.net/)
> > >To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> > . Ross Honniball JCU Bookshop Cairns Supervisor
> > . James Cook Uni, McGreggor Rd, Smithfield, Qld. 4878, Australia
> > . Ph:07.4042.1157 Fx:07.4042.1158 Em:[EMAIL PROTECTED]
> > . There are no problems. Only solutions.
> >
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
