10,940 Topics
 | |
| | 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 … |
| | |
 | 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 … |
| | Hello everyone, I seem to be having a problem inserting some information into a MySQL table. Below is a copy of the MySQL table code I used and also the PHP code. I was wondering if anyone can help me find out why it wont insert the information. What I … |
| | 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, Im once having problems trying to retrieve information from one of my tables. I have a table with the following information: [code] CREATE TABLE `island2` ( `id` int(10) unsigned NOT NULL auto_increment, `user` int(11) NOT NULL default '0', `island` int(11) NOT NULL default '0', `town` int(11) NOT NULL … |
| | 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; using java as language  |
 | 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 … |
| | |
| | hello, basically ive got a while loop which brings up bookings dates but i want to send a selected row to a table within the sql table but depending on, one specific field for instance if the name = "tom" i want to send it to the table called tom, …  |
| | 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 … |
| | i have written a simple class for OOP in mysql and php and when i tested if even if the values that i used also in my normal connection process is the same the mysql won't connect me to it.. this is my class: [CODE] <?php class DBlink{ protected $link,$dbname,$uname,$passw,$db,$hname; … |
| | Hi everyone! :) I'm just starting out with php and mysql, and encountered the following problem: I have installed: Apache 2.2.8-1 PHP 5.2.5-7 MySQL 5.0.51-3 on an Arch-Linux system. Apache and PHP are working: I tested that. I can log in to mysql from the commandline; I made a small … |
| | As you know mysql is not compiled into php as of version 4, so you have to do some configuration for your php script to properly communicate with mysql server. I’m new to php/mysql development environment; at first everything was frustrating and you don’t get the help you require promptly. … |
| | 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 … |
| | hello im doing a driving instructor website for my project, and a driving instructor enters his or her times of booking and the search below gets the results and displays them, but i want the user to be able 2select upto 2results and once they have selected them they click … |
| | This code works but i want to add all the total costs up at the bottom of the search output, the[B] // Loop through data and display[/B] is outputs displayed from MySQL, from this code all i get is the total price for each booking but i want to add … |
| | Hello, I am having difficulties with this, I have been working weeks on getting a site finished and I'm down to the last couple of pages and this has become irritating. If you could help I would be very thankful. Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource …  |
| | 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 … |
The End.