pauper_i

XMB has an install script which will create the tables for you ... you have to give it a username and password for your database and it does the rest. Just make sure you read the instructions properly and don\'t try taking any shortcuts. D

Did you update the directory index: ?

Take a look at Trio Of Trouble - In Windows by Liam Getreu - it walks you through the configuration step by step for windows!

DROP TABLE address_book; DROP TABLE address_format; DROP TABLE banners; DROP TABLE banners_history; DROP TABLE categories; DROP TABLE categories_description; DROP TABLE configuration; DROP TABLE configuration_group; DROP TABLE counter; DROP TABLE counter_history; DROP TABLE countries; DROP TABLE currencies; DROP TABLE customers; DROP TABLE customers_basket; DROP TABLE customers_basket_attributes; DROP TABLE customers_info; DROP TABLE geo_zones; DROP TABLE languages; DROP TABLE manufacturers; DROP TABLE manufacturers_info; DROP TABLE newsletters; DROP TABLE orders; DROP TABLE orders_products; DROP TABLE orders_products_attributes; DROP TABLE orders_products_download; DROP TABLE orders_status; DROP TABLE orders_status_history; DROP TABLE orders_total; DROP TABLE products; DROP TABLE products_attributes; DROP TABLE products_attributes_download; DROP TABLE products_description; DROP TABLE products_notifications; DROP TABLE products_options; DROP TABLE products_options_values; DROP TABLE products_options_values_to_products_options; DROP TABLE products_to_categories; DROP TABLE reviews; DROP TABLE reviews_description; DROP TABLE sessions; DROP TABLE specials; DROP TABLE tax_class; DROP TABLE tax_rates; DROP TABLE whos_online; DROP TABLE zones; DROP TABLE zones_to_geo_zones; Just a simple parse from the information you provided.

Take a look at the DATE_ADD(date,INTERVAL expr type) and DATE_SUB(date,INTERVAL expr type) functions: http://www.mysql.com/doc/en/Date_and_time_..._functions.html

Hi Nick! Not wishing to pour gasoline on your personal hell, but just an observation: If you had picked up a MySQL book on the day you posted in the first of those forums you could have answered your own question by now. 11 days later, and you are still looking for someone else to answer the questions for you! The biggest problem you are facing is that you are providing too much information of the wrong type, and not enough of the right type: Don\'t bother explaining about the sybase crossover - a lot of MySQL programmers will see that and skip to the next question. Get it working in MySQL then worry about the changeover afterwards. You are apparently trying to synch up two tables: please define what you mean by \'synch up\' - same info in both? Replicate any changes in one to the other??? Why? Why not just store the changes one time and access that info from both tables? If this is a replicated table, then why is the data structure different? I\'m sorry, but there are too many questions left open, it would take a book to write out all the possible answers. Please sit down and rethink your problem, see if you can define it for us as simply as possible, outlining the information we need. It would appear that the basic fundamental issue here is database design - I realise that having had this dumped in your lap this is probably not a good time to adddress this, but it would probably be easier to get the databases redesigned now than to fudge around the issues and have to cross many more bridges further down the road. Hope that helps! D

Crossposted: http://www.phpfreaks.com/forums/topic9906.php Please don\'t crosspost. It only means we have to read, and often research the same question multiple times when we could be spending our time on another question or maybe even with our families! Thanks!

http://www.phpfreaks.com/phpref/2.php How many concurrent queries are you running?

Hi Jointy, I\'m assuming you can probably read English so I\'ll keep it in this language so that others can check my answer: From what I can understand with my very rusty German, you are not getting the same results from MySQL as you do from PHP with the MD5 checksum. Looking at your code, however, you are using a double checksum and I think that that is where you may be hitting the problem. Try removing the SHA1 functions, leaving only the MD5 functions and it may cure your problem! The SHA1 version is based on a different RFC from the MD5 version, although the two are fairly similar in their operation, the difference being the algorithm used where the MD5 version operates on 448 bits while the SHA1 version operates on 512 bits. You can read the RFCs for MD5 - RFC1321 and SHA-1 - RFC3174 for full details. (Is the SHA1 capability included in versions of both MySQL and PHP exported outside the US?) Basically, you are calculating a checksum of the password, then creating a checksum of the checksum. I don\'t know whether you took this step in your original checksum of the database stored version, but one or the other is fine, you don\'t normally need both. Could we see the code used to create the field \'MD5 AS hash\'?

