ginerjm

I don't know what samowns is trying to contribute to this very vague topic, but since the OP has apparently left the building, this may all be moot.

Here's the code? What code? A bit of something from somewhere that has no resemblance to what you are asking "how to do" is all this is. You say you want to display the results of a query but you show one data field. You seem to be wanting to display it in an html table format but you don't know how to write one. And why exactly are you using input tags to 'display' your data? You don't say anything about doing an update. Now here is what your code looks like when written in a meaningful way so that you can see what you should really see: $bringitem = $connection->query("SELECT * from item where idItem='$iditemm'"); if(!$bringitem) { echo mysqli_error($connection); exit(); // Seem to have failed so why continue on? } while($rowww = $bringitem->fetch_assoc()) { // Let's show an item in a table but let's // not start a table nor start a row for that table // And let's even put that item in a form but don't plan on doing anything with it // And make sure I use some hokey html attributes to edit it instead of doing some // real editing in my php when I read it in, if I ever figure out how. // And why use a number field to display something called "itemname"?? echo " <td>{$rowww['itemName']}</td> <td> <form action=''> <input type='number' id='quantity' name='quantity' min='1' max='50' style='width:3em;'> </form> </td> "; // The end of my display of ONE item all by itself that no web browser is ever going to display } Sorry for being so harsh but you made absolutely no sense. Are you asking for help with a problem or showing us how you would do it? Really hard to tell from the way you posted this. Barand told you as much. I just went a lot further. Call me irritable.

If what you have posted here is all there is, why are you using a function at all?

Have you opened the original file BEFORE the download to see what is at position 496 perhaps?

Have you debugged the code to ensure that the values you are using are exactly what you expect? How about the filesize value?

People here LIKE TO READ actual code, not look at hard to makeout pictures. Take the hint. And try and limit the code to what you think is the problem area. We don't need to see all your html or all of your css or even your js if it doesn't pertain.

Obviously it is telling you that you are using an array that does NOT have any element named txt_email or txt_password or txt_role. So - how is your code being developed to be looking for those items? Study your pictures and see if you can make out a solution. Or you could look at the actual code, which you didn't want to share with us.

In the long run I would think that brushing up on you db design skills and your mysql writing skills would be a much better path. Playing with data (which is what you are saying) in arrays gets you nowhere since you can't save the results. Updating a db gives you lasting results.

Gee, that's too bad.... No sympathy here. I took classes to learn.

Do you really think that people here are going to DO your homework for you? What good would that be for you? You won't learn anything from it.

"on the test"? Is this 'homework' for your class perhaps? In that case, YOU have some work to do, not us.

Never had a need to do that kind of 'design'. Sounds scary. And - just what kind of users will you allow to change it up? What's to keep one user from changing another user's changes?

When showing us code samples it is generally done using the <> icon and pasting actual code (not an image, etc.) for us to manipulate. So - you have parts of your website and you need help with a single sript/screen. So as Barand has asked already, What Is The Issue?

You have the website written already. What does that mean? To me that tells me that you have all your pages complete as well as any data source management. So - what's left to do since you have said it is done?

I have to ask this, since you are apparently heavily involved in using arrays and don't understand how to work with them. Is all the data you are manipulating stored in a database? And if that is true, why do you even need these arrays when you have a permanent store of your data that a simple query will produce whatever output you want?

PDO is nothing to pick up. It is real easy to use and simpler than mysqli. (call your connection function to create the pdo handle) $pdo = PDOConnect($db_name); // do the connection and assign the database name // write your query separately to make it easier to echo should you need to debug it // This should happen outside of any loop you may be doing on your db $q = "insert into MyTable (order_number, column1, column2, column3) values(:ord_num, :col1, :col2, :col3)"; $qst = $pdo->prepare($q); // define the arguments you used in your query here which would be inside of any loop you are using to update the table $parms = array( 'ord_num'=>$sel_id, 'col1'=>$value1, 'col2'=>$value2, 'col3'=>$value3 ); // now run the query with the current values assigned, testing for the result at the same time if(!$qst=>execute($parms)) { (show an error message here) (leave script or whatever) } // done with any loop doing the querying // continue with handling query results now If you want I'll post my sample connection script.

100 line script? Why don't you post it here?

We've presented our opinion on PDO already. To no avail.

YOu are returning the max of id from your function but then using it (it seems) as the overno value instead of the id value.

How about this for the test portion: $item['did_ivr_disable'] === 0 ? 'Disabled' : 'Enabled'

Since we don't know what it does and there don't seem to be very many comments and the use of meaningless variable names, we would be committing a lot of time to help you out.

If this is some 3rd party code then why not get them to help you with it?

You are running something from your web browser, yes? What is the name and location of that script from the address bar? Use your editor to open up that script. Start reading it and look for that query mentioned in the error message box and copy the lines leading up to it and paste them into a a post here. Be sure to place them in the proper code box triggered by the <> icon above your message. This will help us to see what you are doing and perhaps point out the issue. If you cannot do any of this then perhaps you need to step away and get someone else to solve this on your end. We are not here to do your tasks, only to help you do them.

Show us the code around where the error message is coming from.

Looking at that (blurry) message text it seems that you have a column named "pid" that you are trying to set to nothing as in "set pid='' ". As Barand has told you it looks like an integer (an id of some sort ?) and your table definition does not allow that. Either modify the structure of your table or supply a valid id value for that record