foreach or while help?

[jalrock]

/////////////////GET DATA FROM DEALS///////////////// 
} elseif ($lastname) {
    $sql = "SELECT * FROM deals WHERE lastname LIKE '".$lastname."'"; 
    $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/////////////////

here is where I am lost. I want to do something like this if there are several matches.

while ($lastename LIKE lastname) {
echo "<tr><td>$firstname</td><td>$lastname</td></tr>"; 
}

As always your help is appreciated.

[SuperCam]

well, you will ahve to change your variables around a bit. I suggest making your "$lastname" in your row fetch "$lastname_b"... like this:

    $residual = $myrow["residual"];  

    $firstname = $myrow["firstname"];  

    $lastname_b = $myrow["lastname"];  

    $beacon = $myrow["beacon"];  

Then you can do this...

while ($lastname_b == $lastname) { 
echo "<tr><td>$firstname</td><td>$lastname_b</td></tr>";  

}

[laserlight]

I suggest actually describing what you want to do, since it is not clear what you want.

[jalrock]

I want to echo out a table row for each record in the database that is LIKE the $lastname that is passed to this script.

I will try the first suggestion but changing the $lastname will effect the rest of the program.

[ahundiak]

while($myrow = mysql_fetch_array($result)) {
$id = $myrow["id"];
blah blah blah
echo "<tr><td>$firstname</td><td>$lastname</td></tr>";
}

[SuperCam]

Yes, Sorry about that but I was trying not to change your script all that much so I forgot the while. Here is what you need.

$sql = "SELECT * FROM deals WHERE lastname LIKE '".$lastname."'";
$result = mysql_query($sql);  

while($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_b = $myrow["lastname"];  

    $beacon = $myrow["beacon"];  

echo "<tr><td>$firstname</td><td>$lastname_b</td></tr>";   

}

You don't have to change the $lastname that is used in the if statement, just the one that sets as $myrow["lastname"], understand?

[jalrock]

That worked perfect. THANK YOU!

However I think I may be using LIKE incorrectly because it only returns an exact match for the variable $lastname.

Any suggestions there

[ahundiak]

Lookup up LIKE in the manual and see how it works. Hint: it's not going to automatically find all last names that are close to the one you submit. You will probably need to do some more work.