HP ProCurve Port Mode Configuration Question Mark 2

Question

There are plenty of questions and answers to this like this question but I can't find any that actually use it in a MYSQL query. I need to query the database based on certain amount of days between now and a date in the table. I now there are ways to do math in mysql queries but don't quite know how to begin.

Any suggestions how to do this with PHP and mysql?

Sorry for not mentioning it, my date field is unix timestamp. So how do I accomplish that with that format?

Solution

There is no half-duplex in GigE - so set them to 1000-auto (its the same as 1000-full), also being GigE ports they should Autoneg perfectly fine removing the need to hardcode them at 1000, the days of vendors ended with GigE, Auto negotiation is a requirement for using 1000BASE-T according to the specs - as GigE works in a Master/Slave setup and they have to negotiate that. Why are you having to hardcode their speeds ?

Comments

[Panama Jack]

I forgot to mention my field is unix timestamp. How can that be done?

[Panama Jack]

I forgot to mention my field is unix timestamp. How can that be done?

[Panama Jack]

Thanks for the help. I know should use unix timestamp but that how it was made and it's easier to manipulate with PHP. Don't know if I can convert it but I have til 2038 until I have to worry about it. LOL