vinpkl:
hi pmw57
the invoice that contains mobile shows an extra blank column
but the invoice that doesnt contains mobile doesnt show extra column.
in both case the button is missing.
I suggest that an else condition be used, so that the table ends up with the same number of columns regardless of mobile phone or not.
if($row['has_mobile'] != false) {
echo '<td><img src="images/special_coupon.gif"></td>';
} else {
echo '<td></td>';
}
What do you want to be in the table cell when it’s a mobile phone? An image called special_coupon.gif ?
Atli
April 11, 2010, 8:21am
22
Could you show us the markup that the code generates? If there is a difference in how mobiles are being displayed, that would suggest the problem is not with the SQL but with the output.
vinpkl
April 11, 2010, 8:33am
23
markup
<table width="500" border="0" cellspacing="0" cellpadding="4" class="acount">
<tr style="background-color:#CCCCCC; height:25px">
<td>Order ID </td>
<td>Order Date </td>
<td>Order total</td>
<td>Coupon</td>
</tr>
<tr><td valign=top>410</td><td valign=top>11-04-2010</td><td valign=top>NZ$ 582.00</td><td></td></tr>
<tr><td valign=top>409</td><td valign=top>11-04-2010</td><td valign=top>NZ$ 856.00</td><td></td></tr>
<tr><td valign=top>408</td><td valign=top>08-07-2009</td><td valign=top>NZ$ 1964.00</td><td></td></tr>
<tr><td valign=top>407</td><td valign=top>08-07-2009</td><td valign=top>NZ$ 1414.00</td><td></td></tr>
<tr><td valign=top>406</td><td valign=top>08-07-2009</td><td valign=top>NZ$ 856.00</td><td></td></tr>
</table>
vineet