There are many pro\'s and con\'s for Dreamweaver. Its a complete package and, if you are prepared to use it correctly, it will do a lot for you. On the other hand, there\'s a lot to be said for hand coding too! You will probably find that most of the people on this forum use different editors, and most use more than one. Lets look at your problem and attack it from there: Your data is currently in Access and you want to port it over to MySQL. You don\'t mention what the current front end is: ASP or VBA Access - it does make a difference! If your current front end is in ASP, there are tools available that will convert your ASP into (sort of) PHP. There will still be some tweaking to do, but it will save you a lot of time. If on the other hand the code is in VBA Access, then I\'d suggest you sit down with a stack of blank paper and start writing your requirements since you are going to have to recode it from the ground up. In the former case (ASP), you could probably use notepad, but I\'d lean more towards a good editor such as HTMLKit (www.chami.com). In the latter case, you should probably go with dreamweaver since it will help to maintain continuity between the pages. The final choice is yours to make - there are many posts in this forum comparing the worths of different editors, take a browse through and you will find 400 different opinions! Good luck! D

Not wishing to be the bearer of bad news but ... Your present path includes spaces. Since Apache is really *nix code that has been tweaked to run on windows, it has a whole different idea as to how spaces should appear in a directory listing. Alternatives: * Reinstall apache to a different folder without spaces - pain in the butt, but pays off in the long run. * change your paths to reflect the 8.3 names - easy quick fix, but now you have to do this for every script from now until forever! Using the 8.3 syntax. your path would look something like: C:/Progra~1/Apache~1/Apache2/bin/password.exe You might want to use the DIR command with the /X parameter to get the long and short directory names so you can verify the actual number used after the tilde. Hope that resolves your problem! D

http://www.google.com/search?hl=en&ie=UTF-...lpdesk+software

If you\'ve installed mysql then you will need to configure that too. Part of the configuration is to provide a username and password for access to it. Do you need the mysql part? D

No guarantees on this one, but it may help. Since you are in an intranet environment, grab a copy of the Internet Explorer Administration Kit (IEAK) 6 SP1 and redeploy IE to your users with customised settings. This should allow you to turn the darn bug OFF before you roll it out. Just an idea - overkill perhaps, but I assume you\'re using some form of centralised software deployment so it shouldn\'t be a major problem to do. D

OK, lets start at the bottom and work upwards: Configuring Apache to work on your machine - Take a look at the tutorials, scroll to the bottom of the page and select the one that is appropriate for your OS and it will explain how to configure it. Drag and drop uploads can be done but need a bit of coding to set them up - you might consider using an FTP server on your machine also, you can open a browser to that and drag and drop will work right out of the box. Displaying the contents of a directory is simple enough ... The setup of the httpd.conf (the apache configuration file) defines which files go active if someone browses to a directory. On my test server I have index.html set up so if that file exists it will open automatically. On folders where I want to be able to browse directories, I simply rename the index file to index.htm - it will still work but no longer opens automatically so I can browse the directory. One thing you haven\'t mentioned in all this is security. Please bear in mind that these steps will leave the machine wide open to abuse from internet, so you need to consider at least password protection to prevent this (assuming that the machine is open to internet of course!) Hope that helps! D

Whoops! My goof! I\'ve been playing with NT too much lately and have barely even booted up and of the Win9x boxes! hosts should be in c:windows the rest of the details are as I gave you: 127.0.0.1 localhost should be on the first line or at least under the commented lines (comment lines start with \'#\') Once you fix this, everything else should start falling into place. D

