ferensick

Hi! How can I seach all of the fields of every table in a databae for a particular value? When it is found, I want to be able to display the table name and the field name, then continue to search.

Hi, can anyone please rewrite the following sql-query? It's working, but it takes some time to execute. [CODE=sql] SELECT `cd_e_calls`.`bedrijfs_id` AS gegevens_id, `gebeld` , `status` FROM `cd_e_calls` , `cd_e_gegevens` , `cd_e_negatief` WHERE `cd_e_gegevens`.`RvV` != '1' AND `bedrijfs_id` = ( SELECT `cd_e_gegevens`.`id` AS gegevens_id FROM `cd_e_gegevens` WHERE ( SELECT COUNT( `cd_e_calls`.`bedrijfs_id` …

Hi Im rubbish MySQL joins, and need an assist please. i have a product table and an images table. Each product has 4 images associated to it by a foreign key product id in the images table. I need to pull out the product info (from prod table) and 1 …

Hi friends I am new to mysql . After Installing mysql-standard-4.1.22-unknown-linux-gnu-x86_64-icc-glibc23 in linux i am getting the error ./mysql_install_db ./mysql_install_db: line 85: my_print_defaults: command not found Could not find help file 'fill_help_tables.sql' in ./support-files or inside .. pl help me how to overcome it Thanks in advance

i want to ask.......if i have the data in a database of mysql....how can I generate html, chart from the database(mysql)

hi I have a coulumn named Status which can have only three values: 1. Available (Default) 2. Unavailable 3. CheckedOut How can I add this functionality while creating the table? i.e. while creating the table itself how can i specify that the column can hold only these 3 values and …

Hi, anybody know on how to create table like this- [URL="http://mycbr-project.net/tableEditor.html"]table editor[/URL]- in MySQL? I need to retrieve the value & compare it with the query value ( I am doing this using php). help is really appreciated

Hello guys, i really need help with this one. This is the problem: I have a user with Windows Vista Home Premium and Office 2007 (Sony Vaio Laptop). When i start it and open a xls file its all ok, but if i close that file and i repoen it …

Hi, I'm trying to create a CSV file from Excel to upload into a MySQL db. It's for a web-based dealer locator called Lookup Runner. When I try to import my CSV it never works. The people at Lookup Runner (hitcode.com) did something to my CSVs and they worked like …

I've created a PHP web application in Dreamweaver, which uses a MySQL database, containing 14 tables. On one page, I use an SQL query to select data from 10 of the tables in the database. However, when I try to preview the page in a browser, a PHP warning stating …

I've also wanted to know which of the following is the better approach Does it actually have a difference??? where table1.userid = table2.userid using the proper join statments such as Inner join