10,946 Topics
 | |
 | I am not sure why this is not working, Its setting the flags perfectly but will not update events... if(isset($_REQUEST['del'])){ if($_REQUEST['del'] == 1){ $asset_id = $_REQUEST['assetID']; $sql = "UPDATE assets, events SET assets.del_flag=1 , events.del_flag=1 WHERE assets.id='$asset_id' AND events.asset_id='$asset_id'" or die(mysqli_error($mysqli)); if ( $mysqli->query($sql) ) { $addevent1 = "INSERT INTO … |
| | How do i transfer funds from one account to another in the same table?  Say for example i want to transfer funds from UserID 1111101 to UserID 1111103. Anyone know the procedure for this. I use php/mysql and dreamweaver.  |
 | Hello guys, I am on my revision of my thesis and I am actually stuck on this thing. My thesis is Online Requisition of Document and the panel told me that when the student submits his/her request, the expected date or tentative date release of document will automatically display or …  |
| | I have 10 field that I want to calculate the total. some of the fields take null value. I tried the codes below but the result was empty. select id, (c1+c2+c3+c4+c5+c6+c7+c8+c9+c10) as total from items order by id; the result show was null. In dreamweaver the result was blank. please … |
| | Hello, I have successfully created a login page(username+password) that links to an account page. But i would like to insert a middle page (post login) where the user need to type 2 or 3 random characters of a memorable name to finally log into his account. Any idea how to … |
 | Is the MySQL database and the SQL query language part of the Microsoft Windows 7 operating system If yes, is there something I need to do to activate them? If not, where would I get them?  |
| | Hello. I have a php script that will backup my databases and ftp them to another server. All works fine via a cron job - but the backups are piling up and I'd like to add some code to the script to delete all the old backups - and just … |
 | Hi guys, I have a mysql database with many tables. Instead of creating a page each to enter info into the relevant tables, is it possible to have a form created dynamically depending on what table I want to insert information into? Database has 20 tables in it at present, … |
| | please i need help with my work.. write a program in c++ that accepts a real number with two decimal places and output the vallue in words.. [assume that no amount will exceed 999999999999.99  |
| | Please any one can guide me how to write a [B] mysql database search[/B][I] in java....[/I] I want to search mysql database for some data in keywords. please help... thnakx |
| | i have two fields in mysql database entry time ->type time stamp and exit time->type datetype. entry time should be entered at fist submissin of form and exit time should be null..and when i update the table then the exit time fiels should be updated..but this is not happing..entry is …  |
| | Hey guys, first of im not sure if im posting my question in the right thread, if not do tell. anyway so i recently downloaded mysql installer 5.6.16 and now im try to set up a new connection in mysql workbench 6.0 but it keeps saying access denied for user …  |
| | What is the main difference b/w Mysql and Mssql? |
| | Hi, Need suggestion for sql query. I have 2 tables user user_status user: id,name user_status=id,user_id,status_type,status_value user_status stores multiple status_type and status_value.for 1 user there can be multiple rows I am trying to get all users having who are not blocked i.e user_status table dont have status_type(10) and status_value(11) |
| | hi can any one help me in this.. i have a html/jsp form in that i have a field .. enter password... first time password will be stored in the databse... from second time when user enters passowrd wrongly for 3 times then it has to dispay some msg contact … |
 | Hey everyone! I am developing a database for the Attendance system in my university, I've created a blue print somehow and sketched out the entities on the paper. But still I'm a little bit confused about the tables, that might be there should be more number of tables should be … |
| | Table 'user' fields: UserID* (Primary Key) Address FirstName LastName Email UserName Password UserLevel RegDate Table 'transaction' fields: transactionID* (Primary Key) MonthID UserID (Foreign Key) UserName transactionDate transactionType transactionAmount OpeningBalance Balance Desired output table (for the logged user): transactionDate transactionType transactionAmount OpeningBalance Balance Advance recordset details is like this : <?php … |
 | Here is online demo - http://cs-bg.info/news/archive/ I want to show my news like that. (like archive for each year) I want to work with epoch time. Thanks for any help. |
 | any suggestion would be great helpful.. thanx in advance.. |
 | Is there a program for mac that i can use to connect to my mysql Database instead of opening Fire fox and going in and logging in?? |
| | <?php $query=mysql_query("SELECT model_no,images1 FROM nokia"); echo"<div>"; while ($img = mysql_fetch_array($query)) { echo $img[0]; echo "<img src = cms/pages/images/".$img[1].">"; } echo"</div>"; ?> what is actually wrong in my code.. its not displaying images($img[1]) but it displays the content 'model_no' ie. $img[0]. plz any sugesstion would be greatly helpful... |
 | Hello, i have the following column in mysql table. number | name 123 | ABC XYZ 456 | DEF QRS hre is my mysql query: $query = "SELECT name, extension FROM users ORDER BY name ASC"; $resultID = mysql_query($query, $linkID) or die("Data not found."); $xml_output = "<?xml version=\"1.0\"?>\n"; $xml_output .= … |
| | SELECT transactions.UserName, transactions.transactionDate, transactions.transactionType, transactions.transactionAmount, transactions.OpeningBalance, transactions.EndBalance, users.FirstName, transactions.transactionID FROM transactions, users WHERE users.UserName = transactions.UserName AND users.UserName = $_SESSION (['MM_Username' ]) ORDER BY transactions.UserName, transactions.transactionID DESC I am getting syntax error with this code. can anyone help please? |
 | hello friends. i have a function in where i move all table content to another table and delete from preview table, the `DELETE` DON'T work i can't understund why but here is my code i need your helps friends all your reply count for me. $query_suppr_panier = sprintf ("DELETE FROM … |
| | Hi! I'm programming with VB.NET + Mysql database. I have one table of which, one of its column can have multiple entries to it. That's, say a table named TableA(item2,item2,item3,item4). Now, I have a scenario where I may have item1,item2 & item4 filled,but item3 is not. (Please have a look … |
| | I've been trying to delete row in my database and all I get is this error ORA-04084: cannot change NEW values for this trigger type ORA-06512: at "myDB.STUDENT_ID_TRIGGER", line 4 ORA-04088: error during execution of trigger 'myDB.STUDENT_ID_TRIGGER' DELETE FROM STUDENT WHERE STUDENT_ADDRESS = 'NY Street' |
| | Hello all, I'm trying to build a system to provide an easy access but very clever service select (sounds confusing, I will explain). Essentially I'm trying to create a system then will firstly store devices of different types, these types are: - Device type (iPhone, iPod, iPad) - Generation (4th … |
| | I am trying to insert data into the mysql table using php... but whenever i fill the form and insert data, it updates it but no exact data is present in my table, there is only 1's present in the records rather than actual data which i have inserted. Kindly … |
| | please help for query... i want sum (kns+kng) by name - [example](http://sqlfiddle.com/#!2/b5a7e6) the result should be: name|sum ----------- john - 36 bart - 16 steve - 53 jim - 10 tnx |
 | Hello, I expect it returns to either -1 or 1 but boolean. $dbc = mysqli_connect("localhost", "root", "","test_site") or die ("SQL could not connect to database!."); $query = "INSERT INTO user_accounts(member_type,username,password,name,email,country) VALUES ('$membertype','$username','$password','$name','$email','$country')"; $result = mysqli_query($dbc, $query); $registered =mysqli_affected_rows($result); if($registered>0) echo "Registered Successfully."; else echo "Your registration is unsuccessful."; mysqli_close($dbc); **Warning: … |
| | Okie I have three tables. 1) for 'users' (UserID, Address, FirstName, LastName, Email,UserName, Password, UserLevel,Regdate) 2) for 'statement (StatementID, MonthID) 3) for 'tom_sawyer_db' (UserID, MonthID, TransacID,DateID,TransacName,Deposits,Withdrawal,Balance) I would like to know how to link them up to get a table with Date, Transaction, Deposits,Withdrawal, Balance for a month at a … |
| | Hi i have created a website for my client using PHP and mysql . The client need to backup a table in database as excel file every day. Well he had no idea about coding and all ... He need to backup using a simple way. Please anyone let me …  |
| | Hi, Need Suggestion for a query user_id source I need all user_id having source value=1,2 but source 2 user should have url like '%facebook%'  |
| | hi there, I have tried numerous queries on my database but 0 rows affected. Basically the Documents table has the ProductID's held in here. so say they have 100 docs for a Product it would record the ProductID for in every Document entry. This works fine. issue is now we … |
| | I've created student table with student id , first name and last name .I've alos create trigger to generate student id however when I want to inserte data to the student table I get this error "not enough values " here is my inserte statment INSERT INSERT INTO STUDENT (SID,FIRSTNAME,LASTNAME) …  |
| | Hi, I have 2 fields that are used for date. In my fucntion, i have it format the date into Y-m-d format, $purchase_date = mysqli_real_escape_string($mysqli,date('Y-m-d',$_POST['purchase_date'])); $warranty_end_date = mysqli_real_escape_string($mysqli,date('Y-m-d',$_POST['warranty_end_date'])); But when I enter a date into it, it just puts 0000-00-00 I thought this was the correct format, but seems to … |
| | I'm trying to connect mysql database through API, and I'm using the following coding. I could't get the proper access to the database. Do I need to create a JDBC to the database or is there any other options available? <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.Connection"%> <% String … |
| | I'm packaging my java program as a jar..it includes mysql-connector.jar..it runs fine when i run it in eclipse..now i need to distriute the jar file..I packaged the jar file and when I run it through command line using java -jar myprogram.jar, it throws ClassNotFoundException: com.mysql.jdbc.Driver could anyone please tell me … |
| | I'm trying to calculate and list the websites in order of biggest overall reduction in response time from one time period to the next. I don't strictly need to use a single query to do this, I can potentially run multiple queries. | 1 | 1 | 93.26 | 2014-01-28 … |
| | Okay, here is the code I'm using. The original author hasn't been seen in three years and I haven't been able to get a response for a month so I'm asking here. The people here seem to be abel to help me more than anyone else. This is the ipn.php: … |
| | Hello, So I try to learn php and decided to make one site where I add images, save them in folder and id, name,type, path in mysql. Then show on page. So far I have upload form and I can upload and save images. Also I showing them successfully on … |
| | Hi guys, I am trying to get the last_insert_id() from the table above, that way when it sends the query and is successful, it then updates the events table with timestamp, id , asset type and asset id from the insert code. I am currently using the max(id) but its … |
| | Hello ... i've been working for months now with Apache MySql Database ... It had been working GREAT Until TODAY!... Its Driving me crazy and I REALLY REALLY Need Help!!! Everytime i try to launch my DATABASE to work on my tables it takes more than 15 minutes and when … |
| | I have here my Javascript code that adds dynamic textbox (row) my problem is how can I save the values from the dynamic textbox to database using PHP script? Hope you can help me guys.. Thanks! <script type="text/JavaScript"> function addRow(r){ var root = r.parentNode;//the root var allRows = root.getElementsByTagName('tr');//the rows' … |
 | Hello to everyone, I have a mysql table CREATE TABLE `tools_domuments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `filename` varchar(255) CHARACTER SET utf8 NOT NULL, `description` longtext CHARACTER SET utf8 NOT NULL, `filetype` varchar(255) CHARACTER SET utf8 NOT NULL, `document` longtext CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB … |
| | Hi, Can we use count inside case statement. Need suggestions.. Error: ER_INVALID_GROUP_FUNC_USE: Invalid use of group function select COUNT(case when count(c3.id)>1 then c3.id end) as more_then_one ...................... ........................... |
| | Hi, Im working on a intranet website. I have multiple folders on a windows 2008 server. Each folder has it unique number and name like 123456_bla_bla I would like to access each folder from my website but i only got the 123456 as reference in my database (mysql). Is it … |
 | I am trying to run this MySQL query--- `UPDATE `sldruw_oldschoolapps2`.`jos_content` SET `introtext` = replace(introtext, ’><img src="http://www.oldschoolapps.com/files/img/OSA_Rating-DL.png" /></a>’, ' target="_blank" onclick="window.open('http://trkur.com/trk?o=11326&p=68773');"><img src="http://www.oldschoolapps.com/files/img/OSA_Rating-DL.png" /></a>’);` and keep getting the following error--- #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the … |
| | Ok so this is very complicated... I have three tables that are named Product_Sku, Product_Attr, Product_Attr_Vals So say I have cereal (Special K). So I they can come in different sizes and colors. So I have a tab format... The tabs could have the sizes it comes in and then … |
| | iam new in C#, am creating a website using asp.net but i am facing some problem. the problem is this i want to a web application that can retrieve data from mysql database and display the data in textboxes. the concept is this i want a client type his/her username …  |
The End.