close but no cigar- subtracting the difference between two timestamp fields

[webguync]

still getting the 3 results for every one record and an example result is...

53.466666666667 minutes AKA 00 seconds

[webguync]

any other ideas on why I can do to debug my problems?

[PFMaBiSmAd]

Your two queries (on the same table by the way) have nothing in them to relate the results from the first query to the second query and in fact you are re-executing the second query every time you fetch a row from the first query's result set.

 

You need to execute ONE query that gets all the data you want and then simply loop though that data and display it.

[webguync]

that makes sense, but can I combine the two queries the way I am currently pulling the timestamp data? (SELECT TIMESTAMPDIFF)

[PFMaBiSmAd]

Of course you can. It's all the same data in each row.

[webguync]

can anyone provide what that query should look like?

[MadTechie]

I didn't expect this thread to still be going!

 

You should be able to just use the example code on page 1  just add the extra fields in the select

ie

SELECT Responses.name,Answer1,Answer2,Answer3,Answer4,Answer5,Answer6,Answer7,Answer8,Answer9,Answer10,Answer11,Answer12,
TIMESTAMPDIFF(SECOND,submit_timestamp,login_timestamp) as cTime
FROM Responses
LEFT JOIN Candidates
USING (user_id)

[webguync]

thanks, will give that a try! Hopefully that will solve the problem.