Posted by "Kristen G. Thorson" on 08/05/05 21:28

Jack Jackson wrote:

> Kristen G. Thorson wrote:
>
>> You said "If the user makes changes, those changes get error checked
>> but do not become part of the sql query." Where in your code is it
>> failing to become part of the query? Put a check at each level and
>> see where *exactly* it fails to get deep enough to become one with
>> the query. Also, I'm confused. I asked if the query was what you're
>> expecting, and you answered yes, which implies the data becomes part
>> of the query.
>
>
> Thanks for this; yes I was confused before and thank you for the
> clarification.
>
> Now I am confused by how to check the logic: I echo out the sql as it
> is built, and if I'm going forward in the questionnaire it shows
> clearly but
>
>
> $qidlist_sql="DELETE FROM teresa WHERE q_id IN (" .
> (implode(",",$qidlist)) . ");";
> echo "<br /><br />";
> echo "<br />\$ cqidlist_sql:" . $qidlist_sql . "<br />";
>
> $q_a_sql="INSERT INTO teresa (u_id, q_id, a_id )
> VALUES " . (implode(",",$qanda)) . ";";
>
> mysql_query($qidlist_sql);
>
> echo "<br /><br />";
> echo "<br />\$ q_a_sql:" . $q_a_sql . "<br />";
>
> if($q_a_result = mysql_query($q_a_sql))
> {
> unset($_SESSION['required_fields']);
> $cat = $_POST['cat']+1;
> include_once(QUESTIONS . 'q.inc');
> }
>
>
> shows NOTHING if I hit the BACK button. I'm still not seeing where
> the logic error is which makes it so that when I hit the BACK button
> it loses the plot.
>
> Sorry for my misunderstanding
> JJ
>

Keep going backwards. It looks like maybe you've got an IF statement
that you're not getting past. Find where that is, and why it's
evaluating to false. If it's outputting *nothing*, then you're not
evening reaching those echo statements. Make a note after every IF
statement, something like

echo "Inside if( this == that )";

So you know which blocks of code are being processed.


kgt

[Back to original message]