ginerjm

Or FPDF

Your sms doesn't handle html most likely.

The complexity of this code you have written (?) is such that I think you s/b able to solve it. You are using an index that doesn't yet exist. Figure it out.

I think a link should show up for you only since it is your post.

So this question should be marked 'answered'?

IN your second query you call the 'query' function. In your first query you never made a call to the query function, hence no update.

My previous question re: testing your query result was not answered. Do you in fact have code that tests the result of your query function call? Show us that code and also the complete query statement that you are trying to execute. Use an echo if you have to in case you are building it with php values in it. Something like this code: $q = 'select (stuff) from (table) where (condition)'; $qresult = $pdo->query($q); // test if query ran if (!$qresult) { echo "Error - could not execute query #1. Query is<br> $q"; exit(); } // process valid query results here. Note: the parens in the query statement are only there for example.

Are you checking the query result to see if it failed? If not, why do you think that is the problem?

Do some things that experienced programmers do everyday. Add error checking when you do things that could go wrong. Things like opening up a file, or running a query. How do you know it actually happened if you don't check? When you read the manual ( you did read the manual?) didn't you wonder why many of these functions return a Boolean value? It's there so you can check the success or failure of that function. Make your life easier by using the list() function to capture the csv fields. This will give you real field names instead of an array with numeric indices. Makes it easier to follow what you are doing especially when doing debugging. BTW - why are you inserting only one field when you have all that data?

HTH! BTW - the example was supposed to be indented for ease of understanding and readability. The forum didn't seem to respect my spacing. I like to keep the braces at the same indent level as the verb they belong to, with the statements inside the braces indented one stop. And so on.

if (condition) { if (condition) { statements... } else { statements... } } else { statements... }

What about passing the value as a hidden field from the first script to the form on the second one?

Which script is giving you the error and on what line number? Determine those things and point us to the code that is doing this thing.

So - you don't want to post what I asked to see? ok.

I don't see any form or select tags. Where is your drop down and where is your submit?

Please use the proper forum tags to post the RELEVANT code here for us to view. Many of us don't go to other sites for fear of the risks. Show us the html form for the dropdown and the php code that receives it, validates it and where the failure occurs. Have you done any debugging to see what you are getting from your form yet?

Wild guess but you have a loop that is doing something for you but you have allowed it to continue on too long without ending and that's is causing the excess memory usage. Check your foreach or while loops to be sure that they will reach an 'end point' at some time and not keep on forever.

Have you read the notes in the manual under proc_open function? I don't know a lot about pipes and such but the language there sounds like it describes the problem you are having.

Would have been nice if you posted it in the proper tags.

For the output simply do a new query that retrieves the user's data and build your table from that. This avoids being concerned about capturing other data from the input and ensures that you get the absolute current correct data from the db.

Nice attitude to someone who is only trying to help. How are we supposed to know about the size of your code and the implications of asking to see 'it'? Sheesh!

What do you mean by ' isn't currently working '? Could it be because you aren't using it correctly? Check the manuals for proper examples.

If you post the RELEVANT code here (not the whole 16kb) we could help you by looking at it

Because the 31 row occurs first, the statement fails? Is that what you really mean? If committeeid is 31 and 1 in your two rows, why would the 31 even be selected? Is your getcolumnval method flawed in some way? PS - you have way too many php tags in this snippet. You don't need to turn it on and turn it off all the time.

You won't show us the contents of the arguments? Why?