[database] Forum Topics

Hi, I'm new to java, I'm using netbeans， I create two tables, master table and detail table, detail table has a composite primary key, one of the primary key refer the master table's primary key, when I created a desktop application, the detail parts only show the columns which are …

I have a project, it's simple game just to make a game called congklak. it is traditioanl game from Indonesia. The project has finished, and work, well compiled, all components like package, database (*.mdb), and all the pictures are read by programs. But when it's deployed, the pictures and database …

Hey there. I have a program that uses access, and everytime i go to install it for some one i have to keep my fingures crossed and hope they have office installed on their pc. Is there a way to run my program without buying microsoft office? (using access database) …

Connection String define('HOSTNAME', 'localhost'); define('USERNAME', 'khabarez_naveed'); define('PASSWORD', 'naveed'); define('DATABASE', 'khabarez_naveed'); $dbLink = mysql_connect(HOSTNAME, USERNAME, PASSWORD); mysql_query("SET character_set_results=utf8", $dbLink); mb_language('uni'); mb_internal_encoding('UTF-8'); mysql_select_db(DATABASE, $dbLink); mysql_query("set names 'utf8'",$dbLink); Select Query $query ="SELECT * FROM test"; $result=mysql_query($query) or die ("Connection to database table failed. 106." . mysql_error() ); while($row = mysql_fetch_array($result)) { //$result_no=mysql_query("select count(*) …

hello, I have a situation that i'm wondering if there's a solution. I have specific databases for different cities in texas. I plan on adding more but i do not nkow how many more or what their names will be. Every city is going to have the same tables in …

Hi! Im new to MySQL RDMBS. I know the basic CRUD if you know what i mean. Create Read Update Delete. I have 2 tables: Category table and Product Table Products should be categorized. Product table has PK as an ID and FK to Category Table How to INSERT INTO …

Good day guys =) ..., i know there are somewhat similar threads of this around here but i still cant find the one to solve my problem ... well i am currently building an online store.. and in this online store there's a table of products with the an image, …

Hey. I am working on some sort of client + project management system. Each client can have many projects, many projects can have many staff. The Link (Junction) table allows for many staff members to be linked to the projects. I have attached the relationships which have been put together …

hi, i'm working on this new system which give the option for the user to choose which system method his/her system will work on, eg: file system or database system. when installing the system they can choose the option file or database, assume that user chosed db system, later on …

Hi! Im new to php web development. I am developing an online shopping system where theres an admin page that allows him to add, edit, delete category and products. to cut the story short, what I want to know is, is it safe to save the table for admin username …

Please someone should help me before I faint. I have been working with this login script and am getting this error on a server: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/utimate/public_html/PhpPractice1/index.php on line 32. When I test it with wampserver, I will get this …

so i have a working ish program now, when i add the record it saves and returns the save message box as it should and is viewable in the database where it saves to, but it is not viewable in the text boxes when looking back at the form until …

hi, I am getting this error: Parse error: syntax error, [B]unexpected T_STRING in C:\xampp\htdocs\makedatabase.php[/B] on line 2 here is the code: <?php CREATE USER("jeffrey"@"localhost", IDENTIFIED BY "mypass"); $con = mysql_connect("localhost" ,"jeffrey","mypass"); if (!$con) { die('Could not connect: ' . mysql_error()); } if (mysql_query("CREATE DATABASE my_db",$con)) { echo "Database created"; } …

Hello. I couldn't think of any better name for the title. To the point... I have this database reader method, and In the while loop, where the liga[] is being populated, all its values are the last that is read from DB.. Clubs ID are from 1 - 10 Any …

Hey everyone! I am working on a project that involves querying a mysql database using php, and I am running into some issues. html form is in list_files.php and the query is in query.php .. i also attached my mySQL database which has 2 tables: only the file table is …

Hi All I am creating a program which will (in the end) help me quickly transfer products from one category into another within a MySQL Database. I have a database with TWO separate tables which are connected using INNER JOIN where the products have a categoryID as do the categories …

A new version (9.0) of [URL="http://www.postgresql.org"]PostgreSQL[/URL] is in beta and ready for public testing. If version 9.0 lives up to its proposed [URL="http://www.postgresql.org/about/featurematrix"]feature list[/URL], then it is serious competition for MySQL. PostgreSQL proponents have long suggested that PostgreSQL has always enjoyed superiority over MySQL. I beg to differ but that …

Am using neatbeans 6.8 to develop java application,am able to package and deploy java programs and run them on my computer but when i package and deploy a java program with database it fail to connect with the 'com.mysql.jdbc.driver'.i know someone out there can just post on how to do …

how to make offline database use vb.net and microsoft access?? please help me.. urgent

Hello :) I'm working a project for class that involves a database connection. I have an Acess database called "Libraries" that contains two tables called Libraries and Books. I have to create a form that has two DataGridViews(one that contains the Libraries and their ID #'s, the other that has …

Hello masters! I have a project and need a bit of your help. I would like to access/get values from certain fields from a database and assing that value to a variable. Database is included into my project along with DataSet. Is there any simple way to access certain field? …

I am attempting to take 2 integers from a MySql table. X represents a number that will be stored into an array. Y represents the number of times that X will be put into the array. I am attempting to make a loop that will go through, find all the …

Hi All, Hope your all well Im really new to the world of JSP & AJAX, my question is, I need to retrive names from a database and present them to a user on a JSP form, but I shouldnt show any database interaction on the client end, So as …

Hello I am having some trouble here, I created a Microsoft Access dataset (.accdb) It is being used with some listboxes, comboboxes etc. The problem is when I publish the whole thing the datasets do not publish along with it and my program opens but there are not values. Anyone …

I've my data in a Database. Using SQL,I need to print it on a list For example, My Table is: Teachers, and it has ID, Name and Phone#. I need a button which shows all this data in a list. My first thought is with a DataGridView.. ID Name Phone …

hi everyone, i need to print error message if ID is greater than 1 and log user in if username is correct and display error message if the username is wrong. the code print error message if id is greater than 1 and it authenticates user if correct username is …

Good day everyone, i need to print error message if id or row[0] is greater than 1 and a welcome message if name is correct and error message if the name is not correct. what my code does is that it prints out error message if id or row[0] is …

Hi Guys, I have a 2 errors with PDO: Sometimes give me this error: Connection error, because: SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 111 Other time sent me this: SQLSTATE[42000] [1203] User [MYUSERNAME] already has more than 'max_user_connections' active connections This is …

Ok, I am walking my way through an instructional php book and basically going over the basics again. After I finished doing the script the way the book said to do it, I kept getting a header error saying that the headers have already been submitted. The book had my …

Hello, I am having trouble inserting data from a XML file into a table in a SQL data base. The worst thing is it isn't coming up with an error but nothing is being inserted into the database Here is the condensed version of the XML code I am using …