7,368 Topics
|
|
I need to pass the @startDate and @endDate as variables to @range in the code given below. But when I execute the below code, I'm getting the Error as follows. What is going wrong in my code, and how can I correct it? Errors: Msg 102, Level 15, State 1, … |
|
I need to print labels. I have people who ordered more than one book so i have to print the amount of labels equal to the amount of books they ordered. Below query. select id,name,total_copies from contacts. that's the select statement. As is it can bring back 1,john,1 2,peter,3 3,sara,2 … |
|
Hi, I have a 'persons' table, an 'answer' table and a 'token' table. The token table contains matching unique identifiers from the persons table and the answers table. In my query I want to join the persons table with the answers but I don't know how to proceed since they … |
|
Hi! I want to move on from programming with Access database to MySQL. So I downloaded MySQL Workbenc 5.2CE from [here](https://www.mysql.com/products/workbench/), Installed it and I made my way into even creating a database and a table in it. I just want to know, will it be any different to connect … |
|
UPDATE members a INNER JOIN members b on a.Recommended_By = b.ID set a.Node = CONCAT_WS('(',b.ID,')',b.Node) this statement to update node column from same table, but the problem is i have to execute many times to get the correct: example : ID Recommended_by Node 1 2 1 1 3 2 2 … |
|
i run the below script to get the left and right as per the binary i did and it is ok Script select a.ID,a.Node,a.direction, a.Reference_ID, a.Recommended_By from members a JOIN members b ON a.Node LIKE CONCAT('%(',b.ID,')%') Where b.ID = 2 order by b.id,a.Recommended_By' Result **ID** **Node** **Direction** **Reference** **Recommended_By** 4 … |
|
Hello all, Im looking for a tool that allows me to visualise a single entry in a database, so i can see that entry, and all entries that have a foreign key to it, and foreign keys to those etc. Im not talking about an ERD, but more like a … |
|
Hi, Doing a bit of research at the moment on how to structure my web App. So far I've decided on using PhoneGap with jQueryMobile client-side, which will request and update information in a database hosted on a remote server running php and mysql. From the tutorials I've seen online, … |
|
I've written this code to <?php $getnamequery = "SELECT cat_title FROM store_categories WHERE id = '$catid'";?> <?php $cat_name = mysql_query($getnamequery) or die(mysql_error());?> What would happen is the variable `$catid` would be filled in with a number, for instance 1. The table store_categories looks like this id cat_title 1 Humor 2 … |
|
This is my SQL statement.. SQL Statement: SELECT tbl_subjectsenrolled.SubjectID, tbl_subject.SubjectDesc, studentsubjectgrade.Finals FROM tbl_subject INNER JOIN tbl_subjectsenrolled ON tbl_subject.SubjectID=tbl_subjectsenrolled.SubjectID INNER JOIN studentsubjectgrade ON tbl_subjectsenrolled.SubjectID=studentsubjectgrade.subjectID WHERE studentsubjectgrade.StudentID='04-0044' But the OUTPUT is this: SubjectID1 SubjectDesc1 Finals1 SubjectID1 SubjectDesc1 Finals1 SubjectID2 SubjectDesc2 Finals2 SubjectID2 SubjectDesc2 Finals2 Instead of this: SubjectID1 SubjectDesc1 Finals1 SubjectID2 SubjectDesc2 … |
|
Hi There, Ive been searching everywhere in google but i got nothing. What i need is to be able display user datail after he login on a certain textbox Login.php page code: <?php session_start(); ob_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> </head> <body> <?php … |
|
Just a quick question. I am using Workbench to export a database stored on my hoting providers server, will the server experience any downtime whilst I am exporting the data? The only reason I ask is because when I back up my local SQL database my server needs to be … |
|
Hi everyone, i am designing database for books application. I have main table **Books** and its child table is **Chapters**, chapters child table is **Sections**, So here is the problem, that some chapters has also divided into 3 steps **chapter Name -> Part 1 -> Divisions 1** and each chapter … |
|
Hi, I'm using this SQL statement to retrieve Value and Date which will then be plotted on a graph: SELECT DISTINCT assets.SEDOL,assets.Quantity,stock_names.value,stock_names.Fileid,date_header.dateid FROM assets,stock_names,date_header WHERE assets.Client_ref = '$clientref' AND stock_names.SEDOL = assets.SEDOL AND date_header.fileid = stock_names.fileid I'm also selecting Quantity. Instead of having to multiply out the arrays, how can … |
|
I am working on a PHP project in which a mysql table needs to be updated with lots of rows in a single update. A set of parameters will be assigned for a product. Please find my present steps below: 1. **Delete** all rows with the product_id in the table … |
|
Hello, I have a Mysql table, where i want that after i execute the update query in the JSP form, an automated mail is send to the email id in the record.Can anyone tell me how to do this? |
|
I have problem updating my MySQL database. The user can edit a form in my page and once they press 'send', the php script should be able to update all the information. However the database doesn't seem to be updated after pressing the 'send' button in the form but only … |
|
I'm having a problem with a MYSQL Join accross three tables. I'm new to MYSQL Join functions, and can't quite figure out how to write the code. My current code is horribly innefficient and does not implement explicit joins, which I believe is much of the problem. Here it is(in … |
|
Hi, In my ubuntu 11.10 system Mysql Workbench not opening, but while using mysql-workbench --verbose command in terminal it opens. Please I need it to opened by clicking the button for Mysqlworkbench. Thanks in Advance. Velhassan. |
|
I'm using this PDO query to fetch all the data I need from Value and dateid: $pdo = new PDO('mysql:host=localhost;dbname=contisec_portal', 'root', ''); $date = date("o-m-d"); $stmt = $pdo->query("SELECT stock_names.Value,stock_names.Fileid,date_header.dateid FROM stock_names,date_header WHERE SEDOL = '$stocksel' AND date_header.fileid = stock_names.FileID"); Does anybody know how I can sort the two columns into … |
|
Hello. I have two tables, the itinerary table and location table. The itinerary table consists of all the itinerary: * A - B * B - A * B - C * C - B * C - A * A - C The user will select from the itinerary … |
|
Hi I am having an issue trying to run an sql query from a php script. I have checked the query through phpmyadmin and it runs fine but whenever I run it through php i get an error. The error is "Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean … |
|
I am trying to update multiple rows in my database using php and mysql. Here is my php mysql statment: $sql = "UPDATE book_store SET". "title = '$_POST[title]', isbn = '$_POST[isbn]', price = '$_POST[price]', quantity = '$_POST[quantity]' ". "WHERE ID = '$_POST[id]' "; Here is my Error: Error: You have … |
|
Hello All! This question probably has a really simple answer but I am fairly new to PHP and I'm not very farmiliar with generating numbers yet. This is what I'm having trouble with: * Check MySQL to make sure that this UNIQUE number is not already stored. If it is, … |
|
Hello guys, For my final year project I decide to develop an app for android. I have done some research and stuff for first semester and have to present the working app at the end of second semester. To be honest I'm not that great developer however I'm still interested … |
|
I am new to the datebase concepts.. I am having a DataBase Management course in my engineering program now a days and i have to submit a small database project in 2 weeks which should be based on the core and complete fundamentals Database... I m using mysQL can any … |
|
Hello all, I'm fairly new to using PHP, and for my assignment I've coded it all but I'm trying to go the extra step, and code something that if the item amount = 0 it doesn't print it out on the order form The items are $LAPTOP $MONITOR $KEYBOARD $PRINTER … |
|
Dear all i have created a small windows form application, which connect to mysql database, and the database is installed on a remote pc( virtual machine), i am using visual studio 2010 in winxp 32 bit , and i have build this application using .NET2.0, so that it can work … |
|
I created a stored Proc: Create PRocedure InsertTBL_Supplier ( @SupplierNumber nvarchar(50), @SupplierName nvarchar(50), @Address nvarchar(50), @ContactNumber nvarchar(50), @ContactPerson nvarchar(50) ) AS BEGIN INSERT INTO TBL_Supplier (SupplierNumber, SupplierName , Address, ContactNumber , ContactPerson ) VALUES ('10000','JenRoses Shop','Pasig City','09159675567','Dara Lim'), ('20000','Lawren FlowerFave','Makati City','5564818','Aiden Lee'), ('30000','FLowers&Scents','Marikina City','7280823','Dennis Park'), ('40000','Pretty Flower Spot','Pasay City','09276543789','Joshua Tan'), … |
The End.