Hello! I'm having problems with integrating the Facebook Like button. My website is being restricted by a cookie ( meaning that the user has to go through a age verification page before getting into the actual site ). I have all the required meta tags in the pages header, everything's good! My problem is the following: when I integrat...
I'm trying to create a basic search functionality for MySQL InnoDB. I know there is Full-text search, but I just want to make an easy and simple solution for now. What I want is that when a user search for example "BMW Car" I want to find results not just like "BMW Car" but also "Car BMW" "BMW Z4 Car" and so on.. Is there an easy way to ...
I am trying to integrate iphone application with facebook, and I am stuck at a point where I need to let a user "Like" a page. This is because it's only after Liking the page the user gets to write some comments which will ultimately appear on the page's wall. I am not able to find any appropriate objective C code to implement this funct...
This is a snippet of my query: and ( ADDR_FULLTEXT like upper(:streets1) ) Whenever i execute the query this is a part of, it executes in about 0.05 seconds. This is perfect! But, when I do the following: and ( ADDR_FULLTEXT like upper(:streets1) AND ADDR_FULLTEXT like upper(:streets2) ) it results in a ...
$test = sprintf("SELECT * FROM `table` WHERE `text` LIKE '%%s%'", mysql_real_escape_string('test')); echo $test; output: SELECT * FROM `table` WHERE `text` LIKE '%s but it should output: SELECT * FROM `table` WHERE `text` LIKE '%test%' ...
Hi, I was wondering if there were any approaches recommended to auto logging out a user from Facebook and Twitter after they click a 'like' or 'tweet this'. I'm running a site in kiosk mode and would like to log them out after performing the previous actions. Thanks, Steve ...
I'm doing the following query SELECT * FROM downloads WHERE MATCH (title, artist) AGAINST ('+like ' IN BOOLEAN MODE) ...and it's not returning any results when it should be. It's not the code or anything, since it works fine for any other search terms. Could it be the fact that like is commonly used in MySQL queries so it's i...
I have a table that contains a list of the starting letters in a post code e.g. LS for Leeds and SO for Southampton. I want to match these against a user entered full postcode e.g. LS19 1AB. I've looked into using LIKE and some regexp stuff in my query but I'm struggling to find a way to do this the right way round. Any ideas? ...
Hi! I want to do a 'select' in MySQL using the operator 'LIKE'. But I do not want to use text as a comparison factor. I want to compare text between two fields in same table, like this: SELECT field1,field2 FROM table WHERE field2 LIKE %field1% ; Is it possible? ...
Hi, I have implemented LIKE button on my test page, I used all the og tags to say what it is all about and the result on my profile page looks like : Moshe likes title title on website I don't want the "on website" part because it links back to the root of the server which is not related to me or my content. I found no way to make t...
I'm wanting to do an ANDing or ORing in my mysql query, but the LIMIT needs to be the same regardless. eg. SELECTION * FROM table WHERE text LIKE %word1 OR word2 OR word3% LIMIT 10 I'd like this to work the same way it does on twitter, but I'm finding no help from google :( ...
How can I combine those two queries into one? 1) This finds the japanese sign for dog (犬): SELECT japanese FROM edict WHERE english LIKE 'dog' LIMIT 1; 2) This finds all japanese words with the sign for 'dog' (犬) in it: SELECT japanese FROM edict WHERE japanese LIKE '%犬%'; 3) I am having trouble combining those two i...
I'm new to database structure. I'm trying to create an app that allows users to like certain entries, but I want to be able to tie likes to users so that I can change the visuals before/after the like action. I think from research that I should have an 'entries' and 'users' table and then have a 'likes' table that ties the two to each o...
Hey all, I've been adding a like feature to an entries database... here's the structure of the DBs: **Users** user_id user_name etc. **Entries** entry_id entry_content etc. **Likes** user_id entry_id (It's a little more complicated than that, there are groups/categories, but that should explain it fine...) Here's the SQL query I'm ...
Hi, I set up the facebook like button on my blog and when I click "LIKE", on my facebook profile, it says "XXX (my name) likes Yeok-Rin « GOINGNOWHERE on raw.herobo.com." Only problem is that at facebook recent activity page, it doesn't show the link, as shown here I "liked" a random post and a post from my blog and the one below...