10,940 Topics
 | |
| | I am trying to find the sum of a column( cal) between two dates and then assign or display the result (sum) in a textbox or label in C#. Please help me. [CODE] MySqlConnection mycon = new MySqlConnection("datasource=localhost;username=root;database=church"); mycon.Open(); MySqlCommand get = new MySqlCommand("SELECT sum(cal) from tithes where transdate between …  |
| | Hi, I'm new on this forum, hope you can help to solve my problem :) I would like to modelize a binary tree like that [CODE] A / \ B C / \ D E[/CODE] They will be more nodes be a node can only have a maximum of two … |
| | Hi, I'v only just downloaded MySQL and I'm trying to import a text file but i keep getting an error message: "#1064 - 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 '2009-08-24,00:00:00,2009-08-24,00:01:00,1,444,261,0,0,0 00:b0' …  |
| | Hello everyone I have a problem using a "search" statement in mysql, using c#, here is my code: [CODE] private void btnBuscar_Click(object sender, EventArgs e) { SearchBook(txtBuscar.Text); } private void SearchBook(string bookID) { String connStr = "Server=localhost; Port=3306; Database=biblioteca;Uid=root;Pwd= -----;"; DataTable dt = new DataTable(); const string query = "SELECT … |
| | Hi all, Been pulling my hair out on this one. I have a simple query: [CODE]$query = (" SELECT course_code, student_grade, start_date FROM ccdata WHERE student_id = '$local_id' AND start_date= '20091023' ") $result2 = $mysqli->query($query, MYSQLI_STORE_RESULT); //$total_courses_I = $result2->num_rows; while ($obj2 = $result2->fetch_row()) { $course_code = $obj2[0]; $ypos += 5; … |
| | hi friends, I'm trying to install mysql on linux through rpm. I have install it & when I'm I enter the command mysqladmin -u root -p create mydb its showing Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' … |
| | hey friends I have install mysql on my centos linux systam successfully. Here are the steps install rpms 1) MySQL-shared-5.1.42-0.glibc23.i386.rpm 2) MySQL-client-5.1.42-0.glibc23.i386.rpm 3) MySQL-server-5.1.42-0.glibc23.i386.rpm rpm -ivh package name to check if it is install or not rpm -qa | grep -i mysql after installing server if it showing error like … |
| | hi there, I'm installed mysql on linux I dont have any idea about how to set environment variable and where it to be set sorry if it is a very basic question but really I dont have any idea. plz help me.  |
| | Hi i want to retrieve data from mysql database using ajax and php. my code is below which does not work here is index.html [CODE]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <script> var url = "getCustomerData.php?id="; var xhr = … |
| | i am new in sql and i would like to ask you if i can make a class in mysql. For example class test { INT AGE; INT YEAR; } CREATE TABLE lol (x test); can i do this? Thank you very much |
| | hi there, i want to display my data coming from database..i could do that using a table, however the problem is that the table will just expand everytime there is data. what i want to have is a control which has a scrollbar which will display lots of data. i've …  |
| | CREATE TABLE Item(Item_no varchar(10), Type varchar(10), Size varchar(10), Colour varchar(10), Brand varchar(30), Purchase_Date Date, Price varchar(15), Hiring_rate varchar(10)); What's wrong with this CREATE ＴＡＢＬＥ query? When I try to insert it, it was told invalid identifier. I dunno why. Plz help me. Thank you very much!!! |
| | What is the link between php and mysql? Please anyone help me |
| | Hi friends I'm installing mysql on linux system through rpm. when i'm entering command mysqladmin -u root -p create mydb its showing Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the …  |
| | Hi and thanks for letting me post my question here. I'm trying to create a select statement based on the following conditions, but first, let me visualize the tables. These have been created to give you an idea of the content of the tables but are not the actual values, … |
| | Hello everybody, When I run the following statement, it returns 3660 rows. [icode]select * from symbols where code = 'AAHSY00';[/icode] But when I run the following statement, it doesn't do anything and goes in a never ending loop. [icode]delete from symbols where code = 'AAHSY00';[/icode] Any idea on how to … |
| | hi friends i have install mysql on linux and starting mysqld by command service mysqld start its showing unrecognized service. and socket file also created. what to do |
 | Hello All, Please help me with the question I posed on thread title Thanks you! |
| | Is there anyone knows how to display a blob datatype from MySql database to the RptImage in Visual Basic 6.0 Data Report? Help me, please!!:-/ |
| | Hey, i'm new here and i need help. I'm trying to write an update query so i can update mulitple items in a database, but it aint working.. Ive used the mysql_error() thingy, but it still does not display any errors. All it does is nothing, the web page doesnt … |
| | I'm trying to get some user data into an INSERT query using the Mysql C API (don't know if this belongs rather in the Mysql forum, let me know...) I have the following code taking some pointers from the Mysql webpage forum, but to no avail: [CODE] #include <mysql.h> #include …  |
| | Hi all, Over the last week or two i have been working on uploading images to mysql db, Whilst i have the image uploading to the correct location and the name of the image added to the database, i cant understand how to add the image location to the name … |
| | Hello to All, Good day :) I have developed a vb6 project with Ms Access as it's database. When I use Ms Access as a database, during the package and deployment, I will just have to add the file ".mdb" then all is done... -Ready to install in the client's … |
| | I am trying to find out how i would include the option to upload a picture as part of a form. i need help with the following: 1. how to add picture upload to form 2. how to store image in folder with the location stored in the database. 3. … |
| | hi there, wanna ask for your help guys, i know how to connect MS Access to Visual Basic, now, my problem is that, how can i connect MySQL to VB 6? could you give me some helpful code.. i have MySQL 5, MySQL Connector, MySQL ODBC installed in my computer.. … |
| | I have been working on this a while and have tried just about way trying to delete a row from a database using a button. What I have is a list of websites and data about each on each row. Then next to the row is a Delete button. I …  |
| | Hi, I'm working on a simple dating website with member profiles. I need to do something really simple, but I'm too tired to do this.. There is a profile table, login table and a profile_view table: profiles: profile_id, name, picture, etc.. login: session_id, username, time, etc.. profile_view view_id, profile_id, session_id … |
| | Checkebox doesn't hold its value when i use jQuery styling plugin wich allows me to skin form elements. but when i remove the jQuery the code works !! can someone plz tell me the way to fix it ?! Code: [CODE] <html lang="en-US" xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-US"> <head> <meta content="text/html; charset=iso-8859-1" http-equiv="Content-Type"/> … |
| | Dear all, I get the following problem: My users register on my website and enter a date of birth into the database (Mysql, DATETIME field). Now I would like to create a query that shows the upcoming birthdays within X days. For example: name [varchar(25)] :Tim birthday [DATETIME] : 1984-01-23 …  |
| | Hi, Can anyone help? I have 2 table each over 2M records and it is taking ages retrieving records. 1. A 'product' table that contains all products in store. 2. The second table is the 'offer' table which contains all offers related to the products (e.g price,store,product condition). 1. 'product' … |
The End.