PHP - Ucwords In Foreach($_post As $key => $value)

i want to be able to use ucwords in my whole return results. i know this works.

$choice1 = ucwords($rows['auth']);

BUT. my query returns 14 $rows of data so i thought of doing this instead of doing a new chunk of code for each row.


$sql = "SELECT * from dsgi_serval $column ";
$result1=mysql_query($sql);
$result = ucwords($'result1');

while($rows=mysql_fetch_array($result)){
echo "$rows";
}


needless to say that does not work. i have tried to google this but i only get matches for manual arrays and not an sql query.
is there a way of doing this?

Thanks

I have a registration page I am creating which passes Ajax data from a form to the function ProcessSignUpData. I am trying to use ucwords on this function for the name, address and city form fields and it isn't working.  Any Suggestions what be greatly appreciated!  If I am not providing enough information, please let me know!

Here is what the code looks like:

if ($_POST['ProcessSignUpData'])
{
usleep(3500000);
unset($Data);
$Data['OldCardNbr'] = substr(preg_replace("/[^0-9]*/", "", $_POST['SavingsClub']), -8);
$Data['FName'] = ucwords($_POST['FirstName']);
$Data['LName'] = ucwords($_POST['LastName']);
$Data['Address1'] = ucwords($_POST['Address1']);
$Data['Address2'] = ucwords($_POST['Address2']);
$Data['City'] = ucwords($_POST['City']);
$Data['State'] = $_POST['State'];
$Data['Zip'] = preg_replace("/[^0-9]*/", "", $_POST['ZipCode']);
if (ValidateEMail($_POST['EMail'])) $Data['EmailAddr'] = $_POST['EMail'];
$Data['HPhone'] = phone_format($_POST['HomePhone']);
$Data['WPhone'] = phone_format($_POST['MobilePhone']);
$Data['BirthYear'] = preg_replace("/[^0-9]*/", "", $_POST['BirthYear']);
$Data['BirthMo'] = preg_replace("/[^0-9]*/", "", $_POST['BirthMonth']);
$Data['Sex'] = preg_replace("/[^MF]*/", "", $_POST['Gender']);
$NumberOfCards = preg_replace("/[^0-9]*/", "", $_POST['NumberOfCards']);

if ($Data['FName'] && $Data['LName'] && $Data['Address1'] && $Data['City'] && $Data['Zip'])
{
// Check to see if the person is already signed up with a new card number (dupliate signup check)
$IsDup = FALSE;

// First check database SCVL1
$My->query("select `MembNbr`, `HPhone`, `EmailAddr`, `OldCardNbr` from `member` where `FName` = '" . $My->escape($Data['FName']) . "' and `LName` = '" . $My->escape($Data['LName']) . "' and `State` = '" . $My->escape($Data['State']) . "' and substr(`Zip`, 1, 5) = '" . $My->escape(substr($Data['Zip'], 0, 5)) . "'");
if ($DupCheck = $My->fetchArray())
{
do
{
if (substr($DupCheck['MembNbr'], 0, 1) == "6")
{
$IsDup = TRUE;
if ($Data['EmailAddr'] && $DupCheck['EmailAddr'])
{
if ($Data['EmailAddr'] != $DupCheck['EmailAddr'])
{
$IsDup = FALSE;
}
}
if ($Data['HPhone'] && $DupCheck['HPhone'])
{
if ($Data['HPhone'] != $DupCheck['HPhone'])
{
$IsDup = FALSE;
}
}
}
if ($IsDup === TRUE) break;
}
while ($DupCheck = $My->fetchArray());
}

// Then check database SCVL3 if no dup found in SCVL1
if ($IsDup === FALSE)
{
$My3->query("select `MembNbr`, `HPhone`, `EmailAddr`, `OldCardNbr` from `tblmember` where `FName` = '" . $My->escape($Data['FName']) . "' and `LName` = '" . $My->escape($Data['LName']) . "' and `State` = '" . $My->escape($Data['State']) . "' and substr(`Zip`, 1, 5) = '" . $My->escape(substr($Data['Zip'], 0, 5)) . "'");
if ($DupCheck = $My3->fetchArray())
{
do
{
if (substr($DupCheck['MembNbr'], 0, 1) == "6")
{
$IsDup = TRUE;
if ($Data['EmailAddr'] && $DupCheck['EmailAddr'])
{
if ($Data['EmailAddr'] != $DupCheck['EmailAddr'])
{
$IsDup = FALSE;
}
}
if ($Data['HPhone'] && $DupCheck['HPhone'])
{
if ($Data['HPhone'] != $DupCheck['HPhone'])
{
$IsDup = FALSE;
}
}
}
if ($IsDup === TRUE) break;
}
while ($DupCheck = $My3->fetchArray());
}
}

// Show an error if a dup was found
if ($IsDup === TRUE)
{

I need to add ucwords so that the first letter is caps in POST data. Not sure where to put in within this.


echo $_POST['name'];

Hi

I have the following for an input form,  I was under the impression that ucwords would format the text into Initial Characters, but this does not do that?  What have I done wrong?

$ven_name = trim(ucwords(mysql_prep($_POST['ven_name'])));

This topic has been moved to Application Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=355772.0

I'm not sure if the title explains it very well, but here is an image of it. I am trying to figure out how to access the option selected (equal, not equal, etc.), along with its input box, for each column (the checkboxes on the right) selected. The purpose of this is to allow a non-programming administrator user to create a custom query to access information. I can find out which checkboxes are selected no problem, but finding the accompanying drop-down option and input box is difficult for me. How do I do this?

If you have a suggestion on how to change it, I'm very open. Thank you in advance!



Code: [Select]
if(!isset($_POST['submit']))
{
echo "
<form method='post'>
<table>
 <tr>
  <td valign='top'>SELECT</td>
  <td valign='top'>
   <table>";
 
// LIST ALL COLUMNS IN A TABLE
$result = mysql_query("SELECT * FROM table_name") or die(mysql_error());
$rowcount=mysql_num_rows($result);
$y=mysql_num_fields($result);
for ($x=0; $x<$y; $x++)
{ echo "
    <tr>
<td>
  <input type='checkbox' name='fields[]' value='".mysql_field_name($result, $x)."'>".mysql_field_name($result, $x)."
     </td>
</tr>"; }
 
   echo "
   </table>
  </td>
  <td valign='top'>FROM allocations</td>
  <td valign='top'>WHERE</td>
  <td>
   <table>";
   
// LIST ALL COLUMNS IN A TABLE
$result = mysql_query("SELECT * FROM table_name") or die(mysql_error());
$rowcount=mysql_num_rows($result);
$y=mysql_num_fields($result);
for ($x=0; $x<$y; $x++)
{ echo "
    <tr>
<td>
  <input type='checkbox' name='column[]' value='".mysql_field_name($result, $x)."'>".mysql_field_name($result, $x)."
</td>
<td>
  <select name='operator[]'>
          <option value='='>equals</option>
          <option value='<>'>does not equal</option>
          <option value='>'>greater than</option>
          <option value='<'>less than</option>
          <option value='>='>greater than or equal to</option>
          <option value='<='>less than or equal to</option>
          <option value='LIKE'>is like</option>
         </select>
</td>
     <td><input type='text' name='criteria[]'></td>
</tr>"; }

   echo "
   </table>
  </td>
  <td valign='top'><input type='submit' value='Process Query' name='submit' class='submit'></td>
 </tr>
</table>
</form>";
}
else
{
 echo "<b>Fields to edit:</b> ";
foreach ($_POST['fields'] as $fields) {
echo $fields,", ";
}

 echo "<br><br>";
 echo "<b>Columns to query:</b> ";
foreach ($_POST['column'] as $columns) {
echo $columns," HERE IS THE SPOT, ";
}
}

Hi guys,

I have a form using radio buttons.
For the radio button, lets just say i have the id name as 'rim' + number eg; rim0, rim1, rim2....

When i post the data to another file to execute the data collected, naturally i would use the:
Code: [Select]
$rim0=$_POST['rim0'];
$rim1=$_POST['rim1'];
....
$rim10=$_POST['rim10'];
i tried to shorten this process using this method:
Code: [Select]
//$q is part of the post variable.
for($x = 0; $x < count($q); $x++){

$rim[]=$_POST['"rim"."$x"'];
}
But i get this error
Code: [Select]
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Notice: Undefined index: "rim"."$x" in D:\Apache Software Foundation\Apache2.2\htdocs\.....\#####.php on line 20
Is there something wrong with my POST syntax?

ok am workin on this script its a points market for a text based game but my money is not taking the amount of the players i points on the market ... just say i post 10 points for $29.000.000 ... and when the player  buys the points it takes the money from that user and give the user points but .... when the user buy the points it dont give the user the money it give $290 ?? not sure is its my SQL av post that to


Code: [Select]
<?php
include 'header.php';

$_POST['buypoints'] =  abs(intval($_POST['buypoints']));{


$result = mysql_query("SELECT * FROM `pointsmarket` WHERE `id`='".$_POST['points_id']."'");
    $worked = mysql_fetch_array($result);
    $price = $worked['price'];
    $amount = $worked['amount'];
  $totalcost = $price * prettynum($_POST['amount']);
  $newpointsinmarket = $amount - prettynum($_POST['amount']);
  $user_points = new User($worked['owner']);

if ($worked['owner'] == $user_class->id) {
echo Message("You have taken ".$_POST['amount']." points off the market.");
$newpoints = $user_class->points + $_POST['amount'];;
$result = mysql_query("UPDATE `grpgusers` SET `points` = '".$newpoints."' WHERE `id`='".$user_class->id."'");
$user_class = new User($_SESSION['id']);
if ($newpointsinmarket == 0){
$result = mysql_query("DELETE FROM `pointsmarket` WHERE `id`='".$worked['id']."'");
} else {
$result = mysql_query("UPDATE `pointsmarket` SET `amount` = '".$newpointsinmarket."' WHERE `id`='".$worked['id']."'");
}
include 'footer.php';
die();
}
  $_POST['amount'] =  abs(intval($_POST['amount']));
$_POST['points_id'] = abs(intval($_POST['points_id']));{

}
$_POST['amount'] =  abs(intval($_POST['amount']));
$_POST['points_id'] = abs(intval($_POST['points_id']));{

}
if ($totalcost > prettynum($user_class->money)){
echo Message("You don't have enough money.");
}
if($_POST['amount'] >= 1 && $_POST['amount'] <= $amount && $totalcost <= $user_class->money){
echo Message("You have bought ".$_POST['amount']." points for $".$totalcost);
$newpoints = $user_class->points + $_POST['amount'];
$newmoney = $user_class->money - $totalcost;
$result = mysql_query("UPDATE `grpgusers` SET `money` = '".$newmoney."', `points` = '".$newpoints."' WHERE `id`='".$user_class->id."'");
$newmoney = $user_points->money + $totalcost;
$result = mysql_query("UPDATE `grpgusers` SET `money` = '".$newmoney."' WHERE `id`='".$user_points->id."'");
$user_class = new User($_SESSION['id']);
if ($newpointsinmarket == 0){
$result = mysql_query("DELETE FROM `pointsmarket` WHERE `id`='".$worked['id']."'");
} else {
$result = mysql_query("UPDATE `pointsmarket` SET `amount` = '".$newpointsinmarket."' WHERE `id`='".$worked['id']."'");
}
}
}

$_POST['addpoints'] =  abs(intval($_POST['addpoints']));
$_POST['id'] = abs(intval($_POST['id']));{

}
if($_POST['amount'] < 1){

}
if($_POST['price'] < 1){

}
if ($_POST['amount'] >= 1 && prettynum($_POST['amount']) <= $user_class->points && $_POST['price'] >= 1){
echo Message("You have added ".$_POST['amount']." points to the market a price of $".$_POST['price']." per point.");
$result= mysql_query("INSERT INTO `pointsmarket` (owner, amount, price)"."VALUES ('$user_class->id', '$_POST[amount]', '$_POST[price]')");
$newpoints = $user_class->points - $_POST['amount'];
$result = mysql_query("UPDATE `grpgusers` SET `points` = '".$newpoints."' WHERE `id`='".$user_class->id."'");
$user_class = new User($_SESSION['id']);
}

?>
<link href="style.css" rel="stylesheet" type="text/css" />

<tr><td class="contenthead">Point Market</td></tr>
<tr><td align="center" class="contentcontent">
<p>&nbsp;</p>
<p><strong>You need to be a Respected Warrior to add points to the market</strong><br>
Use this form to add points to the points market.</p>
<p><strong>Bank Account[<? echo prettynum($user_class->bank) ?>]</strong><strong></strong><br />
  <strong><a href="pointmarket.php">[Refresh</a>]</strong></p>
<form method='post'>
  <table align="center">
  <tr>
<td>Amount of points</td><td>&nbsp;&nbsp;<input name='amount' type='text' class="areatest" value='0' size='10' maxlength='20'></td>
</tr>
<tr>
<td>Price per point</td><td>$<input name='price' type='text' class="areatest" value="0" size='10' maxlength='20'></td>
<tr><td align="center" colspan="2"><input name='addpoints' type='submit' class="buttong" value='Add Points'></form></td>
</tr></table>
</td></tr>
<tr><td class="contentcontent">
<?php
$result = mysql_query("SELECT * FROM `pointsmarket` ORDER BY `price` DESC");
while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$user_points = new User($line['owner']);
if ($user_points->id == $user_class->id){
$submittext = "Remove";
} else {
$submittext = "Buy";
}
echo "<form method='post'>";
echo $user_points->formattedname." - ".$line['amount']." points for ".prettynum($line['price'],1)." per point <input type='text' name='amount' size='3' maxlength='20' value='".prettynum($line['amount'])."'><input type='hidden' name='points_id' value='".$line['id']."'><input type='submit' name='buypoints' value='".$submittext."'></form><br>";
}
?>
</td></tr>
<?php
include 'footer.php';
?>



SQL
Code: [Select]
CREATE TABLE IF NOT EXISTS `pointsmarket` (
  `owner` int(10) NOT NULL default '0',
  `amount` text NOT NULL,
  `price` text NOT NULL,
  `id` int(10) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=81 ;

I use a form to sent date and  use php to display it . However , the code only can working on one page. I can not turn the page. I do not why . Please tell me reason . Thank you very much.

<select name="kind">
  <option >kind</option>
 <option value="Copier Toner">Copier Toner</option>
        <option value="Laser Toner">Laser Toner</option>
      <option value="MICR Toner">MICR Toner</option>
      <option value="Inkjet">Inkjet</option>
    
php code

if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };
$start_from = ($page-1) * 18;



$select="select * from $chun where  brand = '$_POST[brand]' or  sort ='$_POST[kind]' or type='$_POST[type]'  LIMIT $start_from, 18";

$result2=mysql_query($select, $connection) or die (mysql_error());

 <?php
   $sql = "select count(*) from $chun  where   brand = '$_POST[brand]' or sort='$_POST[kind]' or type='$_POST[type]' ";

   
$rs_result = mysql_query($sql,$connection);
$row = mysql_fetch_row($rs_result);
$total_records = $row[0];
$total_pages = ceil($total_records / 18);
 
for ($i=1; $i<=$total_pages; $i++) {



?>


      <div class="trunpage"><a href='table2.php?page=<?php echo  "$i" ; ?>&id=<?php echo "$_POST[brand]";?>&cd=<?php echo "$_POST[kind]";?>&td=<?php echo "$_POST[type]";?>'  ><?php echo  "$i" ; ?></a>
      
       </div>
   
The first page is working fine. The second page I get error message.

Undefined index: brand in C:\wamp\www\php1000\table2.php on line 234

Hi guys, running through this tutorial at the moment:

http://www.tizag.com/phpT/forms.php

I seem to keep having problems with the $_POST variable. Is that obsolete syntax now?

Here's the part I get an error on:

<html>
<body>
<?php
$quantity=$_POST['quantity'];
$item=$_POST['item'];

echo "You ordered".$quantity."".$item.".<br/>.";
echo "Thank you for ordering from Boombaby art supppplies!";

?>
</body>
</html>


Here's the error:


( ! ) Notice: Undefined index: quantity in C:\wamp\www\process.php on line 4
Call Stack
#   Time   Memory   Function   Location
1   0.0009   363936   {main}( )   ..\process.php:0

( ! ) Notice: Undefined index: item in C:\wamp\www\process.php on line 5
Call Stack
#   Time   Memory   Function   Location
1   0.0009   363936   {main}( )   ..\process.php:0
You ordered.
.Thank you for ordering from Boombaby art supppplies!



Any help would be appreciated. I tried googling but everything didn't seem to answer my question or was too confusing.

Thanks.

Hello,

My script here is not sending POST vars from form to script. I can't figure it out.

Form:
Code: [Select]
<form action="train2.php" method="POST">
 <tr>
<td colspan="4"><center><img src="pic/toppage16.gif" /></center></td>
       </tr>

<TR> <TD><FONT COLOR="white">Reassign Miners</FONT></TD>

<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD>

<TD align=middle><FONT COLOR="white"><INPUT size="6" maxlength="8" value="0" name="miner>"</FONT></TD>

</TR>

<TR>

<TD><FONT COLOR="white">Reassign Normal Attackers</FONT></TD>

<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD>

<TD align=middle><FONT COLOR="white"><INPUT size="6" maxlength="8" value="0" name="atsold"></FONT></TD>

</TR>

 <TR>
 
<TD><FONT COLOR="white">Reassign Normal Defenders</FONT></TD>


<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD>

<TD align=middle><FONT COLOR="white"><INPUT size=6 maxlength=8 value=0 name="defsold"></FONT></TD>

</TR>

<TR>

 <TD><FONT COLOR="white">Reassign Covert Agents</FONT></TD>

<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD>

<TD align=middle><FONT COLOR="white"><INPUT size=6 maxlength=8 value=0 name="spy"></FONT></TD>

</TR>

<TR> <TD><FONT COLOR="white">Anti Covert Agents</FONT></TD>

<TD align=right><FONT COLOR="white">0 Naquadah</FONT></TD><TD align=middle><FONT COLOR="white"><INPUT size="6" maxlength=8 value=0 name="spykiller"></FONT></TD></TR>

<TR> <TD align=middle colSpan=3><FONT COLOR="white"><INPUT type="submit" value="UnTrain!" name="untrain">
</FONT>

</TD>

</form>

Code: [Select]
<?php
if(isset($_POST['untrain'])){

die($_POST['miner']);
$miners = securevar($_POST['miner']);
$nattackers = securevar($_POST['atsold']);
$ndefenders = securevar($_POST['defsold']);
$covertunits = securevar($_POST['spy']);
$anticovertunits = securevar($_POST['spykiller']);

$totalunits+=$miners;
$totalunits+=$nattackers;
$totalunits+=$ndefenders;
$totalunits+=$covertunits;
$totalunits+=$anticovertunits;

if($totalunits>=1){
$q = "UPDATE `accountinfo_db` SET `miners_1` = `miners_1`-'$miner', `attackers_1` = `attackers_1`-'$natta', `defenders_1` = `defenders_1`-'$ndefe', `covertagents` = `covertagents`-'$cover', `anticovertagents` = `anticovertagents`+'$antic', `untrainedunits` = `untrainedunits`+'$totalunits' WHERE `id` = '$id'"; 
$res = mysql_query($q) or die(mysql_error());

if(isset($res)){
header("Location: train.php?strmsg=".$totalunits."Troops Untrained! For 0 Naquadah.");
}

}else{
header("Location: train.php?strmsg=You must enter atleast 1 troop to be un-trained!");
}

}


?>

when I die($_GET['miner'); nothing is outputed even tho I submited the data.

Thank you,
Brian

hey guys
I know this is html but I'm using the php $_POST to grab the information the user chooses, i can't figure out though how to grab the info i'm looking for in this select option form
if they choose PasswordCracker v3.0 what is it i'm looking to set my $_post['']; to?

<FORM action="buy.php" method="POST">
    <select name="passwordcrakers">
      <option value="v2.0">PasswordCracker V2.0</option>
      <option value="v3.0">PasswordCracker V3.0</option>
      <option value="v4.0">PasswordCracker V4.0</option>
      <option value="v5.0">PasswordCracker V5.0</option>
      <option value="v6.0">PasswordCracker V6.0</option>
      <option value="v7.0">PasswordCracker V7.0</option>
      <option value="v8.0">PasswordCracker V8.0</option>
      <option value="v9.0">PasswordCracker V9.0</option>
      <option value="v10">PasswordCracker V10</option>
        </select><br />
<input type="submit" value="Buy" name="submit" />
</FORM>

Running into some problems with my code.  I am having the user search the Database with either a UAID or the user's full name.  It works fine when you input both the UAID and name; however, I want it to work if only one is give (i.e. just the name or just the UAID).

I decided to use the isset($_POST) function of php but I am not getting it to work correctly.  PHP believe it is set even though it is empty.

Here is my html form.

<?php
@include 'accesscontrol.php';

echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"
      \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">"
     ."<html xmlns=\"http://www.w3.org/1999/xhtml\">"
     ."<title> Hello </title>"
     ."<meta http-equiv=\"Content-Type\"
      content=\"text/html; charset=iso-8859-1\" />"
     ."<head>"
     ."<style type=\"text/css\">"
     ."h1{"
     ."border-bottom-style: double;"
     ."border-bottom-color: black;"
     ."border-bottom-width: 5px;"
     ."}"
     ."p{"
     ."background-color:#4682B4;"
     ."}"
     ."</style>"
     ."</head>"
     ."<body style=\"background-color:#B8B8B8\">"
     ."<table align=\"center\" style=\"background-color:#B8B8B8\" WIDTH=\"100%\" HEIGHT=\"100%\">"
     ."<tr valign=\"middle\">"
     ."<td align=\"center\">"
     ."<form method=\"post\" action=\"user.php\">"
     ."<table align=\"center\" cellpadding=\"10\" style=\"background-color:#5CADFF\" width=\"500\" height=\"400\">"
     ."<tr>"
     ."<th colspan=6 align=\"center\"><h1>Welcome: ".$uid."</h1></th>"
     ."</tr>"
     ."<tr>"
     ."<td colspan=3 width=40% align=center>"
     ."UAID:<br>  <input type=\"text\" size=\"8\" name=\"UAID\" /></td>"
     ."<td colspan=3 width=60% align=center>"
     ."Name (Last, First):<br><input type=\"text\" size=\"8\" name=\"last\"/>, <input type=\"text\" size=\"8\" name=\"first\" />"
     ."</tr>"
     ."<tr>"
     ."<td colspan=6 align=\"center\"><input type=\"submit\" value=\"submit\" />"
     ."</td>"
     ."</tr>"
     ."</tr>"
     ."</table>"
     ."<tr>"
     ."</tr>"
     ."</td>"
     ."</tr>"
     ."</table>"
     ."</body>"
     ."</html>";

?>



Here is the PHP:

<?php
@include 'accesscontrol.php';
//include 'common.php';
include 'db.php';

$fname = $_POST['first'];
$lname = $_POST['last'];

 
 $sql = "SELECT * FROM `user` WHERE UAID='$_POST[UAID]'";
 $result = mysql_query($sql);
 $rows = mysql_fetch_array($result);


if(isset($fname) && isset($lname))
{

echo "Post first $fname <br>"
     ."Post last $lname";
$firstname = $rows['firstname'];
$lastname = $rows['lastname'];

if($fname != $firstname OR  $lname != $lastname)
{
?>
<html>
<head>
<script language="JavaScript">
    alert(" Hello this is crap" ); 
    history.back(); 
 </script>";
</head>
</html>
<?
exit; 

}

else
{ 
 echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"
      \"URL\">"
     ."<html xmlns=URL>"
     ."<title> Hi </title>"
     ."<meta http-equiv=\"Content-Type\"
      content=\"text/html; charset=iso-8859-1\" />"
     ."<head>"
     ."<style type=\"text/css\">"
     ."h1{"
     ."border-bottom-style: double;"
     ."border-bottom-color: black;"
     ."border-bottom-width: 5px;"
     ."}"
     ."p{"
     ."background-color:#4682B4;"
     ."}"
     ."</style>"
     ."</head>"
     ."<body style=\"background-color:#B8B8B8\">"
     ."<table align=\"center\" style=\"background-color:#B8B8B8\" WIDTH=\"100%\" HEIGHT=\"100%\">"
     ."<tr valign=\"middle\">"
     ."<td align=\"center\">"
     ."<table align=\"center\" cellpadding=\"10\" style=\"background-color:#5CADFF\" width=\"600\" height=\"400\">"
     ."<tr>"
     ."<th colspan=6 align=\"center\"><h1>Welcome: ".$uid."</h1></th>"
     ."</tr>"
     ."<tr>"
     ."<form method=\"Post\" action=\"userview.php\">"
     ."<td colspan=3 width=40%>"
     ."UAID:  <input type=\"text\" size=\"8\" name=\"UAID\" value= ".$_POST['UAID']." /></td>"
     ."<td colspan=3 width=60%>"
     ."Name (LAST, FIRST):<input type=\"text\" size=\"8\" name=\"last\"  value= ".$_POST['last']." />,
      <input type=\"text\" size=\"8\" name=\"first\" value= ".$_POST['first']." />"
     ."</td>"
     ."</tr>"
     ."<tr>"
     ."<td colspan=3 width=40%>"
     ."Department:<input type=\"text\" size=\"8\" name=\"department\" value=" .$rows['BOG'].">"
     ."</td>"
     ."<td colspan=3 width=60%>"
     ."Employee ID:<input type=\"text\" size=\"8\" name=\"empID\" value=" .$rows['employeeID'].">"
     ."</td>"
     ."</tr>"
     ."<tr>"
     ."<td colspan=3 align=\"center\"><input type=\"submit\" value=\"View\">"
     ."</form>"
     ."</td>"
     ."<form method=\"Post\" action=\"homepage.php\">"
     ."<td colspan=3 align=\"center\"><input type=\"submit\" value=\"Back\">"
     ."</td>"
     ."</tr>"
     ."</tr>"
     ."</table>"
     ."<tr></tr></td></tr></table></body></html>";

}}
 mysql_free_result($result);
?>

I want to link this two file but not working,  first file to make drop down option form