• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

Putting results into an HTML table

I am retrieving data from my db using two queries:

1. SELECT * FROM DEALERS
2. SELECT * FROM CAMPAIGNS WHERE dealer_id = x ( pulled from 1st query )

What I want to do is put the results in the table below, but am unsure how to do this.

Can anyone show me how to do this in PHP?

Thank you.
<table class="listing" cellpadding="0" cellspacing="0">
    <tr>
      <th class="first" width="177">Dealer Campaigns</th>
 
      <th>Campaign Name</th>
 
      <th>Date Sent</th>
 
      <th># Sent</th>
 
      <th>View</th>
 
      <th class="last">Export</th>
    </tr>
 
    <tr>
      <td class="first style1">- Sperry Ford- ID#12233456</td>
 
      <td>&nbsp;</td>
 
      <td>&nbsp;</td>
 
      <td>&nbsp;</td>
 
      <td>&nbsp;</td>
 
      <td class="last">&nbsp;</td>
    </tr>
 
    <tr class="bg">
      <td class="first style2">- Id: 1234567</td>
 
      <td>Campaign Name Here</td>
 
      <td>5/01/2009</td>
 
      <td>322</td>
 
      <td><a href="#"><img src="img/save-icon.gif" width="16" height="16" alt=
      "save" /></a></td>
 
      <td class="last"><a href="#"><img src="img/add-icon.gif" width="16" height="16"
      alt="add" /></a></td>
    </tr>
 
    <tr class="bg">
      <td class="first style2">- Id: 5687552254</td>
 
      <td>Campaign Name Here</td>
 
      <td>5/01/2009</td>
 
      <td>211</td>
 
      <td><a href="#"><img src="img/save-icon.gif" width="16" height="16" alt=
      "save" /></a></td>
 
      <td class="last"><a href="#"><img src="img/add-icon.gif" width="16" height="16"
      alt="add" /></a></td>
    </tr>
 
    <tr>
      <td class="first style1">- Another Dealer - ID#44556</td>
 
      <td>&nbsp;</td>
 
      <td>&nbsp;</td>
 
      <td>&nbsp;</td>
 
      <td>&nbsp;</td>
 
      <td class="last">&nbsp;</td>
    </tr>
 
    <tr class="bg">
      <td class="first style2">- Id: 9876540</td>
 
      <td>Campaign Name Here</td>
 
      <td>6/01/2008</td>
 
      <td>223</td>
 
      <td><a href="#"><img src="img/save-icon.gif" width="16" height="16" alt=
      "save" /></a></td>
 
      <td class="last"><a href="#"><img src="img/add-icon.gif" width="16" height="16"
      alt="add" /></a></td>
    </tr>
  </table>

Open in new window

table.jpg
0
edvinson
Asked:
edvinson
  • 3
  • 2
1 Solution
 
mosidiotCommented:
ok.. just give you are rough idea..

$query=mysql_query("SELECT * FROM CAMPAIGNS WHERE dealer_id = x",$connectionstring)

echo "<table>";

while($row=mysql_fetch_array($query){

echo "<tr><td>$row[id]</td><td>$row[campaigname]</td></tr>"; // where the id and the campaignname is your sql fields...

}

echo "<table";

You need  to modify to make it right..
0
 
edvinsonAuthor Commented:
I understand, but there are possibly more than one dealer, and X amount of campaigns per dealer.

I am guessing somewhere in the echo-ing needs to be some conditional logic???
0
 
mosidiotCommented:
$query=mysql_query("SELECT * FROM CAMPAIGNS WHERE dealer_id = x",$connectionstring)

echo "<table>";

$dealer="";

while($row=mysql_fetch_array($query){

if($dealer!==$r["dealer"]){

echo "something else for dealer here";

$dealer = $row["dealer"];

}else{

echo "<tr><td>$row[id]</td><td>$row[campaigname]</td></tr>"; // where the id and the campaignname is your sql fields...

}

echo "<table>";

Do you mean this?
0
 
edvinsonAuthor Commented:
well sort of. If you look at the photo, you will see that in the table there are two dealers. Each has campaigns below.

So I would have two loops I think,

dealer loop

    do tr for dealer
      campaign loop
      do tr for campaigns
    end campaign loop

end loop

Do you see what I mean? The dealer row will be different (as in the code example, different class etc).

Hope that helps
0
 
mosidiotCommented:
ya.. that's what my example will do...

just simply change your sql statement to SELECT * FROM CAMPAIGNS WHERE dealer_id = x order by dealerid

in that case will produce the ideal result.. otherwise it will be randomly sorted like the following...

dealer1
info1
info2
dealer2
info1
dealer1
info3
dealer2
info2
dealer3
info1

if you sort them accordingly... it will be:

dealer1
info1
info2
info3
dealer2
info1
info2
dealer3
info1

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now