10,940 Topics
 | |
 | I'm having a brain fart and for some reason it's not coming to me how to do this right now. I'm trying to tally up a table, and store the results in a different table. Like so user score ---- ----- 1 4 1 5 1 2 2 1 2 … |
| | Hey guys looking to create a cool database. But i need some help on what languanges I might need to complete this thing. Just looking for some pros and cons to compare. any ideas? Im a beginner so speak plain languange :)  |
 | I need help with the queries I wrote and I don't understand what is wrong with them? Can someone help me correct them? #11 SELECT BOOK_CODE, TITLE, PUBLISHER.PUBLISHER_CODE, PUBLISHER_NAME FROM BOOK, PUBLISHER WHERE PUBLISHER.PUBLISHER_CODE = BOOK.PUBLISHER_CODE ORDER BY PUBLISHER_NAME; #12 SELECT BOOK_CODE, TITLE, PRICE FROM BOOK, PUBLISHER WHERE PUBLISHER_NAME = …  |
 | if run to a delemia when im out of the hosue and not near a net work i want to be able to run on local, but i dont want to have to change the credientials is there a way i can have it try one and if it snt … |
 | OS:windows 8,compiler:g++,mysql version:5.6 //bookshop.cpp #include <my_global.h> int main() { return 0; } //bookshop.cpp //Makefile CC = g++ LIBS = -L"C:\Program Files\MySQL\MySQL Server 5.6\lib\" -lmysqlclient INCLUDES = -I"C:\Program Files\MySQL\MySQL Server 5.6\include" all:bookshop bookshop: bookshop.cpp $(CC) -fpermissive -o bookshop $(INCLUDES) bookshop.cpp $(LIBS) //Makefile error： In file included from C:\Program Files\MySQL\MySQL Server 5.6\include/my_global.h:68:0, … |
| | hi can anyone see why this is not working please ? `mysqli_query($con,"UPDATE goodship SET brick=brick+1 WHERE id= $_COOKIE['id']");` all i am trying to do is add one to the sessions id col brick, thanks.  |
| | Hi there. I was kinda researching on how I could store data at best (in my opinion). I came on "CSV" files. Which looked great to use. I found out there are two functions that can operate file. So I keep Googling on how to use the syntax and how … |
| | Hi I am New to PHP and my question looks stupid but i am stuck I want to search operation register to search by id and print out put of perticular id my first file has this code: <form action="printotreport2.php" method="POST" target="_blank"> <tr> <td>Ot Reg ID of Patient </td> <td> … |
| | Hi I have data to upload to a Mysql database and I need to get the time taken for each row to be inserted so that I can pass that number through to a progress bar. I have alreay tried accomplishing this by determining the number of rows affetced by … |
| | According to my professor's program, it says that the snippet of code that i wrote has a syntax or runtime error. This is my code: #S3 display fruit name, inventory quantity sum, price and sum quantity*price displayed as value for each row in fruit SELECT name, sum(quantity), price, price * …  |
| | I save a variable in my db row like this: http://www.$site.com When i fetch from my db it echo this :http://www.$site.com but i have a variable $site='google' and i want to change $site to google automatically when fetched from db. Is there a way to this.  |
| | I wrote 2 queries and I am not sure what is wrong with them. Can someone tell me what to do in order to fix them? #T8 select sum( quantity ) * (select price from fruit where name like 'apple') from inventory where fruitID=(select fruitID from fruit where name like … |
 | Hello, I have a function that is working to generate the navigation bar, it grabs the parents and the "childs" and displays them but I have noticed that it is not closing the ul, li tags properly. I will attach a screen shot below. My code is this: <? include … |
| | Hi I have been struggling with this query for a while now I need to get the number of rows inserted into my database table, but I keep getting this error I can't seem to get rid of. $result3=mysql_query("INSERT INTO dest_table.create_info SELECT * from Profusion.source_cdr"); $num_rows = array($result3); $progress=mysql_num_rows($num_rows); echo … |
 | I am trying to get a total of all the records for playerid from table1, table2 and table3 by playername. There are 4 tables, table-1, table-2, table-3, and players. I am not great with queries and I expect somebody here can instantly see where I am going wrong. This is … |
