Results 1 to 3 of 3

Thread: [RESOLVED] Supplied Argument not Valid Mysql Resource

Hybrid View

  1. #1
    Join Date
    Jul 2010

    resolved [RESOLVED] Supplied Argument not Valid Mysql Resource

    Hey, guys!

    I'm working on a script to grab data from a row in a database based on the id of the row (which automatically increments).

    The script will grab a number from the URL (7 in www.site.com/page.php?id=7), and then find the row in a table with an id that matches that number. It will assign variables to data from that row, so the information can be placed in various places in the dynamic page.

    However, something does not appear to be working: This script is on page.php. So when I type in the URL: www.site.com/page.php?id=7 , I receive the error output: "Save me!" and the text "Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/dot/public_html/the_editor/page.php on line 19."

    Following is the script:

    PHP Code:
    $id $_GET['id'];


    mysql_connect(localhost,$username,$password) or die("Could not connect to MYSQL");
    mysql_select_db($database) or die(mysql_error());
    $query="SELECT * FROM [table_name] WHERE id='$id'" or die(mysql_error());

    /*database output assigned variables below*/
    $page_title=mysql_result($result,$i,"page_title") or die("Save me!");
    Any ideas?
    I don't know half of you half as well as I should like; and I like less than half of you half as well as you deserve.
    - Bilbo Baggins in The Fellowship of the Ring

  2. #2
    Join Date
    Aug 2004
    That message normally indicates that your query could not be processed by MySQL, and therefore $result is FALSE instead of a query result resource ID. You can check after doing the mysql_query() to see if $result is false, and if so use mysql_error() to get some info (e.g. via error_log() or user_error()). If the code is exactly as posted here, then I suspect the immediate problem is "[table_name]" needing to be replaced with a valid table name (and not in brackets).
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

  3. #3
    Join Date
    Jul 2010

    $result was false and problem was rooted in wrong tablename


    You were right on - twice! After implementing the error checks that you reccommended, I discovered that $result was indeed false. The error message, however, led me to the solution - I had the wrong table name - that you suspected. I had inadvertently put the database name for the table name.

    Below is the resolved code. I would note, however, that being new to PHP, I did not know how to implement error checks, and so tried to search the web for a how-to on that. I ended up using NogDog's error code that he supplied someone else on this site!

    PHP Code:



    mysql_connect(localhost,$username,$password) or die("Could not connect to MYSQL");
    mysql_select_db($database) or die(mysql_error());
    $query="SELECT * FROM articles WHERE id='$id'" or die(mysql_error());

    /*Checking to see if $result is false*/
    if($result == false) { 
    user_error(mysql_error() . "\n$query"); // or use error_log() 
    die("Fatal database error"); // or whatever you want to tell user 


    /*database output assigned variables below*/
    $page_title=mysql_result($result,$i,"page_title") or die("Save me!");

    Thanks, NogDog, for your generous help.

    Signing off -
    I don't know half of you half as well as I should like; and I like less than half of you half as well as you deserve.
    - Bilbo Baggins in The Fellowship of the Ring

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center



X vBulletin 4.2.2 Debug Information

  • Page Generation 0.10427 seconds
  • Memory Usage 2,971KB
  • Queries Executed 13 (?)
More Information
Template Usage (30):
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (2)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (3)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (27):
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/functions_navigation.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_facebook.php
  • ./includes/functions_calendar.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_notice.php
  • ./includes/functions_threadedmode.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (72):
  • init_startup
  • friendlyurl_resolve_class
  • init_startup_session_setup_start
  • database_pre_fetch_array
  • database_post_fetch_array
  • init_startup_session_setup_complete
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • load_show_variables
  • load_forum_show_variables
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • strip_bbcode
  • friendlyurl_clean_fragment
  • friendlyurl_geturl
  • forumjump
  • cache_templates
  • cache_templates_process
  • template_register_var
  • template_render_output
  • fetch_template_start
  • fetch_template_complete
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • bbcode_parse_start
  • postbit_imicons
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • build_navigation_data
  • build_navigation_array
  • check_navigation_permission
  • process_navigation_links_start
  • process_navigation_links_complete
  • set_navigation_menu_element
  • build_navigation_menudata
  • build_navigation_listdata
  • build_navigation_list
  • set_navigation_tab_main
  • set_navigation_tab_fallback
  • navigation_tab_complete
  • fb_like_button
  • showthread_complete
  • page_templates