11,093 Topics
 | |
| | Hello i need to match a loginid from another label in my MYSQL database. I dont know how or what i should search to get to this. |
| | Okay. I have a whole list of products. Some are the same thing ie: same titles I have a form where people search for the products. I organize the products by a rank I give each product when they are first created. I want to group up the products. For … |
| | Hi, I am learning store procedure. my table structure is user_id int(9) primary user_name varchar(100) user_first_name varchar(100) CREATE PROCEDURE Sp1(OUT p VARCHAR(100),OUT p1 VARCHAR(100),IN p2 INT) SELECT user_name,user_first_name INTO p,p1 FROM pm_user WHERE user_id=p2; CALL Sp1(@Name,@Fname,2); SELECT @Name,@Fname; Output comes like @Name @Fname [BLOB - 0B] [BLOB - 0B] How … |
| | i have this code: [CODE]<?php session_start(); $id=$_SESSION['uid']; include "dbconnect.php"; $query = "SELECT FROM members WHERE id='$id'"; $result = mysql_query($query); $row = mysql_fetch_array($result); ?>[/CODE] and it says mysql_fetch_array is not a valid argument. help please |
 | Hello All, My problem is, i have one database and application in web server, another application in local server which is having another database . But some tables are same in database server and in my local database. I want to update these particular tables from data base server into … |
| | Please can anyone explain me how I can connect a mysql database with a j2me application. I would be great full if you can give me some code samples or tutorials. thank you.  |
| | hi i am having a problem with a php script. i have 3 files index.php, home.html.php, form.html.php. home.html.php is working fine, if has a form that is submitting fine but when it submits i get a problem. maybe someone can help me out please i would be grateful as i … |
| | How to recover data from .ibd file if innodb is corrupted I have one test database and many table with the extension of .frm and .idb file. from frm file i got strucure of database but how to restore data from individiual file of .idb file. |
| | Hi friends, I had a database table as follows ... Id | Film Name | Director | Cast | ---------------------------------------- 12 | Dhoom | Name | 123,128,125,458,12 12 | Dhoom 2 | Name | 129,158,147,455 ------------------------------------------------ I need search by cast column For eg : If I select :- [ICODE]select … |
| | 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" … |
| | i tried to make a new server registration suing pgAdmin3. i filled up the form with this name: test host: localhost port: 5432 Mantainance DB: postgres Username: test the rest i left it empty. but i got an error, [QUOTE]An error has occurred: Error connecting to the server: FATAL: database … |
| | I have one MySQL database field which saves comment from users. Some comments have new lines but when I try to use PHP to display the contents of the database, the new lines are ignored. I know about nl2br() but I guess it will not work as my users will … |
| | What is difference between SQL,MYSQL, and MS-SQL? |
| | Hi all, This is my first post on this forum, I hope someone here can help because the last few forums were at a loss... Any ways, I have this MYSQL command: [CODE]SELECT DISTINCT schedule_date, schedule_time, schedule_team_1, schedule_team_2, event_name, type_name, gen_duration, COUNT(DISTINCT((SELECT id FROM link_schedules WHERE schedule_id = schedules.schedule_id UNION … |
| | hello... I created a website having a database. I realised that I need to set a database username and password. I tried to include it in the connection string but I'm having the below error: Login failed for user ''. The user is not associated with a trusted SQL Server … |
| | I set a password to mysql console in wamp. I followed a video tutorial. And it was successful. But now I can't access phpmyadmin or localhost. It says invalid password ...And gives no option to type the password. How can I solve this?? |
| | I can't find information on this anywhere online. I am building a site using drupal. As you may know drupal installs its own database and runs on Apache. I have a backend mysql database that must be read and written from a vb.net app. I had to purchase a hosting … |
| | Hi Not the first time Ive wondered about this, just the first time Im asking the internet :) I have a list of 'users', and there is a table of 'photos'... each matched to a user via a 'link' table... When I use a left join, and the 'user' doesnt … |
| | I am having a little bit of trouble coding a registration form. The text fields are no problem, its when I have a selection of checkboxes asking why they chose to register with this particular website. There are 3 checkboxes and 3 fields in the mysql table for them, the … |
| | Hi, I am looking for some information about using Underscores ( _ ) in usernames. I currently have a friends system where a user can become friends with another user and this is placed into a database. I then have a query to display all of the users friends, which … |
| | Hi, I guess it's time for my first post here :) I've managed to create a php script that can run through a MySQL table and print out OPTIONS for a HTML SELECT tag. That was Google 101. But I want to keep my php and HTML separate so i've … |
The End.