7,368 Topics
| |
I am trying to update data but i get this error. `Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 ' username … | |
Hi all, Below is my sample data. I am trying to get the 'product' name only if the percentage count is varying. Could you please suggest your maximum no of 'Mysql' queries to approach this. Thanks in advance. Input: ============================================== percentage product ============================================== 100.00 A 100.00 A 100.00 A 2.18 … | |
I am trying to code a search box that will search though a column in my database. If the search matches the column then that record will be printed in the table below. I am searching on a column that contains the county of a company record. There are no … | |
<div class="panel-body"> <div class=" col-xs-12 col-sm-12 col-md-12 col-lg-12"> <form class="form-inline" role="form" action="leadentry.php" method="POST"> <div class="form-group form-groupp"> <label>Business Name</label> <input class="form-control" type="text" name ="business_name" placeholder=""> </div><br> <div class="form-group form-groupp"> <label>Contact person</label> <input class="form-control" type="text" name="contact_person" placeholder=""> <div class="person" id="TextBox_person > <button id="add_person" type="button" value="Add more" class="btn btn-default btn-sm" placeholder=""> <span class="glyphicon … | |
Good afternoon, I have a very little knowledge in php mysql. I want to make a periodical report of my company's strength of various departments. I have a html page like <!DOCTYPE html> <html> <head></head> <body> <form action="" method="post"> Department : <select name="dept"><option>admin</option><option>finance</option><option>motor dept</option><option>logistics</option></select> Designations:<select name="design"><option>clerks</option><option>executives</option><option>helpers</option><option>drivers</option></select> No. of employees:<input type="text" … | |
Hello, I'm looking for the download solution from data on MySql to file .ical aims to import to Outlook Calendar. Do you have something to share with me? Thank a lot. | |
Hello, please help me sold this issue. It can read the content on the MySql table but when I change the value on the input, then click on Submit, nothing is updated on the table. I don't know why. <?php global $wpdb, $current_user; $user_id = get_current_user_id(); $sql = 'SELECT `slot`, … | |
Hello, I hope that I can get an answer for this question. I have a MYSQL table for charges which contains the following fields: ChargesID, ChargesTitle, OfficialFees and ProfessionalFees. What I need is to make a dropdown list which contain ChargesTitle and upon selection to autofill the OfficialFees and ProfessionalFees. … | |
hi, I am creating a form for user to update their details which is saved in the database. So far i can show their details in the form where i have a submit button but the updating part doesnt work(it doesnt update at all). here is the code: [CODE] <html> … | |
Hello everyone, I have been using xampp for my web app developments for quite a while now. Usually after the app development is done, I upload my files to paid hosting. Now, this is the case I'm designing a school's accounts managements software which will be used on an intranet. … | |
I was wondering if someone could tell me how I could store audio files in a mysql database | |
I am trying to update for some products their category in Database. But I get an error and and I dont understand where my statement is wrong. Please help me. I want to find products that have in their name a specific word and after that I want to update … | |
I am trying to force log out an inactive user from my CMS. The timeout value is stored in a value called PREF_TIMEOUT in my database. Ive borrowed this code and modified it a little. The code does not seem to be doing anything. Does anyone know of a better … | |
Hi all :) Before i'm starting futher more about my problem. lets me tell a short description about my program. user will choose path ID (retrieve all this data from table TPATH of database SDO) that they want to delete. before the path ID would be delete, it will compare … | |
Good evening, I wanted to know if we can create a table with an array type fields with phpMyAdmin , thank you | |
I have two tables tb1 and tb2. I would like to sum up field values from two tables. How to do this using a SQL statement. tb1 Name Salary Bob 1000 Tom 2000 John 3000 Winson 4000 tb2 Name Bonus Bob 100 Tom 200 I would like to get the … | |
hello I have an application run in php with mysql database that shows me a list of people in different services it occupies. I would like to make a menu that is based on the clicked service shows me the list of persons who holds this service and each new … | |
Hi, In a representative table, I have fields, like, id, mark_id, rep_id rep_name, father name,etc, In this table, rep_id field is empty, And in rep_area table, the fields are like id, rep_id, dist_id,etc, in this table, rep_id has values. While editing the representative form i want to display rep_id from … | |
I am quite new to web development, so I naturally came to a point where I needed some help. I am making a web site where the user has to log in, and if authentication is successful, the user's data will be fetched from server and displayed on page (and … | |
<?php $this->user_id = $_SESSION['user_id']=$user->id; //create a database connection mysql_connect("host","user","pass") or die("Error:".mysqlerror()); //select database mysql_select_db("db"); ?> <html> <body> <link href="tab.css" rel="stylesheet" type="text/css" media="all" /> <table id="box-table-b"> <tr> <th>User ID</th> <th>Status</th> <th>I.P</th> <th>Offer Id</th> </tr> <?php $result = mysql_query("SELECT * FROM clicks where userId='$id'"); //return the array and loop through each row … | |
Hey everybody, I'd like to get some specific, but not all rows of a MySQL DB into an array, like those I get if I use mysql_fetch_array(). But feth_array, fetch_row, fetch_object, etc... just returns one row. There are many search functions in the internet, so it must be possible. I … | |
Hi guys i have simple problem that i can't seem to solve and has been frustrating me for some time i am a newbie when it comes to Codeigniter so be kind hahah, okay so on to my problem i have form validation on a subscription form that seems to … | |
Hi I am trying to read the datas from mysql using php in json. but i am not getting my expected output. Please help me to fix the issue. **code** <?php include('../config.php'); //mysql_query("SET NAMES 'utf8'"); $tdate = date('d-m-Y'); $url = 'url'; $sql = "SELECT * FROM pimage where date<='$tdate' and … | |
I'm trying to implementing faceted search in a Jewellery store, but failed. Problem is when try to filter the attributes table. structure is as follows: Products Table: Id Product_Code Product_Name 1 ABCGOLD1GM 1 gm Gold 2 ABCGOLD2GM 2 gm Gold 3 ABCGOLD394 3.94 gm Gold Attributes Table: Id Attr_Name Alias … | |
Hi, I am displaying list of jobs that are posted by admin from mysql db. In that Table I used requisition_id (job id) , and the datatype is varchar(255), if we click the job id , it will show the description . My problem is, if it more than one … | |
Hello, Is it possible to join two tables from two different databases? I have the following query whereas the table named "calendar" is in a separate database than the table named "history". Any ideas on how to join bottom? SELECT C.theDate as day, IFNULL( sum(case when DATE( CAST( H.timeentry AS … | |
Hi, No matter what I do I get the Access denied for user error.I watched the video but still get it. Are there any common errors I should be aware of in setting up a db user? Thanks, duchaine | |
I have a large MYSQL / PHP in a while loop report being run and in many cases the report times out due to the large amount of data being calculated. Is there a way to make have a div displaying "Processing" when the while loops is calculating and if … | |
| Hi I have this query: `SELECT SUM(`KN`) + SUM((COALESCE(`EUR`, 0)))*7.5 FROM log WHERE `KN` IS NOT NULL and `EUR` IS NOT NULL` And it retunrs 0 SUM(`EUR`)* 7.5 should be zero but SUM(`KN`) is 60. I am not shure what I am doing wrong here, I want to add numbers … |
The End.