Recent content by richclever

Hi Drj, Please excuse my ignorance, but could you clarify how to construct the sql query. Currnetly I have $userquery="select * from users where (username = '$login' and password = '$pass')"; as my mysql query so it just queries for a valid login and password combination. I need it also...

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

It's OK now. I sorted it out. The problem was because I was using the wrong file type (text instead of ASCII).

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

What can I say, Absolutely brilliant DRJ478. Works like a dream. Well it's certainly been a learning day today! Many many thanks, you have really dug me out of a hole!! Richard

Thanks heaps DR, I am a bit confused as to what the other while you mention should be though. Richard

No problems, I will have to post the data as an image on a site as it won't copy pate properly. I will label it properly for you . Look at ictechinformatique.com/cedit.jpg for the pic. The data will be input if I use phpmyadmin, but not from the script below.(I have removed connection...

That's what I thought too, but for some reason it doesn't want to take the data on the lines with the CR/LF on them. No idea why, but that's whats happening. It's not actually important to have the CR/LF's there (infact may be better no too) so I'm definitely looking for a way to strip them...

Interesting, I got DRJ478's solution working really easily - Except in some of my sql statements there seems to be a Carriage return (looking at it in crimson editor it has a small square symbol). Whilst if I execute the script file through php myadmin everything is fine, when I read the file...

Thanks a million. I will get to it straight away. Fortunately I only have insert statements in the sql. I know that the command line stuff would be nice and easy, but like I said I need to do various other bits and pieces too so thought it'd be better all in one file. Thanks again, Richard

I know that the command line would be best, but I need to run a cron job that inserts the data into a database and then a few other bits and pieces. I'm best with php rather than bash etc. so wanted to do it in PHP and call it from cron.

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

The script needs to work as a cronjob (the php does that on the source server to get the mysql data entries) then it needs to ftp to the destination server and run. I was going to have a php cron job (or bash) that processes the sql data file.

Problem identified (not resolved though!!) My host doen't allow incoming or outgoing external connections to mysql. Probably on the firewall as I have opened all access hosts for the database but doesn't make a difference. Can't access the database from outside or connect to a remote...