Databases Forum

Hello, I am trying to display various types of search results on a seperate page: Here is my PHP CODE for the form: --------------------------------------------------------------------------------------------------------------- <table width="75%" cellspacing="10" cellpadding="10"> <tr> <td width="22%" class="subtiwhite"><strong>Search by Name:</strong></td> <td width="74%"><form name="form1" method="get" action="searchname.php"> <input type="text" name="namelist" id="namelist"> <input type="submit" name="searchname" id="searchname" value="Submit"> </form></td> <td …

Hello DaniWeb, I have been working on a Maintenance Application. My company builds a specific type of system using specfic types of components. What I need to be able to do is keep track of which component is in which system given a certain event. ComponentType Table: Ident, Type ( …

So i have this table: numb_1 | numb_2 | numb_3 ------------------------ 5 | 5 | 5 1 | 5 | 5 2 | 2 | 3 5 | 3 | 6 5 | 4 | 7 how do i find the most common value in the 3 fields? so for …

Hello. I'm new to php and sql. I nee to insert data in multiple tables and rows. the problem, in the first table, I just nedd 1 row, and that's fine, in the scond i need to input data in the minimum of 1 row and max of 6 row's. …

Hello DBAs, Any one familar with the ER diagram generation in TOAD. I am able to generate the diagram for one particular table. I need to generate for the whole schema. Can you please help me to find out a way? Always Thanks, BMantri

I am trying to create a search form for my database where a user can search for a customer name and all of that customers addresses will be displayed. my structure looks like this Customer table + ID + First Name - Last name - Company Name Address Table + …

Hi Friends i like to know more about the difference between mysql, Phpmyadmin, sql and also which one is more safe and secure for webpage. Can any one help me to know about it.

I have created a linked server in ms sql 2005 on server machine A . It links to another database(say D1) located physically on a different server machine B. I have jsp code on Server A which accesses local database on server A. Can I access the remote database D1 …

Hey Friends, I recently came across a question which asks to approximate the data volume of a table which contains 10 Million records. Any idea on how to do it? Thanking You In Advance.

I am running easyphp12 running mysql as a local db server for a some software. This software can also connect to a remote db where it doesnt give this error while performing the exact mysql query, so I only get the error when using the local db. Ive tried increasing …

Hello all, I'm trying to set up an add contacts page but when I click submit then check the database there is nothing there. I ran my sql query in phpMyadmin and got an error but for the life of me I cannot figure out what is wrong. I can …

i have 'topic' and 'comment' fields in table of database ,when some one give comment on topic no 1 ,it save in dabase with topic number and comment, i want show topic number with higest comment. tell me sql query to show result

I am wondering if anyone can help me or point me inthe right direction. We are currently subscribed to a company that allows us to list products onto eBay. We can upload images through their web interface. For every 10Mb of images we are charged extra. Their is a count …

Hi. I am having trouble with this: <?php $host="localhost"; // Host name $username="username"; // Mysql username $password="password"; // Mysql password $db_name="database"; // Database name $tbl_name="table"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); // Line with the error (Line 8) mysql_select_db("$db_name")or die("Error. MySQL …

How do I change all greater than .00 cents to .49 cents be .00 and all greater than .50 to be round off? I'm using SqlYog btw. Example: price 1: 16:03 price 2: 16:53 Output: price 1: 16:00 price 2: 17:00

Every once in awhile I get email from my web site vBulletin that there is an error on MySQL. Below is the most recent error message. Looks like it might be caused by a hacker to me, what do you think? I've asked the technicians at iPage and they have …

Im going to create database.there are few table in that db. I need to know what is the best ; add more column to table or use separate table rather than add more column

I'm new to triggers, but have been working with MySQL for quite a while. Now I need to implement a trigger. I want to create a trigger on my 'persons' table so that after an update, ***if the attribute clubid is changed***, attribute clubname should be changed. I have a …

I have problem with database system that where it would make sense not to use a database system?? Practically I didn’t meet such that situation and need to know about your ideas. (It not need to practical at always) Thanks

Hi Guys, Here is my requirements: I need to pullout records based on datetime fields ranges from 12 am in the morning of 2012/6/4 and 12 am in the morning of 2012/06/05. kindly please check my declare parameter for date if it is correct. Thank you in advance. Data: Declare …

I have about 16 tables in a database schema that are empty and wish to populate them with junk row values of the same type which I have defined,is there a way to do it?

Hi there, I have a form with some fields. Address is one of them. I used textarea tag for address. Now the problem is, when i search something according to one address, it only works for the one line addresses. I mean if i entered a newline (Paragraph format) in …

Hi guys i first thank you for helps. and i have a script i use that for application authentication In fact the users must use your user name and password to use that App then after authentication of they user and pass passed they allow to use that application. and …

hi, what is the query to fetch duplicate (related) records in oracle.

hi I am having a challenge with a Fetch statement being used in a stored procedure. I am declaring a cursor and fetching data into a set of variables. The variable types match the column declarations exactly. There is data in the table from which I am fetching. @@FETCH_STATUS is …

I have a column called pEditDate in the table rc_Pages I need to extract the date for each page so when the users goes to page /example the last edit date shows at the bottom. I try to do is but can't. Using SQL Server Comptact and C#

HI,I WANT TO LEARN SQL IN PROPER MANNER.PLZ TELL ME SITE FROM WHERE I CAN LEARN ..

We are running a C program where for every one second there is a function callback. Below is the snippet of the code listed. It is ran over every second without missing so we notice sometimes when is busy doing the insert part and the next select is up and …

Hi, These are the opening lines of my code USE myDatabase GO PRINT '@@FETCH_STATUS: ' + CAST(@@FETCH_STATUS AS nvarchar(30)) This returns FETCH_STATUS as -1. I have just opened the connection. Can anyone tell me why this is occuring?

I need to store both text and images to be stored in the same field? How can this be implemented in php using a mysql database? I have used BLOB to store images in the past . Which datatype should I use for this problem? And how will this work...? …

Hi guys I got a table called rc_Pages then I got a column called pName (Pages Name) and now I have made a new column called pCategory (Page Category). Since there are like 60 pages and updating the pages manually can be a big issue. I need to set the …

i was wondering how can database replication on a sql server be accomplished?

IN ORACLE 10G I CREATED A TABLE AND INSERTED 3 ROWS AND COLOUMNS.NOW MY DOUBT IS WHERE THE DATABASE FILE WILL BE STORED????THE REASON WHY IAM ASKING IS BCOZ IT MAY NEED FOR JAVA CONNECTIVITY

how to delete duplicate record in a table by using SQL query

hi need to show the duplicates on a column table when they have two other values in common on other column. form_name + field_value name1 | value_x name2 | value_y how can i create the query to search when values x, y, etc have form_name name1 and name2 ? thanks

Hi, I’m making an online database (with some help). What I’m having trouble figuring out is how it might be possible to sell ‘records’…or rather the ability to add records. I would sell access to the database based on the number of records a user buys. Once you buy a …

Hi I am basically designing a database to store our development team metrics...here are some of my tables. What do you guys think? I am having a lot of trouble coding this on SQL Server so that question is asked towards the bottom :). ProductTable: productID (PK) productDescription SprintTable: sprintID …

