modern PHP installations are presumed to be for production servers so they have lots of usefull stuff for developers turned off by default
look at
PHP.NET for Set Error Level
personally I'd suggest you go back to the place you got your script form and ask them whats wrong
you have multiple sources of error
1) it could be with the connection to the DB (you are not reading or writing or connecting to the db)
2) it could be the variables you are getting from the previous instance of the form are incorrect, you dont' set default values
3) it could be that you are not integrating the PHP with the HTML.. at a brief glance I suspect its likely to be the latter. I don't see anywhere where you set the value for the HTML text boxes in PHP
I don't recognise that style of PHP & HTML, but that doens't mean its not correct, it may mean my PHP is too rusty.
so at present you have a script and that isn't working, and you expect us to trawl through your code to find why its not working. theres very few people contributing to the PHP forum on this site, and mostly we deal with db errors not PHP errors.
I think you need to develop a debugging technique to work out what the errors are
the you need to go through each line of code to work out what it does, and then make sure your perception is the same as the PHP runtime
use lots of debug messages
examine the SQL to make sure its legible and correct
never do anything to the DB without some form of error reproting or trappin
make certain your IF's have an else.so you can see where the code path is going, evven if its no more than
if (condition='blah')
{ //do soemething
} else
{ print "condition was blah";
}
some consider it good practise to put an empty else in trheir code to demonstrate they have considered the else condition but don't need it.. seems silly to me as a comment can help
use comments in your code if you want help.
consider using an IDE such as eclipse or netbeans if you want
VB.VBA style debugging, but those IDE's are not for the faint hearted
I don't claim the following is 'good' code however you define that
PHP Code:
<?PHP
include ("./incfiles/cmnvars.php");
include ("./incfiles/cmnmod.php");
if (isset($pTXID)!=TRUE or (isset($pTXID)==true and $pTXID<=0)) {
//just in case someone has got to here without a txid (in theory impossible)
header("Location: http:/FrameSetShop.php?DM=ListManufacturers");
exit;
}
// script to extract all Manufacturers from DT_Manu
$cnn=@mysql_connect(HOST,UID1,PWD1) or die(handleerror(EMAILID,"ListManufacturers","E:1035 - Failed to open cn:$cnn ".mysql_errno().": ".mysql_error()));
$dbr=@mysql_select_db(DBN,$cnn) or die (handleerror(EMAILID,"ListManufacturers","E:1036 - Failed to open db:$dbr ".mysql_errno().": ".mysql_error()));
$sql = "select * from DT_TX where TX_ID=$pTXID;";
$sqlr=@mysql_query($sql,$cnn) or die (handleerror(EMAILID,"ListManufacturers","E:1037 - Failed to open rs:$sql ".mysql_errno().": ".mysql_error()));
if (@mysql_num_rows($sqlr)==0) //if not found then start over
{ header("Location: http:/FrameSetShop.php?DM=ListManufacturers");}
//rest of script follows
dBforums
>
Simple Form Problem
07-26-10, 11:24
Linear Mode
