11,093 Topics
 | |
| | Hi I'm facing this error : Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /var/www/core/inc/config.php on line 7 I've tried to replace mysql with mysqli but I faced some errors.So I decided to return to mysql but my … |
| | I have three tables 1.course(c_id(pk),c_name,sem_no); 2.student(s_id(pk),s_name,user_name,password); 3.student_info(s_id(fk),c_id(fk)); i have logged in the student.. den i run this query select distinct sem_no from course,student_info where course.c_id=student_info.c_id and s_id='0001' order by sem_no; it shows all the semster he passed inclueding the running semster.. now i want to show the last value of …  |
 | Hello, What's the mysql syntax to rename column in a table? I try this: ALTER TABLE static_content RENAME COLUMN title TO shorttext MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to … |
| | hi im making a database for my project is it possible to have multiple foreign keys shown at the picture? i tried to alter the tables and add foreign keys but i always get a #105 error, so i deleted all of my tables and will make a new set … |
 | I created a table in phpmyadmin and i was curious to know if it is possible to assign multiple values to one variable/field in the same table. For example here is what i have: ID | Shoe | Sizes ____________________ 1 | CK | 7 ____________________ 2 | LV | …  |
 | Hello, guys.. I am actually working on a project. I can't figure out how to limit the displayed content on a table of a particular data. I have a table (tblservices) that have fields (service_id, service_name, service_content, date_created).. *the service_name* is the title of the service, *service_content* is the whole …  |
 | HELLO! I've been debugging my code for an hour now. seriously. So I have this string: SQLString = "UPDATE `etmsystem`.`main` SET `timeIn` = '22:00' WHERE `main`.`serialNo` = '70002B4A8F9E'" actually the TIME and the SERIAL NO. here is to be represented by a variable. But I changed the code into that …  |
| | I made a new MySQL table in Phpmyadmin in Wordpress in the same database from Wordpress but a new table. I want to make a new page and add a script in the body that allows: 1. when i insert the page title to the new page, the script should … |
| | Below are 2 functions that will handle the Query and rending of the menu from MySQL Database. This function Loops through the array. Takes in 2 arguments. function loop_section($array, $parent_id = 0){ echo '<ul>'; foreach($array as $section){ echo '<li>'; echo $section->section_name; echo '</li>'; } echo '</ul>'; } This function handles … |
 | Hello. I am beginning to re-develop a small database using PHP/MyQL; I have already sucessfully done this a year ago but no longer have access to the machine, code or credentials. It worked great! But now, I'm rebuilding it. The test site (PHP) seems to be fine. I see no … |
| | Please provide detailed description of how to update ft_min_word_len value in global_variables table of information_schema database.  |
| | hi i am currently working with php which requires registration once the user registers with his/or her details then an email is sent to the user for activation once the link is clicked the account is activated this works perfectly but the question is how do i expire the link … |
 | Somebody can help me. I'm new in php and highcharts. I tried to populate my chart using mysql and php, but when I tried to run it, the chart didn't appear, only a blank web page. And there's no error appeared. Her's my codes (sorry for messy code): <!DOCTYPE HTML> … |
| | The following snippet shows how you can use binding in your queries when using MySQLi. For starters, here's the table structure I've used: CREATE TABLE `mytable` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `dob` date DEFAULT NULL, `level` int(11) DEFAULT NULL, PRIMARY … |
| | Hi, I am using VB6 and phpMyAdmin connected by WAMPServer for my system. I am new in this language. Here's the code in my that seems to be wrong: Private Sub cmdsubmit_Click() Dim rs As ADODB.Recordset Dim strsql As String strsql = "insert into table1 ( surname, firstname, middlename, house, … |
| | 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 "É" |
| | 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 … |
| | seems like a simple issue but i can't wrap my head around this. i need to get all rows where date is today BUT a new day starts not at 00:00:00 but at 02:00:00 the results are displayed all the time (page is refreshed every few minutes) so the current … |
| | Hi.I'm Nizam. Sorry if the question I asked is unclear. I have the table as below **Classroom** - id - capacity - code - ...... **Schedule** - id - group_id - classroom_id - ...... The schedule will be filled with the group and classroom. My problem now is how can … |
The End.