[mysql] Forum Topics

how to write nested queries ex: [code=sql]SELECT * FROM [table1] WHERE [column] IN (SELECT [column] FROM [table2])[/code] in a function. i tried this but MYSQL is getting stoped. is there any alternate.

Hi all. I have posted on this before with no response. Let me try a different way. I have a db with a few tables :- ATHLETE, which contains fields ATHLETE (the record Id), FIRST, LAST, AGE and SEX; MEET, with fields MEET (the record Id), and MNAME; RESULT, with …

hello i am trying to display an image from a database which has just been uploaded by the user. when they go onto the next page the image should be displayed here. I have been able to get it to display the path for the image that haas been stored …

i am trying created a table on the server called images and when i text to see if the table has been created i get the message table already exists. as i did not develop the rest o the site i thought a table might have been created already called …

Hello i am having a problem with trying to create a table on the server every time a try to enter data into the database i get the message table already exists. I have moved the code to create the table on to its own page and only recall that …

Hi, I can create all tables but order table. What is wrong, is it foreign key? [code=sql]CREATE TABLE customer( customerId INT(10) NOT NULL AUTO_INCREMENT, customerName VARCHAR(10), customerSurname VARCHAR(10), customerAddress VARCHAR(10), PRIMARY KEY (customerId)); CREATE TABLE order( orderId INT(10) NOT NULL AUTO_INCREMENT, customerId INT(10), PRIMARY KEY (orderId), FOREIGN KEY (customerId) REFERENCES …

Hello, I am using a GeoLite Country ip csv and storing it in the db. it contains ip numbers which are normally huge. My problems comes when I search for some of these numbers. my query: [CODE] SELECT * FROM range WHERE range1 >= 1213099967 [/CODE] This query works fine …

Hello this statement below works when the date is set as 02/02/2008 but when i enter it like this 2/2/2008 it dont search the date, in the database the date is set as 2/2/2008 because i need it in that format. i want to search dates from and to like …

i want to generate a query example: if the english question s given ->list all the details from my_table where name='smith' and age <30 it shld generate a mysql query for the question ->SELECT * FROM my_table WHERE name = 'Smith AND age < 30;

Dear programers, i am new to mysql and webhosting. i have one website script,i want to instal the same script to my two domain names(for example: domain1.com and domain2.com) i dont want to add this two domain like addon domain. i have two different hosting for this two domains. for …

is this possible, i had to use the mysql class to connect to the database, but i would rather use oledb. the connection string i used is "Provider=MySQLProv;Data Source=mySQLDB;User Id=myUsername;Password=myPassword" when i try to connect a popup titled "MySql Data Source Name Setup" always comes up. even if i try …

hello i am using Mysql plse send DataBase Connection and ROOt

Hi All, I am a Problem with Database. I Don't Know How Can i Import my Data in MySQL Database Using CSV Format. Can anyone Plz Help me. I am Using phpMyAdmin for Accessing my Database... Plz Help me.

If you read an earlier thread i started i was having completely the opposite problem that i am having now. Before it kept telling me that the table already existed and now it tells me the table does not exist. I have created the table in the db.php page where …

Girlfriend would like to learn about MySQL. Can you recommend any book that purely deal with MySQL? No adds on as PHP or any other web developing technology? I know there are many sites with great tutorials but she insist on book so I have the "pleasure" to find the …

Hello everyone! I am writing a music database, and I need to insert into album table the path to its cover. However, not every album has a cover in its directory, so I've made an algorithm that only gets the albumID that has a cover. My question is - how …

i have once again been asked to fix some code on a website. this time the website is meant to have a content management system but once again the person who made the original website did not complete what he started. the content management system side of it is using …

I am trying to set up a database on the server and keep getting the same error message. it say to me that it was successful in connecting to the db but access is denied for the user. what is causing this as the password and user name that is …

Hi all The following query works and gives me the desired results. The only problem is that it is very slow, and I suspect it is because of the multiple sub-queries included in it. The table, RESULT, has multiple records per athlete, per stroke, per distance stored in the order …

i am trying to recall data from my a database which someone else has set up. the site is a contnet management system and it uses innovaStudio which is a wysiwyg to do all the editing for the text on the website. the editor side of it works where it …

Hello everyone, I was elected to be the company "IT guy" at a printing company aside from my day-to-day job here (lucky me), and have done a minimal amount of coding (HTML, ASP), but could definitely use some help on this project. We have some large clients who insist on …

Hi, I have a question about how to select form a subquery. I'm attempting to count the number of times each m_id is returned after running this query: [code]SELECT m_id FROM taglink WHERE m_id <> '25' AND t_id IN ( SELECT t_id FROM taglink WHERE m_id = '25' )[/code] The …

What would I need to add so that I can return a count of the number of rows retrieved in the query? I am not sure where to include the COUNT (another query?) and then what syntax to use to print the result. thanks [CODE]$data = mysql_query('SELECT * FROM `bus_basic` …

Hi, Am sort of in a fix at the moment. Am at the stage of creating my database from my ER diagram of which certain tables rely on the InnoDB storage engine for referential integrity, transactions etc. By shockingly enough my ISP doesnt offer InnoDB table types due to the …

Hello All, I have declared one of my fields in the database as PropertyName varchar(100); Now the problem is that when I try to insert the text having an apostrophe using my html form it gives me an error. Can you please help me with the issue as I am …

I am running a .sql file against my database to build the tables. However Once i reach the Create tbl_static i recieve the following error on one of the insert statements: MySQL said: Documentation #1366 - Incorrect string value: '\x80\x99s Ba...' for column 'fld_description' at row 1 The Insert Statement …

I am relatively new to mysql. I am updating a site for a customer, and I'm using mysql 5 w/ phpMyAdmin. I was supplied an .sql (echeck.sql) script to build the database for this site. I create a database named "echeck" in phpMyAdmin, and once created go to the import …

hi all experts here, i am currently doing my web project using PHP and facing no clue for the database connection between 3 tables....here it is: i'd created 3 tables, one keeps users' username, password, and id....the other keeps the details that user input from a form...both contain a common …

i am adding elements to my db and the elemtents which have been add will be displayed on a different page. i am using an upload page which creates a thumb nail of an uploaded image and then stores the path for this image in a variable called $thumb_name. the …

Hello I'm trying to teach myself how to use mysql and php via a couple of books and a lot of hacking away. I have Jesse Feiler's book "How to Do everything with Web 2.0 Mashups" and I'm stuck on chapter 11 which is a practical exercise in mashup building. …