Ad:

PHP Discussion Thread
Unsolved
Views: 604

Jun 4th, 2008

Problem in displaying data from DB

Expand Post »

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:

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?

Similar Threads

Data from mysql in a 3 columns table in PHP
Winsock C++ help: receiving data in C++
Help me about JSP problem... in JSP
Hash Table display problem in C++
Cartesian Product Problem in Oracle

Suhacini

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

90 posts
since May 2008

Permalink

Jun 4th, 2008

Re: Problem in displaying data from DB

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

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 4:30 am.

kkeith29

Reputation Points: 235

Solved Threads: 193

Nearly a Posting Virtuoso

Offline

1,315 posts
since Jun 2007

Permalink

Jun 4th, 2008

Re: Problem in displaying data from DB

what is $p here

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

Suhacini

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

90 posts
since May 2008

Permalink

Jun 4th, 2008

Re: Problem in displaying data from DB

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

kkeith29

Reputation Points: 235

Solved Threads: 193

Nearly a Posting Virtuoso

Offline

1,315 posts
since Jun 2007

Permalink

Jun 4th, 2008

Re: Problem in displaying data from DB

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?

Suhacini

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

90 posts
since May 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Sending data to a form using hyperlink

Next Thread in PHP Forum Timeline: Display forms results

DaniWeb Message

Cancel Changes

User Name
Password