JQuery Multi-Select Plug-in
About Jquery Multi-Select Plug-in:
This plug-in is aim at providing a custom multi-select box with custom CSS. It has been tested all of the major browsers: IE-7 & 8, Fire Fox 3.5.x and 3.6, Safari 3.0.x, Google Chorme.
Requirements
It requires Jquery’s version 1.3.2 or later and in the case you want to use the custom scroll bar, it requires JScroll Pane. You can download JQuery from here
How to install:
1. Keep the required files to your desired folder
2. Include the files to your web-page.
3. Set the parameters which you want to change.
4. For using JScroll pane, set the ‘jScrollPane’ parameter like this
jScrollPane : ‘$(”.table_scroll”).jScrollPane({scrollbarWidth: 6, scrollbarMargin:0})’
Note the quotes around the statement. You can change the JScroll pane setting according to your need.
5. To initialize:
$(function(){
$(’#mulit’).multiselect({selContainerID : ’selboxID’ });
});
Give the selector to select the multi-select box and call to the “multiselect” plug-in. Set the parameter and give the id of the container where the selected values would be shown.
That’s it.
Version 1.1.0 Release Date March 12, 2010
A new version of JQuery Multi-Select has been launched. In this release some issues related to the Selected values box have been fixed.
If is2ShowSelected is set to true and selContainerID is not provided, it was throwing error on IE-7 and Google Chrome. So this issue has been fixed.
Download Sample Code and Plug-in Version 1.1.0 here
Download Sample Code and Plug-in here
Thanks
Syed Murtaza Hussain Kazmi
Efficiency in code is good but that must be reasonable.
PHP and Dotnet 1.1 Website and Software Engineer
Causes of delay in achieving the milestones of the projects taken from Freelance websites
After having worked on different freelance websites and in different companies; I found some issues which become hurdle in accomplishing the targets of any project:
1: Clients which come on freelance websites do not disclose the complete information about their businesses in the initial requirement phases even someone tried his/her level best to elicit the requirements from them.
2: Clients deliberately or in-deliberately hide the information which becomes on later stages a menace in attaining the milestones.
3: Immature processes of the workers or companies who work on freelance websites also become the cause of delay in delivery of projects on time.
4: Project management issues and Quality assurance team’s overlooking about errors and bugs in the program, is also another reason of failure.
5: Absence of HCI and lack of ergonomics rules make it difficult for a developer to focus on his/her work and in return delay occurs.
6: Very high demands and expectations from the developers and a pressure of unreal deadlines put a huge pressure on developers which in turn appears as an obstacle in hitting targets.
Human anomalies in doing work and other language related factors must be discussed according to the Software engineering rules and practices before going to start the project.
Real deadlines and mature processes must be implemented in the software houses or in the work place of freelancers.
Thanks
Syed Murtaza Hussain Kazmi
Efficiency in code is good but that must be reasonable.
PHP and Dotnet 1.1 Website and Software Engineer
Discrimination of International Community for Pakistan
Now a days, when each and every country is coming closer to one and other using new technologies and mediums, we are seeing that Pakistan is being neglected by most of the international courtiers in many area of the fields especially in the field of IT. Some of the points are listed below:
1: Most of the internet websites, related to travel, don’t include Pakistan as a destination to be visited.
2: Some international payment merchants do not provide services in Pakistan. An example is: Paypal. Many times workers who are providing services in Pakistan have to interact with such clients who tell that they will send payments via paypal, and it becomes a headache for the service providers to receive payments of their provided services.
3: Urdu which is the language of 6th largest population of the world was being ignored by many international websites including yahoo and hotmail for many years. Now yahoo and hotmail have started some services in Urdu, but still many sites do not contain Urdu in their language boxes. Now, as a 6th largest populous nation in the world, Urdu must be at least on every site which audience and services are not geographically bounded to one country.
4: It is also very strange that on some freelance websites where a large number of Pakistani people are providing services better than other countries, a prejudiced attitude can been seen when these websites write about the emerging and progressing countries, they include India, Romania etc but Pakistan is ignored. While the reality on the ground is, Pakistani service providers are more capable and intelligent and not lesser than any others in their fields. It seems a blatant effort to overlook the services of industrious Pakistani people. Pakistan must be incorporated in the list while tempting clients to select service providers from progressing countries.
The reason which might be behind this ignorance is, current situation prevailing in northern parts of the Pakistan, and one can say that one can not include Pakistan to their travel sites because Pakistan is not a secure country. But if someone has mind on his head, then he can see that that situation have been for few years, before that Pakistan was always a safe place and still it is. So, why was Pakistan ignored at that time? Tourists may come to Pakistan especially Lahore, where they can see many ancient buildings and can find many things which are worthwhile to see. They can go to Kashmir; they can come to see the beauty of vast magnificent deserts, Thal and Cholistan.
Besides the current situation, Pakistani economy is still progressing, Pakistani people are alive and providing services, So Pakistan must be treated in a good manner by the international community.
Thanks
Syed Murtaza Hussain Kazmi
Efficiency in code is good but that must be reasonable.
PHP and Dotnet 1.1 Website and Software Engineer
Review of some Free-lance websites
Review of some Free-lance websites
Attended Audience:
This article is intended for the programmers and buyers which have some plan to work on different free-lance websites for getting work or hiring the free-lancers.
Abstract:
Now a days, getting completed your tasks is not difficult, there are many service providing sites which provide an opportunity for the people to acquire work from around the glob. You have a problem, worried about pocket, no problem, logon to any of the service providing site and sitting in America or anywhere in the world at your laptop you can easily hire a resource at 1/10th of the cost which you will have to pay to your local labor. And the same for the service providers, they can sell their services by sitting at home to the different buyers living any where in the world.
But are the both secure? Are the websites which provide such junctions for the customer-buyer relationships able to build up such environment where the buyer and the customer can have the business smooth and fruitful? Are the attitudes of the service providers registered on such sites professional? Is the behavior of Buyers listed on such websites good or even least satisfactory? And many more queries which can come to someone’s mind; this article is a small effort which will discuss about such questions and their answers and will try to conclude about it at the end.
Discussion and Review:
In this critique, we will see in short the porn and cons of the selected free lance sites. Rentacoder, Elance, GetAFreeLancer.
RentaCoder:
If we google free service providing sites, among the many names you will find a prominent name “Rent A Coder”, the url of the site is “http://www.rentacoder.com”. This is a US based website run by “Ian Ippolito” and the major buyers registered on this site also belong from USA.
This websites allures the buyers to place their projects on it. The buyers are authenticated by a staff member of the website to know about his/her validity. Coders on the website can belong from any where in the world. They are rated by the buyers when they complete their projects.
The major qualities of this site are “Escrow Money System” and “Arbitration process” in the case any dispute occurs between the two parties. Escrow system is used to protect both the buyers and coders from doing fraud. Both parties have the rights to initiate the arbitration process which is based on settling up the contention in an unbiased way and justice way. This site tries to provide such atmosphere where the businesses can run smooth.
Now let’s see, is it what I aforesaid? I had read many of the online articles and came to know that the success situation or ratio is according to me 60: 40 in the case if we see the attitudes and work environment provided by the website. If we look at the coders comments, many of they seem to be crying the misbehavior of the buyers and the staff members of the site especially, and when we see the buyers end, we see them carping over the incomplete jobs and unresponsive coders whom they worked with even they get many successful projects at cheapest price.
As described above that this site has a feature of arbitration. It is good thing to resolve the issues and it must be there. But if we see in depth about this procedure, we come to know that this is a horrible, time consuming and mind stressing practice. Why this, because it has been seen and you will find many evidences on the internet as I found that it is not matter who started the arbitration, 99.9% arbitrations are gone to the favor of the buyers even though the site claims something else. It has also been noticed that the manner of the arbitrators is very rude and insulting especially towards the coders. Whenever any mistake is committed by them, they become a human being but when a little or minor gaffe is committed by the coders, they are not let off. Further more, it has been witnessed that the arbitrators violate the rules and regulation so called written by them on their site in the favor of the buyers. Sometimes dramatically change the arbitration which is going in the favor of coder in the favor of buyers and they give time to respond to the coder when he is sleeping. Moreover the major drawback is that they are used to threat the coders that their account will be blocked even that coder is high ranked and rated.
The second major problem on this site is the lowest priced bids even on 3 to 5$. This site already cut a huge amount of the %age as a commission and other charges from the coder’s amount, which is I think the highest among all the free-lance websites.
The third major problem on this site is the attitude of the buyers, buyers who come on this website take the edge of the arbitration and many times they take the efforts and work of the coders and run away without paying them. The buyers do not choose the person by seeing the ratings and previous records of the programmers but they see the cheapest price and look for some highest quality work. Every person wants cheapest solution but; is it right to exploit the service provider? Definitely it should not be, because he is also human being. In addition, it has been observed that buyers try to force the service providers to work more than what was stated in the initial bid request. Rentacoder people will not protect you any way even they show off that on their website.
Whereas if we talk about the service providers; clients are also not very much happy. On this website, more than one lac service providers are registered but in the comparison of service providers, clients are not in good numbers. They post a project and get many of bids low and high from India, Romania and Russia. And it becomes difficult to choose from. Sometimes they choose wrong service provider which does not complete his/her task and also unresponsive.
I rate 2.25 out of 5 Ratings to this website.
Elance
This website charges the service providers some fee for getting themselves registered on it. A quota of bids to be placed on the open projects is given to every service provider. So that everyone can get his/her share from the Market. Its virtue which I like the most is the attitude of the staff. The staff members are so nice, well mannered, and cooperative but they have not full control over the frauds.
Elance provides two kinds of projects, hourly based and fixed, in the same way it provides you Escrowing system (Does not force the buyer to place money in escrow even the project is marked escrowed.).
Moreover elance system is based upon mutual understanding of both the parties, both parties agreed upon an accord which chalks the procedures and plans in order to complete the project with success.
Elance website is in many cases better than the other websites. Its environment ensures the success ratio of the projects to be high.
Elance’s buyer’s behavior is good and mature in comparison with other websites.
Besides all these virtues, two or three years ago, this site seemed to be very sober and very good place for selling and buying services around the world. But now instead of becoming better, it is also behaving like others. In spite of bid limits imposed on the number of bids a service provider can placed, it has been seen that the trend of other sites has also shaken the walls of this website. The Free posting of projects just to catch the attention of the buyers to submit their works on it has attracted many of such none professional buyers who are spoiling the environment of the website by accepting the bids at lowest costs. They ignore a well written bid and the work of the service provider and reject the bid by saying “Bid is too high or prefer another style”. A person who has paid to get work, he looses all of the bidding chances and money he paid. Also in the reward he gets wastage of time and frustration.
There is no way of marking a project “Completed”, which leaves the projects remain open. Also they cut the payments without seeing that the buyer paid or not.
I rate 3.89 out of 5 Ratings to this website.
GetAFreeLancer:
I am not going to discuss in detail about this website. Getafreelancer as its name suggest is a hub of freelancers, anyone can register and bombard on a single project by posting his/ her bid. The serious pitfall of this is s/he is ready to sell out her/his services for just $30, the lowest limit for placing a bid on GetAfreelancer. This site is a response by Europe against rentacoder which as I sated comprises over a big share of US market. It is run by Sweden based company. Before a month or so, there was no way of handling disputes. The work posted on this website is also substandard. I have personal experience that my project bid was accepted and buyer took from me more than 10 templates and every time he comes up with new details and samples of the projects, at the end he vanished not only from the IM but from mails and buyer canceled the project. I have never seen him online again. He did not even speak any word about the project, just took the work and disappeared.
If you want to earn some petty cash for your house, you can go to this site and place a lowest $30 bid on any project. There is 70-80% chance you will not be selected, why still will not be selected? Yes, because you will find more than 20 bids which will have the same cost i.e., $30 with some ratings on their credit.
It is not always but most of the time, this is. Many coders are earning from this website and they are making money but still I will not suggest this website.
I rate 1.00 out of 5 Ratings to this website.
Conclusion
In my point of view, if I sum up, clients (Not all but most of them) ignore the previous history and track of the provider and just look at the lowest price quoted for their large project. Because the number of service providers is high than the clients, every person wants to get the work and in this running, they quote much low than the work mentioned in the bid. They sell their services for pennies and when they start working on the project they come to know the reality. There might be another reason that many of the coders on this website are not real professionals and most of them are just collecting their pocket moneys by doing the cheapest works. This kind of trend discourages the real clients and they feel unhappy with the work results.
It is also a problem seemed on this website that the details depicted by the clients about their projects are not clear and well written. Because the people living in the developing countries are not the English speaking, they could not grasp the real essence of the project and the project goes to a deep pit and faces the failure. This is also a main drawback.
Communication is an essential element in all over the world. In the failure of outsourced works, communication gaps also play a key role. Because the foremost of the working force lie within the borders of developing countries in Asia, and the large community of clients lie in USA and in west. The time differs which becomes slow and steady a dragon in the path of the triumph of the project.
The buyers who come to get done their works are mostly webmasters and many of them have not a single know how about their projects. They pose their projects as so simple and small just to save money and when somebody bids a low cost on their project, they choose them and in the result 80% projects lingered on and being delayed by the service providers.
Buyers come and want their work done at night. This kind of manner also compels the coders to adopt the shortcuts.
Too Rigid and too loose policies, low cost prices for large projects, ignoring the profiles and tracks of the service providers by buyers, unnecessary protection of buyers, unprofessional approach of the webmaster and service providers, humiliating behavior of the website staff all are the factors which must be tackled down.
I read an article which was on the miseries of buyers. How, they were conned them into accepting codes which were not working etc. This article was giving the impression that everything is due to the service providers. But it is not, I already stated that incomplete and fake information, lack of knowledge about the projects, getting the work at cheap prices, compelling the service providers to do what was not mentioned by the buyer in the bid request. Putting the blames of the technologies or servers issues on the service providers all are the cause of the failure.
In quoting low prices, Indians are at the top, I don’t understand how they sell their solutions for none. Many unprofessional service providers who are just making fun on the websites hinder the others to get the good projects. Also such providers mar the good fame of the expert professionals. Good and bad are every where. But in general these free-lance websites are providing a big portion of the income of the service providers and also providing cost effective solutions to the buyers.
The rentacoder has good features like arbitration and escrowing money, but with a lot of biasness which is shown; elance has good working environment but no protection in the case of fraud by buyer or coder; getafreelancer is good and has a lot of work but most of the bids are not of the quality bids and the buyers who just come their to make completed their tasks on 30USD only. I suggest if we make such an environment where both parties can feel better, that will help to increase the productivity. The buyer must come with knowledge about his/her projects and s/he must choose only the professionals which have some good track and history not essentially on the websites where they are posting the projects but anywhere. Arbitration processes must be unbiased; Projects and their costs posted by buyer must be examined and must be analyzed by professionals so that the actual work time to be delivered and cost can be estimated. Buyers must be forced to pay if they want extra work. The service provider must be bound to work which they agreed upon initially. There must be such system where both parties can be fined internationally in the case of any fraud done by anyone, living anywhere in the world even in USA or UK. An unprejudiced justice must be given at cheap cost and fast. An appealing court must be established now where anyone can sue against the maltreatment by other without any race, color, breed, sect or religion and threat. This must be so cheap and fast because many of the service providers from under developed countries are not able to pay such heavy fees and sometimes it must be free because if the cost of the project is low, the person can think, not to go to the court. It is indispensable because free-lancing and outsourcing of the work has become a trend of the today’s age. The expenses of the court must be fulfilled by the member countries as this court will be to prevent the internet frauds globally without bothering the boundaries of the countries.
It appears to be difficult but not impossible. Hope and courage must be there. In this way we can make such online businesses safe.
Thanks
Syed Murtaza Hussain Kazmi
Efficiency in code is good but that must be reasonable.
PHP and Dotnet 1.1 Website and Software Engineer
Problem with URL rewriting using .htaccess based Articles
Problem with URL rewriting using .htaccess based Articles.
This small writing is intended only for the beginners. It is not for the coders who have know-how of .htaccess and are experts or advanced programmers.
Url rewriting using .htaccess is very common now-a-days for the programmers who work especially in PHP on linux or unix based Operating systems with Apache as a web server.
.htaccess is a Global Configuration file in Apache. It is not only use to make redirection but it is also used for many other tasks like Stop displaying the directories of the site if there is no Index or start up page, changing the start up page to something else etc. I am not going into detail of it as you can find much about on internet.
Visit Apache rewrite guide for this purpose if you are interested in knowing further about the rewriting.
The only purpose for this small article was to address the issue with the articles for url rewriting while they are written and published.
They mention in detail about what the rewriting URLs is. They gave examples how to use that but they don’t mention about to change URLs in the code. Coders must write and make URLs according to SEO friendly format and then define a rule for them in .htaccess.
They just mention this is URL and see how it will be redirected.
Example:
Rewriting product.php?id=12 to product/ipod-nano/12.html
RewriteEngine on
RewriteRule ^product/([a-zA-Z0-9_-]+)/([0-9]+)\.html$ product.php?id=$2
The author has mentioned about the url and showed that how the url will be redirected seamlessly. Definitely it will come from the Browsers address bar. But he has not mentioned that this kind of URLs will be made in their programming coding.
Why it is essential, because for the beginners it becomes difficult to understand. So whenever such articles must be written, they must start from making the ground.
Conclusion
A coder must think how the urls will look like before making rules, then he must format the links generated from his code, for instance, make a link for editing the profile of a user according to what he has planned.
Example: http://www.domain.com/profile/Murtaza-2/
Or
http://www.domain.com/profile/Murtaza/2/
It must be generated through the code.
Then he can write a rule in .htaccess like this.
RewriteEngine on
RewriteRule ^profile/([a-zA-Z]+)-([0-9]+)/$ acp/users/options/profile.php?name=$1&idPk=$2
This “acp/users/options/profile.php” is the directory structure where the profile.php is present. Use your own path.
One more thing to be noticeable that when you write a SEO friendly URL which has some query string, You must enclose your query string portion with Parenthesis ‘()’ without single quote. Because it tells the rule that now the sub pattern is going to be started. And it assigns the value to the right hand side’s variables defined as $1, $2 so on.
e.g, in the above rule this part ([a-zA-Z]+) tells the Rule to assign whatsoever is coming at let to right hand side’s $1 and this ([0-9]+)/$ to $2. Note down the parenthesis.
Syed Murtaza Hussain Kazmi
Efficiency in code is good but that must be reasonable.
PHP and Dotnet 1.1 Website and Software Engineer
Recommended Font Size for the content’s text of your website Now-a-days
Recommended Font Size for the content’s text of your website Now-a-days
It has been seen that now a days many users use high resolutions because as technology is advancing large resolutions are coming into market.
Before it, most of the users used small resolutions and also small font sizes were in practice. The size which were used was between 10px to 12px.
But now the resolutions are high, it is difficult to see such small font on them. So it is suggested to use the large font sizes.
One can use the font size 12px(min) to 16px. It is also a good habit to define the font sizes in ‘em’ unit. Default em is 16px. Mostly every popular browser’s default font has been set to 16px as every one knows about that.
Here is a very good article which mentions about this topic in detail. So read and do happy coding.
http://informationarchitects.jp/100e2r/
Syed Murtaza Hussain Kazmi
Efficiency in code is good but that must be reasonable.
PHP and Dotnet 1.1 Website and Software Engineer
Store And Retrieve data to Mysql db which has many to many relation without creating new third table and keeping intact the normalization
Store and retrieve data which has ‘many-to-many’ relationships with each other without creating a third table
This article is intended for website and software developers who have some knowledge about programming and Databases.
During development in any computer programming language, we usually come across situations where we have to store data taken from different Medias like web forms, CSV files, RSS Feeds etc.
There are also different ways to store the data, like storing data to an XML file, storing data to a CSV file and/or storing data to any database.
Many times software and website developers face a situation in which data has ‘many to many’ relationship with each other. And for this purpose, they make an extra SQL data table in any Database which they use. This is done just to keep the database normalized.
To make life easy, let’s take a simple example and see something about normalization step before moving to the actual topic of this article. I am explaining it here just for the developers who have less knowledge about database and development and are at beginning level and also for making the ground for my solution.
Suppose you are working on a project which is related to any restaurant website. A restaurant website mostly has Menus, Recipes/dishes etc. If you explore further, you will see that the Menus can have many recipes/dishes whereas a dish can be served in different menus; Here Menus are Breakfast, Lunch, Dinner, and Supper etc. Dishes can be Bread, Juices etc.
So you can serve bread in Breakfast, You can serve in Dinner etc. And a menu can have many type of dishes for instance, bread, Fried chicken, Berger etc.
In the above example, you can see that there is a ‘many to many’ relationship between dishes and menus. In order to store data and information for dishes and menus, you will definitely make a data table for Menus, a data table for Dishes. Now if you try and save the data, you will realize that there is repetition of fields in Dishes table.
The Problem
Data is not normalized.
See the below screen shots below for two different tables tblmenu and tbldishes created in MYSQL Database. Please note that these tables are just for explanatory purposes and do not contain all the necessary data fields.
tblmenu
tbldishes
Suppose there are Two Menu items in tblmenu and some dishes in tbldishes tables respectively.
Screen shots of both tables with values are given below:
You can see that ‘Bread’ is served not only in ‘Breakfast’ but also in ‘Dinner’ and it is being repeated. Here is the solution:
The solution
The solution to this problem is to create a new third intermediate table as most of the developers do.
I am not going to create any new third intermediate table. Instead I am moving towards another solution which will suggest how to solve the above problem without creating a new table and keeping intact the normalization.
New solution
Creating a new table will solve the issue of normalization without any problem. But when I used to do that, I always had to know which third table was related to which other two tables in a large database. Also while coding, I would have to store data to that third table and then at query time, I had to make such a query which could fetch the required data from the second table or first table depending upon the third table. It was extra overhead and work which I had to do.
Here is an idea on how this problem can be resolved with just a simple SQL query.
The Idea
I will move forward by again taking the example of restaurant which we are dealing with at the moment. Suppose you have a web page where you have to display some dishes, and you have selected a dish say Bread and you have added it to or attached it with a (or many) Menu like Breakfast or/and Dinner.
Now you need to store that to the db so that it might be available to the user not only for Breakfast but also for dinner.
Do Not go and create a new table in order to store the selected Dish and Menu’s id.
To do so, just make a simple change in tbldishes by changing the type of Menu id foreign key field to Varchar instead of int.
Now you just need to store or insert the selected menus id(s) separated by Commas into that field. e.g, 1, 3
It means Menu # 1 and Menu # 3 have been selected.
Using this technique, there is no need of making the third table or calculating Binary value of the Ids and then summing the Ids up in order to store to the Db menu foreign key Field. You can see the data in the table is normalized.
Also, there is no need to count Total # of Menus in order to calculate 2 ^ n-1 formula for making # of bits and then doing the bit shifting operations on MySQL side in query.
The total cost which will come on this action that is concatenating the Menu ids is just constant and minimum, which makes this solution fast and efficient.
Ok this was the answer of how to store the data.
Now the concern is how to retrieve a Recipe/Dish which is present in different Menus.
That is so simple, easy and efficient using the method I am going to tell you now. No need to be worried about shifting correct number of bits and performing bit wise operations etc or making complex SQL queries for retrieving data.
IF YOU WANT TO CHECK ALL THE RECIPES/DISHES WHICH ARE AVAILABLE IN BREAKFAST AND HAD ID EQUAL TO ONE (1) IN DB TABLE, JUST DO THIS
SELECT dish_Name FROM tbldishes WHERE dish_MenuIdFk REGEXP ‘1′
OR
SELECT dish_Name FROM tbldishes WHERE dish_MenuIdFk REGEXP ‘[1]‘
Both will work. You can confirm it by using an example to see the result yourself. No need to manipulate bits or making complex queries.
Again, if you want all the recipes in menu 1 or 4, do the following:
SELECT dish_Name FROM tbldishes WHERE dish_MenuIdFk REGEXP ‘[1 | 4]‘
And if you want 1 and 4, do like this.
SELECT dish_Name FROM tbldishes WHERE dish_MenuIdFk REGEXP ‘[1]‘ AND dish_MenuIdFk REGEXP ‘[4]‘
So will it work for digits (ids) greater than 9?
No, it will cause some repetition.
So what is the solution?
Let’s make some modification to improve it. Store the values from your programming code separated by ‘!’ or any other character which has no Special meaning in REGEXP. ‘!’ this will work as a boundary of the number or Menu id.
I am using ‘!’, so store the values like this
!1!!333!!4! So on
And retrieve as
SELECT *
FROM tbldishes
WHERE dish_MenuIdFk
REGEXP ‘!1!’
OR dish_MenuIdFk
REGEXP ‘!33!’
LIMIT 0, 30
It will work up to any number of digits within a number.
Conclusion:
In my example, only the operation of concatenation of the Ids is being performed before storing them to the DB. In the routine way in which we make a third table, you need to use some loop in order to store multiple ids within the table. This will definitely take much time than just performing a simple concatenation operation.
One can also enhance and optimize the query by indexing the columns which one think will be used for search filters. In my example you can put the “Index” on “dish_MenuIdFk”.
I would appreciate the addition or subtraction and any comment on it in order to make it better.
Note: The command which has been used here in the solution with in sql query is ‘REGEXP’. This is a MYSQL command. You will have to see the alternative command in your database manual if you are not using the MYSQL database.
Thanks
Syed Murtaza Hussain Kazmi
PHP and Dotnet 1.1 Website and Software Engineer
Efficiency in code is good but that must be reasonable.
Solution Summit Mania
I welcome all of you on Solution Summit Blog. Kindly feel free to post about Solution Summit. Leave your comments and suggestions in order to make this site and our services the Best. We will welcome all of your suggestions and we shall try to make the adjustments and make better our services if required and essential in the light of your opinions.
Please click on the above “Solution Summit Mania” link for leaving the feedback.