| | Hello in my code i am unable to fetch rows please check if (isset($email) && isset($key)) { $get_verify_email = "SELECT * FROM users_registration WHERE email_address ='$email' AND com_code='$key'"; if ($result = mysqli_query($dbc, $get_verify_email)) { while ($row = $result->fetch_row()) { $name = $row["Name"]; $business = $row["business_type"]; } /* free result set … |
| | These are my queries for an assignment. It says that I made a mistake on query 8 and 9... problem is that I don't see any mistakes? Can someone tell me what is wrong? #T1 SELECT * FROM `inventory`; #T2 SELECT fruitID, sum( quantity ) FROM `inventory` group BY fruitID; …  |
 | Hallo, How to rename database in MySQL - 5.0.21 ? I try this: rename database sunvone_scn TO indonusacms; and get this error: Error SQL query: RENAME DATABASE sunvone_scn TO indonusacms; MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your … |
 | Hello, I am using mysql as database, innodb as tables engine. Some of my tables have foreign keys referencing to other tables primary keys. Since the definition of foreign key is to restrict the value of itself, I would like to know if I should check the existence of the … |
| | Hi Everybody I have to import excel data in MySQL table, I know how to do this for simple excel data to 1 MySQL table. Here also I need to import data from excel to 1 table but data is provided in 1 form which needs to be converted first … |
| | Public Sub login() SQLConnection.ConnectionString = ServerString cmd.Connection = SQLConnection SQLConnection.Open() cmd.CommandText = "SELECT employee_id, password FROM employees_list WHERE employee_id='" & Form1.EMPLOYEE_ID_txt.Text & "' and password='" & Form1.PASSWORD_txt.Text & "'" dr = cmd.ExecuteReader() If dr.HasRows Then Form1.PASSWORD_txt.Text = "" dr.Close() Form1.Hide() MessageBox.Show("Signed in", "", MessageBoxButtons.OK, MessageBoxIcon.Information) 'get firstname and lastname" label4="firstname … |
 | Hi All Daniweb PHP Group, I have a big favor to ask (well for me this is big lol). I have 3 databases first (LOCAL),(AIMIS),(ERM). Here's the table (namely account_manager) of LOCAL.  and Here's the table (namely customer_call) of AIMIS.  and Here's the table (namely quotations_header) … |
| | Hi, I am trying to get last updated time of database in mysql. need suggestion??? |
| | Hello, I am looking for a calendar to use with my website that I can add tasks/appointments into the db and have them show on the calendar. I would like to edit on the fly either by using a page to create the task/appointment or via the calendar using ajax. … |
| | Hello Sir, I want to submit some data. already i have created some kind of registration form and PHP/MySQL things and it is working fine.in that form i have to add print option also.i have one word document file in that document some of the content there.the content should be … |
| | Hello Friends, I have a table which says stores 4 values id,publisher name,bookname,time I am firing query like SELECT * from table where time>='sometime' group by `publisher name` order by time DESC What I want is to select results in DESC order of time with unique publisher name. When I …  |
| | what collation to use for storing english and French in phpmyadmin(MYSQL) I am using collation "utf8_general_ci", but some french characters are not stored properly in database e.g. "É" is stored as "É" |
| | I have php page with two forms. One for searching and the other one for updating the searched data. When I updated data it wont show the search form. How can I show the search form after I summited the data. Please help me. My script is below <html> <head> … |
 | CREATE TABLE Artist ( A_id INT NOT NULL, A_song varchar(100), A_name varchar(100), PRIMARY KEY(A_id,A_song) ); CREATE TABLE Instrument ( I_id int NOT NULL, I_keys varchar(100), I_name varchar(100), PRIMARY KEY(I_id,I_name), a_id int NOT NULL, FOREIGN KEY (a_id) references Artist(A_id) ); CREATE TABLE Song ( S_id int NOT NULL PRIMARY KEY, S_vocalist … |
| | I am trying to search mysql databse and display it in an editable form and then update records. I can search and display data in a form. But when I am trying to update data not going to the database. If any one can help me please have a look … |
The End.