vb.org Archive - Proper syntax

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Proper syntax (https://vborg.vbsupport.ru/showthread.php?t=98146)

Lionel

10-11-2005 05:53 PM

Proper syntax

I am trying to do an insert in database only if all conditions are met. But the below is inserting no matter what. What is wrong in there?

Thanks.

PHP Code:


		
			
if ( $_POST["type"] == "rate" and ($_POST["rate"] != "" or $_POST["rate2"] != "" or $_POST["rate3"] != "" or $_POST["rate4"] != "" ))
{
do the db insert
}
 
else ...

Adrian Schneider

10-11-2005 06:15 PM

If it is inserting then all your conditions ARE being met.. :p

I'm thinking you probably want to replace those ors with ands? That would ensure all the fields have been filled out, and type is equal to "rate".

Lionel

10-11-2005 06:57 PM

OK I will try "AND" because conditions were not met.

Andrew

10-11-2005 08:37 PM

Quote:

Originally Posted by Lionel

OK I will try "AND" because conditions were not met.

If all of your variables need to be set then just use AND instead of OR. Right now it's seeing if "type" and "rate" are set - If either of them isn't it looks to see if "rate2" is set OR if "rate3" is set OR if "rate4" is set to fulfill the statement. That make any sense ?

All times are GMT. The time now is 02:40 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01507 seconds Memory Usage 1,718KB 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)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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
Messages: