DaniWeb Forum Index > Web Development > PHP

Problem in displaying data from DB

Please support our PHP advertiser: 50% off 6 Months Dedicated Server Hosting from 1&1!

•

Join Date: May 2008

Posts: 90

Reputation: Suhacini is an unknown quantity at this point

Solved Threads: 0

Suhacini

Offline

Junior Poster in Training

Problem in displaying data from DB

Jun 4th, 2008

Hi,
I wanted to display data which is in my db.The format of displaying must be in a div, in that div 3 columns & each column must have 10 rows.Am using this:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
while($data = mysql_fetch_array($result)) { 
    echo $query;
    echo ' <tr> <td colspan="3" > <a href="'.$data['MedName'].'" >' . $data['dispname'].' </a> </td>'; 
    echo'</tr>'; 
}
while($data = mysql_fetch_array($result)) { 
    echo $query;
    echo ' <tr> <td colspan="3" > <a href="'.$data['MedName'].'" >' . $data['dispname'].' </a> </td>'; 
    echo'</tr>'; 
}

which is displaying it in a single line. I used even for loop which is displaying again in the single line.What way can be used to print in the above format?

Suhasini

•

Join Date: Jun 2007

Posts: 1,237

Reputation: kkeith29 has a spectacular aura about

Solved Threads: 171

kkeith29

Offline

Nearly a Posting Virtuoso

Re: Problem in displaying data from DB

Jun 4th, 2008

here is something i typed up a few weeks ago. it should work.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
 
$table = '<table id="module" class="module" border="0" cellspacing="0" cellpadding="5">';
 
$cols = 3;
$per_column = 10;
$col = 1;
$table .= '<tr>';
$table .= '<td>';
$table .= '<table id="module" class="module" border="0" cellspacing="0" cellpadding="5">';
$i = 0;
while ($row = $p->fetchAssoc($query)) {
	$table .= '<tr>';
	$table .= '<td><a href="' . $row['MedName'] . '">' . $row['dispname'] . '</a></td>';
	$table .= '</tr>';
	if ($i == ($per_column*$col)) {
		$table .= '</table>';
		$table .= '</td>';
		$table .= '<td>';
		$table .= '<table id="module" class="module" border="0" cellspacing="0" cellpadding="5">';
	$col++;
	}
$i++;
}
$table .= '</table>';
$table .= '</td>';
$table .= '</tr>';
$table .= '</table>';
 
echo $table;
$table = '<table id="module" class="module" border="0" cellspacing="0" cellpadding="5">';

$cols = 3;
$per_column = 10;
$col = 1;
$table .= '<tr>';
$table .= '<td>';
$table .= '<table id="module" class="module" border="0" cellspacing="0" cellpadding="5">';
$i = 0;
while ($row = $p->fetchAssoc($query)) {
	$table .= '<tr>';
	$table .= '<td><a href="' . $row['MedName'] . '">' . $row['dispname'] . '</a></td>';
	$table .= '</tr>';
	if ($i == ($per_column*$col)) {
		$table .= '</table>';
		$table .= '</td>';
		$table .= '<td>';
		$table .= '<table id="module" class="module" border="0" cellspacing="0" cellpadding="5">';
	$col++;
	}
$i++;
}
$table .= '</table>';
$table .= '</td>';
$table .= '</tr>';
$table .= '</table>';

echo $table;

Last edited by kkeith29; Jun 4th, 2008 at 3:30 am.

•

Join Date: May 2008

Posts: 90

Reputation: Suhacini is an unknown quantity at this point

Solved Threads: 0

Suhacini

Offline

Junior Poster in Training

Re: Problem in displaying data from DB

Jun 4th, 2008

what is $p here

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
while ($row = $p->fetchAssoc($query))
while ($row = $p->fetchAssoc($query))

Suhasini

•

Join Date: Jun 2007

Posts: 1,237

Reputation: kkeith29 has a spectacular aura about

Solved Threads: 171

kkeith29

Offline

Nearly a Posting Virtuoso

Re: Problem in displaying data from DB

Jun 4th, 2008

my bad, use to my class is use. change that to mysql_fetch_assoc($query)

•

Join Date: May 2008

Posts: 90

Reputation: Suhacini is an unknown quantity at this point

Solved Threads: 0

Suhacini

Offline

Junior Poster in Training

Re: Problem in displaying data from DB

Jun 4th, 2008

Its Working.But have small problem, I have 4 buttons Home Categories Brand Store in a row.When I click each button the text display.Here if catogery is clicked that is in the same row but remaining 3 buttons are moving down.when it is clicked again..they are going back to normal position.Why is it like that?

Suhasini