10,940 Topics
 | |
 | 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 |
| | I created two dropdown which is filled with data fetched from mysql database by using the ajax and php function, Second dropdown is dependent on the first one and show relevant data. I placed both dropdown in adjacent to one another in table cell format. For the first row the … |
| | 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 everyone, I have 1 raspberrypi and 1 windows server which already has mysql (phpmyadmin) inside it. I need to insert data by using a python script inside the raspberrypi (I work from the raspberrypi) but the data must go to the windows server (it doesn't work yet), the point … |
 | when i click upload button, it takes long to load wthout csv, but when i upload csv it dispays csv pocessed..but there is no data uploaded...what could be the wrong with my code?...please assist me <form enctype="multipart/form-data" method="POST" action="" > <input type="file" name="file" /><br /> <input type="submit" value="upload csv" name="submit"/> … |
| | 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 … |
| | how to update /delete and search in datagrid using mysql database? |
 | 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? |
 | Hi all, I am working on Bank Management System,,i wanna connect my programm to MySql Can anyone refer me Book(s)/links where i can learn so...i have know how of Mysql already and worked on it  |
| | 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: … |
| | My dear friends, I'm stuck in the middle of my project because I'm unable to figure out how this problem could be resolved. I have to implement a time constraint ( admin supplied ), MCQ type of quiz with a fixed structure of only 4 options which is to be … |
| | 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 …  |
| | hey buddy's, i'm creating the program of employee details and i will inserted the fields are ADD,UPDATE,DELETE,EXIT,. I hope the all thing to find the exact solutions but, particular one thing only, that was UPDATE and these are the following some tips and code: 1.the input is not going store … |
| | I am using MYSQL and php version 5.4.16.My table structure is as given below. I want to sort the temp_id cat_id and colors based on the cat_id as given in the second table. The com_id same values should not come at once. My Table is something like this: col1 col2 … |
 | Recently I've need to do some table repair and got into my variables and noticed some bizzare numbers. For those of you that know MySQL, these may be familiar to you, so I'll just list the variables and values: max_join_size: 18446744073709551615 max_seeks_for_key: 18446744073709551615 max_write_lock_count: 18446744073709551615 myisam_max_sort_file_size: 9223372036853727232 myisam_mmap_size: 18446744073709551615 The … |
 | Hello there.. I want to backup my database (MySQL) using a command button in VB6...How can I do that? thank you for answering... :) |
| | Im using LOAD DATA INFILE to import a csv file, the files date format is 29/11/2010 and the database format is 2010-11-29, what can i use to format the date inside the query? I've tried str_to_date: `SET date_start = STR_TO_DATE(@from_date,'%Y-%m-%d'),` but that only inserts 0000-00-00  |
 | I have a project that must have centralization of databases that will have access to the web on a PHP script. I can merge MSSQL and MySQL databases if and only if they were both: 1.) On a same server or 2.) Of the same server type The problem is … |
 | Hey everyone, I'm looking for a free tool to administer MySQL databases. I currently use PHPMyAdmin, which is great, but I'm looking for the same functionality in a desktop software. I've actually found quite a few, but wondered if you any of you could recommend one for me. My only … |
| | <?php include 'connectMySql.php'; $emri=$_REQUEST["emri"]; $mbiemri=$_REQUEST["mbiemri"]; $email=$_REQUEST["email"]; $data=$_REQUEST["data"]; $ora=$_REQUEST["ora"]; $nr_persona=$_REQUEST["nr_persona"]; $query="INSERT INTO rezervim(emri,mbiemri,email,data,ora,nr_persona) VALUES(' ".$emri." ',' ".$mbiemri." ',' ".$email." ',' ".$data." ',' ".$ora." ' , '".$nr_persona."')"; mysql_query($query) or die(mysql_error()); mysql_close($conn); ?> |
| | i have a problem,i log in even though im not registered in database, please help me urgent!!!!!!!!!!!! |
 | Hey I want to make a backup and restore of a MySQL **SERVER** to another machine. Please note the **SERVER** part; I want to backup/restore datebases, tables, procedures, users, configuration, etc....**EVERYTHING** What is the best way to do this? Thank you |
The End.