18,960 Topics
Hi Everyone, Does anyone know how to set the schema so that it can stores chinese character. Thanks.
I'm having a strange problem with a website I'm working on. What I want to do is pass a SQL query variable (in this case cid) using a link, but for some reason it just isn't working. This type of query works just fine on other pages of this site, …
Hi guys, I'm in the process of learning PHP. I know the dribs and drabs and can kind of understand code when I read it, but I'm not to the point of being able to write an advanced script from scratch. I've been interested in chatbots and the concept AI …
$result = mysql_query("SELECT * FROM rooms"); while($row = mysql_fetch_array($result)) { mysql_query("insert into chat (name,text,date,chat_id) values('$_SESSION[username]','$_POST[text]','$date','$row[id]')"); } can i do that without repeat the mysql_query code?
Ok, I feel like I'm so close, but could use some help. I am trying to retrieve data from mySQL database via use of a form with checkboxes. This form is working somewhat except that it is only pulling one selection, not all that are selected. Can someone look at …
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
i need simple shopping cart (without shipping fee and those things) but with/without cPanel and registration form with MySQL to save members data, any suggestions? :D
Hello, I have a database where I insert records into, in Hebrew. One of the fields needs to have quotes in it. Then I need to use this field as the title attribute in an image tag. I got confused with all the different functions: mysql_real_escape_string, addslashes, stripslashes etc. Up …
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. …
I am analyzing a code and I receive the next error Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\wamp\www\AktiveKB\admin\includes\classes\class.auth.php on line 175 I am new in php and I don't know how to handle this error
Hey, I am very new to php. I have a PHP script (modified from [url]http://woogley.net/misc/Highscore/)that[/url] I call from a my Java code to access a database in order to read/write records. The SELECT part of it was perfect. However, i can't write to the database when I try to UPDATE. …
Hi, i am trying to connect to a database(mysql), is this way right ? I have added[CODE]using MySql.Data.MySqlClient;[/CODE] I am getting a error on [CODE]Conni.Open();[/CODE], the error is saying: "Unable to connect to any of the specified MySQL hosts." Need help [CODE]string email = textBox1.Text; string password = textBox2.Text ; …
I want to connect the mysql database in netbeans IDE 7.0 but I dont know how to do this. plz plz provide me any idea about this as soon as possible.
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 …
Hi folks, I am in the midst of updating a clients website, only I am having some trouble using their existing code. They have a fixed schedule which displays what times the presenters are "on-air".... I have created some timezone offset's for basic countries and I would like it to …
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, My application is in VS2008 coded in Vb.net. I have a datagridView which is getting populated from the Database.I has RegNo,RollNo,Name etc fields.The data in the Name column of database is coming from 3 columns of a certain table from database. This is how im concatinating it and displaying …
Hello guys, I am very new to Java. I've been trying to select two different tables but fails. The error is "Invalid operation at current cursor position.". Here is my code. [code] private void display() throws SQLException{ TableModel model = schedTable.getModel(); PreparedStatement stmt = con.prepareStatement("select * from APP.SCHEDULE"); ResultSet sched …
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 …
I have a webpage that builds an html table if there is any data in a mySQL table. That works fine, the html table is populated with data from the mySQL table. My problem is when there is data it populates the html table but lists the first mySQL table …
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 all, Im starting to program in java with sql. The problem im having is that when im trying to complete a combo box with data from a table in sql i get this error: [U]"null error in cargarComboProvincias()"[/U] when i run the program, and i cant find the error …
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 …
I am not getting how to display stored database in MLM format? I have attached problem and desired answer images Database fields are : id new_id, name I want to display all members under member 1 all or one of that may be having member under itself.
OK, first off let me say that I know that javascript is a client side language and that php is a server side language. I've read that you can't assign javascript variables to php variables too. But I'm still absolutely stumped as to WHY my code below doesn't work. Perhaps …
Hi Friends, I am working on php from builder, where user can add text-box, text-area, chekbox, radio-button etc field using jQuery. Now i am ready with html code of form. Next step is to save each attributes(i.e. name, optionstags, label, title, tooltip, class etc) in mysql database. How can i …
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 …
So I found a small flaw in the comment system I've made. When someone presses enter while typing a comment and puts in a new line, it doesn't show when the comment is gotten from the mysql database. I don't have any "if (new line within comment, add newline to …
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.