Recent content by spamjim

Yes, you are overlooking something simple. When you run UPDATE, it automatically steps through each row if you have not limited the statement or added a condition that restricts the update to one row. It may help to further explain your intended update.

There's nothing in your HTML that includes the Verdana font. The HTML only suggests the Verdana font if it is installed on the system. If the system does not have Verdana, it falls back to any sans-serif font. Verdana is typically installed with Microsoft applications, such as Office. You may...

Adding another option if one cannot go back to the Linux or Mac system... On Windows, you can use the free version of Recuva, a file restoration utility. One of the features of this program is to sanitize filenames while copying from a "bad" drive to a good drive. In the Recuva preferences...

I've apparently never crafted the proper google query in the past 25 years that I've fought this issue. It looks like I can resolve this with detox. https://linux.die.net/man/1/detox

I have a few USB portable NTFS drives that have also been used on Mac and Linux systems, via fuse and other native OS accommodations. When I reconnect a portable drive to a Windows system, I discover that the Mac and Linux systems did not fully follow the rules for NTFS filenames. While copying...

Why would your teacher give this assignment without teaching how to do it?

It loads once in my browser because I have JS turned off for unfamiliar web sites. Examine your JS. You can also us the network tab in your browser's developer tools (F12) to see what's happening.

There is the additional benefit of accessing this second drive on a system that isn't actively trying to back up more data to it. Running an alternative OS (through this live USB) or taking the second hard drive to another computer offers many opportunities.

I'm not following either example file. You might try sharing 3 rows that show sample source data and then enter example values in columns K, L for what you want to obtain from a vlookup. If you have 11 rows of data, your vlookup in L2 might be "=VLOOKUP(H2,$D$2:$I$12,6,FALSE)" ...but even...

You are probably bumping into a conflict with a reserved word ("name"): https://dev.mysql.com/doc/refman/8.0/en/keywords.html Employ the backtick: ` Instead of: $queryResult = $g_dbFindATradie->query("SELECT id, name, description FROM trades ORDER BY name"); Try: $queryResult =...

While it may not be exposed on the internet, its local connection to other computers could invite exploit. How trustworthy are those other systems? Can ransomware spread from those other systems?

This forum is barely trafficked. You will probably get better feedback on Adobe's user forums. As a general tip, it is best to avoid PDF forms for data collection. Most people really want web-based forms, even if they don't realize it yet. A web based form can better manage data and may even...

Great! Now you can take it a step further by using prepared statements (or other data sanitation methods) to avoid SQL injection.

Focus on the query, not the PHP. There's even a Tek-Tips forum to focus on MySQL. [bigsmile] https://www.mysqltutorial.org/mysql-left-join.aspx SELECT `order_id`, `customer_id`, `order_item`, `order_date`, `order_value`, `customer_name` FROM `tbl_order_id` LEFT JOIN `customers` ON...

My DVD player on Windows 11 uses the very same keyboard shortcuts I use in VLC media player, and on any other platform. It makes it very convenient that I don't need to remember different sets of shortcuts when I am on different computers. https://wiki.videolan.org/QtHotkeys/ If this was not...