Need a way to do this please

[jalrock]

<?php
require "./connect.php";
include "./header.inc";

/////////////////GET DATA FROM DEALS/////////////////
if ($id) {
    $sql = "SELECT * FROM deals WHERE id=$id";
    $result = mysql_query($sql);
    $myrow = mysql_fetch_array($result);
    $id = $myrow["id"];
    $saleprice = $myrow["saleprice"];
    $rebate = $myrow["rebate"];
    $tradevalue = $myrow["tradevalue"];
    $tradepayoff = $myrow["tradepayoff"];
    $cashdown = $myrow["cashdown"];
    $msrp = $myrow["msrp"];
    $residual = $myrow["residual"];
    $firstname = $myrow["firstname"];
    $lastname = $myrow["lastname"];
    $beacon = $myrow["beacon"];
/////////////////GET DATA FROM DEALS/////////////////

/////////////////GET DATA FROM TT&L/////////////////
    $sql = "SELECT * FROM ttl";
    $result = mysql_query($sql);
    $myrow = mysql_fetch_array($result);
    $tax= $myrow["tax"];
    $vit = $myrow["vit"];
    $doc = $myrow["doc"];
    $registration = $myrow["registration"];
    $title = $myrow["title"];
/////////////////GET DATA FROM TT&L/////////////////

///-------PRE-SET----------///
$tradediff = $saleprice-$rebate-$tradevalue;
$taxamount = $tradediff*$tax;
$cashprice = $saleprice-$rebate;
$vitamount = $cashprice*$vit;
$amountfinanced = $cashprice+$taxamount+$vitamount+$doc+$title+$registration;
$sixtymonthpmt = $tradediff*.0240;
$fortyeightmonthpmt = $tradediff*.0260;
$thirtysixmonthpmt = $tradediff*.0311;
///-------PRE-SET----------///
include "./maintemplate.inc";
} else if $lastname {
/////////////////GET DATA FROM DEALS/////////////////
    $sql = "SELECT * FROM deals WHERE id=$id";
    $result = mysql_query($sql);
    $myrow = mysql_fetch_array($result);
    $id = $myrow["id"];
    $saleprice = $myrow["saleprice"];
    $rebate = $myrow["rebate"];
    $tradevalue = $myrow["tradevalue"];
    $tradepayoff = $myrow["tradepayoff"];
    $cashdown = $myrow["cashdown"];
    $msrp = $myrow["msrp"];
    $residual = $myrow["residual"];
    $firstname = $myrow["firstname"];
    $lastname = $myrow["lastname"];
    $beacon = $myrow["beacon"];
/////////////////GET DATA FROM DEALS/////////////////
include "./maintemplate.inc";
} else {
echo "ID = $id";
echo "<form method=\"post\" action=\"recall.php\">";
echo "<center><table border=1 bgcolor=\"ffffff\"><tr><td>Recall Deal #:</td><td><input type=\"Text\" name=\"id\" value=\"$id\"></td></tr>";
echo "<center><tr><td>Recall Last Name:</td><td><input type=\"Text\" name=\"lastname\" value=\"$lastname\"></td></tr>";
echo "<tr><td colspan=2><center><input type=\"Submit\" name=\"submit\" value=\"Recall Deal #\"></center></td></tr></table></center>";
}

?>

<?php

include "./footer.inc";
?>

The Idea is to display the form if no variable is passed otherwise select data for deal that matches $id or $lastname.

Any help appreciated.

[razz]

First of all you are testing for $ID.

if ($id) {
$sql = "SELECT * FROM deals WHERE id=$id";

The you do an else, meaning if NO $id:

} else if $lastname {
/////////////////GET DATA FROM DEALS/////////////////
$sql = "SELECT * FROM deals WHERE id=$id";

But you are still using $id in that query, not $lastname.

Then you do another else for the form. That means:

If $ID
{ do this }

else if $lastname
{ do this }

else
{do form}

So the form only shows if no $ID && no $lastname.

Do this:

If $ID
{ do this }

else if $lastname
{ do this }

do form here.

razz