hello ! may God bless all of you, i m good in mssql , but this is very first time that i am very confuse , the case is , i have a table , having fields 1- ContactPersonId 2- Name and 2nd table having fields 1- recId 2- ContactPersonId …

I have a bunch of records that I get from doing multiple joins. # Name, ID, Date, Gender, Birthday # John Doe 111 01/02/2003 M 01/01/2001 Jane Doe 222 03/04/2005 F 02/02/2002 Jane Doe 222 **03/05/2005** F 02/02/2002 Jim Doe 333 07/08/2009 M 10/11/2012 What I am trying to get …

Hi I have databse having id and name field. In that I wanted to fetch random names from that database but the records which fetch in 1 st attempt wpuld not repeat in next attempt. May be this can be done by using some stored precedure or something else i.e. …

Hello, I have a MSSQL database with a table called "people" and a table called "attendance". The people table contains the person's ID (primary key, identity increment), last name, first name, and active fields (I would only be interested in grabbing fields where active = Yes). The attendance table contains …

how to drop multiple columns at a time.. i tried with the following syntax "alter table <table_name> drop column <col_name1>, <col_name2>" but i am getting syntactical error.

can we use double quotes to the column name while creating a table?? if yes, then how to insert the records into it???

Hey experts. I have two database, i want to fetch values from one of the table from one database and then insert that into another table on another databse, server is same. can i do it? if yes please give some suggestions how to make it hapoen. many thanks in …

Hi guys, Just looking for some advice on database design. I'm relatively competent in MySQL (competent at a push, haha) and I'm in a bit of a pickle right now when I'm trying to generate products for a Magento store. Well, Magento is where it ends up, I currently use …

I want to fetch names and address of all my friends from facebook and store it in my system, Can AnyOne tell me how this can be done with html, php or anything...I don't have any idea for this..

In my script, I have a table displaying the results of a SQL query. However, I am using the results as a sumamary, but the SQL is making the page display the table as many times as there are results (rows) in the returning SQL that are allowed because of …

Dear All, I want to create a dynamic website with a database. Visual studio 2010, dreamweaver CS5, sql server management studio and all other requirements are installed (like IIS 7). I set the IIS server configuration in dreamweaver cs5. I check simple ASP codes like <%Response.Write ("The time on the …

Hi, I'm creating a website/database that my dad and his partner will use to help manage there business. update new appointments / manage customers ect. My dad wanted to host it on our server, however I'm not confident about setting up security so I was just going to use a …

Hi all, Here's to hoping that a SQL Server guru is hiding among the ranks of DaniWeb members. I have two servers, DB01 - the production database server and BKP01 - the backup server, that are in two different geographical locations. Since some queries on DB01 are accessing BKP01 there …