OK, you have a problem with your hosts file. This file tells the machine who it is - don\'t panic, its just a text file! Assuming you have a standard installation, the file should be located in c:windowssystemdriversetc It will be named HOSTS and has no extension. When you double click it, select NOTEPAD to open it with (do NOT use wordpad or any other word processor!!) The very first entry should be 127.0.0.1 localhost The number of spaces is not important so long as there is at least one. Check to make sure that that is where it should be - if you change it, you will need to reboot the machine to make the changes stick. Then you can retry the http://localhost and see what comes up. D

Well, you can put your windows install CDs away - go and take a look at http://tud.at/programm/apache-ssl-win32-howto.php3. There is a link from there to an apache 2.x version but it seems to be on a linux install, so you might have to fudge a bit between the two! Hope that helps! D Oh yes, and if you\'re looking for somewhere to send that fee to, there\'s a paypal link on the front page of phpfreaks.com that will help keep this forum alive!

Check your hosts file and make sure that there is an entry for localhost in it. Does it work if you type http://localhost/anyphpfile.php ? What is the default file type set to in your httpd.conf ? Here\'s mine for a comparison: Note that this is from my test server, so the index.htm option is left off deliberately - a lazy way of allowing directory browsing when I need it!

The objective here is to eliminate the obvious first before digging deeper: Put a test html file (just displays \'test\' or something) in the folder where the php file is located and try loading that into your browser through the web server. Then rename the same html file to a php extension and try it again, see if it comes up. If it comes up the first time, your folder is working, if not then you have a problem in your Apache setup. If it fails as a php file, then your problem is in PHP setup. If it works the second time, then we need to have a rethink!! Let us know how you get on! D

URL <> PHP URL == Apache You have a problem in your Apache configuration. It isn\'t a case of the file isn\'t executing (PHP), rather it isn\'t being found at all. Are your .HTML files working correctly?

Have a look at the tutorial on this subject at http://phpfreaks.com/tutorials/73/0.php, it should give you exactly what you need! D

If you have 10 gallons of water, it\'s going to take the same ammount of space whether you store it in pint jugs or gallon jugs. The trick here isn\'t the space taken by the storage, but rather the speed of access to the storage. Lets look at this logically. From the information you have provided, this would appear to be some kind of payroll system, so lets look at the information based on how often it is going to be used: Employee ID: This is going to be hit every time, for every record, so it need to become the cornerstone of your system. In order to access it, you will probably need first and last names, middle initial (if any), social security number and possibly a department. This will make your first table. I don\'t know what other fields you have in this genre, so you may want to adjust this slightly. Employee data: An employee joins the company and their data is entered. They leave, and it gets deleted or marked as inactive. Uness they move address, change departments or whatever, this data isn\'t going to change much so lump the majority of it into one big table or two smaller ones - the first with data which the employee can change (address, phone, etc.) and the second with data which remains \'untouchable\' to the employee - last pay review, performance review, start date etc. Payroll data: This is going to be hit every pay period (weekly, bi-weekly, monthly) so it needs to be a fast, lightweight table with the necessary information only to allow the payroll calculations to run at optimum speed. Payroll history: This will be where the results of the payroll are stored as a history - it gets appended to by the payroll program, but lookups on it are probably infrequent. With this information, you can now start categorizing your fields and assigning them to their eventual tables. Naturally, all of this is based on assumptions made from what is in your post. To arrive at 900 float fields, you are probably storing a lot of history in there that could probably be better stored in a table rather than in a record. Hope that helps! D

take a look at the code implications: Metalblend: Your version: Why would you go to the well three times when you can do the job in one. In other words, your server is going to work its butt off trying to keep up with your extra queries when it doesn\'t need to since you could pull the same info all in one go and access it from a memory array! D

Now there\'s one I didn\'t know! Thanks for the info! (Betcha I still get it wrong when it comes time to use it though!) D