Forum: MySQL  5 Days Ago |
| Replies: 1 Views: 119 |
| Forum: MySQL 9 Days Ago |
| Replies: 10 Views: 275 Re: MySQL Error 1064 when DELETEing
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. |
| Forum: MySQL 9 Days Ago |
| Replies: 10 Views: 275 Re: MySQL Error 1064 when DELETEing
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 have the... |
| Forum: MySQL 9 Days Ago |
| Replies: 10 Views: 275 Re: MySQL Error 1064 when DELETEing
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. |
| Forum: MySQL 9 Days Ago |
| Replies: 10 Views: 275 Re: MySQL Error 1064 when DELETEing
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. |
| Forum: MySQL 15 Days Ago |
| Replies: 2 Views: 265 Re: Image Database
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... |
| Forum: Database Design 16 Days Ago |
| Replies: 3 Views: 367 Re: expandable tables?
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... |
| Forum: MySQL 19 Days Ago |
| Replies: 5 Views: 202 Re: to make a link
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... |
| Forum: MySQL 20 Days Ago |
| Replies: 5 Views: 202 Re: to make a link
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... |
| Forum: Database Design 23 Days Ago |
| Replies: 4 Views: 322 |
| Forum: Database Design 23 Days Ago |
| Replies: 1 Views: 264 Re: Newbie Question
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... |
| Forum: Database Design 23 Days Ago |
| Replies: 2 Views: 279 |
| Forum: MySQL 26 Days Ago |
| Replies: 6 Views: 313 Re: absolute paths
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... |
| Forum: MySQL 26 Days Ago |
| Replies: 6 Views: 313 Re: absolute paths
You are correct. In this case the message has to be sent as HTML.
Use Content-Type: multipart/mixed; |
| Forum: MySQL 26 Days Ago |
| Replies: 6 Views: 313 Re: absolute paths
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... |
| Forum: MySQL 26 Days Ago |
| Replies: 3 Views: 258 Re: command prompt view
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 with your... |
| Forum: MySQL 26 Days Ago |
| Replies: 4 Views: 393 Re: How do I edit a file in MySql please?
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... |
| Forum: MySQL 26 Days Ago |
| Replies: 2 Views: 346 Re: Pivot table report
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 |
| Forum: Perl 26 Days Ago |
| Replies: 1 Views: 217 |
| Forum: Perl Apr 9th, 2008 |
| Replies: 6 Views: 415 Re: Question on Creating Hashes
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... |
| Forum: Perl Apr 8th, 2008 |
| Replies: 6 Views: 415 Re: Question on Creating Hashes
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 comp.lang.perl.misc,... |
| Forum: MySQL Apr 8th, 2008 |
| Replies: 3 Views: 426 Re: saving image as longblob
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... |
| Forum: Database Design Apr 8th, 2008 |
| Replies: 5 Views: 529 Re: database design advice
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 point... |
| Forum: Database Design Apr 8th, 2008 |
| Replies: 5 Views: 529 Re: database design advice
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... |
| Forum: MySQL Apr 4th, 2008 |
| Replies: 1 Views: 250 Re: database structure theory question?
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... |
| Forum: MySQL Apr 4th, 2008 |
| Replies: 1 Views: 247 |
| Forum: Database Design Apr 4th, 2008 |
| Replies: 6 Views: 570 Re: To delete or not to delete - DESIGN ISSUE!
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... |
| Forum: Database Design Apr 3rd, 2008 |
| Replies: 6 Views: 570 Re: To delete or not to delete - DESIGN ISSUE!
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,... |
| Forum: MySQL Apr 3rd, 2008 |
| Replies: 8 Views: 342 Re: mysql problem
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. |
| Forum: Database Design Apr 2nd, 2008 |
| Replies: 1 Views: 361 Re: Simple Job Logging Database
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... |
| Forum: MySQL Apr 2nd, 2008 |
| Replies: 8 Views: 342 Re: mysql problem
What command did you try to execute? Copy and paste exactly what is on your command line, and the resulting screen. |
| Forum: Database Design Mar 27th, 2008 |
| Replies: 3 Views: 429 Re: Database Design Help and Suggestions
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. |
| Forum: Database Design Mar 27th, 2008 |
| Replies: 3 Views: 429 Re: Database Design Help and Suggestions
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. Why... |
| Forum: MySQL Mar 27th, 2008 |
| Replies: 3 Views: 298 Re: i need help
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. |
| Forum: MySQL Mar 24th, 2008 |
| Replies: 3 Views: 210 Re: Please Help - Login page needed
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... |
| Forum: MySQL Mar 24th, 2008 |
| Replies: 3 Views: 210 Re: Please Help - Login page needed
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,... |
| Forum: MySQL Mar 22nd, 2008 |
| Replies: 3 Views: 298 Re: i need help
I'm confused. Are you asking for help with MySQL or an HTML editor called InnovaStudio?
We can only help you with MySQL questions here. With that in mind, you say that
So if there is no connection... |
| Forum: MySQL Mar 19th, 2008 |
| Replies: 5 Views: 473 |
| Forum: Database Design Mar 19th, 2008 |
| Replies: 7 Views: 402 Re: Product DB
What tables? Do a 'describe' for each table and post it, along with what exactly you are having trouble with. |
| Forum: Database Design Mar 19th, 2008 |
| Replies: 7 Views: 402 Re: Product DB
You already have the basic information you need to start the database: item name, color, size, cost, price, etc. So make those fields in a Products table and start populating them. Include an ID... |
