11,093 Topics
 | |
| | hello guys...i have a class table in which there are two fields [B]class_id[/B] and [B]class_name[/B] and a student form in which there is a text field in which user will mention the student class and then hit add.this will retrieve class_id from class table instead of class name into student … |
| | I want to have a setup where users from hundreds of sites hosted elsewhere will all be pulling information from my one master database that I host. I don't want to allow them to make any changes to the databases, just pull information from it to display on their site. … |
| | hello friend...want to ask something after completing my [B]student form[/B] now i am up to [B]classes table[/B] so i make a table in DB which consist of two fields [B]'class_id'[/B] and [B]'class_name'[/B].[B]class_id [/B]is auto_incre.so i thought to add a field in the same [B]student form [/B]in which the user will … |
| | I have written a mysql database using PHP which uses a multi-field form to collect descriptive information about archaeological finds/features etc. Some of the fields are text or medium text in length. It is common when describing things to include references, which frequently now take the form of a url. … |
| | hello... i need help from you all.. i am still new in php.. i hope you all can help me.. i am desperate. i can't delete delete data(delete multiple row from mysql using check box). this is my coding.. the cooperation is greatly appreciated. i have 2 file this is …  |
| | Hi every one, I have a problem in inserting database entry, suppose I have two paragraph entered in one richtextbox what I want is that When I hit save, every paragraph will be save as one database entry therefore my database will have two records.. This uses VB.net 2010. Please … |
| | Do anyone see what im doing wrong with the update query? i get this mysql_error message; 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 '-xxx WHERE id = '616' AND userid = '15'' … |
| | good morning. i am new still new in php. I need help from you all. why i cannot delete multiple rows from mysql with checkbox in my database... this is my coding.. <?php $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="cek"; // Database name $tbl_name="del"; … |
| | hi,im using registration form for registering users to the new account.i have 2 tables in one database.database name is test and table name is student and member.in student table which contain the register no of student which is already stored in the database.in member table,it has 4 fields which is … |
| | This is my 2 tables. [B]account_details[/B] (account_number, nic, full_name, phone_number, address, gender, date_of_birth,__) [B]account[/B] (account_number, name_with_initials,account_type, fd_period,__) I want to select records in both the tables. This is my SQL line. [CODE] $query ="SELECT account_details. nic,full_name,phone_number,address,gender,date_of_birth,account.name_with_initials,account_type,fd_period". "FROM account_details,account". "WHERE account_details.account_number=account.account_number"; [/CODE] The following error occurs. You have an error in … |
| | Hi I get my data posted from another form.html page i receive it just fine and decode the json just fine, and the validation works just fine, the only problem is the part where i have to insert the values into the database.. any suggestions.. [CODE] <!DOCTYPE html> <html> <head> … |
| | hello..., [CODE]SELECT DISTINCT store_type FROM stores s1 WHERE NOT EXISTS ( SELECT * FROM cities WHERE NOT EXISTS ( SELECT * FROM cities_stores WHERE cities_stores.city = cities.city AND cities_stores.store_type = stores.store_type));[/CODE] please any one help me to understand this query... and what would be the output of this. and please …  |
| | I created a Javascript application that creates a moving quote.([url]http://economymoving.net/get_an_online_moving_quote.php[/url]) The quote page should insert a record in the db, display the record on a new page called viewquote.php and send an alert email to the company. Currently, the phpmyadmin database receives the record but viewquote.php doesn't display the correct … |
| | I wanted to connect mysql with C# But I was faced with the following error error text:connection unexpectedly terminated Please help me |
| | here is my stored procedure [code=sql] begin select indexes.IndexID, languages.LanguageID, languages.LanguageName, indexes.OrderID, indexes.IndexName FROM indexes, languages where indexes.LanguageID = languages.LanguageID and languages.LanguageID = Language order by indexes.OrderID asc; end [/code] here is my php code [code=php] <?php $Server = "127.0.0.1"; $Port = ":"."3306"; $DataBase = "abc"; $UserName = "def"; $PassWord … |
 | |
| | I want to update a table based on what a user enters. I know I got the username and password correct. But I keep getting an error based on my debugging code. I'm connecting to the database successfully, but it's just not updating. The variables print into the page, so … |
| | hi evry one, my problem statement is i have table as follows [CODE=text]jobId | stagename | Count 623 Technical Screening 5 623 Technical InterView 3 623 Second Interview 6 623 Final Interview 7 623 Hr Interview 1[/CODE] i want Query To Display result as given below [CODE=text]jobId |Technical Screening | … |
| | hi, I hav a created a field with unique constraint, so if it got duplicated error must be returned from procedure. Wats wrong here? [CODE] $dbconn = new DbConn; $dbc = $dbconn->Fn_CreateDbConn(); $Qry = $dbc->prepare("CALL CMS_School_Insert(:SchoolID,:SchoolName)"); $Qry -> bindParam(":SchoolID",$SchoolID); $Qry -> bindParam(":SchoolName",$SchoolName); try { $Qry -> execute(); }catch(PDOException $e) { …  |
| | I need to update database table fields that contain URLs based on evaluation of the those URLs. Specifically, I need to eliminate the empty the fields of any URL that contains the directory "img_ours", and I need to take any URL that contain UPCs and change the URL formula, but … |
| | I have field date_of_birth.... If I want to calculate age "select floor((to_days(curdate())-to_days(date_of_birth))/5) as age from table" So I can use the above one... instead of executivg this at every time I want, Is it possible to create a field named age with above structure so If I store the date_of_birth, … |
| | I am using netbeans to do "Library book search system"in EJB. I have a html page in which I want to display the list of books that match with the entered keyword. I get the keyword from the user and send it to a servlet through an ajax funtion which … |
 | Hello, What I am trying to do is use the following query: [CODE] SELECT * FROM players WHERE NOT EXISTS (SELECT * FROM raidgroups WHERE players.name=raidgroups.player) AND itemlevel>=346 AND level=85 AND NOT EXISTS (SELECT * FROM verification WHERE players.name=verification.username AND verification.organizer=1) AND suspended=0 ORDER BY RAND(); [/CODE] What the above … |
| | Hello there, I need some help with a query .. Table gamedate cutofftime 2011-08-25 13:55 I want to list games that are today +7 days but today games where the cutoff time has passed should not be displayed. Can anyone help me with this query please. Thank you for any … |
| | Hello, I have a table that looks like this: [CODE] +----+-------------+-------+-------+-----+ | ID | Player Name | Col 1 | Col 2 | ... | +----+-------------+-------+-------+-----+ | 01 | Some Guy | 2 | 3 | ... | +----+-------------+-------+-------+-----+ [/CODE] the ... represents a (technically) unknown amount of columns. What … |
| | Hi, I need some help. I have data in a table (cust) and one of the columns has multiple values in it (cat_id). I need to use those values to select data (cat_name) from a second table (cat) and display this with the data from the first table where (cat_id) … |
| | for example: i m currently work on online results system i can't understand how i could this.. teacher search students seat numbers in 'student enrollment' table and these seat numbers search in text fields than teacher write their numbers three columns mid marks, lab marks and terminal marks student seat … |
| | Hello Everyone, I am trying to delete some rows from a given table using mysql and php. No errors come up, the page doesn't die, however the records are not deleted! Here's the code [CODE] $delete_temp_query=("DELETE FROM temporary where contactemail='".$emailcheck."'"); $delete_temp=($delete_temp_query) or die(mysql_error()); [/CODE] The value of $emailcheck is [CODE] … |
| | Hi, Actually I don't know if my question belongs in this topic or in the VB.net topic. But I'm making a VB.net application with a mysql database and i have to make a trigger but I don't know where I have to use or implement it in my application. I … |
| | Hi All Please can somebody help me. I am trying to output more than 1 row of data querying a table called tblbanners. The normal while loop isnt outputting more than 1 row. it seems to be just printing only 1 row. not too sure why? would be greatfull if … |
| | I'm trying to make a Menu manager in PHP + SQL. My goal is to save every menu item and where it should link to in a seperate row. Every row has an internal identifier column called 'menu_id'. I also want to add a function to be able to add … |
| | I have a table in which I want to retrieve the table as follow. Login Name Parent User Email ID Mobile No abc abc_parent [email]abc@abc.com[/email] 9999999999 MySql Table as follow in tbl_users user_id parent_user loginname email mobile 321 123 abc_parent [email]abc@abc.com[/email] 9999999999 231 456 abc [email]123@123.com[/email] 8888888888 I am having … |
| | I have more than 420,000 rows articles in my table. I just want to query a data which is has only one row, but it takes too long.. any suggestion? database : mysql, Storage engine : MyISAM mysql_query("SELECT id, title, ... ,postdate FROM table_name WHERE id = 1 the result … |
| | Hi I'm new to GWT and I am learning using the GWT plugin for eclispe and also have smartGWT. I have found afew tutorials online which have been very helpful but havent found one that explains how I can connect, send, recieve and display database information in the different widgets. …  |
| | I want to insert data from the textBox to MySQL Database. Here is the code snipped that I have created. [CODE]private void button6_Click(object sender, EventArgs e) { string connectionSQL = "server=localhost;database=db_junisman_kulit;uid=root;password=;"; MySqlConnection conn = new MySqlConnection(); double no_simpan = 0; try { conn.Open(); MySqlCommand cmd = new MySqlCommand("INSERT INTO tb_backorder …  |
| | I'm adding an extension to my Wiki - or, at least trying to. I'll reiterate, I'm using Mediawiki. For the most part I can figure things out on my own but I've rarely used MySQL other than making databases for CMS and forums. I've completely new to creating tables and … |
| | Hi.... I have a list of students with their id, name, branch_name, grade, gender. So how can I find the rank of a student in a particular branch by using grade with nested select statements? So anyone please post the script to this here.........  |
| | Hi....... While I create a outfile as in format of csv... I am using the command select * from table_name into outfile 'result.csv'; I am getting all properties(field) of a record into one shell in excel.. Is there anyway I can get each property in different shells... Any answer could … |
| | Hi guys, Im getting duplicate records with a select statement. Below is an assignment question that I have to write a query for: 'Write a query that lists only those computers that belong to a department where the department's city is the same as the city that supplied the computer.' … |
| | Hi I'm not sure wher I am going wrong. I've borrowed some code and tweaked it. The database table consists of id,dates,day,type,. The form brings up the mutiple enteries to edit, but when the submit is pushed it refreshes with the original information. i've checked the databse and that remains …  |
| | I work for an instrumentation company as an in-house software developer. We are thinking of restructuring our database that we use to record data. I am wondering what would be more efficient. Basically theres an array of sensor values Starting at Data0 and ending with data appended with the sensor … |
| | Hi! I'm new here, I have been stuck on this for about to weeks. I am trying to replicate something like the [URL="http://humblebundle.com/"]humble bundle's[/URL] website, where they give you a url like [url]http://humblebundle.com/?key=hj2qg4j2h34234[/url] and you can access the page. I have tried for about 2 weeks but can't figure it … |
| | I am making an admin product form where my client can insert product title, description and thumbnail into the mysql database table which displays on my product page. They want to be able to add products on their own so I need to be able to let them to do … |
| | I have a mySQL that is continuously being added to and I need to make an AJAX function that checks the database periodically and only returns the results that it hasn't seen before. |
| | Hello Gurus, I have a table that holds one date field and one time field. The formats are 2011-12-01 and the time field format is 22:55:01 I want to compare a string "2011-12-01 22:58:00" to the date and time field of the table, without having to take the string apart. … |
| | hello .. m trying to get/fetch the database value into dropdown box as a selected value in the dropdown box using PHP script and mysql - phpmyadmin database .. but m having problems in it .. here is my script which i m using .. try.php <body> <?php $conn = … |
| | please some one help me,i have created this code for searching from database but the problem is i am getting an output without even searching,i am no php expert,so please guys help me. [ICODE]<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>" onSubmit="return validateThis(this)"> <!-- Sending Search Keyword to "search_handler.php" --> <p> <label … |
| | Hi, I can't figure out how to write this query, I'm sure it's something silly, but I just can't figure it out!! I have a table with student's grades in different classes they took, example- studId, classId, yearClassTaken, grade 1, 11, 2008, 90 1, 12, 2008, 78 [B]1, 13, 2007, … |
| | Hi, I am receiving the following error when i run my code on localhost: [CODE] Error creating database: Can't create database 'library_db'; database exists Warning: mysql_query() [function.mysql-query]: Access denied for user ''@'localhost' (using password: NO) in C:\Program Files\EasyPHP-5.3.6.0\www\databaseEx.php on line 45 Warning: mysql_query() [function.mysql-query]: A link to the server could … |
| | I have 10 tuples in my table.And now I create another field of serial number.For all tuples, the field of serial number contain null values. So, is there any way to numbering all the tuples from 1 to 10 at once. Any answer could be appreciated...... |
The End.