DonaldFaulknor

it's cool, I mean, if the different css' are working (for whatever reason), I can just keep them this way. It's just irritating not to know why they require to be different. Like I said, I think it's an inheritance problem. One page is inheriting different properties than another page.

I meant to say they're NOT viewed in different browsers.

Thanks for verifying my confusion. Yes, I DO have a padding and margin reset and NO, they are being viewed in the same browser. It's not a padding/margin variation between browsers or whatever, the difference from one code to the other is EXACTLY what the padding is set at. Therefore, I have concluded that for one code, padding adds to the overall width and for the other code, it doesn't. I have to wonder if it's do to an inheritance, sometimes inheritant properties can be hard to find.

oh, I should mention, the codes (that are currently different - look at the width and the height) are doing the same thing (like I want). But why do they have to be different to do the same thing?

/* Profile */ .updateStatus { background: url("http://inyoursocialnetwork.netne.net/members/Whiteboard.jpg") no-repeat center top #008d35; border: 0 none; color:#008d35; cursor:text; font-family:Kaushan Script; font-size:110%; width: 230px; padding-left:16px; padding-top:12px; height: 157px; } /* Homepage */ .updateStatus1 { background: url("http://inyoursocialnetwork.netne.net/members/Whiteboard.jpg") no-repeat center top #008d35; border: 0 none; color:#008d35; cursor:text; font-family:Kaushan Script; font-size:110%; width: 246px; padding-left:16px; padding-top:12px; height: 169px; } <!-- Profile --> <div style=\"float:right; padding:24px; margin-top:96px\"> <form action=\"update-status.php?id=$_SESSION[user_id]\" method=\"POST\"> <input type=\"hidden\" name=\"users_id\" value=\"$_SESSION[user_id]\" /> <textarea class=\"updateStatus\" name=\"statuses\"></textarea><br /> <center><span title=\"Update Your Status\"><input class=\"dryErasePen\" type=\"submit\" value=\"\" /></span></center> </form> </div> <div style=\"float:right; padding:24px; margin-top:96px\"> <form action=\"update-status.php?id=$_SESSION[user_id]\" method=\"POST\"> <input type=\"hidden\" name=\"users_id\" value=\"$_SESSION[user_id]\" /> <textarea class=\"updateStatus1\" name=\"statuses\"></textarea><br /> <center><span title=\"Update Your Status\"><input class=\"dryErasePen\" type=\"submit\" value=\"\" /></span></center> </form> </div> I had both html codes set to the same css, and it worked fine for a week. And without changing anything, all of a sudden, the Box model applied to one page but not the other page. The first css, padding adds to the overall width, the second css, it doesn't. Why did it change by itself. I never even touched the code.

yes, in JOINs, I understand the ON clause to be the main part of the query, some call it the "glue" that connects the two tables.

I know they're not /that/ difficult, I just need to learn them. I was simply saying, someone, probably has the ability to make them /even/ easier. The main thing I'm not fully understanding about relationships is the ON clause.

Well, when people in these forums "explain" things to me, they tend to complicate them MUCH more then they need to be. When given an answer, I can usually find out why it works that way. I learn better by knowing the answer and disecting it (teaching myself). But I appreciate everyone that tries to help me out. I'm just a lil frustrated since I've filled out 600 job apps in 6 months and no call, so, my only hope is self employment, since its not landscape season, I'm trying to get an internet thing going. I've been developing in html/css for 3 years, programming php for 1.5 years, and database relationships for a little over a week. So, I'm definitely lacking skills working with relationships. If only they had a way to work with relationships like Microsoft Access, then it would be easy lol

is it users table or friends table? The friends are listed in a friends table, wasn't aware I should use the users table at all. select s.statuses, s.whens, u.id, u.name from Statuses s join Users u on (s.users_id = u.id) join Friends f on (u.id = f.friend.id) where f.users_id = 123 order by s.whens; There's some things I don't understand about this. s and u, is that suppose to be the name of the table? Statuses.statuses and Users.id also... FROM? Statuses s - is the lowercase s the name of the column statuses inside the table Statuses? Are the (parenthesis) part of the statement or just a note?

I believe I tried it, let me go check that, I'll get back with you.

ok, I'm close... $query4 = "SELECT Statuses.users_id, Statuses.statuses, Statuses.whens, Friends.friend_name FROM Friends JOIN Statuses on Statuses.users_id = Friends.friend_id WHERE Friends.users_id=$friend && Statuses.users_id=$uid OR Friends.users_id=$uid AND Statuses.users_id=$friend ORDER BY whens DESC"; This displays my statuses on my homepage once - an improvement from the duplicate entries. Now, if I replace the variables $friends I have above there, with a user id I know exists and has statuses (such as my mother's account), then all her statuses will show on my homepage as well. What kind of replacement would I make to get all my friends into that variable or where those variables exist?

