Databases Forum

i am new to study web development..can anyone help me to how i can connect my website with the database..what are the requirements..very basic please.!!

I am working on MS ACCESS database and I have to combine multiple entries in the table into one as for example, min 1 2 3 8 9 11 max 2 3 5 9 10 12 and the result should be min 1 8 11 max 5 10 12 How …

Hi All, I am currently working on a MySQL database, and am using mySQL Workbench to create a local server. From this computer(the one that is hosting the server) i have no problem connecting to the mysql server through 127.0.0.1:3306, however when I try to connect from another computer, I …

I am trying to learn SQL programming in my spare time, but I'm running into some issues. I currently have Visual Basic Studio 2010 installed, as well as Microsoft SQL Server 2008/2012. I've been told that I should be using MySQL to practice the coding. Should I lean towards MySQL …

sir i have three sheet in excel..first sheet i have many colounm with filder option..in second sheet i have same coloum with filder option .IN third sheet also same ..sheet name only varying ..what i want is in first sheet i have one colounm name is form with filder( C,F,S)..IF …

Hello, I have a members area on my website. I'm trying to check if a user with a specific username and id has logged in, and then echo a string of text on page B (members area page) if its them. The user logs in on page A (login page). …

can you help me in 1 cell in a row can handle many data ? for example in the picture for costumer 1, he order a banana, it cost 50 apple, it cost 60 orange, it cost 70 and my program will retrieve the datas and it will get the …

<?php $mysql_host = "***"; $mysql_database = "***"; $mysql_user = "***"; $mysql_password = "***"; mysql_connect($mysql_host,$mysql_user,$mysql_password); mysql_select_db($mysql_database); $query = "SELECT * FROM people coming"; $result = mysql_query($query); while($w=mysql_fetch_array($result)) { echo $w['Name']; } ?> this doesnt work--Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource y?

Hi there. Still a newbie question... a) I tested my code at localhost (my computer) and ALL was good. Now I uploaded my files to remote site and I can't get my page to work. There is an Ajax call to database. Do I need to change the URL in …

