savagenoob Posted December 15, 2010 Share Posted December 15, 2010 I am trying to append data to a variable through each loop of a MySQL array, but I am doing it wrong. Is this possible? Here is the code. $html = <<<TABLE <table border = "1" align = "center"> TABLE; //// Get Endorsement Info $endo = mysql_query("SELECT * FROM endorse WHERE endonum = '$endonum' AND agency = '$agency' ORDER BY ID DESC LIMIT 1"); while($endofetch = mysql_fetch_array($endo)){ $endotype = $endofetch['type']; $typeid = $endofetch['typeid']; $change = $endofetch['changetype']; $info = mysql_query("SELECT * FROM $endotype WHERE ID = '$typeid'") or die(mysql_error()); $infoout = mysql_fetch_array($info); $date = date("m/d/Y g:i a", strtotime($endofetch['date'])); if($endotype == "drivers"){ $firstname = $infoout['firstname']; $lastname = $infoout['lastname']; $licnum = $infoout['driverslic']; $vyear = $infoout['year']; $vmake = $infoout['make']; $vmodel = $infoout['model']; $vvin = $infoout['year']; $html .= <<<TABLE <tr> <td>Endorsement Request Date:</td><td>{$date}</td> </tr> <tr> <td>Change Requested:</td><td>{$change} Driver</td> </tr> <tr> <td>Driver Info:</td><td>{$firstname} {$lastname} </td> </tr> <tr> <td>License Number:</td><td>{$licnum}</td> </tr> <tr> <td>Signature __________________</td><td>Date:_____________</td> </tr> TABLE; } if($endotype == "vehicles"){ if($change == "Delete"){ $veyear = $endofetch['year']; $vemake = $endofetch['make']; $vemodel = $endofetch['model']; $vevin = $endofetch['vin']; $html .= <<<TABLE <tr> <td>Endorsement Request Date:</td><td>{$date}</td> </tr> <tr> <td>Change Requested:</td><td>Delete Vehicle</td> </tr> <tr> <td>Vehicle Info:</td> </tr> <tr> <td>Year:</td><td>{$veyear}</td><td>Make:</td><td>{$vemake}</td><td>Model:</td><td>{$vemodel}</td> </tr> <tr> <td>Vin Number:</td><td>{$vevin}</td> </tr> <tr> <td>Signature __________________</td><td>Date:_____________</td> </tr> TABLE; } else { $html .= <<<TABLE <tr> <td>Endorsement Request Date:</td><td>{$date}</td> </tr> <tr> <td>Change Requested:</td><td>{$change} Vehicle</td> </tr> <tr> <td>Vehicle Info:</td> </tr> <tr> <td>Year:</td><td>{$vyear}</td><td>Make:</td><td>{$vmake}</td><td>Model:</td><td>{$vmodel}</td> </tr> <tr> <td>Vin Number:</td><td>{$vvin}</td> </tr> <tr> <td>Signature __________________</td><td>Date:_____________</td> </tr> TABLE; } } } $html .= <<<TABLE </table> TABLE; echo $html; This code is for creating a PDF with fpdf and a third party table class. Its only displaying the last table data in the loop when I echo $html so the data is being overwritten each loop. Quote Link to comment https://forums.phpfreaks.com/topic/221792-appending-to-variable/ Share on other sites More sharing options...
PFMaBiSmAd Posted December 15, 2010 Share Posted December 15, 2010 ORDER BY ID DESC LIMIT 1 You are only selecting one row ^^^ Quote Link to comment https://forums.phpfreaks.com/topic/221792-appending-to-variable/#findComment-1147813 Share on other sites More sharing options...
savagenoob Posted December 15, 2010 Author Share Posted December 15, 2010 Oh F***. Thats what I get for late night coding and beer. Quote Link to comment https://forums.phpfreaks.com/topic/221792-appending-to-variable/#findComment-1147815 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.