vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   Help with this bit of code please! (https://vborg.vbsupport.ru/showthread.php?t=42376)

Prince 08-16-2002 05:28 PM
Help with this bit of code please!
 
Something is wrong here...whether the email address exists in the database or not it comes back as if it does exist. It's supposed to come back with a different result if the address exists in the database.

Anyone?


PHP Code:
 if($new_sub == 'unsub') // User wants to unsubscribe the letter
  {
    $query = "DELETE FROM ${prefix}_newsletter WHERE email='$new_email'";
    if(!mysql_query($query))
    {
      echo mysql_errno(). ": ".mysql_error(). "<br>";
      CloseTable();
      include("footer.php");        
      return;
    }                   
    cgiCenter();
    echo _new_unsbuok;          
    cgiBR();
    cgiLinkM("index", "def", _new_clickhere);
    cgiCenter(1);
    CloseTable();
    include("footer.php");        
    return;         
  }
        
  CloseTable();
  include("footer.php");          
} 

Issvar 08-17-2002 11:21 PM
The SQl query is valid, it deletes 0 or more lines. If you want to check if 0 lines were removed use mysql_affected_rows()


All times are GMT. The time now is 02:13 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01391 seconds
  • Memory Usage 1,712KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete