vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   Who knows sql? (https://vborg.vbsupport.ru/showthread.php?t=36497)

The Keeper 03-24-2002 08:22 AM
Who knows sql?
 
PHP Code:
if(!mysql_query("INSERT INTO $tablename (name,comment,date,ip) VALUES ('$name','$comment','$date','$ip')")) { 
$url = 'blog.php?is=save'; 
header("Location: $url"); 
} else { 
$maxi = mysql_query("SELECT max(id) FROM blog"); 
mysql_query("DELETE * FROM blog WHERE id < '$maxi' - 20 "); 

header("Location: blog.php"); 
} 


ok I think I borked this.

What it's meant to do is find out what the maximum ID is... then delete all tuples that are 20 or more smaller than that number... so only about the 20 newest tuples are kept at each update.

What have I done wrong, because it's not doing it's function..

Admin 03-24-2002 11:22 AM
PHP Code:
$maxi = mysql_query("SELECT MAX(id) AS maxid FROM blog");
mysql_query("DELETE * FROM blog WHERE id < ($maxi[maxid] - 20)"); 


All times are GMT. The time now is 03:52 PM.

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.01097 seconds
  • Memory Usage 1,713KB
  • 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
  • (2)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