Re: [PHP] $_POST arrays not evaluated in sql statement -- why?

2003-02-25 Thread CF High
Hey John et. al I tried your method John, and it works! Re: excessive single quotes in the sql, but I tried stripping them out to no effect. Using curly braces in the sql statement wasn't an option I knew about. Thanks again for illuminating another bit of the PHP world. --

RE: [PHP] $_POST arrays not evaluated in sql statement -- why?

2003-02-25 Thread John W. Holmes
> ('1','1','$date','$_POST['jersey_id'][$x]','$_POST['first'][$x]','$_POST [' Let's just be smart and think about this for a second. Look at all of the single quotes you've got. How do you expect PHP to be able to tell what's a variable and what's text? Do you mean $_POST or $_POST['jersey_id'] or

Re: [PHP] $_POST arrays not evaluated in sql statement -- why?

2003-02-25 Thread Joshua Moore-Oliva
I believe that single quotes will display exactly what you type in, and double quotes will actually process it.. e.g. $foo = "hello"; echo '$foo'; You see $foo echo "$foo"; You see hello On February 25, 2003 09:42 pm, CF High wrote: > Hey all. > > Got a problem with this sql statement -- php

[PHP] $_POST arrays not evaluated in sql statement -- why?

2003-02-25 Thread CF High
Hey all. Got a problem with this sql statement -- php vars are evaluated (e.g. the $date var), but not the $_POST arrays.. All of the arrays return correct values -- What am I missing here? $sql = "INSERT into rosters (school_id, sport_id, date, jersey_id, first, last, position, grade, t