WampServer

I am trying to access phpmyadmin from a machine other than the server it runs on and get an error message Forbidden You don't have permission to access /phpmyadmin/index.php on this server. What do I have to set to allow this? RIck
Forum: WampServer English

Hi all You will now know how inexperienced I am at all this... I have a simple database...names, addresses, telephone numbers, etc...and a web page front end. What I would like to do is present a page with all the fields on it and have a user enter the search criteria they have and make a search...at the moment, the only way I can get this to work is to provide a number of pages with a sing
Forum: WampServer English

Have I posted this is the wrong place? I would have thought a lot of people needed to print results to paper at some point or other? ANy idea where I might post my question that would elicit an answer or two? Regards Rick
Forum: WampServer English

Hi I have an sql query against a MySQL database. I need the results printed and have been told that I can export the results to a file. However, this file is located on the server, which then needs tobe downloaded before being run through excel for instance for formatting. However, phpAdmin provides a feature whereby an SQL query can be exported to the client desktop. Is this a php feature
Forum: WampServer English

I am having similar problems, that don't appear to react well to these processes...tried the console, but it won't accept the password...error message says: host 'localhost' not allowed to connect to this MySQL server... Regards Rick
Forum: WampServer English

OK...not quite done...in fact, not done at all...tried this and it doesn't work...tried the console and it won't accept the password...error message says: host 'localhost' not allowed to connect to this MySQL server... Regards Rick
Forum: WampServer English

Thank you do much...I should have looked a few posts down and saved you the effort of repeating it...desperately sorry Regards Rick
Forum: WampServer English

I have had a major breakdown and have had to reinstall Wampsserver. For some reason, when I use phpAdmin I get an access denied error...what ini/conf files hold the login name and password for accessing MySQL? Thanks and sorry to be a dork Rick
Forum: WampServer English

Thanks for that...but the tutorial seems to assume that you have a server running with the database you need to recover...I have reinstalled MySQL so I do have a server running, but the database is in the old set of folders... And I am not an expert at this at all... Regards Rick
Forum: WampServer English

I recently had one of my clients lose a hardrive on the machine that I had installed a MySQL database for them. The operating system went completely, but I have managed to retrieve the folder containing my database from the MySQL folder in wamp. If I reinstall wamserver on the machine, is it straightforward to place this databse folder where it should be or is it more difficult than that? H
Forum: WampServer English

Have done so...thanks for having a look... I have made a join between the two tables, just to add to the complexity...the linking field is CardNumber. Have I got the join around the right way? would that have an affect? Babbling now, sorry.. Rick
Forum: WampServer English

I hope someone out there can help in this. To set the scene...I have a table of payments made with a year in which they were made. I need to search to find out how many people paid in one year but not in another. I have done a search with the first date and a search with the second to produce two arrays consisting of around 16 columns each. I have tried using array_diff in php to show the diff
Forum: WampServer English

Thank you you don't know how much I appreciate your time.. Rick
Forum: WampServer English

Thank you Steven Yes I do have a number of inputs. So, it is IF SET field1 etc? Regards Rick
Forum: WampServer English

I saw that, but surely that searches a number of columns for the same data...mine is almost opposite.. I need search lastname if someone has entered a name or search postcode if the postcode field was used etc etc Rick
Forum: WampServer English

Hi I had similar problems and it was all down to ensuring that all the log ons and passwords were correct in the congif files. Rick
Forum: WampServer English

Hi I want to build a search page allowing the user to add info to one of a number of fields and use this as the search criteria. At first I thought that this would be a 'WHERE field1=?? OR field2=??, but this uses NULL for those fields not used. Is there a way other than using an if statement such as if field1!="" use this info else if field2 etc? You can tell I am a newbie to all
Forum: WampServer English

Thank you so much for that Steven...not saying that I will be able to put it into action without some further explanation, though, but I will try...I understand the process, but not too clear on how you replace the values on the second loop... I will experiment.. Best regards Rick
Forum: WampServer English

Let me explain more fully...just before I dive in and find a deadend: There is a club which takes members...they can either join singly or as a couple. WHen they join as a couple, both become members, but there is a join. The idea is to have two forms on screen for the couple and have each insert a record. Oh, by the way, I promise not to stalk you now you answered my question so fully...lo
Forum: WampServer English

Thanks Steven, That makes a whole lot of sense...I have taken a note of your code, but also taken you advice and used database query each time and it works a dream...thank you... While I am writing, there is something else you may have an opinion on...can you insert more than one row into a table from a single page? Regards Rick
Forum: WampServer English

Good point. However, my thinking is this...at the beginning of the code I draw in a dataset, which I understand is stored in memory. I then use this for a number of individual queries throughout the application rather than keep querying the database each time. Or is this wrong thinking? Bestest Rick
Forum: WampServer English

Hi all... I am a newbie, but am managing to get there. However, it appears I to still have some basics to get my head round. I have an SQL query and placed the resultant dataset into an array. How do I then search that array for a particular row? I can loop through and get the whole thing, but I need to be able to take a user input and use that to find a value in the array. I bet it is real
Forum: WampServer English

Thanks...all working now... Rick
Forum: WampServer English

Thanks for this....the resource appears to be defiinitive...can you give me some idea of where to start...this is all pretty daunting... Thanks Rick
Forum: WampServer English

I have used Wampserver to install apache, php and Mysql and with a few surmountable glitches it is all working fine. Until that is I tried to use Dreamweaver on another machine to build a site using a MySQL database. I get an wrror message saying: The testing server specified for this site does not map to the [127.0.0.1] Has anyone else found this? Dreamweaver is being run on a Mac, but I c
Forum: WampServer English