7,494 Archived Topics
Remove Filter  | |
| | Hello, I have a problem with update in MySql database. In a university system a student apply for what is called a petition then the admin signs it and adds a note. When the admin signs for the first time and enters his note it works. But when the student … Databases mysql |
| | In the below query,the "Account has been successfully approved" message dispayed. But in the database still approved_status remains '0'. [CODE] <?php $connect=mysql_connect('localhost','root',''); mysql_select_db('bank',$connect); if(isset($_POST['account_number'])) $account_number=$_POST['account_number']; else $account_number=''; $query = "UPDATE account_details SET approved_status='1' WHERE account_number='$account_number'"; $result= mysql_query($query) or die(mysql_error()); if ($result) { echo "Account has been successfully approved"; } ?> … Databases mysql |
| | Hi, I am creating a database for a car hiring service and would like to produce reports. I know these are simple to create in MS Access but i dont have the fainest idea if these are at all possible in MySQL. I have created tables and queries to which … Databases mysql |
| | 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 … Databases mysql |
| | 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. … Databases mysql |
| | 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 … Databases mysql |
| | 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. … |
| | I'm still pretty new to this and I need some help. Here's the situation. First the user opens a form to select which database (one of 3) they are working in. Then they will be using several forms. The same set of forms are always used no matter which database … Databases microsoft-access |
| | 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 … Databases mysql |
| | 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 … Databases mysql  |
| | Hi, I have a select statement and I need to find a way to apply a filter to it: [CODE] select * from my_table where my_table.field_1 like :filter_item [/CODE] The real problem is that filter_item can be a string, a string that includes '%' or a comma-separated string that can … Databases oracle |
| | Hi Guys, How do i obtain the nearest shipdate prior to Returndate. here is my sample script. thanks. kindly check my script. the result should be 2011-02-23 [CODE] Table1 ESN--DateReturn 123--2011-03-08 TABLE2 ESN---ShipDate 123---2010-09-28 123---2011-02-23 Select a.DateReturn max(b.shipdate) from Table1 as a left outer join table2 as b on a.esn=b.esn … Databases mssql |
| | Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at … Databases client-server microsoft-access sql  |
| | 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 | … Databases mysql |
| | The command FileSearch does not excits in ACCESS 2007, my code is as follow: How do I import this filein a different code? Public Sub Import_Labolink() Dim sourcefile, destinationfile, miscresults As String Dim i, N, m, o As Integer 'Dim mFileSearch As New myFileSearch ' New code for filesearch N … Databases microsoft-access |
| | 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, … Databases mysql |
| | 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, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at … Databases client-server microsoft-access mssql sql |
 | 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 … Databases mysql |
 | Hello Everyone, I know this is going to be easy to all of you, this is my first time performing an if else statement in SQL, after performing this query: Collapse | Copy Code IIf(IsNull(EventSummary.[Event Information - Event Status]),"ACTIVE",EventSummary.[Event Information - Event Status]) AS [Event Status], I get this error … Databases mssql |
| | I am using SQL Server 2008. I have data from SQL like this. [CODE] ID ID2 PartNo -- ---- ---- 75 23921 DENT 75 26145 PLGD 75 26145 PRRP 75 26145 SIST 75 57290 PRMD 75 57290 abc 75 57290 def 75 57290 ghi 75 57290 jkl [/CODE] I need …  |
| | 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 …  |
| | I am using SQL Server 2005. I have a data from SQL like this. ID ID2 PartNo 75 23921 DENT 75 26145 PLGD 75 26145 PRRP 75 26145 SIST 75 57290 PRMD 75 57290 abc 75 57290 def 75 57290 ghi 75 57290 jkl I need an output like this. … Databases client-server mssql sql |
| | 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 have [B]Windows 7 Home Premium SP-1, 64-bit[/B] version on my PC. I want to install SQL Server either 2oo5 or 2008. but i am unable to install this. Error: [I]OS Incompatibility[/I] Pls Reply: Thank U Databases mssql sql windows-server  |
| | 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....... 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 … Databases mysql |
| | 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.' … Databases mysql |
| | Hello guys. I have a problem to check datetime overlapping in oracle database. I have this kind of data in my table in oracle. [B]START_DATE[/B] 2011-01-01 08:00:00 [B]END_DATE[/B] 2011-01-01 16:30:00 Given datetime from user is something like this : ---------------------------------------------------------- StartDate = 2011-01-01 07:30:00 EndDate = 2011-01-01 16:20:00 [B]OR[/B] StartDate … Databases oracle |
| | 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 … Databases mysql |
| | SELECT * INTO NewTable FROM existingdb.dbo.existingtable; I am executing this query but it is showing me the error as undeclared variable:Quanti (as quanti is my NewTable) Databases mssql |
 | Hi guys, i have got a client who wants to make an online food guiter / counter. I have got the book Calorie King with 17,000 foods but i don't want to type out the data. Is there someone who has the Australian food in a excel, access or mysql … Databases |
