Re: Is there anything special I should pay attention to when doing SEO? Digital Media Digital Marketing Search Engine Strategies by dianapps … down. Tools like Google PageSpeed Insights and GTmetrix are your friends here. **4. Quality > Quantity (Especially for Backlinks):** It’s… Hello everyone, I'm threedslider Community Center Say Hello! by threedslider Hello to all, I am developer of C++ (intermediate by self-taught) and I would like to have some friends here to make as fun learning and to exchange some knowledge in C++ and Computer graphic, are you agreed on that ? :) Thank you ! Re: Selling the house that I grew up Community Center Geeks' Lounge by Dani … in Florida, which she loves because she has lots of friends there now. However, depending on how my health journey goes… she has an active social life there. Most of her friends in New York have since moved away or she lost… Re: How does Microsoft defender operate? Hardware and Software Information Security by Reverend Jim … my laptops and the various machines I support for family/friends and have never had an infection. Re: How to Implement Lazy Loading for Faster Web Portals Programming Web Development by jkon … NOT be lazy loaded. Cumulative Layout Shift (or CLS for friends) is where most sites have problems. Many struggle with other… Re: Hello everyone, I'm threedslider Community Center Say Hello! by Dani Hi and welcome!! What got you interested in computer vision? Re: Hello everyone, I'm threedslider Community Center Say Hello! by threedslider I am searching also for other peoples in computer graphics and share their knowledge as well :) Friends system help Programming Web Development by breakforce …lt; 1){ $sql = mysql_query("INSERT INTO friends (`f_id`, `us_id`) VALUES ('".$_GET['f_id']."',…accept"){ $qfn = mysql_query("SELECT * FROM friends WHERE id = '".$_GET['id']."'"); $rfn… = mysql_fetch_array($qfn); $updf = mysql_query("UPDATE friends SET active = '1' WHERE id = '"… friends please help ? Hardware and Software Hardware by yusuf.business hello friends ? i am going to start a computers company.. We will have to tight up with intel in india ? can you tell me where in india intel manufacturer branch is located or any other computer manufacturing branch ? thanks in advance ? friends Programming Web Development by tcollins412 how would i do something like facebooks friends in php? Re: Friends request in PHP Programming Web Development by mrcniceguy …quot;); $_row = mysql_fetch_array($_query); $friends = unserialize($_row["friends"]); $friends[] = $_SESSION["logged"];…quot;); $_row = mysql_fetch_array($_query); $friends = unserialize($_row["friends"]); $friends[] = $_GET["accept"];… Friends database program Programming Software Development by StarZ … using sorting algorithm..so it asks to creat a friends database application that maintains a file of friend objects… names, telephone numberrs, and email adresses..etc. The friends application should load friend records from a file and then… allow the user to add new friends, delete friends, display a list of all friends by either first naem or last… Friends database program. Programming Software Development by StarZ …names, telephone numberrs, and email adresses..etc. The friends application should load friend records from a file and… the user to add new friends, delete friends, display a list of all friends by either first naem or …a friend. "); System.out.println("2. Display friends by last name. "); System.out.println("3… Re: Friends list SQL help Programming Databases by gunnarflax …friendship with? Anyway I do it I always receive all friends: accepted, pending and requested. Or accepted and the ones…me all kinds of confirmed options: [CODE] (SELECT id2 FROM friends WHERE id1='$user' AND confirmed = 1) UNION (SELECT id1…the ones that has asked me: [CODE]SELECT * FROM friends GROUP BY confirmed,id1,id2 HAVING confirmed = 1 AND … Friends list SQL help Programming Databases by gunnarflax …I read about some techniques for sorting a user's friends in this [URL="http://www.dbforums.com/mysql…retrieve the first described data: [CODE] (SELECT id2 FROM friends WHERE id1='$user' AND confirmed=1) UNION (SELECT id1 FROM…as in the previous code: [CODE] (SELECT id2 FROM friends WHERE id1='$user' AND confirmed=1) UNION (SELECT id1 … Friends list Programming Web Development by Toxikr3 Hi guys, I am in need of a simple friends list code. I don't know how to start it, … with login and password, I want to also add a Friends column. I will setup a "Profile page" soon…. It simply puts the name of the person in the Friends column and adds a comma. When reading the column it… Re: Friends list Programming Web Development by mrcniceguy … do like this 1.create a separate table call it friends with fields ,friend and username. 2.when someone is logged… rows. [code=php] mysql_query(INSERT INTO friends (friend,username) VALUES('$friend','$username')); mysql_query(INSERT INTO friends (friend,username) VALUES('$username','$friend')); [/code… Re: Friends list SQL help Programming Databases by gunnarflax … find out who YOU have asked to be friends with you: id1 = USER, status1=1 … script that looks like this: [CODE] $result = friends($profile['username']); while ($row = mysql_fetch_array($result)){ echo $… I've solved it like this: [CODE] $result = friends($profile['username']); while ($row = mysql_fetch_array($result)){ if ($row['id1… Re: Friends list Programming Web Development by diafol …'d advise against having a comma separated list in your friends column. This would make it difficult to search… friends. You need a dedicated friends table: friend_id (autonumber/int) user_id (int : foreign key on… Re: Friends database program. Programming Software Development by javaAddict You don't add friends here: [CODE] System.out.println("Enter a friend by … Re: Friends database program. Programming Software Development by StarZ [QUOTE=javaAddict;1057999]You don't add friends here: [CODE] System.out.println("Enter a friend by … Re: Friends database program. Programming Software Development by javaAddict … one thing at the time. First try to keep adding friends to the list and have another option that just displays… Re: Friends list SQL help Programming Databases by gunnarflax Or would it be easier to use several tables, one for requests, one for accepted friends and one for blocked friends? I went with this design I have now as it seems easier on the server. Re: Friends list SQL help Programming Databases by gunnarflax I don't think that will work since I don't have the friend's id. I'm trying to view all the friends of User so Friend will change every row. Do you understand what I mean? Re: Friends list SQL help Programming Databases by gunnarflax …? The thing is that when I should display all the friends of one user I will have to search both the… Re: Friends list SQL help Programming Databases by nileshgr You can put a OR predicate in the SQL query, something like this: [code] SELECT * from friends WHERE ( id1 = 'user1' or id2 = 'user1' ) and ( status1 = 1 and status2 = 1 ); [/code] This will return all the results which have both parts confirmed. Re: Friends request in PHP Programming Web Development by digital-ether … you added an accepted field do it. eg: viewing friends $userid = intval( $_SESSION['logged']); select f.* from …friend ids. If you needed complex queries, like "friends in common" or "most friendly" then… keeping the friends list in an indexed table like friend_requests would be better… Re: Friends list Programming Web Development by paradox814 You would need a SELECT statement in SQL to do this, the same way you inserted all of your friends to the database just ...[code]SELECT id,firstName,lastName FROM Profiles WHERE isVisible='1'[/code]of course you will need to change the names based on your table structure. Re: Friends request in PHP Programming Web Development by Shanti C … to the another member,the insert all the records in friends table like,memberid,accept,friendid...at first make the accept… his friend accept ,then update the friends table accept is 1,then show in their friends list.... Follow this for every request… Hi friends, Iam new. Community Center Say Hello! by Bijeesh T V Friends, I am Bijeesh T V (Kerala,India).I am an Engineering student.Likes to share everything I know with u.Hope u all will be my friends today onwards.