Yes, I have received replies in that newsgroup, but no solution as yet. And no solutions here either. If I had a solution, it would have been noted and posted here. Thanks for your help. You can...

I have code that successfully displays results, but throws an error in
Fx 3 and IE 6.

A sample of the XML file:

<?xml version="1.0" encoding="ISO-8859-1"?>
<mycds>
<cd>
<title>Wolf...

How have you determined that the data is lost? Just by trying to connect through the MySQL server?

Look for the actual files that make up your database. Since we still don't know what OS you are...

Your data is probably fine, but it sounds like you may have to install the mysql server again.

How did you 'copy all the files over'?

What versions of MySQL are running on your original host, and on your new host?

There are a few things that can munge a migration, but knowing the answers...

Huh. Yes that is very strange. Glad you got it figured out though. And thanks for posting the solution in case someone else runs into this.

Can you execute

DELETE FROM images WHERE image_id = 803 AND plant_num = 2277 LIMIT 1;

from the command line?

Can you execute that literal string from your script?

Your script might not...

What does
SELECT * FROM images WHERE image_id = 803 AND plant_num = 2277\G


show you? If you can't find that image, then obviously you can't delete it.

What does your PHP query statement print out as? I'm betting it's not what you think it is.

Also, a describe images would help us help you.

It is generally more practical to save the path to the images in the database, rather than the images. This applies to any binary file. Let the OS file system take care of the files.

If you save...

bcasp is pointing you in the right direction. As a further enlightenment, any time you ask yourself the question 'what if column X has more than Y choices' is an indication that that column should be...

Again, I have to ask: does your query work from the command line? If you are not sending the right query, then you won't get the right results.

I don't know what 'annons.område' is but you are...

I notice you have some non-standard characters in the query. You might be trying to match something from one character set to something in a different character set.


WHERE...

This is good advice. Whenever you have a field / column with multiple values that's a clue to pull it out and put it in a separate table.

I'm not sure what you mean by 'FE' or 'BE', but if you are planning on mounting this database on a web server I suggest you forget about using Access. Actually Access is not even the database, but...

What have you got so far?

In order for your images to be available via a web link, they have to be in the 'public' tree of your web server. Think of where you put images to be displayed on a web site. The images you want to...

You are correct. In this case the message has to be sent as HTML.
Use Content-Type: multipart/mixed;

You can't 'display' an image in an email. You can however attach a file to an email and send that. However that is not a MySQL topic. You would be better in a forum for the language you are using to...

Can you not use the \G switch?


select * from customers \G


This displays the field names vertically instead of across the top. At least in 5.* it does.

Otherwise you will have to play...

Why not just access the database using the 'mysql' client side program?


mysql -hwww.yourwebsite.com -uyourusername -p


This will prompt you for the password. Once you are logged in you have...

Is this any help?
http://dev.mysql.com/tech-resources/articles/wizard/index.html

http://www.tek-tips.com/viewthread.cfm?qid=1289414&page=1

Where have you looked?

The Perl FAQ that comes with every Perl distribution contains
'How can I lock a file?' I suggest you start there.

The use of 'strict' controls the scope of your variables. It forces you to practice good programming by not using global variables, and to declare all variables before use. There are some situations...

Try to get in the habit of putting

use strict;
use warnings;

at the start of your scripts and it will save you a lot of frustration and time later on. Also, if you ever post to...

The typical solution to this is not to save the image in the database, but the path to the image (or any large binary file for that matter).

MySQL can handle binary data but it is hardly worth the...

47000 records is trivial - MySQL can handle billions of records, and many companies use it for large databases and heavy traffic.

I'm not sure what kinds of queries you will be making, but one...

First I suggest you sit down with a good book on relational database design ('Database Design For Mere Mortals' by Michael Hernandez and 'MySQL' by Paul DuBois come to mind). We can help you help...

Well, you sort of have the right idea with primary keys and foreign keys. But really what you need is to get a good handle on design. I'm not familiar with that book, but if you can get your hands on...

You might want to investigate indexing.

If that is your only reason, then again, the suggested solution of setting a 'Display' field to True or False should suffice for your needs. If not can you explain why not? It seems to be quite a...

From your description, blater's solution will do what you want. If you want to 'delete' a record, why move it to another table - just delete it. However for some reason you want to retain the data,...

There may be a problem with that field named 'DATE', as that is a reserved word. It will always have to be quoted in every query. Perhaps better to rename it 'OrderDate' or something that makes sense.

Your design seems to be well on the way to what you want. In your 'Job Task Table output' you might want to replace the task ID with what the actual task is, unless you can remember what a task_id...

What command did you try to execute? Copy and paste exactly what is on your command line, and the resulting screen.

You didn't mention this initially. I take it these are members of the same family, sharing a last name and address? In that case, then you could break out the address into a separate table.

You might be on the right track for 3NF but I suggest you take a closer look at your overall design.

You have a client table, but it is mostly populated with IDs for other client-related data....

Then you should be looking in the documentation for that editor, or posting your query in a forum for the same. There is no MySQL question here that I can see.

If you are paying for your disk space then you shouldn't have a problem. However, my understanding (from others) is that any freebie host has to get revenue from somewhere, so they place ads on their...

Unless your company plans on saving the order data for future use, a database is not necessary for this. Which is not to say you shouldn't log attempts to log in with date/time stamp, IP address,...