10,940 Topics
 | |
| | Hi, Need suggestion for a query. I am trying to get count(c3.id) for all days of feb. As in cs.created_at some dates are missing.How can i use below clause. **group by day(cs.created_at)** something like group by day(month(cs.created_at)) not working.. select count(case when cs.id IN(select max(id) from complaint3_status where complaint_id=c3.id and …  |
| | i already searched about displaying the data fields, my problem is how to retain the checked item and then set its value as 1. please help. i tried some code but didn't work: <html> <form action='' method='post'> <?php $database = 'sample'; $table = 'checklist_stud_columns'; $mysql = mysql_connect('localhost', 'root', '') or … |
| | Hi all, I'd like to create an interactive voice response menu system on my own. I'd like to use my MySQL database. I have a found an interesting idea (https://ivrhttpozml.codeplex.com/), but it's based on using a webserver. In short, the previously copied guide presents a simple XML code (more exactly … |
| | I am struggling with this, I have a database (mysql where i am trying to delete a single row. The idea is a list of items populated from the database. I am trying to add an additional column where there is a graphic and it reloads the page and runs … |
| | Hello Guys. I am fetching some results from database and show into a page. This is a CodeIgniter Project. Here si the code for that: This is the view: <div class="product_view"> <form action="" method="POST" name="form" id="form"> <?php foreach ($get_product->result() as $key => $result) : ?> <h4>Product Name: <?php echo $result->product_name; … |
 | hi i am working on a project:auto parts web store With installation and I do not know where and how to start؟ help me |
 | I am trying to populate a select box from my database. The value chosen must be the id of the item, and the text shown the name of the item so that once selected it will insert the id into the table column and not the name so that the …  |
| | I am working on online shopping website(e-commerce) website, in which I have a task to retrive products (product id, name, imageurl, price, details of product) Image having in image folder folder where stored images and that pah is given to database.. HereI want to fetch category on clicking menu categories … |
| | Hi all, i am new to python how to store image into database blob using python please help me for this its urgent  |
 | I use visual basic 2008 and MYSQL (Storage engine is innodb) Is use this code to retrieve informatie (see below) The SQL string ="select * from articles where articlenb=12345" I want to check of this record is used by een othor user in the network. Can use innodb for row-based … |
| | What is the best Way to start working on projects if u already familiar with php and mysql?  |
 | Didnt know where to post this question mysql or here, since im working with php i decided to put it here.. Im starting to learn mysql now :) SO i just wanna retrive a full name from a user how would i do this? im imaging this should be done … |
| | Hello.I have problem please help me. Thank you in advanced. I have radio button in my form. The data will be insert into MySQL based on the selected radio button. For example, I have A and B table. The radio button value also A and B. If I select A, … |
 | 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 … |
The End.