| | hi dear i i have two columns in an access table, first column is of percentage and second is of result . i want that result should be automatically calculated as if the percentage is les than 33 then ruselt fail and if percentage is greater than 33 then result … Databases microsoft-access  |
| | hi i have to search based on opening and closing times of shops. e.g. opening time of one is from 9 am to 11 pm another can be 5 am to nextday 2 am. e.g of sample data below [CODE] ShopID open time close time shop1 10am 11pm shop2 6am … Databases mssql |
| | 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. … Databases mysql |
| | Hi, I have a sql view below: [CODE] SELECT b.Stk AS secode, b.TktE AS Ticket, CAST(a.Last / 10 AS integer(10, 3)) AS Last, CASE WHEN CONVERT(integer, a.Last) <> 0 THEN (CONVERT(integer, a.Last) - CONVERT(integer, a.Ref)) / 10 ELSE (CONVERT(integer, a.Ref) - CONVERT(integer, a.Prev)) / 10 END AS Change, CAST(a.High / … |
| | Guys, Please take a look my script. my object here is to get the most recent date from table 2. what if the recent date from table 2 is less than the date from table 1? [CODE] Table1 Type-Date1 -------- 1-2011-07-16 2-2011-07-16 3-2011-07-10 4-2011-07-10 Table2 Type-Date2 -------- 1-2011-07-06 2-2011-07-07 3-2011-07-01 … Databases mssql |
 | |
| | 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, … Databases mysql |
| | 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...... Databases mysql  |
| | Hey, I have some background with db creation and have done lot's of work creating and programming with RDBs. I am currently working on a huge website and I am curious about cost/benifits of using a json array vs a relational table. My gut says I should be using a … Databases json |
| | Hi I would like to know how to create a MySQL statement with Count(*) and natural join. I have a table named iphead and another table named even. iphead has a number of IP addresses and I would like to count the total number using count(*). Next, the even table … Databases mysql |
| | Good Day Everyone.. i have two tables..how to read from one table1 to table2.. example.. Table1 with thousand over records various types of recurrance and due pattern. where ID = History_ID Table 1 ID Reccurance Duepattern 1 Monthly 10 2 Yearly 25 3 Monthly 15 4 Weekly 5 yearly 14 … Databases mssql |
| | |
| | Hi guys, Need you inputs on my query. I have an excel file which we have to upload weekly. They want me to make an application using SSRS (MS SQL) . To read the excel file from a certain folder And then make some data entry to inputs like date … Databases mssql |
| | here's the deal. I want to import data from xls file.at the moment I'm using phpMyAdmin's Import option to do it, but I'm wondering if there's another way to import the file to a new table in my db because- -the first rows and cols in the file are empty, … Databases file-system mysql |
| | Hi, am stuck on some question from : [url]http://sqlzoo.net/3.htm[/url] can anyone please help me to get the answer of section 4a,b,c,d and e. please Databases mysql |
 | Hi all, I am getting an error in my application that reads: Incorrect syntax near the keyword 'set' It only occurs in a database at a particular venue and only when the offending query/queries are run locally. I have restored the database on my PC and the queries run without … |
| | <input type="button" name="b2" value="Delete" onClick="<? $delQuery = 'DELETE FROM artist_schedule WHERE artist_schedule_id=.$artistID'; $result=mssql_query($delQuery,$con); ?>"/> ------------------------------------------------------------ when i echo $artistID i get the value. how do i delete using a javascript button onClick ?? if using function also then how do i implement the function ? Databases mysql |
The End.