[SOLVED] MySQL Store every login dates and times

[roopurt18]

Call mysql_query() inside the loop after assigning to $sql; that will make multiple calls to the database though.

 

With a small amount of cleverness you can do it with a single call.

 

This will insert three rows into the table `table`.

INSERT INTO `table` (`col1`, `col2`) VALUES
  ('a', 'a'),
  ('b', 'b'),
  ('c', 'c')

[samona]

I checked that code and it works.  However, I don't understand how it works.  How would $sql be able to submit all those tasks in the database with only one command?  Does it have to do with some special property arrays (checkbox) have?

[samona]

ok i got it, thx

[samona]

I'm trying to do a left join to get tasks that were not completed. However, the query gives me tasks that were completed as well as tasks that were not completed.  How, do I get only tasks that have a NULL Value.  My code is below: 

 

 

Select Task.Description, task_user.created From Task
LEFT JOIN task_user ON Task.Task_ID = task_user.task_ID
AND DATE_FORMAT(task_user.created, '%Y %m %d') = DATE_FORMAT(CURDATE(), '%Y %m %d')  

[roopurt18]

Append this:

WHERE `task_user`.`created` IS NULL

[samona]

It worked perfectly.  Thanks! 

[roopurt18]

It worked perfectly.  Thanks! 

 

I'm glad to hear it.  Do you understand why?

[samona]

Yeah, because we are using a conditional which evaluates whether it is NULL (no value)