10,938 Topics
 | |
| | 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 … |
The End.