View Single Post
  (#1) Old
webgovernor is Offline
Banned from DF
webgovernor is on a distinguished road
 
webgovernor's Avatar
 
Posts: 160
Gallery: 0
Comments: 0
Join Date: Oct 2004
Location: Euphoria, all the time...
Zodiac Sign: Capricorn
Rating: Not Rated
Credits: 206
   
In need of SQL function. - 11-03-04

Hello fellow techsters,

Short and sweet,

The Problem,

I'm looking for a way to load multiple SQL queries and display them to the screen WITHOUT using an autoincrementing feild, like id.

The reason for this, i'd like to allow users to enter data and have it alphabetically formated when displayed, and allow then to delete their data at will.

Now I'm using mysql_fetch_array with the ID field within a while loop, and I'm dropping and re-inserting the id feild everytime a post is deleted.

Desired Solution,

I'd be incredibly gratefull if someone knew a function to load all of the rows in a field and access them without using an id key.


Well, thanks a lot for the replies in advance!
  
Reply With Quote
 
X vBulletin 3.6.8 Debug Information
  • Page Generation 0.35250 seconds
  • Memory Usage 7,258KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)iprof_zodiac_sign
  • (4)option
  • (1)postbit_legacy
  • (1)postbit_onlinestatus
  • (1)postbit_reputation
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)welcome_headers 

Phrase Groups Available:
  • global
  • photoplog
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./vbseo.php
  • ./includes/functions_vbseo.php
  • ./includes/functions_vbseo_pre.php
  • ./includes/config_vbseo.php
  • ./includes/functions_vbseo_url.php
  • ./includes/functions_vbseo_createurl.php
  • ./includes/functions_vbseo_db.php
  • ./includes/functions_vbseo_vb.php
  • ./includes/functions_vbseo_seo.php
  • ./includes/functions_vbseo_misc.php
  • ./includes/functions_vbseo_crr.php
  • ./includes/functions_vbseo_cache.php
  • ./includes/functions_vbseo_hook.php
  • ./includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/vblogetin_config.php
  • ./blogs/plugins/init_startup.php
  • ./blogs/plugins/style_fetch.php
  • ./geek/gars/includes/gars_ignition.php
  • ./blogs/plugins/cache_templates.php
  • ./blogs/plugins/global_start.php
  • ./blogs/backend/functions_blog.php
  • ./blogs/backend/functions_seo.php
  • ./blogs/backend/class_blog.php
  • ./blogs/backend/class_siradrian.php
  • ./blogs/datastore/blogstatistics.php
  • ./blogs/datastore/categories.php
  • ./blogs/datastore/blogcustomfields.php
  • ./blogs/backend/class_permissionCheck.php
  • ./blogs/backend/class_permissionCheckCore.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_misc.php 

Hooks Called:
  • init_startup
  • fetch_postinfo
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • gars_ignition_start
  • gars_ignition_end
  • global_start
  • blog_permissions_start
  • blog_permissions_process
  • blog_permissions_complete
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • fetch_musername
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete
  • postbit_display_complete
  • error_fetch
  • showpost_complete

Action Status Required Cached
canViewBlogs true false false
blog true false false
blogPosts false false false
createBlog false false false
modifyBlog false false false
manageEntries false false false