Welcome Guest, Not a member yet? Register   Sign In
help with mysql query
#1

[eluser]quasiperfect[/eluser]
hi

i have a table that contains : visitor id (int),visited id(int), when (timestamp), seen (tiny int 0 or 1)

is possible to insert (using one single query) only one visit ?
if so can you be so kind to post the table, and query sql ?
i tried with insert ignore and with on duplicate key but no luck because the date has to be a timestamp not only the year-month-day




Theme © iAndrew 2016 - Forum software by © MyBB