7,368 Topics
| |
Hi all, I've problem with inserting data values from .csv file to MySQL data table. My query as follows; LOAD DATA INFILE 'C/Customers.csv' INTO TABLE pc.customers FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (CustID, RegDate, CName, CAddress, CPhone1, CPhone2, Order_OrderID) It returns error msg as follows; **Error Code: 1406. … | |
Hi, I am a complete novice with MySQL but have been persevering with it for a project I am doing at work. I have created a results server to analyse and collect data I receive from quizzes I have created using QuestionWriter HTML5. I have figured out how to run … | |
My school has an apache/mysql server that we make and host websites from as projects. I am doing an ebay type site where people bid on a product until time runs out. Problem is I don't know how to trigger that the product should be delisted and the buyer and … | |
| HI, I am new to mysql and have two problems. 1. I have two tables that need to have same values from one field , if that values are not same in second table change it to value of first table Frist table is ps_product and they all need to … |
Hi im a beginner in mysql land and i need to derive AGE from my D.O.B column i am wondering if someone could explain how and whether you could break it down more simply... i know im asking alot but we all have to learn .. thanks hopefully barb :D | |
I've been trying to make dynamic queries, where the user determines what will be queried. The reason is because I'd like the images being displayed in my gallery reflect the category selected by the user. mysql_query("SELECT(whatever category they chose) FROM products") below is the generation of categories as links. (not … | |
Hello, I'm sure I'm missing something small. If a category doesn't exist in the database yet, how can I have the query accept a value of 0 without reporting an error? The $subcategory is what the user selected. The result should either be 4 images or a blank place holder … | |
I'm new to MySQL and following a tutorial in a book to design a PHP MySQL website. Following this tutorial, I created a PHP page from which I can update entries in the MySQL database. What's strange is that only specific entries in the database will not update, while others … | |
hi i have a table like this for attendence: table name attendence. id std_rolNum std_fname date std_bkfast std_lunch std_dinner i want to make search on the base of `date`, `std_rolnum`, `std_lunch`, `std_bkfast` and `std_dinner`. so that if on the same date if student have already taken breakfast, lunch or dinner … | |
hi m getting the following exception: `System.Data.SqlClient.SqlException: Incorrect syntax near '4'.` the following is what i was trying: public void hostel_cpacity(ManageHostelRoomsBE hmr) { string str; string conString = System.Configuration.ConfigurationManager.ConnectionStrings["Hosteluog"].ConnectionString; SqlConnection con = new SqlConnection(conString); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; con.Open(); DataTable dt = new DataTable(); DataTable dt1 … | |
Hi All, I need to optimise the below query. The below query takes 13 seconds to run on live. Kindly, suggest how I can optimise this query and how can I index the table? The query is as mentioned below:- SELECT *, a.forxmlfeed, a.lastupdated, a.mark_for_deletion, a.is_mixed_use, p.value as projtypeformixuse, b.active … | |
Hello, It is my first time to post here. I have been spending many hours trying to figure out how to get imagedata from my MYSQL database. I have tried these following codes but it wont work for me. view.php <html> <head> </head> <body> </body> <?php include "dbconn.php"; $sql = … | |
I'm not sure that my title is descriptive enough, but here is what I need to do... I had a bit of a screwup today with launching a site... Within about 10 minutes of opening the site, the members created 337 transactions (stored in trans_table) Each of those transaction should … | |
| I want to check if value is already exists in database with php. But this value can be as for example "John" or "JOHN" or "JOhn" or ... e.t.c how to check for all conditions? |
Hi, I made a table named staff_info containing 4 column name,day,duty_start,duty_finish. This table still have no parimary key. Now assume that there are 4 staff and they do their work in each day of the week.That means in each day there work 4 staff and 1 staff work in 7 … | |
hi i have the following problem after importing databse in c#. i have import a mdf database in C#. but it has exception after pressing `F5` for debugging. `A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. … | |
Hi all, using these tables, Im trying to write a query that will list the students that have taken any type of class (class_level) and how many of that particular type they have taken so using a count of somekind. Tables: ATTAIN PK FK Rank_Num integer refers to RANK PK … | |
Hi guyz , PHP newbie and this piece is givin me a hard time please Help, have indicated the source of the error with a comment <?php ob_start(); include("dataaccess.php"); ?> <?php $strAction = "list"; $num = ""; $strTable = ""; $strkey = ""; if(!empty($_POST)) { if (trim($strTable) == "" ) … | |
Thanks you all in advance. I want to make a website showing the result of exams that are conducted in India. I want the user to enter his/her Roll Number in the form created at my website and as he/she press enter. His/her results should be displayed on the page. … | |
Hello all: I have the following mysql query statement: SELECT COUNT(*) as ttl_rows FROM (SELECT DISTINCT(date(timeentry)) AS day, COUNT(*) AS total FROM history where MONTH(CAST(timeentry as date)) = MONTH(NOW()) AND YEAR(CAST(timeentry as date)) = YEAR(NOW()) GROUP BY DATE_FORMAT(timeentry, '%d') ASC) as ttl_row the statement performs a search for all records … | |
I'm having some trouble with selecting the Max values of three different tables in my SQL. I have 3 tables Car [CarID, Name] - Price [CarID, Price] - Group [GroupID, CarID] With these Values Car: CarID --- Name 1 ------- Car1 2 ------- Car2 3 ------- Car3 Price: CarID --- … | |
Hi all. I am a beginner in Zend and I am wondering if there is any good book or tutorial for developing applications with Zend Framework, using json for data encoding and decoding and how to use jquery with Zend. Thanks. | |
Hi! I cannot figure out how to install and use a database that I am given for a project. I'm running Windows 7. Can anybody help me? | |
Hi; I have an sql database with a table called: "stardate" with default value set up with "dat" I want to modify this column default value to current date (server side) I'm trying this: Alter table my_table Modify startdate DATE DEFAULT CURRENT_TIMESTAMP; with this error: Error Code: 1067. Invalid default … | |
Please people, i'm trying to create a chat room, and .... I jst nid some guidance pls | |
HI Im looking for a javascript game to download for free so I can give my users on my website a way to get points. so the points that they get in a javascript game would be added to the mysql database to add the points into their account. does … | |
hello, i'm having trouble getting my delete selected checkbox working for a code I'm writing: the trouble is really just in the bottom half of the code after i make the while loop...i made this off of an example that i found on a site but like it was pretty … | |
Dear Experts, my website was hacked yesterday and when i retrieve my website it will give Ã, ¢â etc these character in my each and every page and post. Kindly tell me step by step process to remove these characters. I am new here sor plz kindly tell me step … | |
Hi, I'm really hoping someone can help me. I've created a clocking system. The user clocks in,the clockin time is stored in the db, the user clocks out, the time is stored in the db. However, I want to store the difference, in other words the hours that would've been … |
The End.