Code not working

[paul]

Hi could anyone please help me. I am a newbie to php. I am using php4
and trying to put together some code to update a db but I am not having
much luck. This is the code I have come up with so far.

<?php

if (isset($_POST['submitted'])) { // if the form has been submitted
handle it

// check the required form fields.
if (!empty($_POST['JobNumber'])) {

// Include MYSQL info
require_once
'/home/e-smith/files/ibays/mct/cgi-bin/mysql_connect.inc.php';

// Create the query
$q = "INSERT INTO MyDB (JobNumber) VALUES ('{$_POST['JobNumber']}')";

// Execute the query
$r = mysql_query ($dbc, $q);

//print a message indicating success
if (mysql_affected_rows($dbc) == 1) {
echo '<b><font color="green">It Has Been entered!</font></b>';
} else {
echo '<b><font color="red">Sorry it has failed!</font></b>';
}

Close the connection
mysql_close($dbc)

} else { //print a message if they failed to enter a catagory
echo '<b><font color="red">You forgot to enter a value</font></b>';
}

} else {
?>

Add a new category to the Job Number:<br />
<form action="add_expense_category.php" method="post">
<input type="text" name="JobNumber" size="30" maxlength="30" /><br />
<input type="hidden" name="submitted" value="true" />
<input type="submit" name="submit" value="Submit!" />
</form>

<?php
}
?>

but for some reason it doesn't work. Am I missing something I have
looked over it 100 times but everything seems fine. Can anyone help me
out.

Thanks in advance
Paul

[Emil]

pa**@sunnyland.com.au napisał(a):

Hi could anyone please help me. I am a newbie to php. I am using php4
and trying to put together some code to update a db but I am not having
much luck. This is the code I have come up with so far.

<?php

if (isset($_POST['submitted'])) { // if the form has been submitted
handle it

// check the required form fields.
if (!empty($_POST['JobNumber'])) {

// Include MYSQL info
require_once
'/home/e-smith/files/ibays/mct/cgi-bin/mysql_connect.inc.php';

// Create the query
$q = "INSERT INTO MyDB (JobNumber) VALUES ('{$_POST['JobNumber']}')";

// Execute the query
$r = mysql_query ($dbc, $q);

//print a message indicating success
if (mysql_affected_rows($dbc) == 1) {
echo '<b><font color="green">It Has Been entered!</font></b>';
} else {
echo '<b><font color="red">Sorry it has failed!</font></b>';
}

Close the connection
mysql_close($dbc)

} else { //print a message if they failed to enter a catagory
echo '<b><font color="red">You forgot to enter a value</font></b>';
}

} else {
?>

Add a new category to the Job Number:<br />
<form action="add_expense_category.php" method="post">
<input type="text" name="JobNumber" size="30" maxlength="30" /><br />
<input type="hidden" name="submitted" value="true" />
<input type="submit" name="submit" value="Submit!" />
</form>

<?php
}
?>

but for some reason it doesn't work. Am I missing something I have
looked over it 100 times but everything seems fine. Can anyone help me
out.

Thanks in advance
Paul

Is it the whole code? I can't see where you connect to database
(mysql_connect(), mysql_select_database()).
Anyway try to be more precise. What is the real problem?
There is nothing in $_POST after submit or database returns an error?
If there is database error then what it is? Try putting
error_reporting(E_ALL) in the beginning of your script it could help
to diagnose your problem.
greetz Emil

[Kimmo Laine]

"Emil" <em**************@podczta.onet.pl> wrote in message
news:e6**********@news.onet.pl...

Is it the whole code? I can't see where you connect to database
(mysql_connect(), mysql_select_database()).

I'd assume those are called via this require:

require_once
'/home/e-smith/files/ibays/mct/cgi-bin/mysql_connect.inc.php';

--
"ohjelmoija on organismi joka muuttaa kofeiinia koodiksi" -lpk
sp**@outolempi.net | Gedoon-S @ IRCnet | rot13(xv***@bhgbyrzcv.arg)

[David Haynes]

pa**@sunnyland.com.au wrote:

Hi could anyone please help me. I am a newbie to php. I am using php4
and trying to put together some code to update a db but I am not having
much luck. This is the code I have come up with so far. [snip]
Close the connection
mysql_close($dbc)

should be:
// Close the connection
mysql_close($dbc);
-david-

[Alan Little]

Carved in mystic runes upon the very living rock, the last words of
<pa**@sunnyland.com.au> of comp.lang.php make plain:

but for some reason it doesn't work.

"It doesn't work" isn't much to go on. Can you provide more detail? What
are you expecting to happen, that doesn't, or not expecting, that does?

http://www.catb.org/~esr/faqs/smart-...html#beprecise

Try outputting the query to be sure it's being properly formed. If there's
a db error, check mysql_error().

--
Alan Little
Phorm PHP Form Processor
http://www.phorm.com/

[william.clarke]

Usually when I'm debugging I 'echo' program flow (eg. "Attempting DB
connection" so I can see at which point my logic has gone astray) and
as many variable values as I think could be causing issues (often
things like the actual query being run are a good place to start, as
others have already suggested).

[paul]

Thanks for all your help.

I have put into action your suggestions and I have found the problem
(turns out I missed a ; bugger!)

anyway it was great to find out the ways to debug.

Thanks again.

Paul