Easy Question (Looks of table)

techgearfree

I am inserting data from mysql database into a table on my website. However, when it loads (the text it loads is long), it loads it looking like this:

2005
2005
2005
2005
2005
2005
2005
2005
2005
2005
2005-01-23 21:37:16
2005-01-23 21:48:22
2005-01-23 21:50:58
2005-01-23 22:18:07
2005-01-24 18:15:29
2005-01-24 18:18:07
2005-01-24 18:19:18
2005-01-24 18:21:16
2005-01-24 18:21:47
2005-01-24 18:23:08
2005-01-25 17:20:18
2005-01-26 15:56:44
2005-01-26 16:02:37
2005-01-26 20:46:26
2005-01-26 21:13:01
2005-01-26 22:13:36
2005-01-26 22:23:59

Now, the collumn is only as wide as the title, and I want it to display all the times in a line across the page.

This is the code of the template for the page,


<P ALIGN="LEFT">

<B>User {USERNAME} (# {USER_ID})</B>
<BR>
<TABLE WIDTH="100%" cellpadding="4" cellspacing="1" border="1">
	<TR>
		<TD><CENTER>User ID</CENTER></TD>
		<TD><CENTER>Username</CENTER></TD>
		<TD><CENTER>Password</CENTER></TD>
		<TD><CENTER>Sign up IP Address</CENTER></TD>
		<TD><CENTER>Street</CENTER></TD>
		<TD><CENTER>City</CENTER></TD>
		<TD><CENTER>State</CENTER></TD>
		<TD><CENTER>ZIP Code</CENTER></TD>
		<TD><CENTER>Referral</CENTER></TD>
		<TD><CENTER>Completed Offer?</CENTER></TD>
		<TD><CENTER>Sign Up Resolution</CENTER></TD>
		<TD><CENTER>Sign Up Time</CENTER></TD>
		<TD><CENTER>Log In Times          </CENTER></TD>
	</TR>
		{TABLE}
</TABLE>
</P>

and this is how I put the datainto the table:


$table = "<TR>
							<TD><CENTER>" . $user_id . "</CENTER></TD>
							<TD><CENTER>" . $user_username . "</CENTER></TD>
							<TD><CENTER>" . $user_password . "</CENTER></TD>
							<TD><CENTER>" . $user_ip . "</CENTER></TD>
							<TD><CENTER>" . $user_street . "</CENTER></TD>
							<TD><CENTER>" . $user_city . "</CENTER></TD>
							<TD><CENTER>" . $user_state . "</CENTER></TD>
							<TD><CENTER>" . $user_zip . "</CENTER></TD>
							<TD><CENTER>" . $user_referral . "</CENTER></TD>
							<TD><CENTER>" . $user_completed_offer . "</CENTER></TD>
							<TD><CENTER>" . $user_resolution . "</CENTER></TD>
							<TD><CENTER>" . $user_signuptime . "</CENTER></TD>
							<TD><CENTER>" . $user_login . "</CENTER></TD>
						</TR>";
			}

Thanks

rehfeld

is this an html question or php?

im not too usre what you want.

techgearfree

I think that it maybe like a combo. It is entering the variables which I think is php, but the layout of the table, my true question might be html.

I took a screen shot of what it iss currently.

http://www.techgearfree.com/images/current.jpg

Now, you see that the login times are displayed incorrectly:

I would like them to not go downward on the screen, but for the table collumn they are in to expand to the right of the screen and keep it all on one line like:

kasdfj aksjdfklasf askdfjls askdfjlaskf askldfjsl asdklfjklsf ....

not like:

sadjf
asdfasdfsadf
asdfasdf
asdf
sadf
sdff
fsd
f

As I said before, the page has a template, but I do not know if I change this or the way I enter it?!

Hope this helps you help me 😃

Thanks

rehfeld

well, most likely you would want to change the template, because templates are for display, and this is a display issue

if you dont want a td to wrap the text, make it like this

<td nowrap="nowrap">

if you wanted a php way around it, you could replace all spaces with non-breaking spaces


$user_login = str_replace(' ', '&nbsp;', $user_login);