Colance, Connecting Ideas With Professionals. J5j
Webmasters: Colance specialise in connecting your ideas with Freelance Professionals to produce your project.
Programmers: Providing your Service is made easy through Colance. It is free to sign up with no monthly costs.
UMwxniywdsCdYae
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
UK BASED MNC NEED PHP/MYSQL PROFESSIONALS
UK BASED MNC NEED PHP/MYSQL PROFESSIONALS Job Category : Information Technology Job Code: WEb-PHP Company Profile: As a company, and as individuals, we value integrity, honesty, openness, personal excellence, constructive self-criticism, continual self-improvement, and mutual respect. We are committed to our customers and partners and have a passion for technology. We take on big challenges, and pride ourselves on seeing them through. We hold ourselves accountable to our customers, partners, and employees by honouring our commitments, providing results, and striving for the highest quality. Job Title : PHP/MYSQL Professionals Job Description : 1 The desired candidate would be involved in full software/ website development life cycle starting from requirement analysis to testing. 2 The candidate must be very proficient in PHP/MSSQL/ Qualification : Graduate Skills : PHP,MYSQL,HTML,JAVA SCRIPT Minimum Experience : 1 year Maximum Experience : 2 years To Apply online visit http://www.arjobs.in/job_details.php?jobid=925
Fread - Any Ideas?
I have a socket open (opened with fsockopen()) and I'm sending pop3 requests over it. When I use fread() to get the response of the pop server, there's the possibility that the response can be of length anywhere between 1 character and several million (obvious reasons). Does anyone know if there's a way to read the entire incoming data when you don't know the length of it, without putting in some rediculously large number into fread's length parameter?
Ideas ..with Webpage
Hello I didn't do any web page development since university ,I wanted to create a web page for the fun of it ,an I was surprised of how easy it is to use frontpage and dramweaver to do basic stuff ,but I wanted to do something that I am sure it can be done but I don't really know the way . The webpage is not something original and it has been done before . Xe.com is a currency converter from a currency to another currency I have the following questions : 1) Wanted to auto detect the users country and accordingly set the starting currency (from this currency) to the currency that his country is using. And also change the language to the user's language ... 2)lets say that I have users from two countries Germany and Hungary I can create two starting web pages one with Hungarian and one with German ..but lets say I have users from 30 different countries is not very convenient to have to create a web page for each language there must be a way that someone can i have a webpage that takes textiles or something with the language strings and just displays them. 3) Lets say that the language is wrong and the user is using a computer of the Spanish person and the user is Japanese I want to give them the option to change the language at any time ..do they have to install another language e.g Japanese in this case? or only the encoding has to be changed .? 4)I wanted to give the user the option to select the currency in a better way than dropdown box ,or a list box .. like a menu somehow but I can't come with anything ...I don't know what guys can you suggest I guess the list box is the obvious especially if there are so many currencies but I would like something nicer... for example to display the currency image at the side ..not sure.. 5) If I create user login for example and I have different users that they pay for the services how can I restrict certain currency converter for certain users e.g. we have two users and the one user didn't pay subscribed for the free service (he can convert Euro to dollars, visa versa, pounds to dollars visa versa, pounds to Euro visa versa), the user that paid can convert any currency .. 6) How can I restrict users from copying the website (using offline explorer for example). I was wondering what tools do I need to use to create the website(recommended reading books?/online tutorials ),how will I be creating the functionality that I want and how will I be resolving every problem listed ?
Mysql_num_rows .... Error??? Any Ideas?
Does anyone have a good reason why I'm getting this error. I'm clueless on this one... I'm getting the error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource.
Aggregation Class Ideas?
I have many classes that use database connections to fetch data and manipulate on it. I also have database abstraction class that is handling all the database queries and so forth. Usually all my classes take instantiated database object as the first parameter to constructor so they know what database to use:...
Text To MySQL Problem Need Ideas
I know how to upload text files and such my problem is that I may have many many text files so any editing of the files is out of the question. The files are not delimited, well so far I use and it works but with help of some editing.
Any Ideas How To Read A Url That's Changed By The Server?
I apologize, but I posted this in the php general forum earlier and realized that this is the more appropriate forum. Hopefully there's a coder here who has done this in the past. I've got code that uses CURL to go a web page to read the data. When I type in www.website.com, the server automatically adds a session variable to the url. I need to be able to read that session variable. Then I will use that session variable to input into a new CURL session. Any ideas how I can do this? If I use code like this: // find out the domain: $domain = $_SERVER['HTTP_HOST']; // find out the path to the current file: $path = $_SERVER['SCRIPT_NAME']; It gives me the code for where my script is sitting on my server rather than the values for the web site that I'm trying to read. Any ideas?
Ideas For French/english Sites, Using PHP?
I run a small site, I used it to learn html, and now PHP, next MySQL! I live in Quebec Canada and I would like to translate my site into french. I think I can get many more hits if I let the people around here take a look at my site and understand it! I wonder if I could use a smarter way to do this using PHP or even MySQL. Instead of having twice the html/php pages. I don't have any ideas with my limited knowlage of programming. Maybe using variables in the URL like mydomain.com/index.php?language=french&file_id=23 or something??? Well maybe it is more trouble than anything else and I shouldn't even think about it? Right now I'm just planning on making twice the pages and have a french/english page as my index for people to choose. But if anyone has any ingenious ideas let me know! I like figureing things out for myself, but if you would point me in the right direction.
Any Ideas On Invalidating A Session From Another Process?
I have a slight problem with sessions. I use a session var to store a user's details and also a set of permissions to various parts of my application. This involves several SQL queries which is why I do it once and cache the result in a session var. My problem occurs when I change a user's permissions. At this point I need to invalidate that user's session to reload their new permissions. I don't think it's possible to do it directly is it? I'm thinking at the moment of a timestamp in the user record which requires an SQL query every page.
Any Ideas How To Run Macro In Microsoft Publisher Through PHP COM ?
my macro in Publisher changes "123" into "321" (example) but I can't be able to run it. This is how far I get throught with PHP & Publisher: <? $pub = new COM('publisher.application') or die('Unable to load Publisher'); print "Loaded Publisher, version {$word->Version} "; $pub->Open('xxx.pub'); $pub->Documents[1]->SaveAs('xxx2.pub'); $pub = null; ?> this works, but of course does not do anything else than open xxx.pub and save it as xxx2.pub. I am trying to run my macro: $pub->Documents[1]->RunMacro(replaceme); where replaceme is my macro. I tried different variations: $pub->Documents[1]->Run(replaceme); $pub->Documents[1]->Application->Run(replaceme), etc but no luck so far :(
Looking For Recent Visitor Code Examples/ideas
I am working on updating my content management page and wanted to overhaul my "recent visitor" code. The code that tracks who has been and is still on my pages. I have not been able to find some examples I saw here a few months ago and was wondering if anyone could point me to some examples. The more versatile the better.
Data Transfer Problem - Ideas/solutions
I have an interesting problem. I have a (LARGE) set of historical data that I want to keep on a central server, as several separate files. I want a client process to be able to request the data in a specific file by specifying the file name, start date/time and end date/time. The files are in binary format, to conserve space on the server (as well as to increase processing time). The data in each file can be quite large, covering several years of data. New data will be appended to these files each day, by a (PHP) script. The server machine is likely to be a Unix machine, whereas my clients will be running on windows machines. My clients program is written in C++. My main problems/questions are as follows: 1). Transfer method issue: What is the best (i.e. most efficient and fast way) to transfer data from the server to clients ?. I think SOAP is likely to be too slow, because of the sheer size of the data 2). Cross platform issue: How can I insure that that the (binary?) data sent from the Unix server can be correctly interpreted at the client side? 2). Security issue: How can I prevent clients from directly accessing the files (to prevent malicious or accidental corruption of the data files.?
Ideas To Create User Personalize Page Without Login.
Hi,I am new with PHP, I am a new junior internet programmer. My boss asked me to do a personalize page for his search engine. Do any one willing to give some ideas of how to create a personalize page without login by user(only read the user cookies and mysql)
PHP Search Engine Code? (Rather Verbose Php Link) Any Ideas?
I've totally hit a brick wall and I've checked the numerous (some helpful) tutorials in making a php link search engine friendly but the following link: <font face="Tahoma" size="2"> <a href='ps2reviewsdisplay.php?page=ps2/ps2acecombatsquadronleader&type=htm&title=- Ace Combat Squadron Leader Review - www.impulsegamer.com Australia'> <span style="text-decoration: none">Ace Combat: Squadron Leader<br> </span></a></font> I just don't know how on earth to make it search engine friendly?
Php & Connecting
For example I have an IP : port and on connect (for example using telnet) it shows me some info (like current air temp) and after it closing connection. How can i insert it on my web page using PHP? And on every visit on this page php connects to this IP, gather this info and shows it on page?
Connecting To Db..
this seems pretty straight-forward.. got this code $link = mysql_connect('localhost:3306', '<uid>', '<pswd>'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully' mysql_close($link); from here.. http://us2.php.net/function.mysql-connect but can't connect, get this error: Connect to db: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in C:xamppxampphtdocshomeconn.php on line 19 Could not connect: Can't connect to MySQL server on 'localhost' (10061) I connect to this same MySQL server from Tomcat w/no problem.. what is issue here pls... now on top of pg mentioned above, there this description: resource mysql_connect ( [string server [, string username [, string password [, bool new_link [, int client_flags]]]]] ) what does 'resource' refer to here pls... and where to do specify what db to connect to... (in java you put db-name in same line where you make the connection..) (and don't you need a driver to connect, I use a JDBC driver to connect w/Java..)
Connecting To An API
I need to use a company's API in order to try and convert video files into flash files and then play them Youtube style. There is a set API to use, but the instructions are incredibly vague, and me being new to APIs in general, I have absolutely no idea where to start to get the results. I can program basic PHP forms and database stuff, but this is all new to me. Code:
Connecting To A Different Host
Is there anyway to connect to a given host from a form and do all the processing of information and calculations at that host and then display the results on the clients computer? I was thinking of a socket connection but I don't know if that would work well. Any suggestions would be appreciated.
Connecting To A Acess DB
I have been connecting to an acess db by ODBC. i am wondering if there is another way to connect to it.
Memcache Not Connecting
memcache appears to be installed correctly, but when I use memcache_connect I get the following error: Warning: memcache_connect(): Can't connect to localhost:11211, Unknown error (0) I'm connecting using the following command: $memcache_obj = memcache_connect('localhost', 11211); Memcache info from phpinfo(): memcache memcache support enabled Active persistent connections 0 Revision $Revision: 1.53 $ Directive Local Value Master Value memcache.allow_failover 1 1 memcache.chunk_size 8192 8192 memcache.default_port 11211 11211 Finally, var_dump(extension_loaded('memcache')); returns true.
Connecting To MS-SQL Using PHP4!
I am trying to connect to our NT based MS-SQL server from my remote linux box, i have a RH linux 6.2 plat, with PHP4.0.3, using sybase ase libs, i compiled it like the faq says, configured it, set up the interface files, but i get the following error: Fatal error: Call to undefined function: mssql_connect()in /usr/local/apache/htdocs/mssql.php on line 4 So i havent got to actually be able to connect to anything being, its saying function isnt supported.
Trouble Connecting With FTP
I'm using PHP 4.3 on Apache 2, connecting to a VSFTP server running on Fedora Core 5. The Fedora machine is my home computer, which sits behind a router. I have opened up the FTP port, and I can connect fine from an FTP client if I'm using active mode. However the following code fails to upload a file // set up basic connection $conn_id = ftp_connect($ftp_host); if ($conn_id) { // login with username and password $login_result = ftp_login($conn_id, $ftp_user, $ftp_pwd); if ($login_result) { // Disable passive mode ftp_pasv($conn_id, false); // upload the file $remote_path = "$ftp_dir/" . SQL_PRODUCT_SHORT_FILE_NAME; ftp_delete($conn_id, $remote_path); // line 96 $upload = ftp_put($conn_id, $remote_path, $sql_file_path, FTP_ASCII); // check upload status if (!$upload) { die("FTP upload has failed!"); } with the following Warning: ftp_put() [function.ftp-put]: Failed to establish connection. in /usr/local/apache2/htdocs/super_admin_rs/sa_prod_fns.php on line 96 FTP upload has failed! I have verified that the file in question exists. Any other ideas on how I can troubleshoot this problem?
Connecting To Access Db
i was working with asp but the site is launched in linux server.had to switch to php. i had a access db admin.mdb i need to connect to admin.mdb and insert and retrieve data from it.
Connecting To Remote Dsn
Is it possible to connect to a remote server's dsn: odbc_connect("198.162.1.1:webAccess", "user", "password") where "webAccess" is the system dsn in the remote server..
Connecting To Pervasive SQL
In a development I'm doing I need to connect to a Pervasive SQL database to retrieve some data for use in my application. In the PHP documentation I couldnt' find any connections to Pervasive SQL and would prefer not to use ODBC as the app will be running of a Linux box, while the Pervasive SQL is running on a Windows Box. Do you have any suggestions how I can create a connection to Pervasive SQL with PHP?
PHP Not Connecting To MySQL?
I installed Apache 2.0.55, PHP 5.1.1, and MySQL 5.0.17 (in that order, on Windows XP). I have managed to get Apache and PHP working right, and MySQL by itself seems ok too. However, when I try to do any MySQL command within PHP, it just does nothing. No success, no error. I tried uncommenting the line "extension=php_mysql.dll", but when I restart Apache it tells me "PHP Startup: Unable to load dynamic library php_mysql.dll - The specified module could not be found.". No matter where I copy the file so that it can find it. No matter what I put in "extension_dir". What's wrong?
Connecting To Mysql With Php
I have been racking my brain trying to figure out what I am missing trying to follow this book to get a php script to work. I would really appreciate if someone could point out my errors. I've been up really late going over all the config files. Why do they always scim installation for the applications and put it in the Appendix when its the first thing that new users need to do. Then we run into these problems because the author takes so much for granted I'm using Apache 2.0.55 with PHP 5.1.2 and MySql AB 5.0.18. Windows XP SP2. What I believe I'm missing is how do I tell PHP & Apache where the Databases are?? Here is the pathing my my installs. C:/mysql/bin, c:/mysql/data/books, c:/apached/apache2/htdocs for servering up web pages, and c:/php. Here is the error log in apache, and the script ....
Connecting To LDAP
I am having some issues connecting to LDAP through PHP. I am using the function provided here: http://www.php.net/manual/en/function.ldap-bind.php (By 'edi01 at gmx dot at'). I don't get any errors till it tries to do the search. I get the following error: ldap_search(): Search: Operations error verification on 'ldap://newkenny': ldap_error(Resource id #2) failure: search in LDAP-tree failed ACCESS DENIED I'm trying to connect to a Win2003 AD server. I have set the "LDAP_OPT_REFERRALS" to 0 as someone else stated. When I do: ldapsearch -H ldap://myserver -b "cn=users,dc=base,dc=com" -x -W -Dmyaccount -LLL "(SAMACCOUNTNAME=myaccount)" from the command line it works fine.
Connecting To Aim And Sending IMs
Is it possible to write an Instant Messenging client that connects to the AIM servers in PHP? I want to write a small script that would sign on a screen name, and send an instant message to someone after they've put their screen name into a form. Does anyone have any idea how difficult or complicated this would be?
Connecting To SQL Server Using PHP
I am still trying to connect to SQL Server 2000 (MSDE) form PHP I did the following: 1. enabled php_mssql.dll extension in php.ini (phpinfo() shows it) 2. every dll is in proper place (System32 or php folder and few more folders just to be sure) including ntwdblib.dll I am running Apache, PHP 4.3.9 and MSDE on the same machine with Win2k SQL server config.: 1. Two instances: default SERVER and SERVERPortal 2. Both instances are using SQL auth mode, and user that I try to log in has db admin rights can't connect to any of the instances :( I tried the following: 1. specyfing the port in mssql_connect ('SERVERPortal,1433') DIDN'T WORK 2. different notations 'SERVERPortal' or 'SERVERPortal' DIDN'T WORK 3. different naming like: SERVER, localhost, 127.0.0.1 DIDN'T WORK The ASP pages that are using the same sql server work fine :| so there is a connection to the server for ASP :] So my question is what I did wrong? and another question is: How to connect to a named instance of a sql server if it isn't running on the same machine with web server, what would be the connection string in mssql_connect?
Connecting To SQL Database
I have been asked to create an e-commerce website, where we need to connect to an SQL database. The database is used to run their POS in several branches. As this database is on the company server and we are hosting the website with a webhost we have to solve an communication issue. Here are the options that I can see: a. create a branch like environment on the webserver and then directly access the branch database (OBDC??) b. run a script that sucks data from the SQL environment and then ftps it as a text file to a LAMP server. PHP and Mysql (my preferred platform), will then notice the new file and do something with it? c. have a direct OBDC connection between the website and the company's server What option do you recommend? What difficulties do you see? I would love to get some ideas from you and more ideas on the typical problems.
Connecting To An FTP Site Using PHP
I am trying to create a script that will connect to an FTP site and grab a file from that site. It will then format that file and place it on the root on my machine. I keep getting "SITE EXEC" not understand on line 22. Below is my script. Any help will be greatly appricated. Also the IP address, username and passcode is purposely 'X' out. Code:
Connecting / Registering
i try to register a new account to my game it says "cannot register user". ive searched for this in my php files but cannot find it. also, when i try to log in to my game, it works and displays the new page. but the moment i refresh it says i am not logged in again. is this a problem with my cookies? does anyone have any ideas?
Connecting To A Program
i wanna try get php to execute a command to a process/application running on a linux box(same computer). the application that is running is called asterisk. asterisk uses a CLI, how i normally do this is: Open a terminal type in: asterisk -r <--- connects to the CLI reload <----- reloads the config files exit <-- exits the terminal/CLI
Mssql_connect() Not Connecting
I am getting a Warning: mssql_connect(): Unable to connect to server: error and when I look at the log from my router/firewall I don't even see an attempt to connect. Is there some configuration in the php.ini file I need to check or anywhere else? phpinfo() shows a mssql section so i assumed that it was installed correctly.
Connecting Tables
I have one table in a database that is essentially stuff from a commenting script. Things that are posted in it are name, timestamp, id, etc... After this I have another table in the same database that is like a comment system for the first database with id, name, time. How can I set it up so that comments from the second database are only shown if it matches the id from the first database that the person commented on.
PHP Connecting To MySQL...
I am learning with Kevin Yanks book, "Build you Own Database Driven Website," and I have run into a problem. I have uploaded a PHP file to my local server, and none of my content is being displayed from my database. According to the book, the jokes that I have entered into my database should be displayed using this code. Here is the error I am getting: QuoteFatal Error: Call to undefined function mysql_connect() in C:.... on line 14 Code:
Connecting To A Server Via PHP
i was wondering what i would need to write, to connect to a newsgroup server (or any other server for that matter) is it a case of defining my username,password and the server address?
Connecting Through A Proxy
What I am trying to do is connect to my newshost (unlimited.newshosting.com(63.218.45.254 port is 119)) to download usenet headers for my site.After sending a whitelist request to Godaddy, they replied with this: Thank you for your email. Applications that need to make https connections (port 443) will need to be made "proxy aware". This will require additional coding to varying degrees, depending on the application. You will need to know the ip address and port of the proxy server in order to correctly modify your code. The ip of the proxy server is 64.202.165.130 and connections will be made on port 3128. You will need to use this when coding with PHP: curl_setopt ($ch, CURLOPT_HTTPPROXYTUNNEL, TRUE); curl_setopt ($ch, CURLOPT_PROXYTYPE, CURLPROXY_HTTP); curl_setopt ($ch, CURLOPT_PROXY, http://64.202.165.130:3128); curl_setopt ($ch, CURLOPT_SSL_VERIFYPEER, FALSE); I'm not sure how I go about this. The code: ......
Connecting Through A Proxy
What I am trying to do is connect to my newshost (unlimited.newshosting.com(63.218.45.254 port is 119)) to download usenet headers for my site.After sending a whitelist request to Godaddy, they replied with this: Thank you for your email. Applications that need to make https connections (port 443) will need to be made "proxy aware". This will require additional coding to varying degrees, depending on the application. You will need to know the ip address and port of the proxy server in order to correctly modify your code. The ip of the proxy server is 64.202.165.130 and connections will be made on port 3128. You will need to use this when coding with PHP: curl_setopt ($ch, CURLOPT_HTTPPROXYTUNNEL, TRUE); curl_setopt ($ch, CURLOPT_PROXYTYPE, CURLPROXY_HTTP); curl_setopt ($ch, CURLOPT_PROXY, http://64.202.165.130:3128); curl_setopt ($ch, CURLOPT_SSL_VERIFYPEER, FALSE); I'm not sure how I go about this....
Connecting To A Mssql Database
I tried to connect to a MSSQL database and I was told I had an invalid function call, function not defined. Is there an add-on that needs to be installed for MSSQL to work properly? $dbconn = mssql_connect("localhost:,"user","password");
Problem Connecting To Mysql
I keep getting the error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) How do I know if a mysqld is already running?
Connecting Dreamweaver To MySQL
I'm new to MySQL. I recently installed it as part of a preconfigured package (Apache, PHP and MySQL) from "Apache Friends (XAMPP). I was following a tutorial on connecting Dreamweaver to MySQL at http://www.macromedia.com/support/dr...sql_config.htm when I hit a snag. I think I created the MySQL username and password in the wrong directory, and it messed everything up. I reinstalled XAMPP and am giving it another try. But before I mess with the MySQL password again, I'd like to ask a couple questions. First, do I really need one? I'm only using MySQL on my computer, which no one else uses. I publish my sites to an ISP, which has their own MySQL program installed. Or is MySQL something that has to be customized and published along with your websites? This is what the Deramweaver instructions say about the password: "During the MySQL installation, MySQL creates an account called root with no password, which can be used to log into the database. It is highly recommended that a password is assigned to this account since root has full control over the MySQL databases. To assign the root account a password run the following command, which will set the root password to new-password. You should replace new-password with a password of your choice that is harder to guess." > mysqladmin -u root password new-password My next question regards this statement: "It is recommended that separate MySQL accounts are created for each PHP web application. You can create as many MySQL accounts as you wish and assign different rights and permissions to each account. Web application users do not need the same level of privileges as the root account." When they say "each PHP web application," do they mean create a separate MySQL account for each WEBSITE? Does that mean I have to create a new MySQL password for each of my websites and connect it to Dreamweaver individually? I also have PHPMyAdmin installed, but I haven't learned how to use it yet. When I click "Test PHPMyAdmin," I get a page that has a setting labeled "Create new database." There's also a link to "Privileges," which leads to a page with keywords like "user," "password," "root" and "edit." Maybe I should use one of these pages to add a MySQL password (if necessary). But I thought I should first ask if it's NECESSARY to create a password for MySQL.
Connecting To A Database On A Different Domain ...
I have several sites that need to use a single database. Each site is on a domain of its on with the database on a separate domain. I usually use : ----- $connection = mysql_connect("localhost","username","password") or die("Couldn't make a connection."); $db = mysql_select_db("database", $connection) or die("Couldn't select database."); ----- ...but since the database is not on the "localhost", how do I form the php code to link to an external database? I have set the external sites as "Access Hosts" on the main site. What do I do to connect these external sites to the main database?
Links Not Connecting To Description.
I have a query that when called, brings up the found results which are hyperlinked. When clicked on, the link should connect to the description of the product searched for. Right now, the results just contains a link to http://ehagglers.com/v2/showdetails.php?productid=1 or http://ehagglers.com/v2/showdetails.php?productid=2 or whatever the query number clicked on in the results. I need someone to make it so that the links (when clicked) bring up the correct description for that specific product. Is this easy?
PHP & MySQL - Connecting Two Databases
I am trying to understand the best way to extract a list of users from a table based upon their location. To do this I have a table containing all the UK postcodes with a grid reference x & y. postcode x y AB10 392900 804900 AB11 394500 805300 AB12 393300 801100 AB13 385600 801900 AB14 383600 801100 AB15 390000 805300 AB16 390600 807800 AB21 387900 813200 AB22 392800 810700 AB23 394700 813500 AB25 393200 806900 AB30 370900 772900 In a seperate table I have a list of users including a postcode. id firstname postcode 1 Heather BH4 2 Vicky OL1 3 Paola CF8 4 Joanna W14 5 Steve BD13 6 Sally NN1 In short I would like your opinoin on how best (most efficiently) to calculate the nearest 20 users. The method I am using to calculate the distance between the users and any chosen postcode is good old Pythagoras dist = sq root ( (userX * userX) + (userY * userY) - (locationX * locationX) + (locationY * locationY) ) It seems that looping through the users to first calculate the distance is essential. After that point I am not sure about the besr way to proceed. Do I write the results to a temp table (with distances) then call them in order of distance or is there a better way?
|