ferensick

Not enough info is given here... such as, db used, is this front-end, back-end, etc? One way to do this is to simply use a SELECT statement. [code=sql]SELECT * FROM <table1> WHERE <field1> LIKE '%value%'[/code] The best bet is to have the statements automatically generated, having the <tables> and <fields> …

Hi kishan112, Which storage engine are you using (MyISAM, InnoDB)? And how many records are expected to be returned? Out of curiosity how are you executing the query? (via phpMyAdmin, MySQL Administrator)?

Hi lifeworks, this could work, but does it matter which image is pulled for each product? [code=sql]SELECT * FROM products, images WHERE products.id = images.product_id ORDER BY ____ LIMIT 0, 1[/code] Depending what your ORDER BY column(s) are, will determine which image is selected first... this could help if you …

re: vnanaji - mysql installation I've seen this problem before. I recommend using a more current version. However your problem is that you have to run the script from the root dir where MySql is installed. ./scripts/mysql_install_db --user=mysql

To Generate HTML based on your MySQL database you can use QCODO: [url]http://www.qcodo.com/[/url] I've used this before and it's pretty handy. Also what is the overall objective? Are you trying to manage your DB via your web browser? Or are you trying to make a simple report? For managing PHPMyAdmin …

Pretty much as mentioned the constraints are the way to go. You can use a lookup table to easily do this as well. So you have your lkp_Status table, just with those 3 values. And you can create a primary foreign key constraint as well. This way in the future …

This seems like a pretty big project. But there are some useful tools or apps that have been developed already doing these types of things... such as: [url]http://www.phpguru.org/static/TableEditor.html[/url] Possibly this could be used and modified to fit your needs. Have you started anything at all? Are you using a framework …

Hi, It seems that your .xls file is being shared. Turn the sharing off and you should not have this issue anymore. I know it Excel 2003, when you open the .xls file you can change the sharing option under TOOLS in the menu bar. I am not sure where …

Possibly this is solved already. (I hope) =) Nonetheless, what I noticed that wasn't mentioned are the file formats. Yes they are both .CSV however Lowes2.csv is in a MAC ANSI file format and the other is in a Windows ANSI file format. This makes a difference with the line …

Take a look at this if you have not already: [url]http://dev.mysql.com/doc/refman/5.1/en/out-of-memory.html[/url] "[I]To remedy the problem, first check whether your query is correct. Is it reasonable that it should return so many rows? If not, correct the query and try again. Otherwise, you can invoke mysql with the --quick option. This …

[B]cgyrob[/B] is correct. In general for simple joins there is no performance difference. If you have larger complicated queries with several filters and joins or subqueries, strictly for readability it would be better to use the proper JOIN syntax so the filters and join conditions can easily be separated. Keep …