Member Avatar for super9876

Hi. I'd like to add time (and no date, and not a timestamp) data to a field in MySQL through a PHP form. I've been having problems, as the date is also included. But I only want the time (I want to be able to sort the data by the time, and I think it was adding today's date along with the time, so if I enter the data on 5 different days, it won't sort correctly).

PHP Insert Code:
.strtotime($event_start_date).

MySQL field:
Type: INT
Length/Values: 10
Default: None
Collation:
Attributes: Unsigned
Everything else empty

Can anyone help with:
1) what should the php insert code be
2) what the field type, attributes, length/values, etc should be

Thanks!

  • 2 Contributors
  • 2 Replies
  • 165 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by super9876
Member Avatar for super9876

Thanks Catherine. I'll play around with that and see if it works for me.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.