serving the solutions day and night


Friday, July 30, 2010

Common Code Errors in PHP & MySQL

1. Displaying the current region/country in the top of the list using MySQL statement.
SELECT * FROM country ORDER BY country='US' desc;
An example of social/yellow pages site, want to bring top of the country or state in the list based on the user region. The above code listed US first then rest of other country.

Tuesday, July 20, 2010

Executing MySQL Stored Procedure using C#.NET - Part 2

In this blog contains business layer code and error description.

Business Layer
Class Admin - used to call Stored Procedure class, get result and pass to the client page

Executing MySQL Stored Procedure using C#.NET - Part 1

In this blog is going to explain how to get list of records, single record detail and insert/modify/delete records from MySQL stored procedure using C#.NET code. Blog contains information about MySQL table structure, stored procedure, C#.NET code and Error.