Other Software > Developer's Corner
MySQL Syntax Question
mouser:
--- Code: Text ---SELECT * FROM table WHERE id LIKE '$id'
Just make sure before you change it to an = that the $id variable is never used with % inside it to do a wildcard search.
Stoic Joker:
--- Code: Text ---SELECT * FROM table WHERE id LIKE '$id'
Just make sure before you change it to an = that the $id variable is never used with % inside it to do a wildcard search.
-mouser (October 18, 2017, 11:29 AM)
--- End quote ---
Oh I passed that point months ago (been on this since April) ... It just finally got to me this morning. One of the other more glaring bits was a 1 page report that took almost 3 minutes to generate because of how badly it was coded. Now that same report only takes 300ms.
Hope you're getting paid hourly...
-wraith808 (October 18, 2017, 11:22 AM)
--- End quote ---
rofl ... Nope - Bid flat rate for job - This is what's technically referred to as a huge fucking mistake.
wraith808:
Hope you're getting paid hourly...
-wraith808 (October 18, 2017, 11:22 AM)
--- End quote ---
rofl ... Nope - Bid flat rate for job - This is what's technically referred to as a huge fucking mistake.
-Stoic Joker (October 18, 2017, 01:13 PM)
--- End quote ---
Vodka. Lots of Vodka. Might not make you feel better about it, but it will make you not care. ;D
Navigation
[0] Message Index
[*] Previous page
Go to full version