How To Bind DropDown In PHP

<select name="selbrand">
<option value="">All Brand</option>
<?php
$select="car";
if (isset ($select)&&$select!=""){
                $select=$_POST ['NEW'];
            }
                $list=mysql_query("select distinct BrandCategory from cardetail") or die(mysql_error());
            while($row_list=mysql_fetch_assoc($list)){
                ?>
                    <option  value="<?php echo $row_list['BrandCategory']; ?>"<?php if($row_list['BrandCategory']==$select){ echo "selected"; } ?>>
                                         <?php echo $row_list['BrandCategory'];
$abc="selected";
?>
                    </option>
                <?php
                }
                ?>
</select>

How To Incrise MySql datbase Size For Import Purpose

Left Click Om wampserver--->php--->open PHP.INI
THEN SET FOLLOWING PARAMETER.

memory_limit = 700M
post_max_size = 700M
upload_max_filesize = 800M

How To Use MySQL Stored Procedures For PHP Development

How To Create MySQL Stored Procedures
DELIMITER //
CREATE PROCEDURE SelectAllProducts()
BEGIN
SELECT * FROM products;
END //
DELIMITER ;

in above syntax SelectAllProducts is PROCEDURE Name
And products is your table name

How to call Stored Procedures

After creation of SP You have to require call procedure
use following syntax

CALL STORED_PROCEDURE_NAME()

or in our present case procedure name is SelectAllProducts so
syntax is

CALL SelectAllProducts()

then you wiil get all product list.
Connect with us for reading more blog regarding PHP WITH Stored Procedures
if you like this post then please like the blog.

http://www.flipkart.com/arts-photography-books/1-0?affid=yogeshbaja

How TO Use SVN FOR Team Work.

How TO Use SVN FOR Team Work.
please visit this link.
http://www.youtube.com/watch?v=4yola1Q9KEQ

PHP Open Source Projects.

These are following website from where you can downlode PHP Project.or there Source Code.
www.hotscripts.com
http://www.opensourcescripts.com/
 http://www.killerphp.com/articles/killer-php-projects/

BASIC SELECT SQL SERVER QUERY.

BASIC SQL SERVER QUERY.
=========================================================

SELECT * FROM MasterControl

FOR ACCESS ALL RECORD FROM DATABASE

SELECT CODE,CONTTYPE,MANDATORY FROM MasterControl

FOR ACCESS SPECIFIC COLUMAN FROM ANY TABLE


SELECT CODE AS CODE,DATATYPE AS "DATA TYPE" FIELDNAME AS FIELD NAME FROM MASTERCONTROL

THIS QUERY USE FOR TABLE ALISING

SELECT  TOP 3 *  FROM MASTERCONTROL

THIS QUERY USE FOR ACCESS TOP 3 ROW FROM ANY TABLE.

SELECT DISTINCT MANDATORY FROM MASTERCONTROL

THIS QUERY USE FOR ACCES DIFFERENT RECORD FROM ANY TABLE

SELECT *,* FROM MASTERCONTROL

THIS QUERY IS USE FOR PRINT THE RECORD DOUBLE TIME.

SELECT CODE+' '+CONTTYPE AS FULLNAME FROM MASTERCONTROL

THIS QUERY IS USE FOR COMBINE TOW COLUMAN IN A SINGLE COLUMAN.

SELECT COUNT (*)

THIS QUERY WILL RETURN 1

SELECT Code, ' is ' ,CONTTYPE FROM MASTERCONTROL

THIS QUERY USE FOR ADDING AN EXTRA  COLUMAN IN RESULT TIME DYNAMICALLY
===========================================================================