10,946 Topics
 | |
| | [CODE]Imports MySql.Data.MySqlClient Imports System.Data.SqlClient Module connection Public conn As MySqlConnection Public Sub xconnect() conn = New MySqlConnection conn.ConnectionString = "Server=localhost;User=root;Database=test;pwd=;" Try [U][B][COLOR="Red"]conn.Open()[/COLOR][/B][/U] MsgBox("Success") conn.Close() Catch ex As MySqlException MsgBox(ex.Message) Finally conn.Dispose() End Try End Sub End Module System.TypeInitializationException was unhandled Message="The type initializer for 'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception." Source="System.Transactions" TypeName="System.Transactions.Diagnostics.DiagnosticTrace" … |
| | i got 3 users to be registered in the registration form through radio button admin,manager and employee... after registration of a admin the other 2 raadio buttons shud only enable in the registration form... admin shud be disable............ how to implement this in php........... |
| | [CODE] $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'password1'; $dbname = 'DB01'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql for First Database'); mysql_select_db($dbname, $conn) ; [/CODE] This first connection is where the php file is stored. [CODE] $dbhost02 = '192.168.0.16'; $dbuser02 = 'root'; $dbpass02 = …  |
| | how to increase my mysql databse server partitioned in /var/lib/mysql using putty?? my server is linux open suse. can i have a step by step procedure??thnks. |
| | i have mysql xml field like this [CODE]<?xml version="1.0" encoding="UTF-8"?> <record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.loc.gov/MARC21/slim"> <leader>00764nas </leader> <controlfield tag="221">011258</controlfield> <datafield tag="578" ind1=" " ind2=" "> <subfield code="a">jaun</subfield> </datafield> <datafield tag="356" ind1=" " ind2=" "> <subfield code="a"></subfield> <subfield code="c"></subfield> </datafield> <datafield tag="333" ind1=" " ind2=" "> <subfield code="d">ali</subfield> <subfield code="p">22</subfield> </datafield> <datafield tag="222" … |
| | I have two tables that I'm using in this query. We'll call the first one "userGroups" and the second "links". I've included their structure below. I have one system that is running an older version of MySQL, and I also have a system running a newer version. Older Version: 5.0.91-community-log … |
| | guys, can anyone help me on this problem? i have two tables then what I want is that, when an identical item is found in table2, it will not be displayed. Example: [CODE] Table1 Table2 item1 other1 item2 other2 item3 item2 item4 item3 [/CODE] Condition: if we use this query: …  |
| | I am wanting to set up a home server using an old computer, after doing some costs it would work out considerably cheaper than using a hosting service, and although less reliable I feel it would be some good and valuable experience. I have installed Ubuntu server edition onto my …  |
| | Hello everyone , i just need to insert into my database the state of 4 checkbox , i'm trying now only for two . For this, i have two file formulaire.html and form.php , I've created for each checkbox a column in my database , so , what i want … |
| | |
 | Hi guyz,, I have 2 table like, [B]table1[/B] [B]Name[/B], [B]Number[/B] Gates 123456789 Bill 987456321 John 874123658 Peter 562314752 [B]table2[/B] [B]Number[/B], [B]Message[/B] 123456789 Hai hello 874123658 Gudmorning 123456789 Something Went 123456789 verY Nice morning 562314752 Hai spidy.. My Question is how to select all records from table 2 and also i … |
| | I have a mysql table that has id, name, type, size, content, and link. I have pages download.php and showimage.php. I want the link to affect the image so when the user clicks it sends them their. I only created showimage.php cause I had ran out of options on how … |
| | [ICODE]Hi, am wounding where i can find a script that can do something similar to this [url]www.avis.com[/url] Pls look at the right low side. This is just javascript, want something similar, but using php/mysql.[/ICODE] |
| | i can't install vb.net connector 6.4.4 help |
 | So, I wrote the following program to connect to my local mysql server and create a table in the existing "test" database. The program compiled without any errors, but I got the following run-time error: java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on … |
 | I've run into a bit of a problem following a database replace last week. I need an expert in MySQL to help me out as I don't know a thing about the service. If you can help me, I'm able to offer $30 pay. It could be a piece of … |
