Recent content by Olavxxx

Hi, check if you have data in all the colums you use for joins Olav Alexander Mjelde

Maybe you should consider using a iso3166 table with country codes. eg. 3 char 2 char | 3 char | full NO | NOR | NORWAY Look here: http://www.iso.org/iso/country_codes/iso_3166_code_lists.htm Ps. still you have a problem, I for instance use .com emails, I use .net e-mails and .no :-P You...

Yes, I would not store the images in the db, but you can store metadata. However, you can also use metadata in the files :-) If you look here: http://www.bilder.raskt.net/picture/original/web_web_ltpgtvolvo_960_twinturbo_engineltpgt/116.intervev There I read the metadata that the camera stored...

Hi, I think you are on the right track. Use dirlist or database, dont define an array in the script :-) Olav Alexander Mjelde

Hi, maybe the problem is that you are missing data in some of the other tables? You can check this with: SELECT count(*) FROM subscribers WHERE subscribers.uid NOT IN (SELECT uid FROM users_db) AND subscribers.sub_user='1' SELECT count(*) FROM subscribers WHERE subscribers.uid NOT IN (SELECT...

Hi, I thought of another idea now.. That might work better (if it works as I think it will). I'll try to add a new colum that I call weight, with standard value of 1. After doing that, all the records will have weight 1 and I can multiply the weight colum to the score (in the query). So if a...

Hi, you should secure that code. Look here: http://php.net/manual/en/function.mysql-real-escape-string.php I would also on top of the example 1 code do some stuff like: strip_tags() trim() ucwords() strtolower() And more :-) On the comment, you can consider if you want to let the user use...

btw. I know the issue is fixed, but I can just tell you about one that puzzled me once :-) Redirect from www to http:// caused some cookies not working. I figured out that you can define the superdomain when setting the cookie dough, though ;-) Olav Alexander Mjelde

Hi, you could chmod (change permissions) for the include-files :-) Olav Alexander Mjelde

Hi, I have already made a fulltextindex and it works pretty well with score and distance (calculating distance from the user and the record). However I would further like to improve this search by giving first the records with phone numbers and the ones that are "reserved". I tried adding more...

Btw. I use InnoDB as storage engine, that might also affect performance :-) Olav Alexander Mjelde

Hi, do you have indexes? I also use location-diff for querying a large resultset. Mine is lightning fast and I use 3 tables with an outer join. Sorry I cant share the db design, as I made it for a client. Olav Alexander Mjelde

Here is a sollution I can use :-) http://www.stum.de/2008/10/20/base36-encoderdecoder-in-c/ Olav Alexander Mjelde

Thank you.. I have also found this code: http://www.stum.de/2008/10/20/base36-encoderdecoder-in-c/ which I have tested to work in my C# application :-) Olav Alexander Mjelde

Cant you use the maskedtextbox ? http://msdn.microsoft.com/en-us/library/kkx4h3az.aspx Olav Alexander Mjelde