11,093 Topics
 | |
 | 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 … |
| | Hi everyone, i am a newbie to PHP and i am struggling with the following error. i am trying to follow this [URL="http://www.roscripts.com/PHP_login_script-143.html"]link[/URL]l tutorial but its not working. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /Applications/MAMP/htdocs/functions.php on line 73 Warning: mysql_num_rows(): supplied argument is not … |
| | Hey all, first post here and im also very new to PHP, but been having major headaches over one query. The query simply inserts some data into a table, which i've done in myphpadmin, the myphpadmin looks like this: Registration_ID int(10) No auto_increment Registration_Date date No Academic_Year int(2) No Year_of_Study … |
| | 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 … |
| | Hi guys. I have a DB table looking like this: #DATE #NAME #C1 #C2 2007-08-27 user 1250 2294 2007-08-28 user 1816 3096 2007-08-29 user 89 3153 2007-08-30 user 71 2986 [..] I started collecting data in late August 2007 and it's being updated every day. I want to fetch the …  |
| | 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. … |
| | I have a timestamp column in a mysql table. Using PHP, how do I convert the timestamp format which is "YYYY-MM-DD HH:MM:SS" into a format like "March 16 2008, 08:41 am" ? Please help Thanx |
| | hi for all the expert here, i am now facing a minor problem on retrieving data here. MySQL do contain all the variables defined with data inside it. However, i juz need to know how to loop through the array to get all the data in a row? Below is … |
| | Hello, I created this site on my local machine using PHP 5.0.4 and mysql 4.1 and it works perfectly fine. I then ftp it to my webhost but the code to retrieve values give me this error. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/laterallinks/ApplicantInformation.php … |
| | i am trying to connect to my database which i have set up and i keep getting the same message 'could not connect'. i have a php page which sets up the database, and i recall this page with the include db.php to connect to the server. i have tried … |
| | anybody mind teach me how to connect between tables in db??say theres table a, b and c in db .how can i make all these table connected??theres any coding??im using EasyPHP as server  |
| | Dear all site members, my hosting provider says that there are SQL queries running from my i.p address (I am renting a dedicated server, if it matters to the question) to another i.p address on their network. Basically, something on my server is connecting to a MySql database on a … |
| | Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/doreen/public_html/trunk/template/posts.php on line 19 I don't know how to fix it |
 | hi , M facing the problem to get first 4 rows from the table . m using sql2000. i used count but it is showing total no of rows in a table . please let me know the query used to display rowcount. |
| | I need some help suggesting an elegant way of doing something. I'm currently in the planning phase of a media management solution that comes in two parts; The administration website, and the deployment website. What I'm considering doing is, at the time a member signs up for an account, I … |
| | How can I create a trigger to UPDATE this for me when a new record is inserted. I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column. In syntax: [code]UPDATE files SET fullthumb = CONCAT('http://example.com/thumbs/', thumb);[/code] I … |
| | Hey everybody, I'm new to mysql, but I'm developing a real estate website, mostly for condos. I'm setting up the database and want to make sure it's sufficiently designed so that customers can search the database for the type of place they want. Specifically, if someone wants to search for … |
| | i have created an image upload page in my web site which stores the images on the server using php. i now need to get the images to display on a different page. here is the code i have used to set a variable to the file directory // the … |
| | What would fundamentally change with MySQL between using XAMP or WAMPserver so as to render MySQL inaccessible, triggering a MySQL 2003 error code? Last Sunday I was comparing XAMPP with Wampserver. I used the same MySQL database. I approached the experiment from the analogous point of view of using the …  |
| | Could some please help me. I am following a tutorial from "http://www.devarticles.com/c/a/MySQL/Building-A-Persistent-Shopping-Cart-With-PHP-and-MySQL/2/" I keep getting a " Parse error: syntax error, unexpected $end in C:\xampp\htdocs\cart1\products.php on line 59" My db connection is fine but I am trying bring a result from the diagram shown in the url. Please help. This … |
| | How to create a trigger to UPDATE this for me when a new record is inserted. I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column. UPDATE files SET fullthumb = CONCAT('http://example.com/thumbs/', thumb); |
| | Ok I got a new multimedia search engine that im hoping to launch pretty soon. ([URL="http://im1musicc.cs-webhost.com/search/"]temporary link here[/URL]) I all ready got the number of mp3 downloads counter set up there using flat files, but I didnt do that. It was all ready done when I got the script. Now … |
 | [code=mysql] $result = mysql_query("SELECT * FROM cycles WHERE Upper(brand) LIKE '%$brandC%' AND type LIKE '%$typeC%'"); [/code] Above code is not working, pls help. |
| | Attached to this thread is the DB schema I've come up with. I'm trying to do an outer join to join the exercises to the submissions regardless if there's a related record in the submissions table. Trouble is when a user logs in I want to execute this query and … |
| | i have a text area where user can enter some notes ,i save that in database by taking text as data type ,and while retrieving it through Ajax its not retrieving as each new line in text area is entered as a special character ,please help me anyone to get …  |
The End.