10,942 Topics
 | |
| | I have a table EmpList. I want to use loop to bring result as I expected. Example, EmpNo ReportingTo ------------------- 27 14 68 14 104 27 105 27 138 27 139 68 150 8 151 8 8 5 Suppose query input is 14, I need result like this EmpNo ------ …  |
 | So I am reading a book from Pratt and it is called A Guide to MySQL. Apparently the book stinks and I am trying to answer some of the questions from the book. #fc1 show tables in the current selected database # for your current database it should be two … |
| | hi all.. i am having an problem during mysql installation..hopefully you all can give me advice and solution on how to solve it...below is the image of screenshot that i take.please help :)   |
 | 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 "É" |
The End.