10,946 Topics
 | |
| | Hii i am building a financial database. And I have data for each stock for all the days. I want to avoid multiple entry of a stock for the same timestamp in the database. For eg I dont want to have the data for google on 30 jun 2010 twice. … |
| | [B] Hi, I have a 64 tables in my database. I have to know the one column name like "customer" in all 64 tables at a time that this column was exits or not. So that, Is there any query to find that the column name " Customer" has exists … |
| | I've been going round and round trying to sort this. I have this in one of my programs: [CODE]drop table if exists temp2; rename table something to temp2; rename table temp to something; create table temp like something[/CODE] and it's not working, though it will work when I manually paste … |
| | the below code is causing two records to be inserted into mysql. I have no idea why. when i remove it no record is entered. When i add it two duplicate records are entered. Any idea why? it is in an if statement. What would cause it to be inserted … |
| | Hi..... How to access the MySql using servlet.... Now am using Mysql 5.0 & MyOdbc 3.51 What type of connector to be used?... We used the following syntax..is it correct?or not? Class.forName("org.gjt.mm.mysql.Driver"); Connection cn=DriverManager.getConnection("jdbc:mysql://192.168.1.38:3306/suba","root","erp"); Whenever i execute this program i got the error like this [B]ClassNotFoundException: org.gjt.mm.mysql.Driver[/B] |
| | I am trying to set up a web based tool for my wife and I to use to balance our checkbook together. I am using HTML, Javascript (Ajax), PHP and MYSQL. I have read beginner books on all of these subjects, I can get data out of MYSQL, BUT can't … |
| | Hello.. I need to query out most demanded products from my database... i have order table(order id, date, ...), orderitem table(order id, product id and quantity), and product table.. i don't understand how to write a query for this.. can someone kindly help me? |
 | Hi All, I have a list of entries from users and want mysql to only display entries that are unique. The mysql statement is as follows [code] SELECT DISTINCT bids FROM `tbl_bids` ORDER BY `bids` ASC [/code] On running the query it is still displaying items that appear more than …  |
| | Hello, i am trying to update a table row from a form the code is: [CODE]<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" name="votim" id="votim"> <p> <input type="hidden" name="email" id="email" value="<?php echo $usernamepervotime ?>"/> <input type="hidden" name="vota" id="vota" value="<?php htmlentities($row_VotaMiss['vota']+1); ?>"/> <input type="hidden" name="ID" id="ID" value="<?php echo $row_VotaMiss['ID']; ?>"/> </p> <p> </p> <p><a … |
| | I am trying to populate a SQL entry with data from a php script but it doesnt work. I have the config file set up right and everything. This is the code I have [code] <? include_once "secure/dbconfig.php"; //check md5 $SECRET = 'xxxxxxxxxxxxxxxxxxxxxxxxx'; $sig = md5('userId'+":"+'appId'+":"+'SECRET'); if($_REQUEST['sig'] == $sig) { … |
| | I'm learning as i go on a side project i'm trying to do, but am having trouble finding the information i need. I'm making a website with individual user pages with lists specific to them; think netflix or gamefly. I have repeating regions of information for one object, and i … |
| | Ok, I know their's tons of threads.. with the same problem. But.. every code is different. I'm pretty good with HTML/Css but I havn't had time to catch on with PHP. So, I have a site I'm setting up. Which requires a SQL/Database. Which is already configured. I've filled in … |
| | Am having serious problem with creating and installing membership registrations and login database, the most troublesome is the area of creating a database table on the mysal php5 +, Please anyone with a brief and understandable A to Z Coding of these tables should please post it to me, i … |
| | how to install the msqldb package and where to place it in python? then when i compile the code there is an error like no module named MySQLdb.... pls clarify this.... |
| | Hey, I am having trouble with some code I am using. I have used this same code on a different site but it doesnt seem to work now on this site. I am trying to insert something into my database. however I keep getting this error: SQLSTATE[42000]: Syntax error or …  |
| | Hey guys, I was hoping someone could help me out here again. I've seen people pulling entries from multiple MySQL tables by using the JOIN clause, but I can't seem to get it to work with what I am trying to do. I have 3 tables which I wish to … |
| | Hi everyone I am trying to develop a friend system where you can view friends who you are friends with. I have been able to get it to show one result but it wont show any other. Please can someone tell me what I am doing wrong. Here is the … |
| | Hi, I have some pictures in a MySQL database that i am able to retrieve and display. How ever, i want to display them as images in a gallery, but not able to. The MySQL query is ok, it retrieves the images, i think the problem is with my PHP … |
| | Hello everyone, I have been disturbed for a week now. I have a project in vb.net. And on forms I have two masked text boxes. One is for the user to enter their date of birth and in the second one Iam trying to get the date the record is … |
| | Hello everyone, I have got class system going on where object is created for each column in mysql table upon initialization of the class. This class contains one particular attribute($this->table) where i set my table name. This attribute helps in constructing a query when user press "add" to add stuff …  |
| | Can any one tell me, what is the difference between SQL and MySQL? |
 | I am in the midst of refreshing myself on MySQL. The basics have been going well but I am having one issue. I have created a table with two columns and three rows. Next I added a third, null column, Price, which I now wish to populate with data, that … |
