Databases Forum

Hi, I have a problem. I would like to, from a text form, filter out what the user wants to see. I have a mysql database with info on every order placed. Each row is a new order. All users has their own ID. I would like the users to …

I am trying to setup a page on my website with a text input box and a command button. A user will type the serial number of their product and click the button...the result I am looking for is a message telling them if their product is in warranty, out …

i know this maybe to easy for you, this is what i need to accomplish: 2 list menus 1.- Manufacturer (Honda, Kawa, Susuki) 2.- Model (cr250, cr125,etc..) each manufacturer has their own models 3.- Year(1999.1998,etc..) So i would like to have the first list menu listing the manufacturers options and …

Hi guys, How can i store multiple image paths in one single MySQL field, help please Thank you OCBPHOTO

Hello, I was wondering if someone could help me a bit here. Im trying to desing an electronic university students enrollement system. The system requirements are as follows: 1.Students can enroll themself for 1 or more courses. And a course can be taken from 1 or more students. 2. There …

I have an ER model which i need to convert into a relational database design. Can someone please let me know if i am on the right track? Also how do i represent a foriegn Key, do i use italics, and for prinary key underline? I have attached the ER …

Hi guys, i need some help with a too complaicated query for my little brain. I have the following query: [CODE]$query = " (SELECT pic, text, main, gr, min(nr) AS nr FROM info WHERE (gr>0) AND (stl LIKE '$stl') AND ((quantity >= 0 and utg!='J') or (quantity > 0 and …

Hi, I've got a major headache with a SQL Union statement. Basically I'm running a SQL Union statement in ASP that is not returning the first few unions. But if I run the SQL in enterprise manager it runs fine. I can't find anything on the web that even remotely …

Does SQL support ASCII data type?Or we need to do some type casting for it.?

What are the main differences between trancate and Delete? And is "select" command is DML or DDL?

Hi How to start mysql with binlog option enabled in windows. thanks in advance awaiting your reply regards aras

Hey Guys, I want to know how can you connect to multiple tables at a time. I need one table to validate the username and pasword. I need another table to show his details. Please Give Some suggestions(I am using php and MySQL)

hello! i'm implementing an e-commerce system to distribute key codes. right now i'm thinking of a sql syntax to do the following: i have a table: orders here i have the orders_id field (unique for each order placed) with this orders_id field there may be more than one products ordered …

Hey Guys, I've heard that SQL Injection is one of the most common tool that the hackers use to hack a web application. Can anyone please give me a brief overview of what SQL Injection is or any webpages that I can refer to. Thanks

Hi all, I have a problem with my php and mysql project. I use an auctions software, named phpauction for my project. I import into my database with utf8 encodingm and I can see the greek letters inside the fields. The problem is that when i go to the site …

Hi! I started to study Oracle a few days ago and I felt the need of Oracle Database Application. So I entered the Oracle web site and tried to download the given link for download However, then I was requested to submit my "Single Sign-on" User and Password. Moreover, I …

please anybody tell me the query to transfer some amount of money from one account to another account.

Hello again, I'm having a problem and don't know what is causing it. I'm copying from a book. double checked and can't figure out why I'd be getting this error (below in quotes) Link to live view of what is being accomplished (trying to be accomplished) [URL="http://skywardz.com/address_book/addEntry.php"]http://skywardz.com/address_book/addEntry.php[/URL] LINE 87 : …

Hi guys, Probably this is something really over discuss but would you be so kind to teach me. I want to store prices on MySQL table, i currently have my Data Type as FLOAT with my prices on the table but it renders only the same number, what is the …

Hi, I have a cookie with 5 products. There will be a loop to read one by one and reduce from stock in database for each product. Now, If something goes wrong half way through i want to cancel whole transaction. For example; everything went ok for first 3 products …

I have two tables with foreign keys to the same parent table and a junction table between them to map a many to many relationship. I want to know how best to enforce data integrity in the junction table so that both parents' parent is the same. Example: [code=sql] CREATE …

hi friends I need the query , I have stored the ids like this 4,10,12,13,14 in one filed. I need to search the id 4 avaliable in the one filed , how to search the number one single filed? Please advise

Hi i'm a newbie to PHP and MySQL. I was wondering if anyone could help me with some code to Add 1 to a number that is assigned to a person in the database. So, the person types their name in a form. Then the form has to find that …

hi, i'm using LIMIT command in mysql query to retrieve top 9 records but it takes 10-12 min. pl help. thank you in advance

Hi everyone can someone pls help me with my data. I have an sql table(Test) in this form Student_No Grade_code Test_N0 Mark 20427103 DS302 1 60 20427103 DS302 2 65 20427103 DS302 3 60 20427103 DS302 4 70 20427103 DS302 15 69 and my stored procedure Select * from Test …

Hi, again... Can someone help me with the following code: [CODE](LINE 74:) $get_addresses_sql = "SELECT address, city, state, zipcode, type FROM address WHERE master_id ='".$_POST['sel_id']."'"; (LINE 75:) $get_addresses_res = mysqli_fetch_array($mysqli, $get_addresses_sql) or die(mysqli_error($mysqli));[/CODE] it brings up this error: [QUOTE] Notice: Undefined index: sel_id in /hermes/bosweb/web185/b1859/sl.mavedog21/public_html/address_book/selEntry.php on line 74 Warning: mysqli_fetch_array() …

Hi, newbie here just been going through the "Sam's Teach Yourself - PHP, MySQL" book. I've retyped the code for viewing records in an address book. My problem is this line appears to have a problem. Does it look correct? [CODE]$get_list_sql = "SELECT id, CONCAT_WS (', ', l_name,f_name) AS display_name …

