NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Selecting random record
35661
Selecting random record
http://www.dotnetindex.com/articles/8055_Selecting_random_record_from_database.asp
Learn how to select a record from database. First we need to calculate how many records we have in our table. Using randomize function, we generate a random number between 0 to count of records in database.
ASP > Tips and Tutorials > Database-related
Jul 14, 2007
www.dotnetindex.com
send email to www.dotnetindex.com
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
Other links owned by this user
So easy, even a grease monkey can do it!(*) OpenAutoClassifieds is a free, open source vehicle classifieds manager. Intended to be both easy to install and easy to administer, OpenAutoClassifieds uses PHP to drive a MySQL backend, thus creating a tool which is fast and flexible. The original script was written by Jon Roig and rewritten by me. Open source is great isn't it, thanks Jon.
Category:
R-Mail is a family of email recovery utilities for damaged files and deleted messages created by Microsoft Outlook* (later referred to as "Outlook") and Microsoft Outlook Express* (later referred to as "Outlook Express") software.
R-Mail utilities are based on the highly effective IntelligentRebuild Email recovery technology that allows R-Mail software users to repair damaged *.pst and *.dbx files and restore lost e-mail messages just in three steps.
R-Mail utilities are based on the highly effective IntelligentRebuild Email recovery technology that allows R-Mail software users to repair damaged *.pst and *.dbx files and restore lost e-mail messages just in three steps.
Category:
This is a skin for existing FlashChat users. Works with the FlashChat socket server, bot system, and IRC commands. Provides a sleeker, desktop-like interface design.
Category:
phpLD Article is a full featured photo album script.
Another great advantage of phpLD Article is is uses the same engine as PHP Link Directory, so it means there are many templates available and also lots of people that are experienced with using and modifying the script.
We have a very active support forum where people are able to get help, discuss features, request mods, or release mods. If you have questions, you will find answers in the support forum, and we strive to answer all questions.
Another great advantage of phpLD Article is is uses the same engine as PHP Link Directory, so it means there are many templates available and also lots of people that are experienced with using and modifying the script.
We have a very active support forum where people are able to get help, discuss features, request mods, or release mods. If you have questions, you will find answers in the support forum, and we strive to answer all questions.
Category:
Simply drop the dircaster.php script (and accompanying files) into a directory on the web server and it will generate a valid RSS feed suitable for Juice Podcast Receiver, etc., based off the MP3 files (with appropriate ID3 tag information) in that directory. To broadcast a new MP3 file, simply upload it to the same directory that contains the DirCaster script and files.
Category:
Organizes text by expanding or collapsing details information.
Only one details information can be viewed at once.
when user clicks on another header, it collapse previous details and expands current.
Saves space in web page.
Only one details information can be viewed at once.
when user clicks on another header, it collapse previous details and expands current.
Saves space in web page.
Category:
Support: Master card, Visa, Diner's Club /Carte Blanche, Discover
Category:
Advanced Enterprise is a free ERP software designed to keep and track information regarding production orders and generate invoices when goods are shipped to customer.Advanced Enterprise has a number of add-ons to enchance it's functionality:
Category:
Build Your Very Own Interactive Website With Content - Articles, Jokes, Games, Pictures/Images, Audio Clips, Videos And Much More... With Just A Few Simple Clicks!
Your Site Visitors Will Tell You Which Content They Like Most By Rating It!
Your Site Visitors Will Tell You Which Content They Like Most By Rating It!
Category:
Learn how to create cool and practical text effect using the mask. You don't have to use action script code to make this tutorial. This tuts is very easy for create - just follow a few following steps.
Category:
Since the introduction of the object model in PHP4 and the subsequent re-write in PHP5, I have always created my own abstraction classes and have found them very useful for things such as error handling. While looking around one day, I came across a list of abstraction libraries already created. After trying many of them and benchmarking a few of the top ones (ADODB, PEAR:DB, Metabase etc.) I have settled on ADODB. I however don’t use ADODB for its portability to other databases. This is a common misconception that users are given about (DALs) database abstraction layers. Switching from one database to another will never be an easy task, mainly because of a few SQL commands that are unique to each DBMS. One could argue that developers should never use non-standard SQL anyway, but that’s for another time.
Category:
12. Newsletter Pro
Want to start your own newsletter for your business or website? With The CWT Newsletter Pro you can send mass emails for whatever purpose you see fit. It is very easy to use and comes with a secure admin panel.
Category:
We are trying to achieve loading content into a ‘div’ element without refreshing the page, as well as showing a cool loading window inplace of the content as it is loading.
Category:
calendar.class.php is a simple calendar generation class written in php. The class outputs semantic and valid XHTML that is ready to style with your custom CSS. The class was created to be used as a framework object for the firepaper project but was designed to be portable and versatile enough to serve many uses.
Category:
Introduction to the use of mod_rewrite for more search engine and user friendly URLs
Category:
UltraButton is a Web button maker. With its help, you can easily complete the creation of image buttons or Flash buttons for Web pages even without any Web development experience. 80 categories, over 600 types of various popular-style button templates are embedded within UltraButton for you to choose from. Besides, you can fully customize the attributes (text, background, icon, etc.) in all states ("Normal", "Over" and "Click") of the buttons based on your requirements. When the design of the buttons is complete, you can output the buttons as GIF images, JPEG images or an Adobe Flash movie via Publish Wizard, and add them into your Web pages easily and quickly. If you are a user without Web development experience, UltraButton can help you breeze through the creation of image buttons or Flash buttons in just several minutes. What you should do is simply to select a template, enter button text, set attributes such as font style, button background and icon image. If you are an experienced Web designer, you can also use UltraButton to quickly make a group of Web buttons with consistent appearance for your client. Your time and efforts are saved.
Category:
Anyone who operates their own website knows that you need to provide forms in your site for visitors to contact you. The big challenge is providing easy form access to your visitors, without letting SPAM flood your email inbox or database. The techniques described in this article tell you how to reduce the amount of SPAM.
Category:
18. My SigChat
SigChat is a revolutionary new service that lets you take your boring old forum or profile signature, and spruce it up with your very own interactive chat. Now anyone can have a conversation with you within your profile with our great new service.
Category:
19. Password Finder
Create your very own password website! - You do not even need you own database! It searches the web for the passwords and even provides a work rating! Great traffic without any work at all! - (well maybe just uploading the files, but even we can do that for you.. free!)
Notice: Server required to have curl (most host do)
Notice: Server required to have curl (most host do)
Category:
Other links at ASP > Tips and Tutorials > Database-related
In this article we will see on how to search the database for a group of records. Searching a database is very easy and fun provided you know how to do it. Many of you who know SQL will already be doing it. But I will not use any lengthy SQL statements, instead will use some very useful Recordset object properties; Filter and Sort
Category:
In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down database.
Category:
Want to add value to your current search? Allow your users to search from within search results. As databases grow the necessity for the user to continually narrow a search to the item that they truly want will grow also. The following example utilizes our db on U.S. State capitals. Upon the first search two radio buttons will appear indicating a search (default) or a search within the current results. Searching within the current results will take the first search and add it to the new search and so on. Note the db only has 50 observations in it. For best results search on a letter and search for another letter within those results.
Category:
DSN Connections
In my earlier article on Accessing the database from ASP I explained connecting to database via DSN in a step by step mannner. So there is no need to repeat that again, you can see it from there.
DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone e.g Excel spread sheet etc.
I will now skip the steps of creating and assigning DSN to a database, you can see them by clicking here. Once you are done creating a DSN for your data source ( database lets say ), you can connect to it using following code
In my earlier article on Accessing the database from ASP I explained connecting to database via DSN in a step by step mannner. So there is no need to repeat that again, you can see it from there.
DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone e.g Excel spread sheet etc.
I will now skip the steps of creating and assigning DSN to a database, you can see them by clicking here. Once you are done creating a DSN for your data source ( database lets say ), you can connect to it using following code
Category:
Active Server Pages allow us an easy means of querying and updating a database from a webpage. This article describes the basics of using this technique in a nutshell. The examples given here utilize a Microsoft Access database, but the principles elucidated apply equally well to ASP integration with other databaes. (Access has been selected because it is widely familiar, easy to use, and adequate for many small to medium-sized projects.)
Category:
Main Category
165
2028
756
275
169
1801
1074
892
1127
7088
70
874
58
2145
170
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 18673
Categories: 1275
Registered Users: 533
Mailing List Subscribers: 2031
Unique Outgoing Hits: 192427
Pagerank Statistics
PHP News