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