I'm working with MS SQL Server 2005. I am trying to add two columns together, and I have more or less succeeded. However, it obviously adds the entirety of each column, rather than calculating for each row. I can't just include each column in the original SELECT statement, because it …

Hi, MySQL function below is not working. I cant find the mistake. Can you help me? Thanks [code] CREATE FUNCTION testVAT(DECIMAL(4,2)) RETURNS DECIMAL(4,2) DETERMINISTIC BEGIN DECLARE myVAT DECIMAL; SET myVAT = (myMoney * 0.17); RETURN myVAT; END; [/code]

Hello, I have two mysql db which contains 23 tables. The problem is that i have merge them in a one db. Is it possible? Thank you!

Hi Friends I am working to draw a graph . I need to get the data monthly, for example JAN total hours FEB total hours , How to write the query get the total values per month? Advance thanks for your reply.

Is anyone familiar with Oracle based Banner?

Can anyone please help me.........I am at a loss. I am trying to install sql 2005 server on a windows 2003 server and am getting an installation error. The error states that there was an unexpected failure during setup wizard, and to review setup log. [B]In the log there is …

I am looking for some database software I can use on my website. Some type of software that is just like forum software only scaled down without the members posting. More or less looking for something were I can easily post and update items all formed in a database just …

Hey Guys, I have the following code, which averages the scores in a select statement and works no problem. [code] SELECT AVG(score) as 'avg' FROM (SELECT d_key_id, frequency, weighting,(frequency*weighting) as 'score' FROM users_to_keywords WHERE s_user_id=$user_id AND d_key_id = $score_key ORDER BY score DESC)a [/code] However, as there are some duplicated …

I have recently issued nearly 2000 ID mifare cards to all the new students who recently started at the college at which I work. Accidentally, the software that printed the cards reversed the LSB of the UID of each card which means I have a useless database of codes. I …

hi, I am trying to replace certain strings in my mysql database. I have addresses such as this: 60 W 23rd St, New York 10010 Btwn 5th & 6th Ave I would like to get rid off all the words starting from New York including the comma before the word …

I have setup the following table:- [code] IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TlHold') DROP TABLE THold GO CREATE TABLE THold ( pid int NOT NULL IDENTITY(1,1), TS NUMERIC(2,2) NOT NULL, TR NUMERIC(2,2) NOT NULL, TB NUMERIC(2,2) NOT NULL, TP NUMERIC(2,2) NOT NULL, TP2 NUMERIC(2,2) NOT NULL, filler1 …

Hi all, Im very New to My SQL and have done alot of googling and simple studies. I have two Questions: 1. Where can I start with Complete no knowledge of MySQL and databases in general (though i know a little) 2. I have tried to play with MySQL for …

[CODE] CREATE TABLE `categ` ( `id` int(10) unsigned NOT NULL auto_increment, `categ` varchar(32) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; INSERT INTO `categ` (`id`, `categ`) VALUES (1, 'General'), (2, 'Politica'), (3, 'Sport'), (4, 'International'), (5, 'Cultura'), (6, 'Hitech'), (7, 'Showbizz');[/CODE] [CODE] CREATE TABLE `ziare` …

I will explain... I downloaded `"mysql-5.0.45-win-src.tar.gz"` from Mysql download area.I tried to built Mysql.sln inside that,but i am getting errors(about 58) like Error 149 fatal error LNK1181: cannot open input file '..\zlib\release\zlib.lib' mysql_upgrade Error 319 error PRJ0019: A tool returned an error code from "Performing Custom Build Step" mysqld Error …

Hi, I'm new here, and still a noob in sql. This is my query [code=sql] SELECT Payments.ClientID, Payments.CreditorID, Clients.FirstName, Clients.LastName, Clients.SSN, Clients.Address1, Clients.Address2, Clients.City, Clients.State, Clients.ZIP, Clients.HomePhone, Clients.WorkPhone, Clients.OtherPhone, SUM(Payments.Amount) FROM Payments INNER JOIN Clients ON Payments.ClientID = Clients.ClientID WHERE (Payments.CreditorID = 1015 or Payments.CreditorID= 1014) GROUP BY Payments.CreditorID, Payments.ClientID, …

Hello all! I have a few questions about putting images into the database. I have chosen to put the images on my server and then the location will be put in the database, instead of doing the blog thing. However, I am having a hard time trying to figure out …

I set up a server with SQL 2005 Standard and another server with SQL Reporting Services. Now my boss wants to upgrade to SQL 2005 Enterprise Edition. What would be the procedure for this upgrade and any caveats or problems that might arise, not only with SQL 2005 Std to …

hey guys, i am using XAMPP and i want to take the back up of my database. Please give some suggestions

Hi I wonder how to write a query where given record meets at list n criteria from given criteria? For example i have a table PERSON like this: Name Height (short, medium, tall) HairColor (brown, blonde, black) EyesColor (blue, green, brown) I want to fine people who meet at least …

I am trying to install Microsoft Accounting 2008 Express, which requires installing SQL Server Express 2005. I have a Vista Home Premium machine and it's giving me fits trying to get SQL Server (any flavor) installed. I've tried every tweak I can find online, but all to no avail. I've …

Hi, I want to create a form with 2 textboxses(starting number and ending number) and 1 button. When i click on button it is going to list all the records between two numbers in a report. How can i do this? Thansk

hey guys, i have made a database which has two fields namely username and password. Now when the user enters the password, i want that the password should be stored in encrypted form in the database so that the admin cannot see the password. Please give some suggestions.

Can someone please give me a brief overview of MySQL. It's advantages,disadvantages,security and other features. Thanks.