How to create a comment view in Drupal?

Submitted by ravisagar on Wed, 07/28/2010 - 04:18

Today we will share how to create a simple block view to display the comments. Though Drupal offers a predefined block for comments but at many times you may need to create your own block with custom fields and filters.

To create a comment views
1.First you need to create a View with all the fields of comment as preferred.

2.The main concepts comes into the filter portion, you can add a filter of comment body

3.Then when you click on add option it shows (is equal to) and a text box that should be done is (not equal to) > empty body(empty text box)... launches on 23rd July 2010

Submitted by ravisagar on Fri, 07/23/2010 - 05:21

Timerays another project of Sparxsys Solutions has been made LIVE !!


Project Description
This website is basically made for writing articles. In this three types of articles have been shown. These are basically Article Categories. All the articles on the site are divided into one of these three Categories.


The site is broadly divided into these three sections.

Just like any other Drupal site this site is also very user friendly, author can easily make there accounts and post there articles. our new project

Submitted by ravisagar on Thu, 07/22/2010 - 08:17

Very Soon Sparxsys solutions is going to launch another major project.Which is a combination of various functionality this project has been designed with a very hard work and great concepts.
It will be soon available on the base of the website has been kept as a newspaper website its going to have a good articles and you can easily search out for the new articles or old articles easily.It has been developed specially for users so grt user friendly website..
So hope you will check this website out!!

Submitted by ravisagar on Mon, 05/24/2010 - 13:06

We Have some good projects among them NIRMAANAM is one of them.This project is based on interior designing concept .Our company worked hard giving all the quality from content to images.
it have many great modules used of drupal..

We are coming up with more projects like this soon..
Make it live soon..
Check out --

Table view with rows/columns switched

Submitted by ravisagar on Wed, 12/02/2009 - 09:07

These days I am working on my other site to build the database of all the colleges affiliated to GGSIPU. I created a Custom Content Type to have various fields like college address, phone, fax, email, rating, etc. During the counselling time the students wants to compare various colleges based on various parameters like infrastructure, campus and other things. Now I wanted to create a view where a table is shown with the names of the colleges in the header and these parameters on rows.

This views snippet allows you to render a tableview with columns and rows switched. Suppose you have the following output:

Title | Price 1 | Price 2
Node #1 | $10 | $20
Node #2 | $15 | $25

but what you really want is the node titles displayed in the header, and the prices as the rows:

| Node #1 | Node #2
Price 1 | $10 | $15
Price 2 | $20 | $25

I created a view table, but obviously it showed the college names in the rows as it is the dynamic part. I searched around a lot on drupal and google and found this amazing piece of code that transpose the rows/columns.

You just need to replace YOURTHEME with the name of the theme and VIEWNAME with the view name and that's it!

Blank admin page in Drupal 6

Submitted by ravisagar on Sat, 11/28/2009 - 08:05

I installed Drupal 6 today on my windows machine in office. After creating the first user I tried to access the Administration Page, but a blank page was returned. I searched google to fix this problem and got this link.

Go to system table and change the value of 'status', 'bootstrap' and 'throttle' to 0

Enable Dreamhost Stats on Drupal website

Submitted by ravisagar on Sat, 11/28/2009 - 08:03

If you are hosting your Drupal website on Dreamhost then you may not be aware that Dreamhost provides a nice stats feature for all the domains.

It is normally accessible at but the problem is that with Drupal's clean_url enabled you will get "Page not found" error.

Their is an easy resolution for this. Just add the following three lines on top of your .htaccess file.

RewriteCond %{REQUEST_URI} ^/stats/(.*)$ [OR]
RewriteCond %{REQUEST_URI} ^/failed_auth.html$
RewriteRule ^.*$ - [L]

Why I love Drupal?

Submitted by ravisagar on Sat, 11/28/2009 - 08:01

Creating my own Database Driven Dynamic website was a dream for me, yeah I know it is not that difficult, but when you want a Blog, a Powerful CMS, User Registration, Email, Forums, Comments, Access Restriction based on User Roles and bla bla bla other cool things in your website then it get little tough. The very though of making a website with all these features used to Haunt me. I think I am a good Programmer but I am a Lazy person. I do not like do same things again and again.