In message <[EMAIL PROTECTED]>, kab62uk <[EMAIL PROTECTED]> writes >Hi there - y as I might I cant seem to get this to work. I have a >mysql database,am using phpmyadmin,and dwmx2004. >I have a table - tasks with a colum Priority. >I have set this up as ENUM yes or no and the default to no >(PHPmyadmin insists I have a default in there) >Ok in my php page I have the following for the form > > <input name="Priority" type="checkbox" id="Priority" >value="yes"></td></tr> > > >However when a user checks the box it doesnt seem to pass the value >yes to mysql database - the output page just has no in it the >default value!
The default value is in the output page, or in the database? On the output page, I don't see where you get 'no' from - your results on your output page should be 'yes' when checked, and '' when not checked. Have you checked what is in $Priority on the second page (or second sweep)? If you are not collecting the value correctly there, then you cannot be passing it into the INSERT command. I would try: echo "<P>Priority:$Priority:</P>"; to see what is happening - the ':' helps you to see exactly what is there. -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
