7,368 Topics
 | |
 | 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 … |
| | |
| | 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, 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 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 …  |
 | I am currently creating a MySQL back-end database system and have come across a problem. Whilst building my ERD, I have noticed that one table requires 3 Foreign Keys. Is this acceptable database design? Thanks for all your help |
| | Hello All, I wonder if someone could help me, I'm about to start work on a pretty heavy system that will be massively database driven. I was wondering if there was a framework out their a bit like jQuery for example that will assist me in all my MySql funcitonality. … |
| | Hello, my website is created almost intirely in php, its dynamic and we have everything working under mysql database. It has printable cuppons for free, the coupons are inside a form, everything works perfectly. Now im trying to find a (php preferably) script that will count how many times that …  |
| | |
| | As some of you might know I'm working on a movie database to help track my movie collection. For a while I was having trouble getting the output I wanted for that, but I finally figured out some sql code to help with that problem. I'm going to be working … |
 | I have been racking my brain trying to think of how this would work to no success. Can anyone explain how this could be done? |
| | Complaint table id company_id user_id source id=coplaint_id user_id=user which filed complaint company_id=complaint againt company source=source of complaint I am trying to get user_id who have filed complaint via same user_id and against same company. one user can filed multiple complaints against same/different company  |
 | Hi, I'm currently working on a site in which a user basically clicks a button repeatedly, gaining 1 extra point each time he clicks it. Anyway, I'm trying to do a MySQL update so that when the button is clicked, it updates his score in one of the MySQL tables: … |
| | Hello, I want to insert single or double quotes into mysql without using \ or anything else i tried mysql_real_escape_string but it did not work it gives SQL Syntax Error : Check what to use near error...Plz Help... Here's the code... [CODE]<?php $name = isset($_POST['name']) ? $_POST["name"] : ""; $description … |
| | A Database Error Occurred Unable to connect to your database server using the provided settings. the above error am getting when i load the localhost and my database.php and db_driver codings are given below $db['default']['hostname'] = "etc.com"; $db['default']['username'] = "etc"; $db['default']['password'] = "etc@etc"; $db['default']['database'] = "visiting_link"; $db['default']['dbdriver'] = "mysql"; $db['default']['dbprefix'] … |
 | I am trying to search a mySQL database in PhP using POST, but I get these errors: **Notice:** Undefined variable: ban1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php on line 266 **Notice:** Undefined variable: banner1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php on line 268 **Notice:** Undefined variable: bantl1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php on line 270 **Notice:** Undefined variable: banreason1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php … |
The End.