PD> <?php
PD>  $answers="$band, $middlename, $pot";
PD>  $date=date ("l dS of F Y h:i:s A");
PD>   $sql = "INSERT INTO prizeline (id, email, name, address, answers, date) VALUES 
('', '$email', '$name', '$address', '$answers', '$date')";
PD>   echo $sql;
PD>   mysql_query($sql) or die ("There has been an error");
PD> ?>

If this is all of your script, then you are missing those pesky
"connect to server" and "select database" functions.

If you replace your die message with die(mysql_error()) you will
probably see a very helpful error message such as "no database
selected" or "hey buddy, not connected".

- Julie

--> Julie Meloni
--> www.thickbook.com

Find "Sams Teach Yourself MySQL in 24 Hours" at

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to