6,934 Topics
 | |
| | Hello. I have created a filter result using php but it is not properly working for me when i filter result it is not showing me up with any products <form method="POST" action="product.php?cat=<?php echo $cat; ?>"> <div class="price-box"> <h5>Price</h5> <input type="hidden" name='price_range' class="range-slider" min="0" max="600" value="23" /> </div> <div id="filters"> … |
| | this code doesnt save data in db as 1 when i click on yes button.. <table id="main" class="display" cellspacing="0" width="100%"> <thead> <tr> <th>Date</th> <th>Amount</th> <th>Approve</th> </tr> </thead> <tbody> <?php $i= 0; foreach($purchaseorder as $tdata): $i++; ?> <tr> <td><?php echo $tdata['pay_date']; ?></td> <td><?php echo $tdata['amount']; ?></td> <td><td><?php if ($tdata['approve']=='1') { ?> … |
 | Hi all, I am trying to select single record from each year of last ten year. Given below is the code what I am using now. But its taking too much time to get the result. Is there any way to make it fast? $sql_cond ="SELECT Close_Price FROM (SELECT Close_price … |
 | Greetings, I read about database normalization and I knew that there are 8 normal forms to follow. I understand the 3 first normal forms, however, I did not understand the other 5 normal forms and they are: 1- BCNF - Boyce-Codd Normal Form 2- 4NF 3- 5NF 4- ONF - … |
| | developed an admin panel in which users can add products from there and I put fields over there as size and color for the dresses dresses sizes and color would be more then 1 so I made 2 more tables in the database named prod_size and prod_color here is the … |
| | Hello All, I have been working on a registration form for opencart for a while now. I think I am nearly there in how I have coded it. However I just do not know where I am going wrong with it. It is a standard form with text input fields … |
| | Hi all, Just wanted to start a discussion on a database issue that I am presented with; the issue is that I am trying to insert seed data into around 90 tables without having to worry about manipulating/disabling the foreign key constraints. The most logical solution would be to do … |
 | I'm trying to load dxf files CAD into a database for searching. Some of these files are huge with hundreds of thousand of separate entites. I've separated the file into the following tables: * drawings * layers * style * entities * points * flags * floats * text The …  |
 | I'm not looking for others to do my homework, I just want help with getting an idea one what to do. My class was given an assignment and one of the questions is: Create a query that will show the order id, item id, price, sales tax and subtotal for … |
| | Following is my code effort.... I want to read first line of file(comma separated) & then create table in JavaDB but stuck here... Please someone help me how to do next???? public class DatabaseDAO { public void FileRead(String st) throws ClassNotFoundException, SQLException, IOException{ String []tokens=null; try{ try (FileReader fr = … |
| | Please i need help in writing a code showing online friends on a chatting site |
| | Hy there! I have prestashop 1.4.4.1 and i want to export database clients in CSV through Mysql. I want all the fields possible. Is possible to export their passwords also?I mean MD5. Can you please help me? Best regards, Florea Uwe  |
| | Hi, Can you guys reccomend me some good oracle sql journals? Thanks |
| | Hello, What are the different areas of databases I can focus on for my project? Thanks, |
| | Hi all, If I have two table of cod-desc, T1 and T2, and I need to create all possible combination, other than using cartesian product, is there another way more optimal to do that? Suppose every table has 1M rows. RDBMS= Oracle 11G. Thanks sandro |
| | WAMP 2.5 server on my windows 10 machine was working completely fine, until I accidentally installed a software which silently installed Win MySQLAdmin on the same machine. That day since, Wamp server icon remains in orange color (never turns green). **Issues:** 1. localhot/ phpmyadmin displays 'access denied' error. following is … |
| | Please Can Any one tell me How do I Greet a user with his name after he submited His form into my Data base /please i need your help.  |
| | I have a quick question, I am hoping it is an easy answer but if I wanted a query like the following: SELECT * FROM items ORDER BY date ASC Is there anyway to replace the order by information with prepared statement attributes? would either of the following work? SELECT … |
 | How To connet mssql to php please please please help meeee. I'll wait for you guys to answer |
| | I need some help writing a sql query. I have below 2 queries and I want to combine them together. Now I already tried union but it doesn't work. I first want to print all result of query1 than I want to print all results for query2. Ex: --Query#1 results: …  |
| | Hi guys, I really need your help. I am Programming an app where a teacher logs in with a username and password. After the login a new Fragment in the app opens where the Teacher see all his students in a ListView. To Login I only type the username and … |
 | I am writing a custom MembershipProvider for ASP.NET and would like to record certain events in a table when they happen. I have the methods to do it, but I would like to get the value of the "ID" column of the row I insert into the table. I have … |
| | Hi all! I have a simple procedure which should return an 'id' field if parameter is passed. The problem is that if I provide the single letter parameter it returns no records although there are matches. But if i provide the whole word as it's written in a table, I … |
| | Hi guys, am trying to populate textboxes with data from sql server database. below is the code I am trying to use in Visual studio 2012, Vb.net. Private Sub btnSave_Click(sender As Object, e As EventArgs) Handles btnSearch.Click Dim query As String Dim MyConnection As SqlConnection = New SqlConnection("Initial Catalog=PayRoll;" & …  |
| | Hi all, I am trying to insert 1000 above data into a table but after inserting 500 something data its showing an "Internal Server Error". I tried after changing max_execution_time in php.ini and some other methods but no use. But this works fine in localhost. Given below is my code. … |
| | Hi Pls advice me the following calculation in stored Procedure my scenario is packing the magazine Example: Order = 6042 copies. 6042 have to be packed by 20 each. so 302 bundle. balance 2 copies. If I divide 6042 /20 Result is 302.10 . How can store 302 and 2 … |
| | Howdy All, I'm creating a database for UFO sightings and would appreciate some feedback or suggestions. Yes I know, strange topic. Some background info so that the problem is understood: I'm extracting data from several large UFO database catalogs, news articles, and other miscellaneous sources, so that the data can … |
| | i want to import my backup database(.sql file) into mysql using php script. i have given the following code where **case 1** section works. but i need to execute **case 0** section. what the problem in my code please help me anyone. <?php //ENTER THE RELEVANT INFO BELOW $mysqlDatabaseName ='online_admission_form'; … |
| | I'm working on a personal movie database project to help keep track of my movie collection, but I'm having issues and I was wondering if it was even possible and if so how to go about doing this in the first place. I want a way to get an overall …  |
| | [code=php]// display records page wise code starts: $adjacents = 3; $tbl_name="feedback"; // $display = "SELECT COUNT(*) as num FROM $tbl_name"; $display = "SELECT COUNT(*) as num FROM $tbl_name"; $total_pages = mysql_fetch_array(mysql_query($display)); $total_pages = $total_pages[num]; /* Setup vars for query. */ $targetpage = "dispfeed.php"; //your file name (the name of this … |
 | Hi to all! I have to install sql server first time. But I have a confusion that what is difference between sql server and sql server management studio? secondly is sql server management studio embeded in sql server or will it installed separately? If it will installed separartely then which … |
| | |
| | Hiiii,Good Evening I have a code that search for data in the database but I can search for only 1 keyword in a time,which is working fine for single keyword. if I type 2 keywords separated by a space or comma's which return blank page. I would like to modify … |
| | Hello All, I need a bit of advice regarding my final year project. I dont want any help with code but just on what path I should take. My project based on using triggers to solve business problems. I am not sure, on how I should approach this really. if … |
| | **Bold Text Here**Hi there I'm just wondering what the best or a good table layout would be for a little project I'm trying to do at work. I work at a temp to perm agency where companies use us for the probationary peroid of employement and then hire the workers … |
 | hello A newbie in database constuction, need help in adding automated sms functionality in mysql database. A user needs to sent a certain sms with certain keywords like 'location' to the system. the system refines a search according to the location content then sents back the data back to the …  |
| | Hi, using sql server 2012 as backend and coldfusion 11 as front end for development.Nowadays, weird scenario happening that the application is not working at some times. But there is no trace of any error in the coldfusion application logs or in the sql server part. The site start working … |
 | Hi I have written a procedure in PL/SQL to get values from user and then I am updating the same in a table. This worked fine 1st time but its just not showing the new values inserted by the user. The field which should be updated with the user value … |
| | Hi! Just want to ask if it's possible that within a select statement, there has a loop. Have this sample query but when I run this it says missing expression after <column2> Select <column1>, <column2>, FOR Lcntr IN 1..12 LOOP CASE WHEN Lcntr THEN .... END END LOOP; FROM <table> … |
| | Hello, Created a query for getting users list excluding the logged in user well I thought about creating a simple one but huh that didn't worked for me. Okay so what logic and for what did I created for. I tried to show the users that are friends with each … |
| | I need some help with creating a simple search engine for website. Basic idea is that user will enter a string in search bar, which will compare in database key_word and get the reuslts. Lets say I have the following table on sql server database. |----|----------|----------------------| | ID | URL … |
| | Hi All, I have a problem when trying to change user account password in my project I am using Visual Studio 2013 and SQL Server 2012. This is the code I am using and I don't know to how to adjust it to check for the old password before changing …  |
| | Hi EveryOne, I have a following controls in my vb.net form: txtID txtName btnAddNew btnSave This form will be storing a values to the SQL Database (SQL Server 2005). In the txtID textbox the auto id should be generated when ever user clicks on btnAddNew. The ID should be generated … |
 | some how mysql database in wamp server 2 got replaced by older database and i am unable to restore the database to the location (before being replaced by old data) from the latest backup i have . is there any way i can restore the data to my required position. …  |
 | Hi. I have to do a MVC project and I don't know exactly how to do it. on the clientside I will have an input form the data (at least two codes and up to 8) will be sent to the server (best way?) then the server will access a … |
| | Hi, i bought a framework website which i am altering for a client and i am trying to add a new feature to it. i have added new field to mysql table i have added lines of code to show up on form, the choice in new feature will be … |
| | Hello guys. I'm trying to create a registration form that takes in employee information. The error I'm getting is: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 I'm …  |
| | Good afternoon fine DaniWeb folks! I am about to pull my hair out on this one and I'd like to know if someone knows of a simple or obvious "gotcha!" for this problem. I've got a form with some detail fields on it (below)  When a user attempts … |
| | I am currently developing a CMS for my firm using .NET Framework ,ASP.Net(C#) & SQL Server Express 2008 ADV. Whenever a user creates an Article i want to genrate a permalink for each article so that navigation is simple instead of using query strings and exposing article id to common … |
 | The program below is just a simple test to see if I can get it to fetch the correct data from MariaDB and then display it on the screen but so far I'm not having any luck. I left the action attribute's value blank because I want the PHP form … |
The End.