Last night, a friend mentioned to me that one day he was trying to fetch a random 5 rows from a MySQL database. He researched online, and was eventually presented with a working solution in which he would generate five random numbers. Then, he would query the database for items whose ID number matched the numbers. If an item didn't exist (because it had been deleted, etc.) then he would randomly generate a different number and fetch again. He would continuously do this in a loop until he had five unique rows fetched from the database. I was caught off …

Member Avatar
Member Avatar
+4 forum 5

# MySQL Stored Routines: Another Useful Scenario # [In a past guide](http://blog.bobbyhensley.com/sql-procedures-functions-authentication-example/) I discussed MySQL stored routines within MySQL. Now I’m back with another guide on MySQL stored routines. And this time it’s a more concrete case; one that you may run into yourself in the future (or maybe you already have)! Let’s jump right on, shall we? ## The scenario… ## You’re implementing a comments system to your application. Users will be able to comment on articles you and your staff post. A concern arises: **explicit comments**. It’s something all web developers have to deal with: people being crude …

Member Avatar
Member Avatar
+2 forum 1

## Contents ## Overview 1. Alternatives to Deprecated mysql_* Functions 2. SQL Injection: What to do with $_POST and $_GET variables 3. How to Insert Tablenames and Fieldnames Properly 4. What to do With Dynamic Values? 5. How to Use Aggregate Functions (COUNT, SUM, MIN etc) 6. How to Paginate and Create Page Number Links? 7. How do I Store Files: Filenames or BLOB? 8. Splitting the Big Table: Normalization 9. How to Get Data From More Than One Table 10. How to Store Menus and Submenus 11. Storing and Retrieving Authentication Data References and Further Reading _______________________________________________________________________________________________ ## Overview …

Member Avatar
Member Avatar
+6 forum 6

[ATTACH=RIGHT]20145[/ATTACH][B]Building your first DYNAMIC Database application. This is Part One of a four part tutorial on how to install and use your database, Part Two will teach you how to build successful connections and Part Three will teach you how to build database interaction and management of your databases.[/B] There are tons of questions here on VB6 on how to connect to a database, how to add, delete, edit, search data within your database tables etc. This tutorial has been created to serve as a learning curve or to add more knowledge to your current code writing skills. This tutorial …

Member Avatar
Member Avatar
+1 forum 14

The End.