10,940 Topics
 | |
| | Is there a way that if I click on a radio button, it inserts its value to database? [CODE]<form name = "data" method = "post" action = "JSP/insert.jsp"> <p> <font size = "4"> Rate: 1<input name="radio_rate" type="radio" value="1" onclick="return validate()"/> 2<input name="radio_rate" type="radio" value="2" onclick="return validate()"/> 3<input name="radio_rate" type="radio" value="3" …  |
| | Hi I need some help in connecting to the mysql server. Here is the full situation : server H -- i have access to this server -- but this server does not have apache it is basically like a dropbox, i just throw the phpmyadmin config file in here and … |
| | I'm getting an error: mysql_fetch_array(): supplied argument is not a valid MySQL result resource [CODE] function next_record() { $this->myrow = mysql_fetch_array($this->result); return $this->myrow; } [/CODE] Please help! |
| | i have two mysql tables.A java application is working there which picks data and insert into second table.what i want is if there are less than 60 rows in targeted table then java application should stop when there is less than 60 entries only then it should insert data in … |
| | Hello frndz, I want to handle the database error coming on insert query when duplicate entry going for unique key.(I am using mvc frame work in php) Please Help me...... |
| | Hi, I need to develop an interface where scanned barcode information is inserted in MySQL database with using PHP. Is this possible? If so, how it actualy works? It will be done with Wired and Wireless scanners. Does it differ? Regards |
| | I guys, I want to upload files to a MySQL database in PHP.... The connection is OK... but there is a problem with the document column.. If anyone can help me , please give me a working solution.. |
| | The mysql database I set up used date format for the field. Consequently dates have to be entered as 0000-00-00. So when I retrieve the field name news_date from the database it will print as 2011-02-02. I would like to display it as February 2, 2011. Can someone help me … |
| | Hi all am having problems with my login forms. I have written the code and has no errors, but when I run it from my browser i get "Warning: mysql_query() expects parameter 2 to be resource, null given in C:\xampp\htdocs\nicks\includes\database.php on line 269" I have a "MySQL Table with Members … |
| | In my hosting account I have set up a database named george. There is one table named "news". There are three fields "id" (primary key), "date", and "text". I am keeping this simple for illustration. What is the best/easiest/fastest way to import the data or records to the table via … |
| | $sql = "UPDATE USERS SET password='changed password' WHERE login = steve"; header( 'Location: [url]http://steveworld.000space.com/prof.php[/url]' ); this is my code, im trying to allow users to change their passwords at anytime, I put in a set text and it still doesnt work, it is very agitating! |
| | Hi guys. I have a Java program that works in 3 stages after connecting to a MySQL database to give desired results. The first stage involves a function X that returns a value it finds in table A or zero. The second stage involves a function Y that's only allowed … |
| | right now my php script is vulnerable to anyone putting in a random member_id into the url and having it excute sucessfully how can I encrypt the id="id#" in the url, so a guest is unable to type in there own id in the posted id retrieved through the url? … |
| | [CODE]UPDATE movie_temp SET movie_release_year = ( substring_index(movie_title,')',1) ) WHERE movie_title IN (SELECT * FROM (SELECT movie_title FROM movie_temp) AS TEMP); [/CODE] When executing the above query (movie_temp table has more than 660,000 rows), after 600 seconds workbench throws me errors Error Code: 2013Lost connection to MySQL server during query followed … |
| | Hi Guys, I am making a social networking site where I want to have a user's pals shown in a PHP generated table. I want to show pal thumbnails and other information below these thumbnails so that if you click on a thumbnail, it takes you to that user's profile. … |
| | good day, im practicing databases and .net, can you help me in relating multiple tables and manipulating a listview? my scenario is about school subjects of a student, i have a database with data that has 2 tables, which is 'fnsh_table' and 'ofrd_subjects' fnsh_table Student_No nchar(4) Subj_No nvarchar(10) Title nvarchar(20) … |
| | Hi All, I have a problem and I dont understand what's happening, because my method usually works. I am querying a bunch of records from a database given a foreign key id. See code as follows [CODE] $castQuery = "SELECT * FROM cast WHERE production_id = '$newID' "; $cresult = … |
| | i need a script that data's fetch from mysql and display in text scroller using javascript. i' uses it is a news update. please somebody helpp me. |
| | I have 2 tables and want to add the count column from the bottom table to the top table (join on “OID” and “OPTID”) and if no count is found set the cell to zero. How can I do this? [CODE] SELECT questions.pollid, questions.id, questions.title, questions.ordering, options.oid, options.qoption, options.ordering FROM …  |
| | This Error keep show up everytime i use insert query code in my php programs 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 '-student(stud-id,stud-fname,stud-mname, stud-lname,stud-gender,stud-status,stud' at line 1 example code: <?php require_once "formvalidator.php"; … |
| | Hi, I am new in PHP world and know some basics. I have a database where date wise entries to be made by users. I would like to get results in month wise total. e.g. I have these columns in the database: fleet_no, fueling_date, quantity, price. Now I want to …  |
| | Hi friends, I need a simple help or query for my search option in my website. I had a table which storing movie information. The rough form of table structure as follows. Movie name | Director | Genre | Producer | Story line | Cast ------------------------------------------------------------------- | | | | …  |
| | Hi, I want to call MySQL stored procedure in perl. I have tried like this: [code] use DBI; my $create_procedure = qq{ CREATE PROCEDURE simpleproc () BEGIN SELECT 'helloworld' As Messgae; END }; $dbh->do($create_procedure); $sql = "CALL simpleproc()"; my $sth = $dbh->prepare($sql); $sth->execute(); [/code] I am getting an error which …  |
| | Hi guys, im trying to develop a social networking application and im having some trouble showing a user's selected avatar. Every users can upload pictures and there is a field called avatar and when this is set to 1, it is the users avatar pic. Only one pic can be … |
| | I am trying to define the table and fields in a mysql database I set up in my hosting account. I have the database name, username and password set up. I now need to define the table and fields. They want me to import a text file to do this. … |
| | Hey guys I'm hoping someone can help me out. I have an admin page with the ability to update existing data from a table, I have textboxes being created for each record(this works) but its the submit/update script that doesnt work. What it does right now is nothing, i hit …  |
| | I am using the following codes to update my SQL records but these arent working. Please help me. [B]HTML To select which Data to update[/B] [CODE] <?php $connect = mysql_connect("127.0.0.1", "root", "") or die ("Error , check your server connection."); mysql_select_db("shipments") or die("cannot select DB"); $sql="SELECT * FROM info"; $result=mysql_query($sql); … |
| | Hey guys I am trying to create a login that checks for a password in a mysql database. I have just started picking away at this and have no clue if I am even close. If I am not even close I don't need someone to wast there time holding … |
| | hi I'm having trouble with php and mysql I'm getting this error [CODE] [Sun Jan 30 17:43:40 2011] [error] [client 127.0.0.1] PHP Warning: mysql_query(): Access denied for user 'root'@'localhost' (using password: NO) in /var/www/t/view_tg.php on line 29, referer: http://localhost/t/ [Sun Jan 30 17:43:40 2011] [error] [client 127.0.0.1] PHP Warning: mysql_query(): … |
| | I modify a php comment system. I want add it after every article witch are query from database. this is the php part [CODE]<?php ... while($result = mysql_fetch_array($resultset)) { $article_title = $result['article_title']; ... ?> <form id="postform" class="postform"> <input type="hidden" name="title" id="title" value="<?=$article_title;?>" /> <input type="text" name="content" id="content" /> <input type="button" … |
The End.