7,368 Topics
|
|
I came up with this query now when i tried to create a view it failed to create SELECT aDate FROM ( SELECT @maxDate - INTERVAL (a.a+(10*b.a)+(100*c.a)+(1000*d.a)) DAY aDate FROM (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 … |
|
The code below is to select and then echo stuff from my db grouped by either weeks or months. I have a couple of more of these and then use offset to get the second week etc. FROM my_db WHERE DATE >= CURDATE() - INTERVAL 10 ".$grouping1." GROUP BY ".$grouping."(DATE) … |
|
Hello, I am using xampp for mysql: When I try to delete a database : "DROP DATABASE" statements are disabled. That statement appears. Why is it? What other alternative I could use? Thanks. |
|
Hi, I have imported a csv file but for some reason in some values the data after . is missing for e.g. If my value in csv is 0.5 it displays 0. and 5 went missing but in my csv file i have value as 0.5 I don't what step … |
|
I have tried many different scripts I have found but cannot find one that does exactly what I am looking for. I have a table that has parts with multiple characteristics. Part Number, Height, Width, Capacity, Price, Etc. I would like to have a drop downs for all of these … |
|
I have the following simple table: CustomerID CustomerName NumOfOrders 1 Joe 15 2 Jane 20 7 Clara 1 I want to find the customer with maximum number of orders. Seems trivial enough but I can,t seem to find a solution. |
|
Hi i'm practising in creating an android application where a user can store records into an external database (my local server in myphpadmin). I can store records into the the database just fine but I wish to prevent the same information being entered twice. I wish for my system to … |
|
Hi, I have imported .csv file and column is appearing as Col 1, Col 2... and the data I want as a column name is appearing as a first row. How do I convert my first row into column name in phpmyadmin. Thanks in advance |
|
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'some_user'@'abcd.efgh.com' (using password: YES) in /home/some_dir/public_html/some_dir/db.php on line 1 Fatal Error: MySql connection failed.Access denied for user 'some_user'@'abcd.efgh.com' (using password: YES) Here is my code of db.php <?php $connect = mysql_connect('www.example.com','some_user','some_password'); if(!$connect) die('Fatal Error: MySql connection failed.' . mysql_error()); $connect_db = mysql_select_db('db_name'); if(!$connect_db) … |
|
Hi! Ok, here's my problem... Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'hjhwkhjrf'@'10.1.1.43' (using password: YES) in /home/a6653219/public_html/connect.php on line 12 (pw changed) Lower part of connect.php..... $=line 12 // do not edit below this line!! /////////////////////////////////////////////////////////////////////// $dblink=MYSQL_CONNECT($MySqlHostname, $MySqlUsername, $MySqlPassword) or die("Could not connect to database"); @mysql_select_db("$MySqlDatabase") or die( "Could … |
|
Hi all I have an sql output query problem I am trying to resolve. The problem is that I have centres that offer Awards and quals and some centres only offer awards or quals only. What I need to process is the centres that offer both awards and quals. tbl.net.qualification … |
|
Hello, I'm trying to make notification when msql column reach a certain number. For exemple, I have table "items" with products, witch in their structure have columns id, name and quantity, and when column "quantity" reached 5, I want to make automatic notification: - In new table called "notifications" witch … |
|
HI! Just setting up my site... first thing I see after domain working is..... Fatal error: Call to undefined function session_is_registered() in /home/vhosts/www.universal-abundance.com/config.php on line 87 Any ideas..... I'm db impaired! Thanks, L-D |
|
Hello, I have a table called product and whenever the value of the field stock = 0 I want to send a notification email to a specific email address. I would like your help guys on how I can implement that and if this is possible. I considered using PHP … |
|
Hey everyone, Sorry for the lack of knowlege. I've tried google-ing how to imput and display images on a web page without the image showing up in weird symbols, but I've had no luck. Can anyone help me? My purpose is to simply store an image manually into a mysql … |
|
I have a MySQL dump and the dump has timestamp datatype. But the values are not escaped in qoutes. I want to write a regular expression to write to match the time tamp column and replace it by enclosing in quotes I have some thing like this: 2006-02-15 04:44:00 I … |
|
hi, im a newbie and just read about triggers.. i am trying to create a trigger using navicat for mysql in the triggers tab for the table i select new trigger with update after insert( these are the ready options it has) then in the definition i added ` DELIMITER … |
|
Hello Guys, During the process of making my website I have been stopped by a problem. Background Info: I am using jQuery sortable lists and I have multiple lists on the site which submit the information to the file that updates them in the database. Problem: If I want to … |
|
Hi All, I am running the following query: UPDATE YFR_Master_Fundraisers SET FRActive=0 WHERE FRNameCode IN ( SELECT FundRaiser FROM YFR_Master GROUP BY FundRaiser HAVING MAX(CollectionDate) < DATE_SUB(CURDATE(),INTERVAL 2 MONTH) ) It is giving the error described in the subject line. The query seems to be taking too long and timing … |
|
I need to get the Club_ID of all the clubs that have more than one member; Here is the sql: CREATE TABLE `Members` ( `ID` INT NOT NULL AUTO_INCREMENT , `Club_ID` INT NULL , `Name` VARCHAR(45) NULL , PRIMARY KEY (`ID`) ); INSERT INTO `Members` (`Club_ID`, `Name`) VALUES ('1', 'Jim'); … |
|
Hey guys, I want to connect my **VB.NET application to the data saved on my webserver's mysql database**. Can you please tell me, is it possible or not? Can you give me any hint for further coading? Where should i look for help in this regard? Or should I consider … |
|
I have to sync with two tables in the database The following is the error I get: *A database error has occurred Error Number: 1054 Unknown column 'Array' in 'field list' INSERT INTO `client` (`interior_client_name`, `Interior_client_email`, `interior_client_mobile`, `interior_house_id`) VALUES ('a', 'b', '8989898', Array) Filename: C:\xampp\htdocs\ThinkInterio\system\database\DB_driver.php Line Number: 330* These are … |
|
I think this is probably too ambitious, but I though I'd ask anyway. I have a list of about 13 000 music venues, including their name and location, but would like to add phone no., website, and email to that information. To do this manually would take a long time, … |
|
Hi Experts, Which database is better acc to Performance factor. Need Suggestions.. |
|
Hello Today i install mysql on my system and after that when i try to run the server it didn't start from the startup and when i try to run theserver through cmd i found the given error. C:\Program Files\MySQL\MySQL Server 5.6\bin>mysql ERROR 2003 (HY000): Can't connect to MySQL server … |
|
There are two products Harmony Field Unit, and Tuner. The Harmony Field Unit has a Test Date, Test Station, and Test Results that need to be tracked. The Tuner has a Serial Number, Firmware version, and Hardware Version that needs to be tracked. The Harmony Field Unit is made up … |
|
# Creating a register and login page, by creating a mysql database and all php files. # ## I was reading a [thread that is dead](http://www.daniweb.com/web-development/web-design-html-and-css/threads/97183/to-create-a-registration-page-and-login-page) now, so i started this one: ## **Simple PHP login:** Create a database (mysqladmin) Name the table "dbUsers." It will need 4 fields: Name … |
|
Hi all, I created relationship among table using Data Modeling (MySQL Workbench). When I forward engineering the new model, only the data but relationship among them are not updated. Any hint for me? Thanks a bunch. |
The End.