I have a table of questions, and a table of responses (initially empty)
which gets updated every time an answer is submitted, with the question
number, member id and response.
I wish to produce a SELECT query that will find the questions that haven't
been answered by a particular member, i.e. a
; - Also "" is not NULL - be sure you blank fields are NULL and not ""
> - A clever way to search for both "" and NULL in the same query is:
>
> SELECT * FROM foo WHERE NOT bar > ""
>
> This may not work in all DBMS's but give it
Have you tried something like:
$last_access=now();
$update_query = "UPDATE guestbook SET last_access='$last_access' WHERE
guest_id='$guest_id'";
Otherwise...
have you tried entering the query manually (e.g. with phpmyAdmin, etc.)
using a relevant guest_id:
UPDATE guestbook SET last_access='NOW(
Philip,
I don't really see the problem with Arash's post.
If people want to help him out with critique, then that's their option.
This board is hardly swamped with similar postings, is it?
Robin Mckenzie
"Philip Olson" <[EMAIL PROTECTED]>