10,946 Topics
 | |
| | Hi, Can any one suggest how to organize data while using Solr. |
 | hi pls tell me this command is correct or not..... if wrong give me the correct command....... [code] "insert into guesthouse(status) values ('C' where (date_of_arr <= getdate() and date_of_dept<=getdate()) or 'O' where(date_of_arr <= getdate() and date_of_dept >= getdate() or 'S' where (date_of_arr >= getdate() and date_of_dept >= getdate())[/code] here iam … |
| | hey guys... can anyone help me in connecting xammp to vc#.net?? xammp is a package and mySQL is one of its softwares... i cant connect to my database... can anyone give me a code/s....tanx guys....  |
| | How can we connect two databases to PHP at same time. Like .. retrieve data from Mysql and compare it with MSSQL data. :-/  |
 | Hello everyone! I'm Amie, and I'm a little new to PHP and MySQL. That being said, I am attempting to create a Login form with a username and password field. I pretty much have it down with the structure I think. I set up the MySQL database with GoDaddy. I … |
 | Hi All, Help if you can, The following script wont insert a row into my table. There is an auto increment field at the start of the table called "ID". [code] <?php // this is processed when the form is submitted // back on to this page (POST METHOD) if … |
| | 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' … |
| | im new to python, been working in php largely in the past, but wanted to learn something new and different. as such, i want to use python to create webpages, but have been tinkering in the IDLE until now... when using php, I use a local install of WAMP... is … |
| | Hi and I have a database with over 32 million entries and whenever I try the below mysql query or simular it crashes the sql server unless I use phpmyadmin. I have 4 columns all indexed and all are the char() type with a fixed length. Below is an example … |
| | I am tring to import a database from another server that is 10gb in size the database came to me as 10 files xaa xab xac xad etc. I ran a command to dump the 10 files to 1 10gb file mydatabase.sql When I first tried to import via command … |
| | So I'm using Mysql to make a text-to-speech engine. Basically any given phrase by the database is returned to my script, which has to say every word and number, if any, by way of voice . For the voices I'm using Asterisk, but that's another problem of my own lol …  |
| | Hello everybody. I'd like some help with a query. I have a database named 'base1' which contains many tables. Some of the tables have names like 'track1' , 'track2' etc... which have identical columns. I would like to select all the tables beginning with track and show the data of … |
| | [code] <?php session_cache_limiter('private,must-revalidate'); session_start(); require_once("config.php"); include ("classes/db_functions.php"); include ("classes/display.php"); $dbf=new db_functions(SM_DB_HOST,SM_DB_USER,SM_DB_PASS,SM_DB_NAME); ?> <link href="style/report.css" rel="stylesheet" type="text/css" /> <?php if (@$_POST['Submit']=="Save Report") { $sql = "select * from customreport order by id desc"; $linkID=mysql_connect(SM_DB_HOST,SM_DB_USER,SM_DB_PASS); mysql_select_db(SM_DB_NAME, $linkID); $result = mysql_query($sql)or die(mysql_error()); $nume = mysql_num_rows($result); $row=mysql_fetch_array($result); if (!empty($nume)) $nume = $row['id'] + 1; … |
| | I am having trouble with a page where i need to insert data into a SQL field. It comes up with this error 7 times: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in / i would post the actual php page but its over 1000 lines … |
| | Hi guys, Hope i'm putting this in the right place. Apologies if i'm not! I'm making a website for a sports suppliments supplier. I'm having some trouble with how to layout the database. I have a navigation menu which has all the categories listed. But some of my products are … |
| | How can I do a constraint/trigger to check a value from another table for example CHECK tblAcademic.role = 1 and [currentable].post = 1 Please help |
| | Hi All! I'm setting up a very small DB to be used for customer based product reviews. There are two tables: [code]product_tbl: id int unsigned auto_increment reviews int unsigned // number of times product reviewed product varchar(45) [/code] [code]review_tbl: id unsigned int product_id int unsigned // id from product_tbl price … |
| | I am trying to create a trigger that updates one field in a table different from the one being updated/inserted. My create trigger code looks like this: [code]CREATE TRIGGER before_insert_ddsw BEFORE INSERT ON `ddsw` FOR EACH ROW SET products.count - products.count +1; [/code] When I try to create this I … |
| | Hi all. I've been making a site for my gymnastics group. I've got some background on both programming, mysql and PHP, mainly from university classes. However, all the projects where done in localhost, and now that I'm getting in the "real world" I'm having a few problems... The two main … |
| | I have a database in which my parent_id same for many rows. So I wanted to write a code which groups all similar images in a paragraph. How can I do this. |
| | Hi, When i try to restore a database, I get this error [CODE] ubuntu@ubuntu:~$ mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 44 Server version: 5.0.75-0ubuntu10.2 (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. … |
The End.