it is possible for the database that a certain id number will handle or occupy 2 or more rows and then when it called it will take both rows like on the picture .[Click Here](https://fbcdn-sphotos-h-a.akamaihd.net/hphotos-ak-frc3/v/1056791_636382299706472_1144322928_n.jpg?oh=7160bd41f914616aa1a0c59be0821a9a&oe=51F21D0D&__gda__=1374895465_5046fd7250a283eac7faabc35a10c324)

I am working in a dataware house and few things are not clear to me that is why I wanna discus here. For example, I have 10 MS Access files, and each of they have more than 5000658 number of rows, and data is in such a format like **Plz …

hello fellas i'm stuck in this function: function getDataForPagination() { $sql = "select * from t_book limit 1, 15; $result = mysql_query($sql); if (!$result) return false; $num_rows = mysql_num_rows($result); if ($num_rows == 0) return false; $result = dbResultToArray2($result); return $result; } i want to make the above function more flexible …

Hopefully this will make sense and there is a solution in a single query... if not, I'm sure i can do it using multiple queries. I wrote a query that I thought would work, but didn't take into consideration that some of the records won't have data coming from one …

Hi Folks, Recently I installed WAMP server for web development, during my first run I tried My Sql Console, but I was gettting error while creating a new table. I am surely missing something. I googled for it but cannot get what i was looking for . . . Am …

Hello, What's mysql syntax to delete all tables from database1 ?

Please am trying to create a database table that store image and display the image. I want to use vb.net to design the form for user to add their details and picture. i don't know how to go about it please help.Thanks

Hi There, can you please explain briefly what is the difference between Parallel and Distributed Database? Is there any similarilites between them? Can anyone give me any link or some briefly explaination of both type of database? Thanks.

Please help me to correct this, because its relpy: Access denied for user 'flasycom@localho'@'localhost' (using password: YES) and this is my database setup <?php //################################################################# //Only edit the following 4 varibles $SQLhost = /* SQL Host */ 'localhost'; $SQLuser = /* SQL Username */ 'flasycom_admin'; $SQLpass = /* SQL Password …

i have a login box, but when i click login, it will now display (SELECT*FROM members WHERE email='wareez' AND password ='lord' The login box is not working. also the registration form too will submit the form to the database but it did not load the user homepage after the successfull …

Hello everyone. I hope you can help me with my problem. So here is the problem: I cant install mariadb5.5win32 on my laptop, (but my other classmates have already installed it on their laptops). I am the only one who can't install it. On the starting process of installing it, …

Hi All, I have an SSIS question regarding looping through CSV files with the Foreach Loop Container. What I have: 1. A string variable named fName - Global 2. A Foreach Loop Container 2.1 User::fName mapped to the loop container with an index of 0 3. A Data Flow Task …

<?php $mysqli = mysqli_init(); $mysqli->real_connect("mysq.x.com","me","wordup","inthekitchin"); if ($mysqli->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } $res = $mysqli->query("UPDATE plate1 SET potatoes =('$_POST[potatoes]') WHERE id =('$_POST[id]')"); $row = $res->fetch_assoc(); ?> returnes error `Fatal error: Call to a member function fetch_assoc() on a non-object …

`$data= "echo * from table1 where id=$_post[ID] "` can anyone see why this line duz not compute please ?

I have 3 tables as mentioned below: Users Code Name NW London 1 Bill ---- ---- Contacts Code Country 1 USA Location Country City USA NW I need to update Users.NW = 1 in the Users Table. There are other cities like NW, London, Paris etc. In respective cities i …

i creating a shopping website online for a store. and i wanted to add polls to get user input, than store in database. i wasnt sure how to set up tables. we going to have alost of questions. each question will have 3 to 4 answers. user can click on …

Please, anyone here to help me correct this code, it was telling me that could not connect to database. My site is flashysky.com database name : is flashysky please help me to correct it and send it to my email jimohwareez@gmail.com I will really appreciate if you can help me …

Hi All, Hopefully I don't get too scolded here for this question but I can't commit my mind to answer this as I have been ill and am still not fully recovered. In saying that, I have the following set of tables (see pic) and I need to fill in …

I installed a new script onto a Linux server using cpanel. > ERROR: Nothing parsed, nothing printed > Invalid query > SELECT * FROM `dating_country` WHERE `id` IN () > MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version …

i want to ask you when i execute the following sql statement SELECT account_identifier,least(to_number(part_1)),least (to_number(part_2)) FROM TEST5 ; i get the following error ORA-01722: invalid number 01722. 00000 - "invalid number" you should know that when i execute the following sql statement SELECT account_identifier,to_number(part_1),to_number(part_2) FROM TEST5 ; it works fine

why does this thing keeps on showing? what should i do? 

firstly I apologise in advance if this has been asked 100 times over.. I've been ambushed by my company i "HAVE" to use an old Mysql 4.1 server something to do with an atiquated system still running that cannot be upgraded for x,y and z reasons. but they want a …

Hello I have a mysql table with 2 columns, Id and date. How can I insert one more Column "dayname" that will be filled through sql query with day names related to The value in the column "date". Thanks

I have a problem that I've racked my brain with for two weeks without success. I have a table named 'user_answers' containing columns 'user_answer_id' and 'user_name'. Each 'user_name' has 25 rows. I'm trying to compare/count the number of rows where user A and user B match answer_id. SELECT COUNT (*) …

Hello, I was wondering how i would create the Units table for this. Would i just set both Unit_ID and Customer_ID in the Units table as foreign keys or do i need to have a primary key like Customer_Unit_ID then have the two foreign keys? Customers Customer_ID Customer_Full_Name Contact_Name Address_1 …

Hello Community, I was wondering if there is a way to limit users on how many database entries they can insert then once they have reached 100 (Max entried) entries it will delete old entries. So if the user has reached 100 entried and they try to insert another entry …

Hi All I just want to know the following thing; When SQL Functions are used? Provide a couple of examples of situations in which they are necessary. Awaiting response... Also can anyone refer me a ebook for SQL for beginners in which Functions is desscribed detailed...

Hi Guys, I need some help about join queries in SQLite manager. I wanna have some sample queries on joining one or more tables with relationship of course. PLEASE I NEED THIS FOR OUR PROJECT. Thanks. It would be an honor hearing from professionals out there. :)

I need to store the values of a textarea tag using a form to submit the value and finally store to a mysql database table. Here is what I have, I am sure its something dumb, but its been a while since I have used php. [CODE] <?php if(isset($_POST['submit'])){ $con …

I've built a SQL report in MS SQL Server Report builder for our ticketing backend. I want to be able to do custom reporting. I've created this report by using the following query: SELECT SR_Service.Date_Closed ,SR_Service.Date_Entered ,SR_Service_SLA_Workflow.Responded_Minutes ,AVG(SR_Service_SLA_Workflow.Resolved_Minutes) AS Avg_Resolved_Minutes ,SR_Service.Hours_Budget ,SR_Service_SLA_Workflow.SR_Service_RecID AS [SR_Service_SLA_Workflow SR_Service_RecID] ,SR_Service.SR_Service_RecID AS [SR_Service SR_Service_RecID] ,SR_Service.Company_RecID …

Hi folks. I'm developing a MySQL database driven, PHP web application that will be used by the general public and I'm starting to get a bit paranoid about database security. While creating the site I was using a single, full privileges database user to connect on each page that required …

Hello, I need to know what's the best way to search tables with million records. I have a table called <people> and this table has the column: <status> Status might be more than one word like: "I am happy today and the weather is nice". Also, it might be in …

windows xp was crashed, so after formatting & installation of windows I installed (overwrite of all existing files) **XAMPP** which was on different drive, other than **C:\**. As it was not lost when windows was crashed, I just overwrite the all files, this had happened with me lot of time …

Hello Everyone, Hope you having a good day; I just want few definitions, define briefly, the following; What is Normalization of a set of data to 3rd normal form. What is Relational schemas & dependency diagrams and an Entity Relationship Diagram (crow’s foot notation).

Hello I have these database countries ->country_id ->country_name ->language counties ->county_id ->county_name ->language towns ->town_id ->town_name ->language locations ->location_id ->location_name ->language streets ->street_id ->street_name ->language and i have users that select country,county,town,location and optional street at a selected language and i want to show the show the informations of address …

This is a school project which I am a bit lost on. I have two tables with a relationship between course +-------------+----------------+ |id(primary) |coursename | +-------------+----------------+ enrolled +-------------+----------------+----------------+ |id(primary) |studentName |courseid(FK_from| | | |course.id) | +-------------+----------------+----------------+ I can insert a new course into the course table using the INSERT syntax …

I know that I can limit a query by 10 for instance, and have the top rows returned, but I have a situation where I want to return all rows, but I want to be able to mark the rows that fall in the top 10 a certain way. For …

Write a select statement that will display student id, student last name and the number of courses a student has been enrolled. You will need to join two table, use a COUNT aggregate and a GROUP BY clause in your SELECT statement. this is something i found on internet, im …

I'm trying to delete a couple of rows USING SQL Server management studio, for 2 rows only i get the message No rows were deleted Error message A problem occurred attempting to delete row #X Error Source: .Net SqlClient Data Provider Error Message: String or binary data would be truncated …

weather oracle forms language is usefull in mnc's... how will be its job openings

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsFormsApplication4 { public partial class Form1 : Form { SqlConnection clientConnection; string connString; public Form1() { InitializeComponent(); connString = "Data Source=ASPEE56\\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True"; clientConnection = new SqlConnection(); clientConnection.ConnectionString = connString; } …