Teamwolf2000

Many thanks for all your help. Cheers. :-)

yes they are. Could you maybe explain the difference and what it would make to the data files, if its not too much trouble. I would be very greatful. Many Thanks, TW2

Hi, I am running 5.051 and would like to backup my data files and ftp to another remote server. This is just as a backup for a complete system fail. I have written the script and it all works well, it is shedualed to run overnight. I just wanted to check that if I do back up these data files, in the event of a major systems crash I will be able to restore them onto my new box. Currently I copy the entire contents of D:\MySQL\data which is the location of my database files. Could someone let me know if these can be resored if ever i need to. Thanks very much, TW2

Hi, I am currently finishing a intergration with a third party payment gateway and my own bespoke shopping cart. Currently:- My checkout process page adds all the order and customer data to my database tables. There is an HTML form in the HTML of that page that is submitted by javascript onload that posts the required data I have already collected to the Payment Gateway. On sucsessfull payment, the Order in the database is flaged as paid. Process completed. It all works fine, But I dont like using javascript to post the form and I dont like having the form data visable. I had a look around and it seems I should be using Curl to post the data to the Payment Gateway. I can get my curl script to work and post all the data to the payment gateway, but... It is returning the HTML and displaying it in the page. I would really like it to post to the payment page and follow it to it. The Payment gatway page is on https and my page is not. So is asks for payment details on http not https. Does anyone know what i should do to make Curl go to the page rather than display it? Here is the Curl code, I have not put the details in for security reasons. But it all works and displays the page. $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,"https://$URL"); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $data); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE); curl_setopt($ch, CURLOPT_USERAGENT, $user_agent); curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 0); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true); curl_setopt($ch, CURLOPT_COOKIEFILE, "cookiefile"); curl_setopt($ch, CURLOPT_COOKIEJAR, "cookiefile"); curl_exec ($ch); curl_close ($ch); Any suggestions would be great. Thanks very much. TW

opps sorry, I didnt understand that its on a percentage basis. I totaly see what your saying. Many thanks for your help.

Hi, Thanks for the response. here is the site it is on: www.frittendenphotos.co.uk I have also attached the SQL file I would like the search to use the query above to select the items based on the serch text from the keyword table. Many thanks for your help and time. Cheers, [attachment deleted by admin]

Hi, I wondered if any of you experts could help me. I am trying to query a keyword table and return the items that are joined to the keyword table via a simple join table. I would like to use the Match Against on the query as a search. The following query works as expected: SELECT GalleryItem.* FROM GalleryItem, Keywords, KeyItemJoin WHERE GalleryItem.ID = KeyItemJoin.ItemID AND Keywords.keyword LIKE $SearchId LIMIT 0 , 30 Using Match Against include in the query (below) returns Zero results, but should return some results: SELECT GalleryItem. * , MATCH (Keywords.Keyword) AGAINST ($SearchId) AS score FROM GalleryItem, Keywords, KeyItemJoin WHERE GalleryItem.ID = KeyItemJoin.ItemID AND MATCH (Keywords.Keyword) AGAINST ($SearchId) LIMIT 0 , 30 I am sure its prety simple, but I can not get it to work correctly. Any help much appreciated. Many thanks.