10,932 Topics
 | |
 | Hi all Experts , I am converting my application from Oracle database to Mysql , i am facing alot of problems, some experts are really helping me , i am thankfull to all those how helping people like me. They actually encouraging us to do more n more. Thanks all …  |
| | Hi There, I have 2 tables, one with dst codes and one with fees. I want to match the fees with the dst code. I've been trying a for loop but it's not working 100%. What is the best way of matching dst code with the corresponding fee? If TABLE … |
| | i have table in the database for login system [CODE]CREATE TABLE users ( username varchar(30) primary key, password varchar(32), userid varchar(32), userlevel tinyint(1) unsigned not null, email varchar(50), timestamp int(11) unsigned not null ); [/CODE] already have cart for things that doesnt need shipping, but its with JavaScript, [url]http://lasthunter.freehostia.com/rated-online/conf_files/js/simpleCart.js[/url] but … |
| | Hello all, I have a problem in building the query for search. I have a table which contains a column X stores numerous values in each respective cell of a row. For e.g. [CODE] rows Column X 1 120;132;143;154;165 2 122;134;543;566; [/CODE] What I want to do is to make … |
| | I have never worked with mysql. I need to design a few pages for a website that allows certain people to log into the page and be able to update or change the info manually without having to use any html editing software are any programs. How is this done? …  |
| | i have a date column where dates are saved in varchar format like this 17-03-2011 :: 11:19:48 i want to find last date through query.. please help thanks |
| | Hi to all, i need a help I have 2 tables namely subjects & marks. Subjects has 2 columns namely subject_id (PK), subject_name & class_id (FK). Marks has mark_id, student_id(FK), exam_id (FK), sub_1, sub_2, ... sub_n here sub_1, sub_2, ... sub_n are columns in 'Marks' table but actually they are … |
| | What I am upto: I am tryin' to develop a Blog CMS. There is a Database named blog in which there's a table named posts. The posts table has these fields: post_id, post_title, post_url, post_time, post_category, post_desc, post_username. Here, post_username is the username of the user who posted this post. … |
| | My table has 4 types of "r1": 'Standard', 'HD', 'HD + DVR', 'None' There are 3 types of "status": 'NTC', 'Repair', 'In Progress' All I am trying to do is retrieve all of the rows where r1 = 'Standard' and matches all three of the "status": [code] SELECT * FROM … |
| | Hi all I am getting following exception in mysql db randomly. ** END NESTED EXCEPTION ** Last packet sent to the server was 1 ms ago. 11-9-2011 12:0:11 Exception in readFile Method in insertRecordInDataBasecom.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at … |
 | I have prepared an example of login page which displays a form with inputs for username and password and compares submited values with records in database. If match is found the user is redirected to another page, if not error message is displayed. This example is heavy commented. Hope it … |
 | [B]Good Morning, I have a CSV file with thousands of rows of data, and I want to have this data uploaded into a table in a MySQL database. I also want an area where the file could be selected from the computer for the data to be uploaded. Could this … |
| | ERROR UNABLE TO CONNECT TO DATABASE SERVER STORED BACKUP WHOLE WEBSITE IN HTDOCS AND IMPORT WHOLE DATABASE USING IMPORT IN MYSQL AFTER RUNNING [url]http://localhost:8888/[/url] ON LOCAL MACHINE ERROR MESSAGE :UNABLE TO CONNECT TO DATABASE SERVER ANY HELP WOULD HE HIGHLY APPRECIATED |
 | I have to design a database where one requirement says "For each project, for each user, for each skill, store the marks gained". Initially, i had a table where each skill was a column(proj_id, user_id, skill1, skill2, ......., skill_N) I felt this was a bad design because the number of …  |
