Search results for query: *

I have a table on my mysql database which hold an expiry date in mysql's date format. I need to compare it to the current server date to check if a username has expired. I have set date is php to the same format as the mysql date using $today = date("Y-m-d"); I am trying to check the system...

This is probably really easy but as I am new to asp I was wondering if anyone could help. I have an access dbase that holds usernames and passwords and an expiry date. I need to compare the expiry date with the current date and if it is later than the current date it will allow access (if the...

Does anyone know how I can overwrite files that I am uploading using php's ftp functions. I am using php 4.3.10. Thanks Richard

Hi, I have a mysql dump file that I need to get php to process. Anybody know how? Thanks Richard

Hi, I want to export some data from one database to another but unfortunately my host won't allow inbound or outbound connections so I can't connect to the remote host. What I thought I'd do to get around the problem is to write the mysql commands to a text file which can then be run on the...

Hi, I have a script that integrates a set of data from one database with another ro display real estate listings. The database uses an autoincrement ID field to store the listings. At the moment, my integration script sets the ID number a lot higher that the last record so as to not intefere...

Hi, I need to access a remote mysql host from my server. All host permissions have been set but the server refuses to connect. I can use a different one and there is no problem. It just seems to be from one specific host that I can't get access. Richard

Hi All, I am trying to get a php sceduled task to update a remote database and ftp some files. I can't see why the file doesn't do what it's supposed to do (even when I call it in firefox) as it worked fine on my local server. All the table and field names are correct (case sensitive) and the...

Hi, Don't know if anyone can help but here goes. I have created a 360° flash panorama that moves round, but want to be able to link it to other panoramas for a complete virtual tour. Basically, I want to define hotspots on the panorama that when clicked will zoom in on the image and then open...

Hi, This is probably a really simple question but I can't figure out where I am going wrong. I want to upload images from a form that also has other info in it but I can't get the images to upload. My form html is as follows. <form enctype="multipart/form-data" form action="insert.php"...

I know that this problem has been dealt with before, but none of the solutions work. A client is unable to recieve attachments from ONE of his contacts. When he tries to save them, all he gets is an image which is in the message signature and none of the actual attachements. He can open the...

Don't know if this is possible, but can php and cgi sessions be combined so both types of scripts use the same session? Thanks Rich

Hi, I have a drop down list and i need it to refresh the page when I choose a value from the list so that the form underneath pulls some values into itself. I can pull the values using a select button, but want it to do it automatically so is there a way of setting an onchange event that will...

I have a script that is supposed to run in a frame on my page. It checks whether the username and password are registered corrctly using session_register. The problem I am having is that sometimes it does and other times it doesn't. On my computer, IE doesn't seem to have a problem, but...

I have an email that come in every day and need to pass it to an awk script. I have a filter that picks up the email, and it should then process the file and output to another one. The problem I have is that it is just adding it to the end of the awk script I have. The script looks like...

I can run my script on one server but not on another. I get the following error when I try to access the page: Couldn't execute statement: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''0',30' at line 1...

My mysql server keeps going down, and I can't work out why. I enclose the latest part of my error log that deals with the latest crash. If anyone has any ideas please let me know. I must get it working properly. Thanks Richard Version: '4.0.20-standard' socket: '/tmp/mysql.sock' port...

I have been asked to write a script that takes info from a url and does some processing. Easy enough originally as the url was named index.php?id='idnumber' However, now the people who want this want to display friendly url's, so if a url was index.php?id=82 it is now pagename.82.0.html I...

I am really confused. I have a set of database fields that have a list of keywords in them that are comma delimited. I have read them into an array and exploded them so each keyword is in a seperate array element; thus I have the follwing list in my array from one record...

Hi, I have a table with a field called keywords. In this field, there is a comma delimited list of keywords. I need to compare this field for a particular record with all the other records to find any records that have the same or similar entries in their lists. e.g. Record1 has the...