hi if u need key value of an array. try this example.

$fruits = array(“d” => “lemon”, “a” => “orange”, “b” => “banana”, “c” => “apple”);
asort($fruits);
foreach ($fruits as $key => $val) {
    echo “$key = $val\n”;
}

save you excel in csv.

Bulk
INSERT elect
FROM ‘c:\data\file2.csv’
WITH
(
FIELDTERMINATOR = ‘,’,
ROWTERMINATOR = ‘\n’
)
GO
–Check the content of the table.
SELECT *
FROM elect
GO

elect is  your table name and c:\data\file2.csv is your csv file path.

Nishant

Hi..

I was making a procedure in My Sql then I noticed a thing which I should share with all

the common If…. else if*….else…..end if system may confuce u leading to systex error if you forget to concat the elseif togather