Search Results

When you do a query, it returns the result set to the variable as rows. Even if it's just one value in one row, you need to extract the data. $rows = query("SELECT symbol, shares FROM portfoli …

A select statement can always potentially return multiple results, either expected, or because there may be a problem with the data (corrupt database, entry error, etc.), so the process always returns …

Asked and answered in comments. If this answers your question, please click on the check mark to accept. Let's keep up on forum maintenance. ;-) Can you clarify what you mean by "What if price if …

Asked and answered in comments. If this answers your question, please click on the check mark to accept. Otherwise, it'll sit in the unanswered question pool forever. Let's keep up on forum mainten …

Sure. Use the UPDATE sql command, It'll take the form of "UPDATE table SET some value WHERE some_condition". Google sql update For example: UPDATE users SET firstname = "Fred", lastname = "Derf" WH …

It looks like stock is the symbol for the stock in the database, and it is being assigned to both the name and symbol. for purchase in purchases: stock = purchase["stock"] ... purchase['s …

All very good questions and observations. Kudos for thinking about them all. In the real world, this would be very critical. However, this is an implementation of a stock trading website - a simulat …

SQL code is a bit different from programming language syntax. Here's a template to give you an idea how to do what you want. You'll have to change the appropriate vars and values for your needs. ;- …

You're selecting ROWS from a database table, not columns. In short, you're selecting every row from a given table where the value of the column is equal to the given value. Or, in other words, you'r …

The code would need to do a select on the table to find out how many shares are owned and then update the value. In this method, you need to do a SELECT from the table to find out if the user owns the …

Shot in the dark: if dbshares[0]['shares'] - shares < 0: The precedence order has "<" over "-". That means that "shares < 0" is being evaluated first. Maybe try adding parentheses? if (dbshares …

Before I answer, here's a pillow for your forehead so that you don't hurt yourself when you slap it! ;-) It's DELETE FROM, not DELETE * FROM. Just remove the *. And, no, deleting each column indiv …

Well, if I had to guess, I'd say there's a problem with your per share price. check50 reports that it's looking for 112.00 but your screen shot is showing 133.77. Where are you getting your per shar …

Yes, you are wrong. But it's not an unreasonable assumption. A Primary Key is literally the primary restriction on data of a table. It puts restrictions on duplicate data on the table. But there's …

how about toupper(in c) or upper(python)? Best practice is to convert every symbol to uppercase before putting it into a table and before trying to do a search on a symbol. BTW, isupper only check …