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 ?

Showing Answers 1 - 21 of 21 Answers

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

  Was this answer useful?  Yes

Illahi Bux

  • Feb 15th, 2007
 

Yes can run ..... php version .

  Was this answer useful?  Yes

Abhishek Saha

  • Feb 21st, 2007
 

9. using mysql_insert_id() function

  Was this answer useful?  Yes

Priya Ranganathan

  • Apr 4th, 2007
 

2. MySQL command to get unique values.
 
-- DISTINCT

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

  Was this answer useful?  Yes

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;

  Was this answer useful?  Yes

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

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions