11,093 Topics
 | |
| | OK, now that I have your attention, I've got a basic mysql SELECT question that I can't figure out. I want to return the team names for the code equivalences in the games table. I'm trying to do a lookup of the team name for both the home and away …  |
| | Hi, I have got visual basic program connected with access database, well I am planning convert it into mysql in a short time. On the other hands, I have quickbook set up as the accounting package. I want to pass the information that I have in access/mysql database into quickbook … |
| | Hi all. Bit of a problem - hope somebody can help. I am trying to return lists sorted alphabetically in my native language - Welsh. The alphabet: a,b,c,ch,d,dd,e,f,ff,g,ng,h,i,j,l,ll,m,n,o,p,ph,r,rh,s,t,th,u,w,y (29 letters) Note that there are 'double characters' - these are considered as single discrete letters. Roman letters (k,q,v,x,z) can be added … |
| | <?php class UserSession { public $php_session_id; public $native_session_id; public $dbhandle; public $logged_in; public $user_id; public $session_timeout = 3600; # 1 hour inactivity period public function __construct() { # Connect to database // $conn = mysql_connect($_ENV["DATABASE_SERVER"], 'db54496', 'HQe9rpTS'); $conn = mysql_connect('localhost', 'root', ''); if (!$conn) { die('Could not connect: ' . … |
| | hi all i am using phpmyadmin and i have 10 tables in my database. my problem is that i have two tables(tbl1&2) and their respective primary keys i want to reference to the same primary key of another table (tbl3). however the primary key of tbl4 is also referenced to …  |
| | Hi. I am complete beginner in databases, so please bear with me stupid questions. I am just doing for fun a simple exercise. A faculty have students and each student have different subjects. My question is, how to store the different subjects in the db? I could make up some … |
 | i have 2 tables: category, location. i create the tables: [CODE]create database tourist; grant all on tourist.* to dbuser; use tourist; create table category(id integer NOT NULL AUTO_INCREMENT,season varchar(20),num_summer integer,num_winter integer,PRIMARY KEY(id)); create table location(code integer NOT NULL AUTO_INCREMENT,town varchar(20),hotel varchar(20),price integer,star integer,media varchar(70),PRIMARY KEY(code)); [/CODE] i want now to … |
 | |
 | Hello... i have problem with UTF-8 encoding... My database and table collation are utf8_general_ci, and when I add new insert query in the database is ok, but when I'm trying to print i got -> ???? The results are: In the database -> Дамјан Крстевски In the browsers -> ?????? … |
| | Hi all, I am working as a dba in a small bank and I got an assignment to develop an in-house tool for detecting fraud scenarios. I know the technical part of manipulating multiple data sources and mining data, but do you happen to know what tests/scenarios the banks use …  |
| | Good day! How can i display the data from Mysql with the least value of primary key and when a user clicks the next button the next to the least data will appear and then the next and so on? Please help me here, thanks!  |
| | can someone help me? sometimes when my page (connecting with MySQL database) can't open normally, page will like this : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [TCX][MyODBC]Can't connect to MySQL server on 'server.doreminow.com' (10061) even this only for a while (5 - 10 minutes) but this bother …  |
| | Hi, I have a bit of a strange problem where I am unable to "echo" results from a database - I will show you the code then explaine what im trying to do [code] <?php include_once "connect_to_mysql.php"; $sql = mysql_query("SELECT * FROM table ORDER BY RAND(), LIMIT 1"); while($row = …  |
| | Hi all, I am trying to rotate adds that are from tradedoubler !! I have created a mysql db as follows id,add,link,title and i can succesfully connect via a php include and rotate my query to show a different add each time the page loads [code] $sql = mysql_query("SELECT * … |
| | Hi there, does anyone know any good tuts for displaying images using php. The thing is, I have a site that i search for a part number and it displays the info, that i can do but for some reason im lost when it comes to the images. Do i … |
 | As I said, I would like to make a PHP login /Register system that would be free for anyone. Here I have started. Since Iam not expert, then I will be adding small pieces until something emerges. I hope DW guys will help until it grows to mature. I want … |
| | 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"/> … |
The End.