10,940 Topics
 | |
| | please i need your help , there is audio playlist im working on and im try to get music from mydql database and i can get the music file to play but playlist is blank. this is my code html code: <ul id="playlist1" style="display:none;"> <li data_path="assets/mp3/music1.mp3" data-thumbpath="assets/thumbnail/img.jpg" data-downloadable="yes" > <p><span … |
 | Hi, I need to drop tables from a database where all the email addresses end in the same domain, ie, say I have 1000 email addresses i need to input an MYSQL query to delete all rows containing email addresses ending with @mydomain.co.uk. Does anyone know how to do this? |
| | I need to crearte pdf file from database table using java with multiple rows and column format design .  |
 | hi i am attempting to change my connection from mysql to mysqli so far i have gone through all the files in the script and replaced mysql with mysql and i went to check what id done so far and i got the following error can anyone help in this … |
 | registration table broker_id , email , affiliate_id.....etc 40 abc@gmail.com 9999 62 xyz@gmail.com 8888 affiliate_Stats table status_id , affiliate_id , banner_id , campaign_id , clicks impressioins , ctr , sale , sale_price, total_earned...etc 27 9999 3 0 0 1 0 29 9999 3 0 1 0 0 affiliate_chain id name recruitedby … |
| | Hi everybody, pls i need help here. i ve a video player and i want to populate video on it from mysql database, here is my code. <ul id="playlist1" style="display:none;"> <li data-thumb-source="assets/img/ddd.jpg" data-video-source="assets/video/ddd.mp4" data-poster-source="assets/img/ddd.jpg" data-downloadable="yes"> <div data-video-short-description=""> <div> <p class="minimalDarkThumbnailTitle">ddd</p> <p class="minimalDarkThumbnailDesc">dddd.</p> </div> </div> <div data-video-long-description=""> <div> <p class="minimalDarkVideoTitleDesc">dddd</p> <p … |
| | i want to implement forum on my site so please help me to integrate the same  |
| | My problem Im almost certian is a permissions issue but im still very new to this so bare with me. I have a server running the latest mysql with mysql workbench installed and im tryign to modify the users and privilieges for either my one table or all my tables, … |
| | I am not sure if this is possible or not, but I need help writing a query for a running balance report. I tried a few queries on my own; I've come close but not exactly what I need. For convenience, I've created an sqlfiddle: [Click Here](http://sqlfiddle.com/#!9/caa5c) The report needs … |
 | Hello i have formatted my pc with Windows 7 and installed wamp server. My local project doesnt work. I am familiar with the difference between mysql and mysqli? Do i need to install a most recent version of Mysql than the one provided by Wamp Server? |
| | Hi Guys. I have the following scenario: 1. I have build abig management database at our HQ and it is to be fed from several databases spread across regions. 2.I only want to have records of specific tables from those distributed databases be sent to my central database.Changes in Those … |
| | >/ we have three table like follwing </ weather=> id shop_id temp_c datetime shops=> id gstIncludedSales GST_Inc_Sales, gstFreeSales transacion=> id transaction total time transaction_date shopid >/ i have apply this query ... select HOUR(transaction.time) as Hour ,TRUNCATE(sum(transaction.total),2) as Total_Sales,shops.gstIncludedSales as GST_Inc_Sales,shops.gstFreeSales as GST_Free from transaction,shops where transaction.shopid=shops.id and transaction.shopid=7 and … |
| | Converting mysql to mysqli. i need help av been scratching my head how to make necessary changes but its like am making more errors. please help or give direction what to change.. <?php session_start(); include("php/class.user.php"); $msg = ""; $msg2 = ""; //$submit = $_POST['btnaddnew']; if(isset($_POST['btnaddnew'])){ if(empty($_POST['txtUserId']) || empty($_POST['txtFname']) || empty($_POST['txtMname']) … |
| | Hi all, I am not able to get correct count, if col1 (percentage with respect to product) and col2 have uniq value. Below I post my sample table data and expect output and which i query I tried. Please help me to get in to right direction. CREATE TABLE mysample … |
| | I am retrieving from table based on standard and date. For first standard It, has two sections A & B. A has one subject and B has two subject. While displaying I want to display in a table like this: section | Description A | English B | French,English My …  |
| | Dear community, today I am facing a new problem, maybe due to a black out. I am trying to select from a table based on the results from a select statement, however, the result only contains the first few characters of the field. The main table has the field "category" … |
| | I need help with creating a "user account" website (i.e. Facebook, Twitter, etc). I have a home page set up, i just need to have the it jump to the "user's profile page" once they login their credentials (username, password). I know it has something to do with MySQL/PHP. Can … |
| | <grumpy> :( 2 years run an offline mirror of the site, ensuring MYSQLI and MYSQL act exactly the same in my situation, duplicating every transaction Checking and modifying the scripts, there are some dfferences: backed up the DB, uploaded the altered scripts, went live; the host crashed Currently running from … |
| | hello, I am having a problem opening my database. Before this I could directly go to phpmyadmin after logging in to cpanel without entering username/password. Today, I was directed to a page to enter username/password before going to the database so I did but I got this warning: Warning in … |
| | **Hello, please help me on this. I want to select from these table,** table name: User | Register_date | --------------- | 2015-02-04 | | 2015-02-04 | | 2015-02-14 | | 2015-03-14 | | 2015-04-04 | | 2015-04-14 | table name: Reservation | Order_date | Amount | ----------- | ------ | … |
| | Really need soem help here. I'm new to Mysql. my server crashed on me two days ago. I was able to do some data recovery to access the mysql file. the problem is how do i go about getting access my tables after this. I have no backup to restore … |
| | I forgot what type of hashing used for passwords in my database. How can I recover passwords in my database? -Any solution to my problem? or any suggestions? -Thanks in advance.  |
| | Hi . I am writing sp that i will use for generating SSRS reports . In the sp , i hv passed month name as input parameter. I am able to get the required output but need to filter it based on months .i.e entries present for current month upto … |
| | 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 … |
| | I'm referring to this tutorial: http://www.techfounder.net/2009/02/02/selecting-closest-values-in-mysql/ My query and code to execute search (This doesn't return any result).I need to get 100 closets value to the postcode given by user which is collected by $postcode = $data['postcode']; ERROR shown are: 1) Fatal error: in C:\wamp\www\search\ajax2.php on line 79 2) PDOException: … |
| | 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 … |
| | Hello, I am right now having a dedicated server and when i try to execute a INSERT query in table of 2 Lakh rows it takes about 0.02 seconds. so i am having a website where i need to update all 2 Lakh rows every 15 mins. but it sims … |
| | 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 … |
| | Hello, I'm using fpdf library to generate pdf invoice. I manage to view the pdf invoice for one item row only. below is the code: $qry = "SELECT invitems.itemId, invitems.invoiceId, invitems.itemNumber, invitems.ChargesID, invitems.itemDesc, invitems.itemAmountO, invitems.itemAmountP, invitems.discountAmount, charges.ChargesTitle, invitems.itemqty FROM invitems LEFT JOIN charges ON invitems.ChargesID = charges.ChargesID WHERE invoiceId = … |
The End.