| | Hi Advanced Devs, I am very new to php. This is my learning moment. So, Help me. I have added a zip folder with my files. I also have expoted my database as zipped folder. Please help me with this topics. Please. Samrat |
| | hi , freinds ... i am stuck up with same problem new to web development and want to integrate tinymce in it ......but dont knw exactly how to do it can any1 of you can guide me to it. starting installing i didnt get 1 thing how to install gzip …  |
| | Hello! =) I have a big problem here, with PHP charset stuff. My mysql is utf8_hungarian_ci , but the php shows me only '?' and ?inDiamond signs. I guess the PHP's working incorrectly, because my MySQL returns my records just fine. Any solutions? =) Thank you! |
| | I have a database using Access 2003 for the front end and MySQL to store and process all the online queries for the website. Several of the queries I run on the database are done daily as part of creating the data tables to support the site. Some of these … |
| | I am looking for a good C++ example of a simple MySQL client program written in C++ and runs on Linux, using MySQL++ libraries that does the following (no threading): Accessing Option File Contents, ~/.my.cnf, in user home folder to read settings (load_defaults). Constructing and sending the sql statement that …  |
| | I need help with the following query, i will be so thankful if anyone can help me please. I have two tables in database: Table1: [CODE] Column1 Column2 Status smith john 1 jack smith 0 julia rob 1[/CODE] Table 2: [CODE] Column1 Column2 thomas lewis scott smith john evans lopez … |
| | I have a database using Access 2003 for the front end and MySQL to store and process all the online queries for the website. Several of the queries I run on the database are done daily as part of creating the data tables to support the site. Some of these … |
| | Really I am a PHP beginner, I am working on this code and I need help, kinda stuck. I have a database with 3 fields(id, date and venue). This is simply what I want to do; I want my script to go into the database fetch the date and compare … |
| | Hi, been looking all night on net but cannot find ORDER BY Month anywhere. This is my query: [CODE]SELECT MonthPaid AS XLABEL, SUM(Amount) AS YVALUE FROM monthlycommission WHERE YearPaid= NOW( ) GROUP BY MonthPaid[/CODE] However when i display this it goes June, March then May I want to add an … |
| | Hi; I am making one small application which can store data to my online mysql server. But with c++ win32 how can I do it? Please help me. |
| | Hi all, I'm sorry my bad english. If don't understanding something, please ask. I have a problem with my calendar. Can somebody tell me why I can't mark day cell in my calendar. Do I miss something what I can't see or is my code failed? My calendar is full … |
| | Ok here's the situation; I have these tables setup in MySQL; [B]Table name[/B] - Users UserID - INT Primary key Auto increment Email - VARCHAR Password - VARCHAR Firstname - VARCHAR [B]Table name[/B] - WallPosts PostID - INT Primary key Auto increment UserID - INT Foreign key Email - VARCHAR …  |
| | Hi I have encountered the following error: Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in I don't know what is exactly the local host: shell I use only my domain or I need to use a special path...I would appreciate if somebody can help on this. Thanks! … |
| | Hello everyone, I used session and the id of the selected checkbox are passed to another page currently. now I do another query based on the ID of the selected checkbox. I want to display the fields from the selected result in columns like this [url]http://www.bluenile.co.uk/diamond_co...OMPARISON_STEP[/url] I did this [CODE] … |
| | Help I am very new to MySql. I have inherited a website. The previous webmaster used a MySql database for news items. I took a back up of the whole site using FTP, then restored simply by FTP the files back up, but the database now seems corrupt I have … |
| | Hi there, I have been scratching my head for a few days now! with this problem: I am trying to echo out some data from a mysql table. I have a column name Country which has the following Countries: India, Malaysia Austaralia etc. I also have a column name Town … |
 | Hello, have a page where I am going to be doing multiple queries on different databases. However I thought my below code would work but it does not seem to resurn any error message nore any result set. Here is my common database connection file <?php //database username and pass … |
