Jump to content

php code needed in displaying the datas frm db in a new line


bindiya

Recommended Posts

I hav a php page which takes data from the db.But the problem i am facing is for a particular fild in database ,i have long data,which i need to b displayed in a wordwrap way

 

eg my data is " Description      need a site for school    gave order on 12-10-2010    work started on 12-10-2010  "

this shuld  be displayed as

"Description      need a site for school

                        gave order on 12-10-2010

                        work started on 12-10-2010"

 

Description is the field in the database and rest of them are the datas in it

 

$sql = "select * from product where reference_no = '".$reference_no."'";

    $sqlquery = mysql_query($sql);

    $sql_project_fetch_array =mysql_fetch_array($sqlquery);

echo "<table><tr>

  <td class="tableCellOne"> </td>

<td class="tableCellOne">Description</td>

<td class="tableCellOne">

<?php echo str_replace("<p>"," ",$sql_project_fetch_array['description']); ?></td>

</tr>

You need to print more table rows.

 

echo "<table><tr>
  <td class="tableCellOne"> </td></tr>
<tr><td class="tableCellOne">Description</td></tr>
<tr><td class="tableCellOne">
<?php echo str_replace("<p>"," ",$sql_project_fetch_array['description']); ?></td>
</tr>

 

Denno

Well you are printing one row(<tr> </tr>), and then 3 cells (<td> </td>). This means they're all aligned horizontally on the same line.

You want to print your data in a new cell, that's on a new row. I added <tr> </tr> tags to fix this.

 

You will get the format of

"Description      need a site for school

                        gave order on 12-10-2010

                        work started on 12-10-2010"

Using this code.

 

Denno

understood ur code.but some doubt ,suppose there are more lines of description for some id(another field,a primary key).Then how will i use this code?

eg

 

id                          description (no of rows)

1                        4 rows are there

2                        1  row only

3                        8 rows

 

echo "<table>
<tr><td>id</td> <td class="tableCellOne">Description</td></tr>
<tr><td>1</td> <td class="tableCellOne">4 rows are there</td></tr>
<tr><td>2</td> <td class="tableCellOne">1 row only</td></tr>
<tr><td>3</td> <td class="tableCellOne">8 rows</td></tr>
</table>"

 

You'll notice that now there is two sets of <td> </td> between each <tr> </tr> tag. This means 2 cells on one row.

 

I just did a google search for online HTML table generator. Look at this link and it will generate the code you need for a X column by Y rows.

http://www.quackit.com/html/html_table_generator.cfm

 

Denno

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.