Text Wrapping Db Query

[Lazoris]

Ok Mods got another test for ya.. Since I know you are good at this stuff maybe you can help me out again..

I started getting my pages the way I wanted them to look last weekend, and got pretty far in what im trying to achieve basically, but I have a text issue now.

The text that I am putting into the db and the echo'ed text are running off the page and not staying in the table like I wanted. I tried many different ways of fixing it including using css to try and control it and using the table size to control it..

What should i add to my pages to fix the issue? and most importantly should I do it when I write it to the db (if possible) or should I do it when I print it out on the website.. here is what it is doing on the view page

http://www.elitegamers.us/Database_Test/view.php?id=27

here is the page that I am using to call the text from im sure you remember the pages pretty well since you helped me with the issues on the view page.

http://www.elitegamers.us/Database_Test/admin.php

feel free to add test items to the db and see how it reacts

The Code for the View.php

 
<link rel="stylesheet" href="list.css" type="text/css"><center>
<?php
 
$id = (int) $_GET['id'];
 
// change the username and password
$db = mysql_connect("localhost", "User Name", "password");
 
// change the db name
mysql_select_db("test_db",$db);
$result = mysql_query("SELECT * FROM items WHERE id=$id",$db);
$row = mysql_fetch_array($result);
$wrappedtext = wordwrap;
// make these any rows in the table that you want to show
 
echo " <table border='1'>
 
  <tr>
    <th><h2>".$row["item_name"];
echo "
 <tr>
    <td>
</td></tr>
  <tr>
    <td>Location Found: ".$row["item_loc"];
echo "</td></tr>
  <tr>
    <td>Properties: ".$row["prop"];
echo "</td></tr>
  <tr>
    <td>Description: ".$row["description"];
echo "</td></tr>
  <tr>
    <td><br>
    <br></td></tr>
  <tr>
    <td height='30'><br></td></tr></table>";
 
?>
</center>
 
 

The coding for this and what I had before are pretty similar, just a few mods to the layout and added a few more items to it.

Let me know whats up and thanks again.

Laz

[ak1dnar]

The problem is with your table properties. you have not specified the table width, height and <td> widths. this is HTML issue, not php. ask the question in the HTML/CSS forum.
Format your table with the table properties.

[Lazoris]

I tried that using the css for this page doesnt seem to help unless it has to be actually on the page and not in the css. if thats the case then I'm just a moron.
But, I just tried doing it directly in the page with no results what so ever. The text just has a mind of its own.

I'm thinking the solution is not html based at all. I havent been working with db stuff too much and have not played with this stuff in a few years but I know how to use html very well.

I think the solution is probably something to do with writing the code as it inserts the text into the db inserting breaks as they would appear in the input box used to input the data from the website. Or, forcing it to break the word into pieces small enough to fit into the page.

Have to keep in mind that the words running in the discription is actually one word, that is running off the page not many different words. And when it is many different words it sticks to the table size and doesnt break free.

So this tells me its the one run on word issue that I need to fix not the table properties. The tables are working as they should but the echo of the one word is telling it to ignore the table size since its one big word for some reason.

I'm slow but not completely out of it lol...

Laz

[gregerly]

I tried that using the css for this page doesnt seem to help unless it has to be actually on the page and not in the css. if thats the case then I'm just a moron.
But, I just tried doing it directly in the page with no results what so ever. The text just has a mind of its own.

I'm thinking the solution is not html based at all. I havent been working with db stuff too much and have not played with this stuff in a few years but I know how to use html very well.

I think the solution is probably something to do with writing the code as it inserts the text into the db inserting breaks as they would appear in the input box used to input the data from the website. Or, forcing it to break the word into pieces small enough to fit into the page.

Have to keep in mind that the words running in the discription is actually one word, that is running off the page not many different words. And when it is many different words it sticks to the table size and doesnt break free.

So this tells me its the one run on word issue that I need to fix not the table properties. The tables are working as they should but the echo of the one word is telling it to ignore the table size since its one big word for some reason.

I'm slow but not completely out of it lol...

Laz

I'm fairly certain that a browser will render one line of text with no breaks, just as it is doing. Is that one line really neccessary? You mentioned that when it's regular text it's fine. I would suggest adding real content and see how your design holds up. Or if that line is neccessary, add a space or two for the text to wrap.

Greg

[ak1dnar]

If you are using a "singleword" as your dbcontents, you can try such a thing like this. There might be some other ways to wrap your lengthy "single word".

check this out:

<?php
$text = "String1String2String3String4String5String6String7String8";
$splittedString = implode(' ', str_split($text,14));
?>
<table width="300" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="150"><?php echo $text; ?></td>
    <td width="150"><?php echo $splittedString; ?></td>
  </tr>
</table>
 

[EDIT:
There might be a bug with the forum software. on the first line on the php code "String8" has splitted.
]

[Lazoris]

ok thanks ajax. That will work I think.. and no its not really neccessary, but I'm trying to learn so i create problems just to solve them just in case I ever run into the problem ill have a better idea on how to solve it.

Thanks

laz

[ak1dnar]

Good luck ! Hope to see you again "shortly"! :)

[gregerly]

ok thanks ajax. That will work I think.. and no its not really neccessary, but I'm trying to learn so i create problems just to solve them just in case I ever run into the problem ill have a better idea on how to solve it.

Thanks

laz

That's a great way to do things, and I applaud your desire to learn more. Let us know if we can help you again!

Thanks,

Greg