Hi all, I have a list of domains and would like to get the: PageRank for all the domains. So just an integer, there must be an API that returns this. The number of results in Google The position of the word of the domainname. For example, "google.com" would be the position of the word "google". This could be position 20. Hopefully t...
Good evening all, I've been working on an MD5 tool in C# that takes a file, goes through my Hasher class and pops the result in a database, along with the filename and directory. The issue I'm having is that each time I run the test, the MD5 result for the same identical file i.e. unchanged in any way is completely different. Below is...
Hey Guys I have to answer the following question "For each year in the database, list the year and the total number of movies that were released in that year, showing these totals in decreasing order. That is, the year(s) with the largest number of movies appear first. If some years have the same number of movies, show these in increasi...
I'm using my own class for database queries, extending mysqli: class iDatabase extends mysqli { public $errorMsg; private $totalQueries; private $stmt; public function __construct() { parent::__construct( 'localhost', 'asd', 'asd', 'asd' ); if ( mysqli_connect_errno() ) { $this->errorMsg = 'Could not connect to server.<...
I have a table programparticipants, I am currently successfully querying the IDs where count(name) > 1. What I need now is to query the names that belong to those IDs where count(name) > 1. Can anyone help me please? Example, data result currently being returned: ID count(name) 1 2 3 4 4 ...
Inherited problem... the site works fine in 6 other languages, in fact the Russian area is now working fine and the request quote form work (functionally), with one problem, the email results we get is loaded with very weird letters: (here they are copied) ôâàïôâàïôâàï ïôâàïôâàïôâàï ôâàïôâûàïôêàï ôêûâï ïôâàïûâàï I have tried to encode...
I want to build site with a search form on LEFT and RESULTS in content(center) part. I know how to create modules .. but how do I assign their location ? OR should I place SEARCH FORM as BLOCK and assign them to LEFT in build/block/. SEARCH FORM has 3 textboxes, non of them is required. "name","surname","age" whatever user type in I'...
I have a two tables for ex: cities - id_city, city_name properties - id_property, id_city, property_name I want to display cities.city_name and next to it [properties.count(id_city)] How do I make a query that still return ZERO if no records founds istead on NULL so I get results like London [123] New York [0] Berlin [11] and NEW...
Hi folks, I have indexed a website which is available in 14 languages, so far so good. Now I want to limit my lucene search to display only results in the visitor's language. Is there any (query)parameter or any option that I can set? Unfortunately I did not find anything. I am working with Zend_Search_Lucene if this should be relev...
Hi all, I have 2 unrelated questions. I need to do a grouping of data using XSLT. I need this to function like how a nested IF within an IF would function. After which, I need to group the data so that I can split it into multiple files according to the Group condition. Using XSLT Version 1.0 : Q1) How do you nest a key() within anoth...
I have a for-each and when there is nothing output by it I would like to display some default text. If I have... <xsl:for-each select='xpath'> Some content for each matching element result. </xsl:for-each> What I would like is: <xsl:for-each select='xpath'> <xsl:output-this-when-there-is-content> Some content for each matching el...
I have been working on a cURL script and I am finally done, yay! Basically, right now, I am grabbing the error / success message and storing it, but how should I store it? Should I store it in a .txt file or MySQL. What is a efficient/common practice? EDIT: I already have a MySQL database. I do not mind taking a little more time. After...
I would like to join results returned in the set in MySQL with a comma as a separator string. For example, set returned contains: COLUMN_X john jerry maria joseph gugla I would like to receive the result as: COLUMN_X-concat john,jerry,maria,joseph,gugla is that possible? thanks. SELECT CONCAT(rooms.ID,",") FROM rooms AS rooms LEF...
Hi, I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wilcard search of whatever the user enters in the TextBox, and displays the records in other controls (Text and Combo Boxes). To achieve this, I am using the DoCmd.ApplyFilter method and I wanted to know if there ...
I've read about a few alternatives to MySQL's ORDER BY RAND() function, but most of the alternatives apply only to where on a single random result is needed. Does anyone have any idea how to optimize a query that returns multiple random results, such as this: SELECT u.id, p.photo FROM users u, profiles p WHER...
Honestly, I'm not even sure the best way to go about this, but essentially, I have a function in an include file that takes a $type parameter and then will retrieve/print results from my db based on the $type passed into it... What I'm trying to do is have a series of links on a page that, when you click on a certain link, will run the ...
SELECT col1, col2, dbo.myFunc(@param1, @param2, col1, col2) FROM theTable how do I add a "WHERE" here to the result of the function dbo.myFunc, like WHERE resultOfMyFunc > 10 for example? ...
I want to display search result on the screen, i have implemented in such a way that. From the search form user fill the 'search field' and 'search location' i set values into bean and that bean is static so that i can access it from every where. Then i start search result screen intent using Intent mainIntent = new Intent(SearchVenu...
Hi all, I've got a web application that matches images to tags, and I need to create a way of dynamically refine results for tag search. However, I cannot find a clean way to make that SQL queries, and that's where I need your help. The idea is that if I search for tags "clean" and "dog", I will have image results that have both the ta...
Hi, I'm pretty new to jQuery, php and Databases, but i managed to create a database en retrieve data with php from that database. After a searchterm is filled in, The data (retrieved from the database) will be displayed in the resultpage. For example: when searching for Netherlands you will get a couple of cities as a result. These ci...