OHHHH... it's pulling up every situation where I'm a friend of someone. I deleted the connection between me and my mother, only leaving the one connection of me and my friend, and it deleted the duplicate entries. That's the problem, I think to fix that, I need to include my session id in place of users_id, it doesn't make sense not to have my specific session id (me logged in) into the query.

ok, so it wasn't working the way I thought it was... <?php $query4 = "SELECT Statuses.users_id, Statuses.statuses, Statuses.whens, Friends.friend_name FROM Friends JOIN Statuses on Statuses.users_id = Friends.friend_id WHERE friend_id=Friends.friend_id ORDER BY whens DESC"; $result4 = mysql_query($query4); while($row4 = mysql_fetch_assoc($result4)) { echo '<p style="padding:12px 12px 12px 6px; font-family:bookman old style; margin-left:198px"><strong><span style="color:#cc0000;">Posted By </span>'; echo $row4['friend_name']; echo '</strong><br />'; echo $row4['statuses']; echo '<br />'; echo $row4['whens']; echo '</p>'; } ?> I don't believe I have any problems within my while loop. The problem exists in the query. on the page this appears on (homepage when logged in) it is 'meant' to show status messages of all your friends and your own status messages. The friends statuses is working just right... but, your own status messages is repeated twice. Before the question comes up... no I am not on my own friends list, I double checked that and also made that not possible. Thanks for the help.

I'm pretty sure I can probably handle the php myself, I just need to know how is the best way to set up a database for a message other users option. I was thinking Messages Table... ID - Auto Inc, Primary To From Message Datetime/Timestamp And should there be any relationships? I currently have... users table - Register/Login system working Friends table - Friend feature working comments table - to comment on statuses - feature not set up yet statuses table - Statuses working, to include friend's statuses posting on your homepage Images table - Images upload and posting to your image page working Likes table - to like statuses - feature not set up yet The main thing I need to know is how is the best way to set up the messages table and any relationships needed. If someone wanted to write the create table query for me, I won't complain, honestly, I won't. Create table queries are easy for me, but I'm still kind of new to writing queries for relationships, I tend to have to debug errors 5 or 6 tries before I get it right - usually, stupid common syntax errors. And if a constraint is needed, please let me know how to work with that, everytime I try to add constraints, I just get errors I often can't figure out. Like I said, I know about writing queries, but relationships is new to me, have about 5 days experience with relationships. Thanks for the help

well, whatever I call it, I want a dot com to be available. Unfortunately whiteboard.com is taken, so is many other similar options. The only similar halfway descent ones available are whiteboardme (meaning, write on my whiteboard) and whiteboardsocial. Other than that, I have nothing. And when I say nothing, I mean, I've tried probably 30 to 50 possibilities, all of which dot coms are taken. Did I seriously not check the telephone format? That's funny, I'll fix that. And I'll be changing telephone to an optional field. And as for requiring a particular number of characters for username, I really don't know any website that doesn't have a similar restriction. I registered on a website not too long ago that BOTH my password AND username required at least 2 alpha, at least 2 numeric, AND at least 1 special character. My username was set to DonaldF1982@ - believe it or not, Donald1982@ was already taken. But I am definitely open to your suggestions. What do you think the minimum username should be set to? For aesthetic reasons, I want to avoid usernames such as "A" or "CDA1" - too short, probably doesn't mean anything, probably used by spammers, possibly used by stalkers. Although, limiting the username doesn't stop those people, at least it could help to filter them out. I'm hoping to work on a smart system that automatically detects weird, short, or unusual usernames and send those people emails to verify their account via text message/phone call - a feature I hope to be available in the future. Another thing, I need to figure out how to limit each person to one personal account and one business account - yes, a limitation, against my slogan. But this isn't a limitation posed on using the site under your account, it's just, in terms, a limitation of registering. No need really to have more than one personal and one business account. Whereas Facebook, I have quite a few, back when I use to play games, the more accounts, the better gameplay, but I don't have the games options that would benefit from multiple accounts. I'm thinking of checking for matches in first name, last name, birth year, and ip address. Unless you're a twin with the same name living in the same house, you would have to lie in order to create another account. One thing that's impossible to check for is honesty.