Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    PHP




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 ?

Anyone Got Any Ideas On The Best Webstat Packages Available
Im trying to get a good solution to monitor webstats, pages including visitors and referrers.

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 For Sending Out A Basic Newsletter
I want to send out a basic newsletter from my MySql database of contacts.

Does anyone know a nice and simple bit of PHP that allows me to do this?

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....

Trouble Connecting To Outside Server
I have the following code:

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?


Copyright © 2005-08 www.BigResource.com, All rights reserved