10,946 Topics
 | |
| | Hello guys, A Client walked upto me, and told me he wanna create a SMS portal where by user can by a Card from him and log in with a secret Pin on the card and they can login to the website and with th Issue Card and they will … |
| | Hi, How to connect visual basic program with mysql database?I need a sample program of retrieving the data and also inserting the data into the table using mysql database..........I dont have any idea..... please help me ....... Regards, Santhanalakshmi. |
| | hi guys, I have one table: exams(e_no integer primary key,e_name text); now i want to create another table called questions which should have primary key that is combination of exam.e_no (foreign key) and question.q_no questions(q_no,e_no,questions text); so i would like to make q_no and e_no both act as primary key … |
| | I summarised my problem by a simple example,anyone plzz ans this...then I will be able to understand my problem.......: Suppose in a database named "DATABASE"..there is a table called "XYZ"..it has 4 rows named "T1,T2,T3,T4"..one primary key named "T_id"..now what I want that to access this same table via different … |
| | Hi, Don't know why but i always seem to mess my, mysql querys up somewhere, usually silly things like quotes etc. The code below, i have a problem. Basically when user gets an email they click the link and they are taken to a page where they can change there … |
| | Hi, As you can probably tell by now my knoweldge of MySQL is not very good. I basically have two tables. One called [B]userinformation[/B] and another called [B]profiles[/B] My userinformation table is like this: [CODE]CREATE TABLE `userinformation` ( `id` int(11) NOT NULL auto_increment, `status` varchar(20) NOT NULL, `username` varchar(20) NOT …  |
| | Hi Story goes - I have an online store... there is a sales table which records every product sold. Each product is within a style. So a Style might be 'Red Jacket'. I want to pull out (from the sales table), in order of how many sales have been made, …  |
| | how i use apache server, php, and MySql .Tell me the procedure for installation of Apache server, PHP, and MySql  |
| | I have two issues. I have simplified the tables involved. Issue1. advertisers is a table with two columns unique id and name views is a table with two columns id and advtid msgs is a table with two columns id and advtid How do I fetch only those advertisers who … |
| | Hello everybody, I have this text file, and when I import them into mysql through phpMyAdmin, everything is ok, but the persian (Farsi) not shown correctly, also I use ' utf8_persian_ci ' collation, can anyone kindly plz convert this file into MySQL that farsi data shows correctly too? NOTE: farsi … |
| | Hi all! So I've been reading about the "FOR XML AUTO" function which sounds great, but it hasn't been working when I try it in phpmyadmin. I get an error in the area of "FOR XML AUTO", I know SimpleXML is disabled on my package but would that be why … |
| | Hi to all ! Im new to java n i m working on Project of Web base Image Annotation Tool using jsp and java i have to save n retrieve image in to database which im using is mysql How i can store image in to database not the refference … |
| | hi all Database Masters Here i have suffer one critical issue,i have two column a and b, Table name : Student "A" "B" "1" "SAntOsh" "2" "SAuraV" "3" "SAriya" "4" "SAnju" "5" "SAthiYa" These are the sample records from my Table field. The "B" column always start with 'SA', the … |
| | Hi, I am trying to display the users email address when they login to there account on there profile page.. I have successfully done this for there username as i use $_COOKIE to display the users name with the DB. Problem is i am not sure how to do it … |
| | Hi, I have installed the **mysql connector ODBC 3.51** on the remote machine as well as on the local machine. Mysql Connection with VB.Mysql Connection on the local machine its working fine. cn1.ConnectionString = "driver={MySQL ODBC 3.51 Driver};server=localhost;database=dummy;data source=dum;Option=3" When i trying to connect the mysql from the remote machine … |
| | Hey, I've just started using mysql and I have som problem with JOIN. I have table1 and table2 and I would like to join these two on table1.col1 and table2.col1 to eliminate all identical rows. In addition I need to have a WHERE statement on table1. This is my attempt: … |
| | Hi guys, I've been using asp.net 2.0 over the past 2 years making simple web applications but have never used it with MySQL. I've been asked to create a website for a relative. The site will be a vehicle leasing company. After speaking to owner and understanding his requirements i … |
| | Hi, I have been trying to find a way to get my databases on two external hard drives plus one internal hard drive but I just can't find a way to place each database on a separate drive. The only thing I have come across is windows junctions but can't … |
| | Hey all this is a pretty simple question, basically I connect to a mysql database, and iterate a list of names like this: [CODE]$result = mysql_query("SELECT * FROM Students"); echo "<table border=\"1\">"; while($row = mysql_fetch_array($result)) { print " <tr> <td> " . $row['Student'] . " </td> <td> <form name=\"FRMdelete" . …  |
| | Hi guys, I know what I need, but not sure how to do it.. a) Store values in a database field like: 12|3|43 b) How to retrieve these values as seperate variables. Appreciate any help! :'( Thanks  |
| | Hi!, I am trying to update record but an error is coming. Can any one help. [B]error is - mysql_numrows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\xampp\Test\Report\Despatch\update.php on line 10[/B] [B]here is the script[/B] <? $id=$_GET['id']; $username="root"; $password="mysql"; $database="service"; mysql_connect(localhost,$username,$password); $query = "SELECT * FROM contacts … |
| | |
| | I am trying to do a simple MySQL query using my db class, but for some reason I am having issues with getting the query through using my db class. If I hard code the db call bypassing the class, it works fine. Here is the class: [CODE=php]<?php //////////////////////////////////////////////////////////////////////////////////////// // … |
| | [B]I am trying to insert a new record into a mysql database and get the following error:[/B] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '30, 60, 90, DayCreated) VALUES ( 'Rush Shirt', … |
| | |
| | <?php include 'dbconnect.php'; $query="select * from pnmsg;"; $result = mysql_query($query); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $msgs=$row[0]; } echo $msg; include 'dbclose.php'; ?> THis is my code and am working in my local machine it give the same error Anybody help . I could not find any mistake in my code |
| | Dear members, I am after some help with a script I am trying to write/use! I am currently re-designing a website for an animal charity for which they would like to add a section in the members area where people can upload their own photos of their animals/pets. I have … |
 | i have 4 input box of credit card number and 2 boxes of credit card expire date month and year and one for the card holder name i have some code but is it ok or i have to do some thing else [CODE=LANGUAGE]<?php $connection = mysql_connect("localhost","root","password") or die("error connect"); … |