| | hi... im doing project for a school...and new to php and mysql..just learning.. i have to create one loginpage with 3 different users like corres,principal and the staff in the table field what type i have to give like ENUM or SET.. i want to assign 0 for corr,1 for … |
| | Hi to all I am having this problem can anyone help me to solv this problem pls here is the code. first problem [CODE]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hermes/web07/b2501/mydomain.com/htdocs/media.php on line 40[/CODE] media.php code [CODE]<?php $connection = mysql_connect('localhost','test','test'); if (!$connection) { die ('error … |
| | Hi a have 4 tables [ICODE]Table A ID | Data 1 --------------- 1 | A 2 | W [/ICODE] [ICODE]Table B ID | Data 2 ----------------- 1 | B 1 | C 2 | X [/ICODE] [ICODE]Table C ID | Data 3 ---------------- 1 | D 1 | E 1 …  |
| | hi m using php n mysql m trying to merge two tables of same database and then print them but somehow it is not working it gives me the error my code is [CODE]<?php session_start(); print_r($_POST); $con=mysql_connect("localhost","root",""); mysql_select_db("pras2",$con); $date= $_POST['date']; $shift_num=$_POST['num']; $query="SELECT shift_id FROM shift WHERE shift_no='$shift_num' AND date='$date'"; $result=mysql_query($query); … |
| | please help me!!! im restarting the mysql server from putty: Empty pid file /var/lib/mysql/mysqld.pid for /usr/sbin/mysqld when i checked mysql status, unused running unused running what's the problem?? im using putty in configuring mysql server thanks in advance. |
| | Hello Every One ! How to show md5() password from MySql table in PHP, I have saved my user's password as , [CODE]$password = md5($_POST['password']); $save = mysql_query("INSERT into users(password) VALUES ($password)");[/CODE] Its encrypting nice and works fine when user logs in , that's not a problem, my question is … |
| | I'm running the following code in PHP to generate the random list of movies from the database but since value of genere is an array it is just capturing the first value of the array. How can I modify the query so that I can get all the values of … |
| | Hi, I have this program that uses OLEDB connection to open the excel file, and imports it's data. Then I use mysql connection to inserts all this data. Now my question is, is it possible that I can use mysql connection in opening the excel file, or only OLEDB connection … |
| | Hi all........... I shud just how to use ENUM type in mysql..like shud i give any field in form in a website and how to assign a values for eg 0 for admin,1 for manager and 2 for the staff using phpmyadmin?? please help me................. |
| | Hello I'm looking to allow users upload pictures onto my site and have it displayed and linked to their site.. This process is for Ad purposes. Ive looked into php mysql uploading images but ive ran into a lot of threads condemning the practice and suggesting saving the images to … |
 | Hi everyone, I had this problem with phpMyAdmin and successfully fixed it. Then, after some days, I encountered the access problem with the WAMP server. I haven't changed anything yet. Or maybe, I need to set up the environment variables? The message I'm getting is that [QUOTE]Forbidden You don't have … |
| | hi i m writing a program it is workng fine but doesnot update my database it gives me error since there are 4 query how can i know which one is wrong my part of program is: [CODE] $query2="SELECT * FROM rpms WHERE product_name='$raw_material1'"; $result2=mysql_query($query2) or die(mysql_error()); if ($result2) { … |
| | Hi I have one sql query. using this query i can download 10 lakhs of data in csv file for 6 hours. now i want to download 20 lakhs of data for 6 hours or less. please tell me how to increase the performance. SELECT id as imp_addr_id,userEmail, email ,name,mobile_no,gender,city,income,profession,experience,country,pincode,type …  |
| | I want to create a voting system where there is a user and admin pages. so when the user has selected, the user can not choose anymore. To the database system checks whether the user has selected or not. I want to use the session between user and admin. and …  |
| | Hello all, First off, I am not here to debate the merit of storing PDF as a blob in MySQL. I know this is not optimal solution, but this is the requirement that I have to work with. The upload appears to be successful, (Field in the database is filled … |
| | hi all, i have written store procedure which is working fine in MySQL browser the problem i am facing is when i call store procedure through c# usng nhibernate it is throwing exception MySQL.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is …  |
| | Hi, I'm new in php and face some problem in mysql. I want to check some data if it's remain on database. Example: in my form there are two form field. 1) url 2) name. So i want to check if session user have already this 'url' and 'name' in …  |
| | ( old ) sql = """CREATE TABLE (DATABASE1) ( TEXT_BODY CHAR(20) NOT NULL)""" I would like the above to work like the below. [CODE] sql = """CREATE TABLE ('%s') ( TEXT_BODY CHAR(20) NOT NULL)""" % header [/CODE] ( this produces an error ) Does anyone know how I can make … |
| | hi i am writing a program which take the value from form and then execute a error "failed" each time. which means there is some error in my query but i cant find the problem. here is the code [CODE]<?php session_start(); //print_r($_POST); $name=$_SESSION['SESS_CUSTOMER_ID']; $con=mysql_connect("localhost","root",""); mysql_select_db("pras2"); $product_id=$_POST['P_list']; echo "$product_id"; $quantity=$_POST['quantity']; $query= …  |
| | I have this error 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 and I don't know how does this happen because whenever I check the SQL that I have made including the inserted … |
| | Hello, I am a student.For the project we have to store first 20 search engine results (URLS and id) in the Mysql database.We referred to the google search API ,it says we will get results in JSOn/ATOM format.But we are not getting exactly how to store those results in JSON … |
| | [CODE] $query = "SELECT item, description, price, imageData, status, username, item_id FROM items"; $result = mysql_query($query) or die(mysql_error()); $z=0; while($row = mysql_fetch_array($result)) { //echo other columns here// echo "<td><div id=status$z></div></td>"; <script type=text/javascript> function updatestatus(itemnum) { var url="updatestatus.php?auc=<?php echo $row['item_id']; ?>"; jQuery('#status' + itemnum).load(url); } setInterval("updatestatus(<? echo $z?>)", 1000); </script> <? … |
| | Hi, I have been searching for a couple of days now for a resolution to this issue, and while I find a few references to it in google, nothing really defines the entire process. I have a MySql table called 'product_distribution' When a customer orders a product, all pertinent information … |
| | Hi sir pls help i have an error in line 13 .. and still i don't no where can i find this error... Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\login.php on line 13 [CODE]<?php $username = $_POST['username']; $password = $_POST['password']; if ($username&&$password) { $connect = … |
| | Just curious, and well hoping to save myself months of time..lol I've seen databases online already set up to purchase. I know a little about databases...very little, and could probably wing my way through creating a database for car lighting applications for the last 100 years, but thought there might …  |
| | Hello, I am going to be building a blog and have rattled my brains out on this but could someone please explain in much detail as possible how i would go about building a blog archive ? I don't mean i want the php code just the logic behind it. … |
| | Hey, DaniWeb friends! I've a problem with my login.php: When an error occurred, the [CODE]mysql_error();[/CODE] doesn't appear the error. Tested the [CODE]mysql_errno()[/CODE] also, it appears as 0, saying it doesn't have any errors. Take a look at the script: [CODE] <?php $username = $_POST['username']; $pass = $_POST['password']; require "conf/connection.php"; require … |
 | All, Im guessing this is going to be easy for any one to answer bc im such a fucking noob but here goes. I have mysql fields set to DATETIME and i just want to pull out that data and have it display in my form. And i would also …  |
| | Ok i have a lot of tables that are created when a user inputs information. Some info gets stored in a "Main" table while the majority is saved in its own self created table. I do not know the number of "topics" in Main table. so in way i'm trying … |
| | i want to Read DATA From A text file and save it in database and print the logs by using JAVA.? PLSSSSS HELP....  |
| | Hello, I would love to display the values of 65 columns which have been added and then display them on the screen, at the moment only 59 of the 65 columns added appear. here is my code. $result = mysql_query("SELECT SUM(segment) AS segment, SUM(funct) AS funct,SUM(pronoun) AS pronoun.............. right up … |
| | i have to write a c program which connects with the mysql database. i have installed visual studio c++ express 2010 and the mysql installer for windows. i have widows xp os. can anyone tell me the step by step process to connect to the mysql database. and give me … |
| | create table Course ( courseId char(5), subjectId char(4) not null, courseNumber integer, title varchar(50) not null, numOfCredits integer, primary key (courseId) ); create table Student ( ssn char(9), firstName varchar(25), mi char(1), lastName varchar(25), birthDate date, street varchar(25), phone char(11), zipCode char(5), deptId char(4), primary key (ssn) ); create table … |
| | I have a problem at login to the site: Constantly message appears: Deprecated: Function mysql_db_query() is deprecated in /home/vebsajt/public_html/hosting/config/functions.php on line 53 Deprecated: mysql_db_query() [function.mysql-db-query]: This function is deprecated; use mysql_query() instead in /home/vebsajt/public_html/hosting/config/functions.php on line 53 the file in line 53 functions is: $check_login = mysql_db_query($db, "SELECT * FROM … |
The End.