Not only does this not insert to my table, but it brings up a blank screen. Can anyone clue me in on why this is not working? Thanks!
if (!$build)
{
// populate the drop down menu
$namepull = "SELECT * FROM listings ORDER BY agency ASC";
// execute SQL query and get result
$nameput = mysql_query($namepull) or die(mysql_error());
// put data into drop-down list box
while ($r = mysql_fetch_array($nameput))
{
$id=$r["id"];
$agency=$r["agency"];
$agencies .= "<option value=\"$agency\">$agency";
}
?>
In order to build your Transactions Form, please select an agency and how many transactions will be necessary:<br /><br />
<select name="selectedagency" id="agency" size="1" style="background-color:#F7F7F7;">
<? echo "<option value=\"0\" selected>Select Agency";?>
<? echo "$agencies"; ?>
</select>
<select name="transactionsnumber" size="1" style="background-color:#F7F7F7;"><option value=\"0\">Select Transactions number<option>1<option>2<option>3<option>4<option>5<option>6<option>7<option>8<option>9<option>10</select>
<input type="submit" name="build" value="Build">
<?php
}
if ($build)
{
$transactionsnumber=$_POST['transactionsnumber'];
$selectedagency=$_POST['selectedagency'];
if ($transactionsnumber=='1')
{
if (!$submit)
{
?>
<b><?php echo $selectedagency; ?></b><br /><table valign="top" border="0" cellpadding="3">
<tr><td align="center"><br /><b>Transaction 1</b></td></tr>
<tr><td align="center">
Employee: <input type="text" name="Employee1" size="20">
Hours: <input type="text" name="Hours1" size="5">
</td></tr>
<tr><td align="center">
Client: <input type="text" name="Client1" size="4">
Job #: <input type="text" name="JobNum1" size="6">
Project: <input type="text" name="Project1" size="20">
</td></tr>
<tr><td align="center">
<input type="hidden" name="build" value="Build">
<input type="submit" name="submit" value="Submit">
<?php
}
if ($submit)
{
mysql_select_db('esbsolu_powerbucks');
$agencyquery= "SELECT * FROM listings WHERE agency = '".$HTTP_POST_VARS['selectedagency']."'";
$agencyresult=mysql_query($agencyquery) or die(mysql_error());
$row = mysql_fetch_array($agencyresult) or die(mysql_error());
$AgencyID=$row["id"];
$agency=$row["agency"];
$Employee1=$HTTP_POST_VARS['Employee1'];
$Client1=$HTTP_POST_VARS['Client1'];
$JobNum1=$HTTP_POST_VARS['JobNum1'];
$Project1=$HTTP_POST_VARS['Project1'];
$Hours1=$HTTP_POST_VARS['Hours1'];
mysql_select_db('esbsolu_powerbucks');
$query = "INSERT INTO transactions
('Employee', 'Client', 'JobNum', 'Project', 'Hours', 'AgencyID')
VALUES('$Employee1','$Client1','$JobNum1','$Project1','$Hours1','$AgencyID')
WHERE AgencyID='$AgencyID'";
$insertresult=mysql_query($query) or die ('you failed');
if(!$insertresult)
{
echo die(mysql_error());
}
if($insertresult)
{
echo '<h3>Agency Report: '.$agency.'</h3><p><center><br />';
$theQuery = "SELECT * FROM listings WHERE agency='".$agency."'";
$agencyquery= mysql_query($theQuery);
if (!$agencyquery)
{
echo 'Cannot select database. <br /><br />
Click <a href="admin.php" class="roll">here</a> if you are not redirected.';
if(strtolower(substr($transfer, 0, 4))!='http')
{
$base = ($_SERVER['HTTPS'] == 'on' ? "https://" : "http://");
$base .= $_SERVER['HTTP_HOST'];
if(dirname($_SERVER['PHP_SELF']) != '/')
$base .= dirname($_SERVER['PHP_SELF']);
$transfer = $base.'/'.$transfer;
}
header("Location: $transfer");
exit;
}
while($r = mysql_fetch_array($agencyquery))
{
$id=$r["id"];
$agency=$r["agency"];
$budget=$r["budget"];
mysql_select_db('esbsolu_powerbucks');
$HoursSum= "SELECT sum(Hours) FROM transactions WHERE AgencyID=$id";
$result=mysql_query($HoursSum);
$TotalHours= mysql_result($result,0);
$Balance= $budget - (100*$TotalHours);
mysql_select_db('esbsolu_powerbucks');
$transactions= mysql_query("select * from transactions where AgencyID='".$r[ 'id']."' ORDER BY JobNum ASC");
$num_results = mysql_num_rows($transactions);
if ($num_results == 0)
{
echo '<h5>BALANCE: $'.$budget.'</h5>
<br /><a href="admin.php" class="roll">Go back</a>';
exit;
}
echo '<h5>TRANSACTIONS:</h5><table border="0" width="500"><tr><td align="left"><b>Employee</b></td><td align="left"><b>Client</b></td><td align="left"><b>Job Number</b></td><td align="left"><b>Project</b></td><td align="right"><b>Hours</b></td></tr>';
while($r = mysql_fetch_array($transactions))
{
$Employee=$r["Employee"];
$Client=$r["Client"];
$JobNum=$r["JobNum"];
$Project=$r["Project"];
$Hours=$r["Hours"];
$AgencyID=$r["AgencyID"];
echo '<tr><td align="left">'.$Employee.'</td><td align="left">'.$Client.'</td><td align="left">'.$JobNum.'</td><td align="left">'.$Project. '</td><td align="right">'.$Hours.'</td></tr>';
}
echo '</table><h5>BUDGET:$'.$budget.'
BALANCE: $'.$Balance.'</h5><br />
<a href="admin.php" class="roll">Go back</a>';
}
}
}
}