| | I am using mysql as backend in my windows project, some times one of table gets stucked and application also gets stocked after restartin mysql server it will be alright , any alternative solution for this problem... Thanks in advance |
| | Hi, I wonder if someone could help me please. I basically made a registration form and need to insert the data into the database. I am not sure how i use the MySQL functions to do this, I created a db connection file and included it on registration page but … |
| | Hi everyone, I have PHPAuction XL V3.1, please may someone help me. I have managed to create the auctions but i cannot bid on them, the following error comes up: update PHPAUCTIONXL_auctions set current_bid=20, starts=2009-05-01 18:21:29,ends=2009-05-02 18:21:29 where id="1336eca400908b7a04133d27be69e27e" You have an error in your SQL syntax; check the manual … |
| | I'm creating my class for mysql in which i have difficulty dealing with the parameters of which to use with prefix '@param' or '?param' or whatever it is. I need your help guys. I have here my stored procedure [code] DELIMITER $$ DROP PROCEDURE IF EXISTS `davidssalon`.`Customer_SearchName`$$ CREATE DEFINER=`root`@`%` PROCEDURE …  |
| | Hi i am a beginner in php and mysql.... I have a made a database for registration of a customer in shrare market.... Now what i want to show at the front end is the the person who is entering information has a choice to select from a company through … |
| | Hi , I want help in designing a Bonus System Database. I am planning to organize contests on my site where in users will have to answer some 10 questions , and at the end of each day users points will be calculated, based on there answers. Prizes can be … |
| | Azul(Hi) i created program on php where i can output data set of any table by submitting query. i need help to input i mean to load data into the table from the HTML file can any one give help please thank you. this is the program i created, so … |
| | Hi, How to export the data from the sql server 2000 to mysql ....Please help me.I had no idea Regards, santhanalakshmi |
| | I have eight tables with the same schema but containing different data: `node_a_data` ( `node_a_data_id` int(5) NOT NULL auto_increment, `timestamp` int(10) NOT NULL default '', `user_count` int(5) NOT NULL default '0', PRIMARY KEY (`node_a_data_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=795 ; The timestamp field just contains a Unix 10 digit timestamp … |
| | i am designing a site...under xampp with php...now,i have a table called link where i want to link some special links by fething it from database...but my problem is when i open it ....it happens something like below... suppose I give a url "www.intel.com" in the database by hyperlinking a … |
 | cannot connect to mysql server error 10060 on sqlyog on my other domain but ok on the other one. Just awhile ago I can connect to both domains but after restarting my pc I can't connect to the other one. Some said to turn off firewall which I did, it … |
| | [code=java] public static void setValues(PreparedStatement statement, Object... values) throws SQLException { for(int i = 0; i < values.length; i++) { if(values[i] instanceof Integer) { int value = (Integer) values[i]; statement.setInt(i, value); } else if(values[i] instanceof String) { String value = (String) values[i]; statement.setString(i, value); } } } public static ResultSet … |
| | |
| | I am developing a portal using php and mysql. I am facing a problem in the database design because my database is going to take million of records. I am not very much experienced in database design. So I request some experienced people to come forward for my help. I … |
 | Hello all, I work on MySQL and i have knowledge about it. I have no idea of what Apache is? I googled and came to know just like MySQL it is also a Web Server and nothing more about it. When people ask me if i have experience with Apache?! … |
| | Hey All, I wanted to find if it this is possible. I have a db in sql server with some large tables and I would like to transfer the entire db from one server to another server without having to create the tables and so on. Is this possible? Thanks |
 | In a application for online test, the rank list is computed as follows- [CODE] select * from test order by marks DESC[/CODE] How can we make sure that the first record gets rank1, second rank2 and so on... I want to add the field to the table. Can this be … |
| | I have done these scripts a thousand times. I still however can't seem to sort out this issue. The issue is that this block of code should return 3 images although it doesn't it only returns one image. The other one I am getting is from a different loop that …  |
| | Hey Everybody - I'm looking into creating a calculating form for a website. I know that i can be done in JavaScript but my boss is requiring it be done in SQL as well as probably CF. I usually use SQL/CF for only simple databases or form submissions, so this … |
| | hello hi i am using mac osx 10.5 i want to start mysql in it with --log-bin option so as to take incremental backup.so how can i start mysql with that option. i start mysql as mysql -u root -p. plz help me. where can i find my binlogs |
| | hi all i had taken backup of my database and added some tables so as to take inc.backup i had a binary log as mysql-bin.000001 now i want to make a incremental backup from it. plz help me how can i use this log for inc.backup in mysql |
| | Currently connected to remote server but remote configuration is not yet possible this is msg shown when trying to connect remotely to a database what does it means |
The End.