[count] Forum Topics

[CODE] SELECT count(*) FROM information_schema.`COLUMNS` C WHERE table_name = 'your_table_name' AND TABLE_SCHEMA = "your_db_name" [/CODE] TABLE_SCHEMA is required only if table name exists in more than one db

This is **Python** language. Hello, I'm trying to make a program where the user enters his/her initials followed by a block of text. After that, the program will print out the number of times his/her initials showed up in the block of text. For example, if my initials are VKL, …

1) onkeyup send textarea values to script 2) converts textarea value to array 3) loops thru the array 4) uses regex to check if its an email address 5) changes inner html of recipient div

Hi all, I want to share one link to tumblr and also i want to calculte the number of views, likes, posts, shares, followers. How i need to get this all give me any reference or possible ways tel to me.

Hi I'm a newbie in SQL and for scores whose credit is greater than 2, I want to select students with scores of 10 or more .Here is what I wrote and Im having errors(See table below): SELECT Student,COUNT(Score)>=10 AS NumPasses WHERE Credit>2 GROUP BY Student Student Credit Score Tomy …

Hi all... gud evening.......... I want to share one link to tumblr page. How to do? And also i want to calculte the number of likes counts, share counts, post counts, follow counts.. Kindly send me examples or any reference website. Thank you.

What is the step count for this in terms of n ? SequentialSearch(a,x,n) { i=n; a [0]=x; while(a [i]!= x) do i = i-1 return i }

Okay so I have couple of questions about lists in vb.. Please be aware that it's all related to integers only no strings or others 1. How to sum values of a list? 2. How to sort values of list from highest to lowest? Also how would I display list …

I have a CTE based query, to which I pass about 2600 4-tuple latitude/longitude values using joins - these latitude longitude 4-tuples have been ID tagged and held in a second table called coordinates. These top left and bottom right latitude / longitude values are passed into the CTE in …

Hello, What is the best way to count the number of swaps required to sort an array that is sorted using the Quicksort algorithm? I put a counter in what I believe is in the correct position and the tests that I have run seem to be correct however Quicksort …

how can we count the number of products in nested level of sub categories and can show them with the parent category. Please help.

Hello, What is the best way to check my code? I have written a program that counts the swaps required to sort an integer array using the Bubble, Selection, Insertion and Quick sort methods. How can I be absolutely certain that my swap counts are correct? Will someone take a …

Hi i am developing a web site to download softwares.I want to get total no of downloads of softwares.hOw can i get actual values of downlod?? Protected Sub ImageButton1_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton1.Click Response.Redirect("../Mysoftwares/" & dset.Tables(0).Rows(0).Item(1).ToString() & ".exe") End Sub 'code to redirect at softwares …

I realized something just now. A few months ago. I post a question regarding about stats and I think **Dani** mention she has no intention of doing this at all. Even the Gravatar was done within a few minutes last night. What is the benefit of having this now? For …

Problem : String : Hello World Output : H occured 1 times e occured 1 times l occured 3 times o occured 2 times W occured 1 times r occured 1 times d occured 1 times How to do it in Javascript...

package display; import java.io.File; class display { int file=0, directory=0; void list(String path) { File root = new File(path); File[] f1 = root.listFiles(); for (File S : f1) //error { if(S.isDirectory()) { list(S.getAbsolutePath());//error directory++; } else if(S.isFile()) { file++; } } } } package display; public class displaymain { public …

Hi, I have a working program and I need to answer the following questions: 1:where was polymorphism was used in this application? 2:identify where overriding or overloading was used in this application? I belive overriding is used by the Runnable method to override the run() method. Would that be a …

**Program using the *StringBuilder* class that will accept string from user and will count the numbers of vowels in it.** Drag and Drop: 1. A Button 2. A Textbox 3. A Label Public Class Stringbuilder Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim mystring As …

This Python code allows you to get selected statistics of a story text. It will count lines, sentences, words, list words and characters by frequency, and give the average word length. It should be easy to add more statistics using the dictionaries created.

Query to make movement of a record I have this tables User Description Item UID Name DeID Dgroup ID DeID Name 1 Jose 1 Printer 1 1 Stylus 2 James 2 Monitor 2 1 Epson 3 2 Viewsonic Transaction Details Ttype IID UserName NewUser Release 1 Jose Release 2 Jose …

>Hi guys,..i've two arrray data1 and data2 then i do intersect to get same value between data1 and data2, and >use count to get total same value,..how to ARSORT count result from intersect array multidimensional? <?php $data1 = array( array( '7' => 'chelsea everton', '8' => 'everton villa', '9' => …

Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Styl T10 1 1 Repair 1 2 Monitor 2 MPS 1 2 Repair 3 3 ImpSonic 2 I need to count how many printers, Monitors etc. are …

Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are …

Hello again! Now i stucked with another little problem. I have a table: ID____Name______Age_______City 1_____Robert_____20_______London 2_____Fabio______31_______Rome 3_____Hans______35_______Berlin 5_____Josh_______25_______London Now i don't know how to get a city which has the most population in this table. With my code: SELECT City, COUNT(Name) AS Population_number FROM Person GROUP BY City; I get …

Hi, I have 3 tables Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are in Item and …

Hi there, I just wanted to ask how I would go about writing a single function to count the frequency of numbers 0-10 including .5(such as 1.5,2.5) This is what I have done file = open ('grade.txt', 'r') s=file.readline() grade=[] while s[0:3]!="EOF": s=s.replace(' ','') lst=s.split(',') if lst[0][0]!='I': grade.append(float(lst[5])) print(lst) s=file.readline() …

Can anyone assist me. I keep getting and error stating that the Column count doesnt match row 1. I have counted all of my fields and referenced all of them but still no dice. $con=mysql_connect($host, $username, $pass); if(!$con) { die("Could Not Connect: ".mysql_error()); } mysql_select_db($db); $CustLName=$_POST['CustLName']; $CustFName=$_POST['CustFName']; $CBR=$_POST['CBR']; $AcctNum=$_POST['AcctNum']; $CustCode=$_POST['CustCode']; …

Now that MITx first test is over, I got feeling that this one task requested for generate and test solution is begging also for less efficient recursive solution as it is so simple. Here it is! Single liner aproved by the released grader! If you wander if you are able …

Hello I want to count online users in my website. The way which I found in most of the websites is that to insert a new row in a table containing user's IP and visit time and consider an idle time for example 3 minutes and in each visit delete …

i want to query my database using php count to count the number of values in a table then count which value appears more times than the others. Im new to this kind of thing.