[database] Forum Topics

Hi everyone! So, I'm trying to create a program which users can add, update, delete, view, and search records but I am having a hard time about updating records in my database. In my Update form, I've got 1 dropdown menu or option that contains ID number and when I …

Hello there Quick insight of what im trying to achieve here is. User adds data to a database called property in (addproperty.php) Then user can search for specific data in that property database Here is the code addproperty.php [CODE]<?php $dbhandle = sqlite_popen("property", 0666, $err_msg); if(!$dbhandle) die("Could not open the database"); …

Hello there i would like someone to have a peek at this code and does it solve the question correctly ?? Are there any mistakes or any improvements i could add ?? Thank you Question: 1. (a)modify the addnames.php script to read in and store two fields of data – …

Hello there i would like someone to have a peek at this code and does it solve the question correctly ?? Are there any mistakes or any improvements i could add ?? Also If any one could tell me how to save the data entered by person into one file(XML)so …

Hello all! I currently have a drop down which consists of a list of names generated from the database. My problem is that when selecting a name from the dropdown I would like to insert the name and the corresponding ID into the database table. I am not sure if …

Hello there i would like someone to have a peek at this code and does it solve the question correctly ?? Are there any mistakes or any improvements i could add ?? Also i struggle in this questions as i do not get it fully(in fact i dont get what …

Hello there i would like someone to have a peek at this code and does it solve the question correctly ?? Are there any mistakes or any improvements i could add ?? Question 3. Write a script to search for the properties which match a postcode (call it search.php ). …

I'm a having a serious problem creating variable. I am creating an application that gets its datas from a database, and before you can access the application you must login first. My problem now is my Login class can do all the validations but I don't know how to set …

Hello fellas :) I have a task to do, there are 10 questions and i obviously need 10 answers :) I have done (attempted) some of them /not every yet/ but i wonder if there are any errors or any correction or improvements that could be made :) Thank you …

Hi there I was wondering if their is anyone who can convert this statement from 'INSERT' to 'UPDATE' as I cannot seem to do is. Code can be seen below: [CODE]public static void COUNT2( ) { try { ResultSet res = stmt.executeQuery("INSERT INTO TABLE2 (VIDEOID,VIDEONAME,DIRECTOR,RATING,PLAYCOUNT) SELECT VIDEOID,VIDEONAME,DIRECTOR,RATING,PLAYCOUNT FROM TABLE1" ); …

I've looked up many different answers to the question I'm asking but none have them have seemed to work and im completely confused as to why. Here the the problem: When ever I enter the information into the form on the website, I get the message Error: No database Selected. …

Hi guys what I want to do is once the user has entered the id number it displays the results for the particular record. This works fine however what would I need to do to the following code so if the id number does not exist it produces an error …

Hi guys can anyone tell me if it is possible to sort integer values for smallest to biggest which has been stored in my database as Strings. What I want to do is list my items in an textarea that sorts the numbers from smallest to biggest. Also note if …

Sorry I'm new to these stuff but I am having a hard time about this. So I'll trying to create a php and mysql program which can view records from database server. In my form I have 2 dropdown list and 2 submit button, the first one the the list …

Hey fellows, I have three database tables AUCTIONS auction_id name description place date BIDDERS bidder_id firstname lastname email signupdate BIDS bid_id auction_id bidder_id biddate I want to create a drop down menu to select and display BIDDERS signed up for each AUCTIONS. I have coded the following in PHP to …

Hi, I keep getting the error: Object reference not set to an instance of an object. When attempting to check if a database record is Null or not using the line: [CODE] If IsDBNull(dSet.Tables("Subscriptions").Rows(incr).Item(8)) = True Then addsub2() End If [/CODE] I'm sure that I have opened and closed the …

Hi All, I am new to programming and have been trying to learn the c++ language for the last couple of weeks. I feel that I understand a lot of what I have learnt but where I am confused how databases are used if c++. Most the tutorials or books …

Hi all, I just wanted to let you gals&guys know about Opa (opalang.org), a new programming language for web development. I think Opa is really cool. It takes care of both server- and client-side programming in one language, where all the communication between the server and clients is fully automated …

Hi guys well I have two class's 1 class for my methods and another class for my GUI. In my method class I have my update statements for my database and in my GUI class I have obviously my gui and all my buttons that will produce a result when …

This is my first post on Daniweb. I am developing a social networking site and the register form isn't quite working as expected. Here is the PHP code : [CODE]<? $title = 'Register' ?> <?require ('scripts/top.php'); ?> <link rel='stylesheet' type='text/css' href='scripts/form.css'/> <div id='content'> <h1> Register an account </h1> <div id='form'> …

Hi, I am making a website for a car database. I made a table called Cars with fields Name,Make,Model,Color,Doors. I have also made a search function: [CODE]SELECT * FROM Cars WHERE Name LIKE '%$search%'[/CODE] This is a general search that will search the whole table, but what if I wanted …

Hi guys well I have successfully got my update query to work correctly. Now I have two tables in my database. What I want to do is when I click my play button not only does it update my column's in my first table but all updates my colunms in …

Hello, I'm currently following the video tutorials found on asp.net (the site)\ And I just finished my delete page but I'm getting errors. This is the code of the page DeleteMovie.cshtml [CODE]@{ Layout = "~/_SiteLayout.cshtml"; var id = Request["MovieID"]; var SQLSELECT = "SELECT * FROM Names where MovieID=@0"; var db …

only the first item in the combobox will be returened even if i selected another item. HELP! [CODE] try{ //combobox of the products rs = stmt.executeQuery(query2); rs.last(); int i = rs.getRow(); String [] v = new String [i]; rs.beforeFirst(); i = 0; while(rs.next()) { v[i] = rs.getString(2); i++; //break; } …

I want to retrieve email from database and send message to all the email address. I have written code for that but it is not working. I want someone to help me look at the code below and point out where am making mistakes and the correction. The first page …

is it possible to access an access database without ms office or just using references or .dll

This is my first time to do visual basic program Please help me about this problem... When I run the program with maximum attempt of 3 with correct username and password, Illegal user will pop up,,,i really dont know what to do..illegal user must be pop up when i already …

Hi guys!I'm currently making a database project and I want to update an access database. I connected the database using this sql command 'select*from word' And I tryied to update the database using this code ds.tables('word').rows(0).item(1)=”cat” Dim cb as new oledb.oledbcommandbuilder(da) da.update(ds,”word”) da is a data adapter ds is a …

Hi all, first post here, please excuse the newbieness!! I am a complete and total beginner to web development in all forms other than mediocre HTML and CSS. Please be gentle and use small words!! :-) I have recently installed Microsoft's Visual Web Developer 2010 Express in order to have …

I am using Entity Framework in Visual Studio linked to a back end database and would like to change the column name of the tables. Currently they have underscores which I want to remove, although there are many tables and columns. Is there an easy way to do this? I …