Webmaster Forum / PHP / Database Access / November 2003

I have the following 2 tables
+++++++++++
emailnotification
+++++++++++

Below some code where i have a problem with $dt
In mysql i configured the field datumtijd as date type
Problem: each time when i try to insert $dt into datumtijd, always the field
datumtijd remains on 0000-00-00

I have a problem , I can' t create database with command :

if I write this

I have a dynamic table within Dreamweaver / PHP, how can i only have the
CONTENTS of the table scrolling, not the column titles?
Regards,
Darren

Is there a simple way to create a query log for mySQL? I've been
asked^h^h^h^h^h told to add a layer of auditing on an existing
application. It's unlikely that this audit log will ever be looked at so
a listing of sql queries would probably suffice (it'll be big enough to

I have a VERY basic call logging system, and would like to add notes to a
call. how can this best be done? my tables just have a unique record number
(primary key), enginner name, date and notes (blob).
i just want to be able to add notes to a call, without creating a new call.

In my MySQL-DB I have a field "birthdate" and now i want a script who
calculate the age of the member...
If there is in the field "31-08-1981" for example
I want to have on my page:

I'm deleting records from a table using a simple 'delete from table
where something=$x' but need to know how many records have been deleted.
How can I do it? I've tried looking at the php.net site but all I'm
getting at the moment is 'cannot locate remote server' :-(

I think I know the answer to this, but suggestions welcomed.
I have to store lots of information. An electricity reading every half
hour for hundreds of meters for several years.
The ways I thought of storing this in SQL were:

Hi...
I'm relatively a newbie at databases. I need to know if it's good or bad to
have tables named after this sort of convention:
page_01

I have installed mysql and then tested it. It was OK.
Then I ran this command:
C:\> C:\mysql\bin\mysql mysql
mysql> DELETE FROM user WHERE Host='localhost' AND User='';

This script works well at my old ISP. Visitor at my website can fill
in any of the fields in a from and get back the data requested. Now I
have moved my site to a new ISP and now the script give prints out
data each time!?

I have a web page where certain pages have to be opened in a certain order
and should only be available when the user openes them in HTTPS.
They are all forms and the form action sends you to the next https:// page
but you can also take the S out of https:// and it opens also.  ...

$qu="INSERT INTO PRSpics set
userskee=\"$userskee\",note=\"{$_POST["note"]}\",title=\"{$_POST["title"]}\"
,keywords=\"{$_POST["keywords"]}\",category=\"{$_POST["category"]}\"; UNION
UPDATE users SET points=\"points+2\" WHERE userskee=\"$userskee\"";

Hi, All !
I'm looking for some info about design patterns in PHP.
Did somebody used it and can share his impression.
Thanks.