Other Software > Developer's Corner

MySQL Syntax Question

<< < (2/2)

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