| | Hey folks. I currently have a large JSON file made up of entries similar to the below. The file contains information relating to photographs:- [CODE]{ "SourceFile": "C:/Users/Me/Desktop/Photos/5294030805_9497032cd7_o.jpg", "ExifToolVersion": 8.63, "FileName": "5294030805_9497032cd7_o.jpg", "Directory": "C:/Users/Me/Desktop/Photos", "FileSize": "1094 kB", "FileModifyDate": "2011:09:09 22:40:39+01:00", "FilePermissions": "rw-rw-rw-", "FileType": "JPEG", "MIMEType": "image/jpeg", "JFIFVersion": 1.01, "ExifByteOrder": "Big-endian (Motorola, …  |
| | This is my code to hash [CODE]class hashing { private static $algo='$2a'; private static $cost='$10'; public static function unique_salt() { return substr(sha1(mt_rand()),0,22); } function hash($password) { return crypt($password,self::$algo.self::$cost.'$'.self::unique_salt()); } public static function check_password($hash,$password) { $full_salt=substr($hash,0,29); $new_hash=crypt($password,$full_salt); return ($hash==$new_hash); } }[/CODE] This is my login page [CODE]require("hashing.php"); $password=hashing::hash($_POST['txtPassword']); $checkPassword=mysql_query("SELECT * from … |
| | I scripting chating program in python... And i'm on chating program scripting auth with mysql. But no know how to script authentication on python-mysql. How to script chat auth program for chat with python-mysql. -- Sorry with English language. |
| | Hello, I know nothing about PHP and this error has come up and I've been researching for days and have tried just about everything. Hopefully, I've given you enough information, but can you tell me why this line: $row2 = mysql_fetch_assoc($res); is the one called up in the following error? … |
| | I want to upload images that will be saved in a folder. That folder is inside my website folder. eg: mywebsite(website folder). myimage(image folder). And the path of image should be saved in mysql. I tried the following but it is giving error "path not found." This is my path:- … |
 | Hi! I got this messaging system on my website up and running now. But there is something i need to do when the user click the message they got. All the new messages are flagged as New! when they get the message. When they click on it, i got this … |
 | This script will display a previous next script that will look like this: << prev 1 2 [b]3[/b] 4 5 next >> It is clean, and avoids large numbers of pages in the prev/next links [code=php] $server = "localhost"; $user = "username"; $pass = "password"; $databasename = "yourDBname"; $db = …  |
| | Hi to everyone I’m wondering how to make some simple checkbox for multiple data delete from mysql I found some tutorial on net but don’t work. I tested it without changing anything and doesn’t work. I’m wondering did programmer test it before he posted that tutorial ? Here is a … |
| | Good day, I am getting an error on a log-in script: mysql_query(): 4 is not a valid MySQL-Link resource I've done some research on this and followed such advice as: [LIST] [*]ensuring the mysql connection is closed after the results have been returned [*]testing any sql strings I define in … |
| | Hey guys complete noob/novice here, Looking to join multiple tables identical in structure. It's meant for a search box in my school project. [COLOR="Red"]If I have table 1 and table 2 identical in structure, when the user searches for "keyword" it will search through both table 1 and table 2 … |
| | Hi. Well, I am able to program in Java and connect it to MS Access and be able to distribute it as long as I have the *.mdb file together with the *.jar file. Now, I want to have my database on MySQL. I am already able to do it … |
 | Hello All, I wand Firefox to remember my password when i login in phpmyadmin. But Firefox doesn't ask me to 'Remember password'. When i inspect phpmyadmin form using developer tool, i done see any trick. Secondly i also want in my website coding that when user log in Firefox don't … |
| | hello am a newbie sad to say but i got a big problem regarding to the auto increment. i use innoDB for storage but somethinggoes wrong! i dont know why. whenever i input new data (such as name add and tel, member ID should increment by one) there is no … |
 | |
| | OK, I have a table that has: id (int), name (varchar), parent (int) If parent contains NULL it IS the "parent" otherwise it is the child of a parent So: id=1 name=Meals parent=0 Means the above record is a "parent" (there are 100's of parents). So far, so good? Next … |
| | hi every one, i am trying to store store procedure result into temporary table tried using DELIMITER $$ DROP procedure IF EXISTS `Merge` $$ CREATE procedure `Merge`() begin create temporary table table1 call sp1(); create temporary table table2 call sp2(); End $$ DELIMITER ; error :: Script line: 3 You … |
The End.