| | how do i fix this? the error says that the column count does not match value count. thanks in advance!:) -- -- Definition of table `assets` -- DROP TABLE IF EXISTS `assets`; CREATE TABLE `assets` ( `_id` int(10) NOT NULL auto_increment, `_controlNum` varchar(255) NOT NULL, `_category` varchar(255) NOT NULL, `_subcategory` … |
| | i get an error here Can't create table '.\itams\assets.frm' (errno: 150) [icode] -- -- Definition of table `branch` -- DROP TABLE IF EXISTS `branch`; CREATE TABLE `branch` ( `_id` int(10) NOT NULL auto_increment, `_branchName` varchar(255) default NULL, `_branchAddress` varchar(255) default NULL, PRIMARY KEY (`_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- … |
| | I need a help with selecting the rows in a table depending on the [I]status[/I] in previous table. [B][COLOR="DarkGreen"]Table1[/COLOR][/B] [CODE]Column1 Column2 Status Smith Alex 1 Smith Mark 0 John Smith 1[/CODE] I have second table with 2 columns. I want to select only those rows which have ANY of the …  |
| | I am trying to connect to MySQL database at on host (DBhost) from another host (PROGRAMhost). While I try to connect to the database at DBhost from DBhost itself the next is working fine for me: mysql_connect("localhost","qdbname","dbpassword") Now I am trying to find out what to use instead of localhost? …  |
| | Hi all, I have a pagination script that works great apart from one last thing I require some pointers on please. The help i need is with the SELECT query - currently the select query works, but i am bringing back all records, I am trying to bring only certain … |
| | I have some data in a table in mysql. I have written a program which can connect to the database and access all tables and data of mysql. I have a variable in the C program. I want a particular data in one of the tables in the database to … |
| | I import data into MySQL over and over again. Always from .sql scripts. I have tried over and over to come up with a script that will [LIST=1] [*]Ask for a database name [*]Sign into MySQL [*]Drop the Database named in step 1 [*]Create a new database as named in … |
| | Hi Guys I Have a table with 2 fields & several roows like this : Cd val -- --- a 1 b 2 c 1 d 3 f 4 g 2 h 3 k 5 l 6 m 8 n 7 o 1 p 2 I want get the result … |
| | I have a database and will search with that database.. I want to show only first 5 results in the page and generate the "next" button for the next 5 results and on the 6-10 results page generate "next" button for the next results and the "previews" button for the … |
| | Hi! I'm trying to create my own little community for learning purposes and I'm having some trouble with getting the data I want from the table. I'm not that high on SQL but I know the basics but when you get into the more complex mysql-lines I get lost. The … |
| | Hello, I am brushing-up on SQL (using MySQL). It has been many years since I have worked with this and I'm having some trouble getting started. I have looked at a tutorial and entered the code below: [CODE]CREATE TABLE employees ( employeeNumber into(11) NOT NULL, lastName varchar(50) NOT NULL, firstName … |
The End.