SirCobalt

Age: 24

Heard of Stack Exchange through a friend, but just recently started using it for some projects I was thinking of undertaking!

Apr
6
awarded Notable Question
Jan
6
awarded Popular Question
Dec
27
awarded Notable Question
Oct
21
asked Checking disk file usage via CLI on Nitrous.IO
Oct
21
awarded Supporter
Oct
21
asked Opening files to edit in Nitrous IDE via CLI
Jun
20
accepted Are Hardcore characters gone forever if they die in PvP?
Jun
6
awarded Yearling
Jun
6
awarded Yearling
Jun
6
awarded Yearling
Jan
14
awarded Scholar
Jan
14
accepted PHP PDO usage with MySQL BETWEEN and INET_ATON()
Jan
14
answered PHP PDO usage with MySQL BETWEEN and INET_ATON()
Jan
14
comment PHP PDO usage with MySQL BETWEEN and INET_ATON()
Thanks for providing an answer, however I resolved this issue and it ended up being a separate section of code, and not the passing of values to the SQL query and binding them. Also, the value stored as $k was the equivalent of :value.
Jan
14
comment PHP PDO usage with MySQL BETWEEN and INET_ATON()
After some time away from the keyboard, and a day of debugging, I finally fixed this. It was actually an issue with a different section of the code and not the part passing values to the SQL query. Thanks all for the responses! @MarcB I was passing IPv4, no IPv6 (yet) so that will be a beast to tackle another time.
Jan
11
comment PHP PDO usage with MySQL BETWEEN and INET_ATON()
I'm not sure what is causing this to fail then. I can get it to run perfectly fine if I run the query for a single IP address (ie: AND ip_address = INET_ATON(:ip); ). It's only when I use the BETWEEN clause with the function that it does not return any results.
Jan
11
awarded Custodian
Jan
11
reviewed Approve suggested edit on PHP PDO usage with MySQL BETWEEN and INET_ATON()
Jan
11
asked PHP PDO usage with MySQL BETWEEN and INET_ATON()
Jan
9
awarded Popular Question
1 2 3 4 5