What is diff between srand & shuffle2-Mysql command to fetch onlythe unique values?3-how can a script come to a clear termination?4-How do i store binary in my sql?5-How do i limit the no of rows 1 get out of my database ?6- How do i find out weather a no is odd or even ?7-Can I coonect to Ms-access database w/o a DSN?8- How can we remove duplicate values from an array ?9-How an we get the ID genrated from the previous insert operation ?10-Can I run sevral versions of Php of the same time ?

Manoj Kumar

Dec 28th, 2006

1) srand function -> Seeds the random number generator with seed. and shuffle is used for shuffling the array values.

4) Using BLOB data type

6) if (number%2==0 ) then even else odd

8) array_unique() funciton can be used for the purpose

Illahi Bux

Feb 15th, 2007

Yes can run ..... php version .

Abhishek Saha

Feb 21st, 2007

9. using mysql_insert_id() function

Priya Ranganathan

Apr 4th, 2007

2. MySQL command to get unique values.

-- DISTINCT

eg: select DISTINCT 'fieldname' from 'tablename' where 'condition'

Priya Ranganathan

Apr 4th, 2007

5. How do i limit the no of rows 1 get out of my database?
-- LIMIT

eg: select * from 'tablename' where 'condition' LIMIT 1;

brijbhushansh
Profile Answers by brijbhushansh

Oct 14th, 2008

<?php
$input = array ("a" => "green", "red", "b" => "green", "blue", "red");
$result = array_unique ($input);
print_r($result);
?>

This will output:

Array
(
    [a] => green
    [0] => red
    [1] => blue
)

amitverma
Profile Answers by amitverma

Feb 6th, 2009

1> srand function seeds the random number generator with given seed. Function shuffle is used for shuffling the array values. This function generates new keys for the array elements.

2> select distinct column_name from table_name;
3> using exit 0; you may force to terminate clearly a PHP script with
4> Using BLOB data type column
5> select * from table_name limit n, m;
Here n and m defines the upper and lower limit for the selected rows;
6> if ($number%2== 0) then even else odd.
7> To connect to MS Access, you may PHP's ODBC functionality.
8> array_unique funciton will return an array with unique (not duplicate) values.
9> mysql_insert_id function will help you get the ID of lastly inserted record.
10> YES, You can run several versions of PHP at the same time. One you can configure as CGI module and one you can install as Apache Service. For more, read the PHP installation at PHP site - http://in2.php.net/manual/en/faq.installation.php