[database] Forum Topics

Hi, Can someone give an example how the following task can be achieved smartly? I have this Database Table with 2 fields [B]1. Brand_ID 2. Brand_Name[/B] [B]SQL[/B] = SELECT Brand_ID, Brand_Name from brands limit 0,12; and I have to loop through it and place the values in the following HTML …

I found an old thread that had never been answered here - [url]http://www.daniweb.com/software-development/vbnet/threads/330981[/url] Basically, the guy was asking how to retrieve database names and/or table names from a MySql database with vb.net. Here's my answer to that. Yes, I still use vb6 because vb.net is not much better and I …

Hello, I'm trying to display a table in PHP that uses multiple MySQL tables with some repeated field names. [U]Master table field names:[/U] Name, Student Major, Course Major, Course #, Credits, Course Name This is what I have so far...but the variables in the loop are not working and I'm …

Hey, I am creating a website with two forms which contain checkboxes and displays and sends the values input by the user to display on the page as well as save onto a database. The languages I'm using are xhtml, php and sql. The problem for me is that only …

Hey, I've had this question for a while now and forgot to post a thread asking it. I'm really interested in databases and i've been wanting to create a program that recalls information from a database. I've done one that reads a text file but that just seemed...boring to me. …

hi, i'm using UTF-8 in my database and when i insert unicode characters directly through database it's all fine. But when i'm inserting through an html form using php it sends some kind of other characters to the database e.g : ආයුබෝවන් how can i solve this...???

Hi guys, I'm wondering if anyone can help. I have surryussface flu and I just can't seem to concentrate at all. I need to be able to select a colour from a list like the attached image. I've managed to code it right up to the part where it can …

hi all, i just started practicing android and sqlite database. i came across a very strange problem which i am unable to rectify.kindly help me out. Below i have out my DataBaseHelper class. (Description follows after the code block...) [CODE=java] package com.dialog.test; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; …

As an IT placement student I have reached the end of a 3 month project for the company I work for. I have migrated information to MSSQL server 2008 edition and I am retrieving the information for dynamic web page display using php. Now that I have everything in the …

Hey, I am very new to php. I have a PHP script (modified from [url]http://woogley.net/misc/Highscore/)that[/url] I call from a my Java code to access a database in order to read/write records. The SELECT part of it was perfect. However, i can't write to the database when I try to UPDATE. …

How to send the session data in one page to another? here's my code because I am going to bill out all of the orders and Name and ID of the current user logged int , the PHP code [CODE]<?php session_start(); include("Connection.php"); if (isset($_POST['submit'])) { $name = $_POST['customerName']; mysql_query("INSERT INTO …

I need to make the integer "order" save to a text file or database (All I need it to do is to count how many times you win & save it there). Every time the game starts up, I want it to read it, & every time the game is …

Please tell me that in Html website what is the code in javascript to connect to a MS Access database that is hosted on NIC Server. If not so possible in javascript then any other option what can added in HTML website

Please tell me how could i run .asp page on html website that is hosted on NIC's web server. Please reply at your earliest

I have written a Borland C++ database program some time ago that has been migrated to a new machine running Windows 7 home premium. Errors are showing up that suggest a problem with the relationships between tables ( related records are being mixed up ). When I check the tables …

Hello everyone i am a student who has very little knowledge about programming. I would like to know if there is a way to load list from a database to a combo box. there are two fields in my database namely: Age and Allowance. what i want is to load …

Hello, like before, I'm still trying to make a register page with login and logout. Here's the link to my server (If I'm not allowed to share links please remind me.) [url]http://fifarulez.dyndns.org/hacks4all.wapzan.com/registration/[/url] After the registration it will give 2 warnings. ( ! ) Warning: mysql_query() [function.mysql-query]: Access denied for user …

guys, when you log in a username and a password a msgbox will show that you are log in, and then when you enter the same username and password, the program will identify that the username and password is log out. no button will be use in here. what code …

Hello, I've always liked coding and lately I've learned a little but more of it. Now I also understand sql and db a little more. My problem is that my register.php file seems to give me a notice. Notice: Undefined index: op in C:\wamp\www\hacks4all.wapzan.com\registration\register.php on line 11 and Notice: Undefined …

Hi I am trying open a record from a shelve db I Know that it stops working at `copy = db[opened]` But why please help ASAP #*****START VARIABEL BLOCK***** #file = the database/shelf file #db = the database/shelf object #tapp = to be appended/recorded to the database #keys = a …

Hi. I’m creating a system for my client where he goes to a page where he types in a letter. The text is saved as a file (preferably PDF) and then sent as an email to a printing service. I’d prefer not to save multiple PDFs on my server, so …

Hello.. Everyone.. I am very new to PHP world.. I have got a lesson to Saving images in folder and paths to database.. I have tried a lot.. I have tried various websites but there has no complete solution! Will you provide me the proper code?

I need the dates in a specific range.And i want to get the result in java manipulating from a MySQL database.Now how can i do so. Suppose there are 3 days 17.08.2011,18.08.2011 and 19.08.2011 .I want the dates in the range 16.08.2011 to 18.08.2011 .So how can i manipulate it …

I want to write a script if database no this record. It will insert If database have tis reord. It will update [CODE]for ($a=0; $a<count($arr_event_id); $a++) { $query1 = "SELECT evnt_id FROM sales_roadshow WHERE evnt_id = '".$arr_event_id[$a]."' "; $result1 = mysql_query($query1) or die(mysql_error()); $row_s1 = mysql_fetch_row($result1); $P_numrows1 = mysql_num_rows($result1); if …

Hows it going guys, I just had a question, which I think is simple, but I cant seem to get my head around to the solution. I have a Signals Processing lab coming up on modulation and demodulation. Anyway to cut to the chase, one part of the system requires …

I need to update database table fields that contain URLs based on evaluation of the those URLs. Specifically, I need to eliminate the empty the fields of any URL that contains the directory "img_ours", and I need to take any URL that contain UPCs and change the URL formula, but …

Hello all, Im currently doing a project which is a system that adds booking records to it it loads the database from a module [CODE]Set Db = OpenDatabase(App.Path & "\cihansol.mdb") Set RS_Staff = Db.OpenRecordset("EPHS_Staff") Set RS_Customers = Db.OpenRecordset("EPHS_Customers")[/CODE] im very new to visual basic so i dont know much anyway …

Hi all, I want to create code to delete row in datagridview based on checkBox selection. I've managed added the checkBox Button using code below: private void FormTampil_Load(object sender, EventArgs e) { DataGridViewCheckBoxColumn checkboxColumn = new DataGridViewCheckBoxColumn(); checkboxColumn.Width = 30; checkboxColumn.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns.Insert(0, checkboxColumn); // add checkbox header Rectangle …

I want to insert data from the textBox to MySQL Database. Here is the code snipped that I have created. [CODE]private void button6_Click(object sender, EventArgs e) { string connectionSQL = "server=localhost;database=db_junisman_kulit;uid=root;password=;"; MySqlConnection conn = new MySqlConnection(); double no_simpan = 0; try { conn.Open(); MySqlCommand cmd = new MySqlCommand("INSERT INTO tb_backorder …

Hi. I'm new here and I'm new into coding so i have question. Where i can get Simple Php website with login and singup function. I was search in google.com but i don't find nothing what would be good enought.And i don't whant build it my self, becous i can …