76 Topics

Member Avatar for
Member Avatar for k_manimuthu

Hi All, I have a sql query i am trying to get the count of how rows it returned. select a.field1, b.field2, c.field2 from table1 as a, table2 as b, table2 as c where a.field1=b.field1 Considered the above query return 9 rows. I want to get count of '9' in …

Member Avatar for k_manimuthu
0
286
Member Avatar for socialmd

This is the report.php view [CODE] if(isset($_POST["addReport"])) { $report = new Report(); $report->employee_id = $_POST["employee_id"]; $report->date = $_POST["date"]; $report->job_id = $_POST["job_id"]; $report->description = $_POST["description"]; $report->attachment = file_get_contents($_FILES['attachment']['tmp_name']); for($i = 0; $i < count($_POST['date_range']); $i++) { $report->request_date[$i] = $_POST["request_date"]; } for($i = 0; $i < count($_POST['date_range']); $i++) { $report->quantity[$i] = $_POST["quantity"]; …

Member Avatar for Ashvin_1
0
5K
Member Avatar for Yorkiebar14

Hello, I'm having a problem with my MySQL InnoDB table, only one of five. Every now and then a row or two will go missing completely with no trace of it being there in the first place. I have a website which takes HTTP requests from my desktop side client …

Member Avatar for hericles
0
689
Member Avatar for abaddon2031

I have a python script that reads a csv file and converts it to two new files so that my database can add new emails or update existing ones. What im trying to do now is after it has converted them for it to send me a email with how …

Member Avatar for abaddon2031
0
387
Member Avatar for jaejoong

Hi, Hi I only want to select 5 rows. Can you please tell me how to do it in sql? Thank you. example: ratee rater apple banana apple orange apple peach apple sunkist apple mango apple grapes grapes orange I want to see random selected of 5 ratee orange with …

Member Avatar for riahc3
0
385
Member Avatar for RainaAnja

how to order rows in pl/sql? i have a table of numbers, i want to order in ascending order if id of table is odd and descending if id is even

Member Avatar for Alberto Bucur
0
312
Member Avatar for anku83

I have this code which finds the duplicate rows .I want to check if the top row has weight greater than given minimum support..If true then generate its subsets. If row 1 i.e 11110011 wight>min_sup then generate subsets....if not then jump to next row here 1 represents presence of items …

Member Avatar for anku83
0
296
Member Avatar for Thasarath

I need to add Column1 + Column2 And Display Result In Column3 But I need to do it for all rows in column3 automatically. I need a very short code. Thankyou.

Member Avatar for Thasarath
0
236
Member Avatar for sciwizeh

Ok, so I'm working on a web-project, I connected a custom hanlder to the root Logger in `contextInitialized()` of a ServletContextListener: @Override public void contextInitialized(ServletContextEvent sce) { Logger def = Logger.getLogger(""); Handler hand = new DatabaseLoggingHandler(); hand.setLevel(Level.WARNING); def.addHandler(hand); } which looks like: import java.io.PrintWriter; import java.io.StringWriter; import java.util.logging.LogRecord; import java.util.logging.Logger; …

0
248
Member Avatar for iv_jo

I need to get the name of the table with the biggest number of rows, I can find the biggest number of rows with function count and than function max, but i don't know how to see from which table is that maximum, can anyone help? tnx

Member Avatar for Tpojka
0
273
Member Avatar for kyleo92

I'm creating a table with PHP/MySql to enter local election results from my newspaper, I'm not a professional developer, more of just a hobbiest hack (who hasn't worked with PHP for a few years either), so feel free to correct existing code if you so please. What I want to …

Member Avatar for diafol
0
333
Member Avatar for joshl_1995

Hello Community, I was wondering if there is a way to limit users on how many database entries they can insert then once they have reached 100 (Max entried) entries it will delete old entries. So if the user has reached 100 entried and they try to insert another entry …

Member Avatar for joshl_1995
0
378
Member Avatar for MWEB

Hello everyone :) I have this lines of codes and i get : > Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\xampp22\htdocs\folder\index.php on line 52 ( 19 in the code below ) <form method="POST" action="index.php"> CODE : <input type="text" placeholder="Type the code" name="searchfor" /> <input type="submit" …

Member Avatar for Jan_2
0
916
Member Avatar for krunal1986

Hi All, i have requirement like to Convert rows to columns in SQL server. i have retrieved data like below: MatchId SelectionName Odds 322 Home Win 1.33 322 Draw 5.00 322 Away Win 9.00 322 Under 2.5 2.40 322 Over 2.5 1.53 and want to convert like below: MatchId Home …

Member Avatar for urtrivedi
0
350
Member Avatar for garyjohnson

I know there are other post conserning this but they dont seem to help me. When I run the varaible `$results` through the function `Mysql_num_rows()` it returns as an error saying its not a valid result. Also same for the `mysql_fetch_array()`. function results(){ if ($_POST['search'] != "") { $search = …

Member Avatar for garyjohnson
0
206
Member Avatar for utchia

im trying to get the user to enter information into a textbox and then after clicking submit button the page has a table containing with that information in the rows. so for example the table has the heading Artist, Songs, Year made, Gene and the user has to enter data …

Member Avatar for AARTI SHRIVAS
0
270
Member Avatar for opel123

hi :) is there a possible way where in we can combine two rows for an example i have this code: #include <iostream> #include <fstream> #include <string> using namespace std; int main() { ofstream outfile; outfile.open("1stRow.txt"); for(int i=1;i<10;i++) outfile<<i<<endl; outfile.close(); ofstream outfile2; outfile2.open("2ndRow.txt"); for(int j=2;j<11;j++) outfile2<<j<<endl; outfile2.close(); //return 0; } …

Member Avatar for opel123
0
233
Member Avatar for jonsan32

Is there any way to get this to work in Internet Explorer? It shows/hides multiple rows in every other browser, but will only show one class's row in IE. Any help would be great. Here's the code. Thanks! <style type="text/css"> li.merk { list-style:none; display: block; width: 925px; padding:8px; margin-top:-20px; } …

Member Avatar for Airshow
0
704
Member Avatar for jonsan32

Trying to display events on my website based on what my clients want to view. I have 3 checkboxes setup to toggle the connected events, but I can't seem to make the onclick handle more than 1 event at a time. Basically, I want to know 1) how to display …

Member Avatar for jonsan32
0
3K
Member Avatar for jonsan32

I had a jquery-based code that messed up the slider on my page @ http://formidablehoops.blogspot.com Is there a way to have those two co-exist, or is there a way to toggle my calendar at the bottom with javascript instead? I've removed the code for now, but I think it's a …

Member Avatar for jonsan32
0
262
Member Avatar for satti

i have a view named vw_admissionform with columns familycode,Regno,studentname,class for admission form . now if i want to print a student admission form by enetring registration no "regno" in txt1.text then his siblings should also be mentioned on the admission form as requirment by client. for this am using familycode …

Member Avatar for satti
0
323
Member Avatar for pipelian

Hi, i have been trying to combine data from 2 different sources, to make unique rows: here it is my situation Data in DGV already in dgv, Unbound: column1 | Qty "Sugar", 100 "Salt", 100 "Color", 200 "Malto", 150 Data in datatable: column1 | Qty "Sugar", 80 "Salt", 60 "Apio", …

0
137
Member Avatar for ahteck

Hello there, I really need help ASAP. A user has two students(maybe more) where he need to complete marking the score sheet for the students. So, I have a score sheet where the user will insert their id in the textbox and then it will display the first studentName, studentID, …

Member Avatar for AleMonteiro
0
2K
Member Avatar for hlamster

I have the show/hide table rows function working great now (thank you), but I am having a problem with using the back button. If someone has yes to one of the items (yes/no radio buttons) the onClick event in the input tag causes the appropriate info to display. BUT when …

Member Avatar for AleMonteiro
0
441
Member Avatar for sundog1

Hi Guys, I have a form with a DGV and some text boxes.. I am trying to get the program to update the rows shown on the DGV by using the values in the text boxes. Below is my code so far: private void btnOrderEdit_Click(object sender, EventArgs e) { System.Data.OleDb.OleDbCommandBuilder …

Member Avatar for Mike Askew
0
217
Member Avatar for ckarlss0n

Hello everyone. I need some help with a SELECT FROM WHERE query. Let's say I have a row named A and another row named B, and I want to select the eventual cases where values from these two rows, somewhere, match eachother. In this case, you can see, that the …

Member Avatar for diafol
0
230
Member Avatar for ckarlss0n

Hello! This is my first post here, hehe. Seems to be a great site. Anyways, I'm quite new in PHP, but it's fun and I think I'm learning quite fast :) There's appeared a problem for me now though, and I can't see what the problem is...? I have made …

Member Avatar for Atli
0
225
Member Avatar for minuteman263

I have been googling this and have read close variations of the following issue from others. It seems that if you are running MS office 2010 Excel and go to delete a group of rows, sometimes below where you are working a blank row will appear at maxamim height size …

0
143
Member Avatar for Sadia fatima

Is it possible to reuse an identity field value after deleting rows in SQL Server 2005? Here is an example. Suppose I have a table with an Id field as a primary key (identity). If I add five rows, I will have these 5 Ids: 1, 2, 3, 4, 5. …

Member Avatar for cutepinkbunnies
0
750
Member Avatar for joehms22

Question: Does anyone have any recommendations that are likely to keep a large database healthy/speedy? I'm designing a database that is going to retrieve around thirty million data points a year, up to around three hundred million to a billion in a few years time when all of the sensors …

Member Avatar for Szabi Zsoldos
0
215

The End.