10,940 Topics
 | |
| | here is my code want to get records between two dates [CODE] $sql=mysql_query("SELECT * FROM `expense` WHERE `date` BETWEEN '2011-04-26' AND '2011-04-28'") or die(mysql_error()); echo $r=mysql_fetch_assoc($sql); [/CODE] i getting "Array" in output instead of the data please sort it out for me i am not getting it right |
| | hey people, i have the following problem, i'm setting up a webshop with over 2k items and every 6months the prices are changing(wines) so i was wondering how to import an xml file into a mysql database without having to go in phpmyadmin. this because i don't want the people … |
| | Hi All I have to tried to connect MySQL with remote databases(GT.M)i can successfully communicate with remote database and after a specific period of time i face the following error message [B] "ERROR 1296 (HY000): Got error 1 'No response' from remote host". [/B] can anyone guide me what kind … |
| | Hi all, I'm stumped and can't seem to find an answer on Google. I am running a java application through Eclipse and it connects to mysql. It connects fine if I run it through Eclipse but if I make a standalone jar file and then run it through Window's Vista … |
| | Hello all, I have three table name with same data structure. So, I want to insert my data through store procedure by passing table name as variable with my data. Is it possible? Thanking You. Hakoo Desai. |
| | I'm using mysql 5.5.9 I used create database query to create a new database but this new database is not coming in mysql.db table can anyone tell me the reason y and even how to get the database in that table. |
| | Hi, I am new to MySQL scripting. I used tee command to append my logs. But I wanted the log file to be cleared every time i execute the script. Is there any command to do that? Thanks Shiny |
| | i am using netbeans and MySQL. i made an inventory application with a server host name "local host:3306". how do i distribute it to other computer? should i change the server host in mysql? |
| | hello guys , i have a table created in php and within this table there's a liked word that will lead to it's topic , and this topic would be stored in the database. then when it's clicked it will show a page and display what has being stored in … |
| | Hi Friends I have pasted the code below which i was used in my project. But i am getting mysql_fetch_array() error. For your more information i have attached the screen shot of the error Pls give me solution [CODE]<?php // Inialize session session_start(); include("../config.php"); // Check, if username session is … |
| | Good day guy., just want to ask what is the equivalent function of mysql_error in jsp.... i have a program created in netbeans and in successfully build but it doesnt seem to process right ..,  |
 | Hello, I have a query that needs to perform the following: where verified=1 AND where name is like '%$term%' AND/OR owner is like '%$term%' I have a basic knowledge of SQL and was wondering if the above is possible. I need the and/or because i would like it to return … |
| | hello friends i want to sum up my table field data...my table name is fee_info and i the field i want to sum is exam_Fee... i have come out with a query but at last i am not figuring it out yet. here is mine code [CODE] mysql_connect("localhost","root",""); mysql_select_db("new"); $get= … |
| | hello friends i want to add my table fields but i got a problem that when ever i add my field for example i enter two records one of ID 2313 having exam_Fee and transport_Fee and other having id of 2314 having same exam_fee and transport_fee.query for this which i … |
| | Hi friends, I got a table as follows Name | idNo | started | type | entrytype ----------------------------------------------------------------- Nick | 12 | 12-02-2011 | 0 | 1 Sam | 14 | 13-02-2011 | 1 | 1 Paul | 12 | 14-02-2011 | 1 | 1 Jwal | 12 | 13-02-2011 … |
| | At the moment i have dynamic list which displays the latest products added to the inventory list. I want to display birthday cards from the category. In my database i have the column 'category', and in a form you can select different options with values one being birthday. This is … |
| | I would like to develop a database system using ms sql server 2005 express or 2008 express edition where the data may store in other than english language into tables. so i did it using mysql database but not working in 2005 express edition. Is there any solution? |
| | Is there a way to create a program to rewrite a query in an optimal form. If so, how? What can I do to implement this. Rewrite SELECT EMPOYEE.EMPNO, POSITION FROM EMPLOYEE E, JOBHISTORY J WHERE E.EMPNO = J.EMPNO AND STARTDATE <= ENDDATE AND SALARY <= 3000 into SELECT EMPLOYEE.EMPNO, … |
| | I have details stored in a database of a web site firstweb.com I have created another web site secondweb.com I want to use data from database of firstweb.com Is this possible ... Assume : I have all user id and password for both these databases If YES, how to do … |
| | I'm new in using MySQL and I have to do a project where I should implement 6 queries within the database that I have created. The queries that should be implemented are union query, aggregation query, nested query, and three join query. Here is the script for the database. [CODE]create … |
| | hi all, i need to develop windows applications(c#,mysql)as i have started to develop applications recently i need some examples to refer(which includes almost all controls) may be like customer maintenance or order placement form etc..so can any one help me out.. thanks a lot,  |
| | My Alter Table Editor Window Not Coming Up in Mysql Workbench? PLEASE CAN SUM1 HELP ME! ^_^ My Alter Table Editor Window will Not open up.. Is there a way to make it open???? Im using Mysql Workbench Thanks! |
 | Hi, I'm making a custom user management class that inherits from DBManager class. The problem I have so far is executing queries using mysqli prepared statements. DB connects fine but then prepare statement fails. I have mysqli object as an attribute that is shared in the class. I'm new with … |
| | Hi Friends i am having one master table for category which contain 7 fields, i am having sitename as a table which contain 8 fields, if i create [B]newsite[/B] name then it has to copy all the fields from master table in addition to that it has to display the … |
| | I would like to know how to a use a text box in winform to name the table . can anybody help me please I am using the following statement to create table SQL = "CREATE TABLE tbCatalogue ([Id] COUNTER, [Stock Code] TEXT(10), [Account Number] TEXT(6))" |
| | I have these two queries which i want to run together and not one by one. How can i do that? Or can it be modified to be one query. [CODE] UPDATE runquery.table1, runquery.table2 SET runquery.table1.`Column1` = (runquery.table2.`Col1`/runquery.table2.`Col2`*100) Where runquery.table2.`itemid` = 3 and runquery.table1.`Userids` = runquery.table2.`userid`; UPDATE runquery.table1, runquery.table2 SET … |
| | I'm using mysql and phpmyadmin to create a video rental database and I've been having problems with the auto_increment feature and the numeric data type. I have auto_increment on multiple tables for their table id's. The problem is when i enter data into the tables the counter doesnt reset. So … |
| | Hi, Need some guidance here parts of my DB need to be updated by data from another system's DB, what I'm gonna get are CSV files with data that isn't exactly the same as my DB, meaning, the tables aren't the same structure, the fields don't have the same name/format..some … |
| | Hi All; I have a MySql database set up called users. The only things required to register to my website are a username and password. When this is completed, the database populates with the users info as requested. How does MySql make this new users permissions to have it where …  |
| | Hi, I have this code that adjusts the position of the subjects and the pages in my site. This is working where the value of the radio button = 1 (which is = showing, in the database - And 0 = Not showing) And I am talking about pages for … |
The End.