Masterprise

Hello, I am a web developer based in the U.S. with experience in PHP, MySQL, JavaScript and more that I have gained over the past decade. I like to keep my code well organized and free of errors so that future coding can be done without hassle. I have knowledge in MVC frameworks such as Zend and have even created my own, which is available for download on my portfolio page below. Additionally, I have experience in customizing WordPress installations and developing plugins. I am working on a SEO plugin, which is also available for download on my site. Skills: PHP MySQL HTML5 CSS3 JavaScript (including jQuery & AJAX) Object-oriented Programming Model-View-Controller frameworks Adobe Photoshop Media Writing Education: Associate of Applied Science in Computer Information Systems Associate of Arts Awards: Outstanding Student in Computer Information Systems Oregon Newspaper Publishers Association – Best Columnist If you have any projects that need worked on, please feel free to send me a message. Since I haven’t done any major projects recently, I am looking to build my portfolio back up by offering my services for only $15/hr. Website: http://alexjivey.com

No, you shouldn't need another table, just another column in the friends table. The table would have something like id, friend_id, and accepted now. The accepted column should have a default value of 'no', 'false', 0, or something like that. When friend 5 accepts the request of friend 1, Have the script update the corresponding record in the friends table and change the accepted column for that record to 'yes', 'true', or 1 (whatever you feel like using. The ENUM type works great for these types of columns). Now, when you want to get all of the friends for friend 1 do something like SELECT name,avatar,etc FROM userstable INNER JOIN friends ON userstable.id = friends.id WHERE friends.id = 12 AND accepted = 'yes';

My suggestion would be to make a friends table rather than a column. In the friends table have two columns: id, and friend_id (or similar). So when friend 1 adds friend 2 (say friend 1 has an id of 12), insert a record into the table with the id value of 12 and friends_id value of 25. When friend 1 adds friend 5, add a record with the id value of 12 and friend_id value of 26, and so forth. When you want to retrieve all of the friends of friend 1, do something like SELECT name,avatar,etc FROM userstable INNER JOIN friends ON userstable.id = friends.id WHERE friends.id = 12;

try just changing the 'bottom:xxxpx;' to 'bottom:0px;' it worked for me (in Firefox, IE looks bad no matter which page). The reason it wasn't displaying is that 325px makes the table go outside of the div#layoutBodyContent element, which makes it disappear. Anyway, another thing I notices is that above the 'table a, table, tbody, tfoot, tr, th, td, table caption' are #tbldisplay table a, table, tbody, tfoot, tr, th, td, table caption {...} #tbldisplayall table a, table, tbody, tfoot, tr, th, td, table caption {...} #tbldisplay3 table a, table, tbody, tfoot, tr, th, td, table caption {...} The ', table,' in all of those parts are causing the table to be changed 4 times. So the bottom (and such) for the table is being set to 375 to 500 to 375 and finally to 325. Also, I would would definitely do what Pikachu2000 said, alignment is not a valid attribute, etc. Fixing this would probably fix the ugly tables I see using IE on the pages.