Lowyat.NET: Latest topics by cdrw87 http://forum.lowyat.net/ Mon, 28 Sep 2026 14:38:11 +0800 FeedCreator 1.7.2 Add field http://forum.lowyat.net/topic/1166541 hi,i have a question ,<br />how can i add new field ?<br />i want to add 2 more field name &#39;starts&#39; and &#39;ends&#39;.<br />anyone can guide ?<br /><br />this is my current table :<br /><br /><!--SPOILER BEGIN--><div class="spoilertop" onClick="openClose('993a8afac5809bba9a655e808c93d05e')" style="font-weight: bold"><u>&raquo; Click to show Spoiler - click again to hide... &laquo;</u></div><div class="spoilermain" id="993a8afac5809bba9a655e808c93d05e" style="display:none"><!--SPOILER END--><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1-->+------------+--------------+------+-----+---------+----------------+<br />| Field &nbsp; &nbsp; &nbsp;| Type &nbsp; &nbsp; &nbsp; &nbsp; | Null | Key | Default | Extra &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />+------------+--------------+------+-----+---------+----------------+<br />| ID &nbsp; &nbsp; &nbsp; &nbsp; | int&#40;11&#41; &nbsp; &nbsp; &nbsp;| NO &nbsp; | PRI | NULL &nbsp; &nbsp;| auto_increment |<br />| sname &nbsp; &nbsp; &nbsp;| varchar&#40;255&#41; | NO &nbsp; | &nbsp; &nbsp; | NULL &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| department | varchar&#40;255&#41; | NO &nbsp; | &nbsp; &nbsp; | NULL &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| rooms &nbsp; &nbsp; &nbsp;| varchar&#40;255&#41; | NO &nbsp; | &nbsp; &nbsp; | NULL &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| purpose &nbsp; &nbsp;| varchar&#40;255&#41; | NO &nbsp; | &nbsp; &nbsp; | NULL &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| equipment &nbsp;| varchar&#40;255&#41; | NO &nbsp; | &nbsp; &nbsp; | NULL &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| start &nbsp; &nbsp; &nbsp;| varchar&#40;255&#41; | NO &nbsp; | &nbsp; &nbsp; | NULL &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| tstart &nbsp; &nbsp; | varchar&#40;255&#41; | NO &nbsp; | &nbsp; &nbsp; | NULL &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| end &nbsp; &nbsp; &nbsp; &nbsp;| varchar&#40;255&#41; | NO &nbsp; | &nbsp; &nbsp; | NULL &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| tend &nbsp; &nbsp; &nbsp; | varchar&#40;255&#41; | NO &nbsp; | &nbsp; &nbsp; | NULL &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| dd &nbsp; &nbsp; &nbsp; &nbsp; | varchar&#40;255&#41; | NO &nbsp; | &nbsp; &nbsp; | NULL &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| mm &nbsp; &nbsp; &nbsp; &nbsp; | varchar&#40;255&#41; | NO &nbsp; | &nbsp; &nbsp; | NULL &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />| yyyy &nbsp; &nbsp; &nbsp; | varchar&#40;255&#41; | NO &nbsp; | &nbsp; &nbsp; | NULL &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br />+------------+--------------+------+-----+---------+----------------+<!--c2--></div><!--ec2--><!--SPOILER DIV--></div><!--SPOILER DIV--><br /><br /> cdrw87 Codemasters Thu, 17 Sep 2009 14:19:16 +0800 form wont update http://forum.lowyat.net/topic/1159930 i&#39;ve have problem with this form , can anyone help ?<br /><br />and this is my code :<br /><br /><!--SPOILER BEGIN--><div class="spoilertop" onClick="openClose('a99d23ffb1f29557b9197e3d02d10249')" style="font-weight: bold"><u>&raquo; Click to show Spoiler - click again to hide... &laquo;</u></div><div class="spoilermain" id="a99d23ffb1f29557b9197e3d02d10249" style="display:none"><!--SPOILER END--><!--QuoteBegin--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--QuoteEBegin-->&lt;html&gt;<br />&lt;head&gt;<br />&lt;head&gt;&lt;title&gt;Form&lt;/title&gt;&lt;/head&gt;<br />&lt;body bgcolor=&quot;#E8E8E8&quot;&gt;<br /><br />&lt;center&gt;<br /><br />&lt;table border=&quot;1&quot; width=&quot;800&quot;&gt;<br />&lt;tr&gt;<br />&lt;td align=&quot;center&quot;&gt;&lt;font size =&quot;8&quot; color=&quot;purple&quot;&gt;Room Reservation System&lt;/font&gt;<br />&lt;/td&gt;<br />&lt;/tr&gt;<br />&lt;/table&gt;<br />&lt;/center&gt;<br />&lt;br&gt;<br />&lt;br&gt;<br />&lt;br&gt;<br />&lt;center&gt;<br />&lt;fieldset style= &quot;width:650px&quot;&gt;<br />&lt;legend align=left&gt;&lt;font color=&quot;blue&quot; face=&quot;verdana&quot;&gt;Booking Form&lt;/font&gt;&lt;img border =&quot;0&quot; src =&quot;user.gif&quot;&gt;&lt;/legend&gt;<br />&lt;form method=&quot;post&quot; action=&quot;&quot;&gt;<br />&lt;br&gt;<br />&lt;table border=&quot;0&quot;&gt;<br />&lt;tr&gt;<br />&lt;td&gt;Staff Name&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;&lt;input type =&quot;text&quot; name=&quot;sname&quot; &gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br /><br />&lt;tr&gt;<br />&lt;td&gt;Staff Department&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;&lt;input type =&quot;text&quot; name=&quot;department&quot; &gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br /><br />&lt;tr&gt;<br />&lt;td&gt;Room Name&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;<br />&lt;select name=&quot;rooms&quot;&gt;<br />&lt;option value=&quot;0&quot; selected=&quot;true&quot; disabled&gt;Select Room . . .&lt;/option&gt;<br />&lt;option&gt;Room 1&lt;/option&gt;<br />&lt;option&gt;Room 2&lt;/option&gt;<br />&lt;option&gt;Room 3&lt;/option&gt;<br />&lt;/select&gt;<br />&lt;/td&gt;<br />&lt;/tr&gt;<br /><br /><br />&lt;tr&gt;<br />&lt;td&gt;Meeting Purpose&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;&lt;textarea name=&quot;purpose&quot; rows=&quot;10&quot; cols=&quot;30&quot;&gt;&lt;/textarea&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br /><br /><br />&lt;tr&gt;<br />&lt;td&gt;Equipment&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;<br />&lt;input type=&#39;radio&#39; name=&quot;equipment&quot; value=&quot;Projector M1&quot;&gt; Projector M1<br />&lt;br&gt;<br />&lt;input type=&#39;radio&#39; name=&quot;equipment&quot; value=&quot;Projector M2&quot;&gt; Projector M2<br />&lt;br&gt;<br />&lt;input type=&#39;radio&#39; name=&quot;equipment&quot; value=&quot;Null&quot;&gt; Null<br />&lt;/td&gt;<br />&lt;/tr&gt;<br /><br /><br />&lt;tr&gt;<br />&lt;td&gt;Date Book&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;&lt;input type=&quot;text&quot; size=&quot;2&quot; maxlength=&quot;2&quot; name=&quot;dd&quot; &gt;&lt;font size=&quot;1&quot;&gt;DD&lt;/font&gt;<br />&lt;input type=&quot;text&quot; size=&quot;2&quot; maxlength=&quot;2&quot; name=&quot;mm&quot; &gt;&lt;font size=&quot;1&quot;&gt;MM&lt;/font&gt;<br />&lt;input type=&quot;text&quot; size=&quot;4&quot; maxlength=&quot;4&quot; name=&quot;yyyy&quot;&gt;&lt;font size=&quot;1&quot;&gt;YYYY&lt;/font&gt;<br />&lt;/td&gt;<br />&lt;/tr&gt;<br /><br /><br /><br />&lt;tr&gt;<br />&lt;td&gt;Time Start&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;<br />&lt;input type =&quot;text&quot; name=&quot;start&quot; size=&quot;2&quot; maxlength=&quot;5&quot;&gt;<br />&lt;input type=&#39;radio&#39; name=&quot;tstart&quot; value=&quot;am&quot;&gt;am<br />&lt;input type=&#39;radio&#39; name=&quot;tstart&quot; value=&quot;pm&quot;&gt;pm<br />&lt;/td&gt;<br />&lt;/tr&gt;<br /><br /><br />&lt;tr&gt;<br />&lt;td&gt;Time End&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;<br />&lt;input type =&quot;text&quot; name=&quot;end&quot; size=&quot;2&quot; maxlength=&quot;5&quot; &gt; <br />&lt;input type=&quot;radio&quot; name=&quot;tend&quot; value=&quot;am&quot;&gt;am<br />&lt;input type=&quot;radio&quot; name=&quot;tend&quot; value=&quot;pm&quot;&gt;pm<br />&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br /><br />&lt;tr&gt;<br />&lt;td&gt;&lt;input type =&quot;submit&quot; value=&quot;Booking&quot; name=&quot;book&quot;&gt;&lt;/td&gt;<br />&lt;td&gt;&lt;/td&gt;<br />&lt;td&gt;&lt;input type=&quot;reset&quot; onClick=&quot;return confirm(&#39;Reset Form ?&#39;)&quot;&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;/center&gt;<br />&lt;/table&gt;<br />&lt;/form&gt;<br />&lt;/fieldset&gt;<br />&lt;/body&gt;<br />&lt;/html&gt;<br /><br /><br />&lt;?php<br /><br /><br />if (&#036;_POST[&#39;book&#39;] == &quot;Booking&quot;) <br />{<br /><br /><br />&#036;sname = &#036;_POST[&#39;sname&#39;];<br />&#036;department = &#036;_POST[&#39;department&#39;];<br />&#036;rooms = &#036;_POST[&#39;rooms&#39;];<br />&#036;purpose = &#036;_POST[&#39;purpose&#39;];<br />&#036;equipment = &#036;_POST[&#39;equipment&#39;];<br />&#036;dd = &#036;_POST[&#39;dd&#39;];<br />&#036;mm = &#036;_POST[&#39;mm&#39;];<br />&#036;yyyy = &#036;_POST[&#39;yyyy&#39;];<br />&#036;start = &#036;_POST[&#39;start&#39;];<br />&#036;tstart = &#036;_POST[&#39;tstart&#39;];<br />&#036;end = &#036;_POST[&#39;end&#39;];<br />&#036;tend = &#036;_POST[&#39;tend&#39;];<br /><br /><br />&#036;conn = @mysql_connect(&quot;localhost&quot;,&quot;root&quot;,&quot;&quot;);<br /><br />//Select the MySQL database<br /><br />&#036;db = @mysql_select_db(&#39;bookings&#39;, &#036;conn);<br /><br /><br />//SQL Statement<br />&#036;sql = &quot;INSERT INTO booking &quot; .<br />&quot;(sname,department,rooms,purpose,equipment,dd,mm,yyyy,start,tstart,end,tend)<br />VALUES (&#39;&#036;sname&#39;, &#39;&#036;department&#39;, &#39;&#036;rooms&#39;, &#39;&#036;purpose&#39;,<br />&#39;&#036;equipment&#39;, &#39;&#036;dd&#39;, &#39;&#036;mm&#39;, &#39;&#036;yyyy&#39;, &#39;&#036;start&#39;, &#39;&#036;tstart&#39;, &#39;&#036;end&#39;, &#39;&#036;tend&#39;)&quot;;<br /><br /><br />//Execute SQL Statement and store results as a recordset<br /> <br />&#036;rs = @mysql_query(&#036;sqlstring,&#036;conn);<br /><br />//Verify that the record is inserted<br /><br />if (mysql_affected_rows(&#036;conn) == -1)<br /><br />{<br /><br />echo &quot;An error has occured. Record insert failed&quot;;<br /><br />}<br /><br />else<br /><br />{<br /><br />echo &quot;Record inserted successfully&quot;;<br /><br />}<br /><br />mysql_close(&#036;conn);<br /><br />}<br /><br />?&gt;<br /><br /><!--QuoteEnd--></div><!--QuoteEEnd--><!--SPOILER DIV--></div><!--SPOILER DIV--><br /><br />anyone can help ? <!--emo&:hmm:--><img src='http://static.lowyat.net/style_emoticons/default/hmm.gif' border='0' style='vertical-align:middle' alt='hmm.gif' /><!--endemo--><br /><br />[addedon]September 17, 2009, 12:49 pm[/addedon]- solved - cdrw87 Codemasters Fri, 11 Sep 2009 11:47:28 +0800 Event Caledar http://forum.lowyat.net/topic/1127320 can someone provide me a good link for event calendar tutorial ?<br />thanks in advance . . <!--emo&:help:--><img src='http://static.lowyat.net/style_emoticons/default/icon_question.gif' border='0' style='vertical-align:middle' alt='icon_question.gif' /><!--endemo--> cdrw87 Codemasters Wed, 12 Aug 2009 10:11:25 +0800 php save data to ms access http://forum.lowyat.net/topic/1120857 i have created a form for user to key in the data for registration , but the data won&#39;t update to database.<br />i&#39;m using vista and run from iis localhost ..<br />here is my code<br /><br /><!--SPOILER BEGIN--><div class="spoilertop" onClick="openClose('cb95242e6eb7a61198b0d865345183b0')" style="font-weight: bold"><u>&raquo; Click to show Spoiler - click again to hide... &laquo;</u></div><div class="spoilermain" id="cb95242e6eb7a61198b0d865345183b0" style="display:none"><!--SPOILER END-->&lt;html&gt;<br />&lt;head&gt;<br />&lt;title&gt;Welcome To Registration&lt;/title&gt;<br />&lt;/head&gt;<br />&lt;body bgcolor=&quot;#E8E8E8&quot;&gt;<br /><br />&lt;center&gt;<br /><br />&lt;table border=&quot;1&quot; width=&quot;800&quot;&gt;<br />&lt;tr&gt;<br />&lt;td align=&quot;center&quot;&gt;&lt;font size =&quot;8&quot; color=&quot;purple&quot;&gt;Room Reservation System&lt;/font&gt;<br />&lt;/td&gt;<br />&lt;/tr&gt;<br />&lt;/table&gt;<br />&lt;br&gt;<br />&lt;/center&gt;<br /><br /><br />&lt;p&gt;&lt;marquee&gt;&lt;b&gt;Register Form&lt;/b&gt;&lt;/marquee&gt;&lt;/p&gt;<br /><br />&lt;br&gt;<br />&lt;br&gt;<br /><br />&lt;center&gt;<br />&lt;fieldset style= &quot;width:500px&quot;&gt;<br />&lt;legend align=left&gt;&lt;font color=&quot;blue&quot; face=&quot;verdana&quot;&gt;Register <br /><br />Form&lt;/font&gt;&lt;img border =&quot;0&quot; src =&quot;reg1.png&quot;&gt;&lt;/legend&gt;<br /><br />&lt;form method=&quot;post&quot; action=&quot;register done.php&quot;&gt;<br />&lt;br&gt;<br />&lt;font color=&quot;orange&quot;&gt;&lt;b&gt;Registration Information&lt;/b&gt;&lt;/font&gt;<br />&lt;br&gt;<br />&lt;table border=&quot;0&quot;&gt;<br />&lt;center&gt;<br />&lt;tr&gt;<br />&lt;td&gt;Username&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;&lt;input type =&quot;text&quot; name=&quot;uname&quot;&gt;&lt;/input&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td&gt;Password&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;&lt;input type =&quot;password&quot; name=&quot;pword&quot;&gt;&lt;/input&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td&gt;Re Type Password&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;&lt;input type =&quot;password&quot; name=&quot;repword&quot;&gt;&lt;/input&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td&gt;E-mail Address&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;&lt;input type =&quot;text&quot; name=&quot;email&quot;&gt;&lt;/input&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td&gt;Re Type E-mail Address&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;&lt;input type =&quot;text&quot; name=&quot;remail&quot;&gt;&lt;/input&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br />&lt;/table&gt;<br /><br />&lt;br&gt;<br /><br /><br />&lt;font color=&quot;orange&quot;&gt;&lt;b&gt;Profile Information&lt;/b&gt;&lt;/font&gt;<br /><br /><br />&lt;table border=&quot;0&quot;&gt;<br />&lt;tr&gt;<br />&lt;td&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td width=&quot;150&quot;&gt;Real Name&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;&lt;input type =&quot;text&quot; name=&quot;realname&quot;&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td width=&quot;150&quot;&gt;Department&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;&lt;input type =&quot;text&quot; name=&quot;department&quot;&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td width=&quot;150&quot;&gt;Tel&lt;/td&gt;<br />&lt;td&gt;:&lt;/td&gt;<br />&lt;td&gt;&lt;input type =&quot;text&quot; name=&quot;tel&quot;&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;tr&gt;<br />&lt;td&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br /><br />&lt;tr&gt;<br />&lt;td&gt;&lt;input type =&quot;submit&quot; value=&quot;Register&quot; name=&quot;regbtn&quot;&gt;&lt;/td&gt;<br />&lt;td&gt;&lt;/td&gt;<br />&lt;td&gt;&lt;input type=&quot;reset&quot; onClick=&quot;return confirm(&#39;Reset Form <br /><br />?&#39;)&quot;&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br /><br />&lt;/center&gt;<br />&lt;/table&gt;<br />&lt;/form&gt;<br />&lt;/fieldset&gt;<br />&lt;/body&gt;<br />&lt;/html&gt;<br /><br /><br />&lt;?php<br /><br />if (&#036;_POST[regbtn] == &quot;regbtn&quot;) <br />{<br /><br /><br />&#036;uname = &#036;_POST[uname];<br />&#036;pword = &#036;_POST[pword];<br />&#036;repword = &#036;_POST[repword];<br />&#036;email = &#036;_POST[email];<br />&#036;remail = &#036;_POST[remail];<br />&#036;realname = &#036;_POST[realname];<br />&#036;department = &#036;_POST[department];<br />&#036;tel = &#036;_POST[tel];<br /><br /><br />&#036;conn = odbc_connect(&#39;register&#39;,&#39;&#39;,&#39;&#39;);<br />if (&#33;&#036;conn)<br />{<br />exit(&quot;Connection Failed: &quot; . &#036;conn); <br />}<br /><br />&#036;sql = &quot;INSERT INTO register &quot; . <br /><br />&quot;(uname,pword,repword,email,remail,realname,department,tel) <br /><br />VALUES (&#39;&#036;uname&#39;, &#39;&#036;pword&#39;, &#39;&#036;repword&#39;, &#39;&#036;email&#39;, &#39;&#036;remail&#39;, <br /><br />&#39;&#036;realname&#39;, &#39;&#036;department&#39;, &#39;&#036;tel&#39;)&quot;;<br /><br /> <br />&#036;rs = odbc_exec(&#036;conn,&#036;sql);<br /><br />if (&#33;&#036;rs)<br />{<br /><br />echo &quot;An error has occured. Please try again&quot;;<br /><br />}<br /><br />else<br /><br />{<br /><br />echo &quot;The record was successfully inserted.&quot;;<br /><br />}<br /><br />odbc_close(&#036;conn);<br /><br />}<br /><br />?&gt;<!--SPOILER DIV--></div><!--SPOILER DIV--><br /><br />first,this error come out :<br /><!--SPOILER BEGIN--><div class="spoilertop" onClick="openClose('fda6c239a9363e6f66c1ddd7a58357ad')" style="font-weight: bold"><u>&raquo; Click to show Spoiler - click again to hide... &laquo;</u></div><div class="spoilermain" id="fda6c239a9363e6f66c1ddd7a58357ad" style="display:none"><!--SPOILER END--><br />PHP Notice: Use of undefined constant regbtn - assumed &#39;regbtn&#39; in C:&#092;inetpub&#092;wwwroot&#092;Room Booking&#092;reg&#092;register.php on line 124<br />PHP Notice: Undefined index: regbtn in C:&#092;inetpub&#092;wwwroot&#092;Room Booking&#092;reg&#092;register.php on line 124<!--SPOILER DIV--></div><!--SPOILER DIV--><br /><br />then i Google it and finds this, i follow the instruction , but still my db won&#39;t update :<br /><br /><!--SPOILER BEGIN--><div class="spoilertop" onClick="openClose('cf8f7c71ccb02e2dfe59fc5b64b5d331')" style="font-weight: bold"><u>&raquo; Click to show Spoiler - click again to hide... &laquo;</u></div><div class="spoilermain" id="cf8f7c71ccb02e2dfe59fc5b64b5d331" style="display:none"><!--SPOILER END-->Re: Notice: Use of undefined constant string<br />Posted: 07-23-2004, 11:18 AM<br />Hello,<br />You need to change your php.ini file<br /><br />find the word &quot;error_reporting&quot; in your php.ini file and make the<br /><br />change like below..<br /><br />error_reporting = E_ALL &amp; ~E_NOTICE &amp; ~E_STRICT<br /><br /><br />regards<br />R.Sureshkannan<br /><br /><br />On Fri, 23 Jul 2004 11:43:58 +0200, Vince wrote:<!--SPOILER DIV--></div><!--SPOILER DIV--><br /><br />tq for ur help cdrw87 Codemasters Thu, 06 Aug 2009 09:38:24 +0800 ASP problem http://forum.lowyat.net/topic/1113632 i have a problem with my asp page,<br />i have create a user form to register , ms access file for database and the connection.asp . .<br />the problem is , at the login page got register button that link to the register.asp , but when click to the button , an error occur , i&#39;ve ask my lecturer , she say no problem with my coding and she run using xp , mine using vista and im running from local host . <br /><br />the problem said <br /><br /><!--SPOILER BEGIN--><div class="spoilertop" onClick="openClose('babe5251503a706db380da6a65c348e8')" style="font-weight: bold"><u>&raquo; Click to show Spoiler - click again to hide... &laquo;</u></div><div class="spoilermain" id="babe5251503a706db380da6a65c348e8" style="display:none"><!--SPOILER END-->Microsoft JET Database Engine error &#39;80004005&#39;<br /><br />Unspecified error<br /><br />/room booking/reg/connection.asp, line 5 <!--SPOILER DIV--></div><!--SPOILER DIV--><br /><br /><b>this is my connection.asp code<br /></b><br /><!--SPOILER BEGIN--><div class="spoilertop" onClick="openClose('0f1668cb9c057b781f110804ff4e965e')" style="font-weight: bold"><u>&raquo; Click to show Spoiler - click again to hide... &laquo;</u></div><div class="spoilermain" id="0f1668cb9c057b781f110804ff4e965e" style="display:none"><!--SPOILER END--><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1-->&#60;% <br /><br />dim connection<br />Set connection = Server.CreateObject&#40;&#34;ADODB.Connection&#34;&#41;<br />connection.open &#34;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&#34;&amp; server.MapPath&#40;&#34;register.mdb&#34;&#41; &amp; &#34;;Persist Security Info=False&#34; <br />%&#62;<!--c2--></div><!--ec2--><!--SPOILER DIV--></div><!--SPOILER DIV--><br /><br /><b>my register.asp code</b><br /><br /><!--SPOILER BEGIN--><div class="spoilertop" onClick="openClose('a0a7f53d8dcd2aa01c6c611198191552')" style="font-weight: bold"><u>&raquo; Click to show Spoiler - click again to hide... &laquo;</u></div><div class="spoilermain" id="a0a7f53d8dcd2aa01c6c611198191552" style="display:none"><!--SPOILER END--><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1-->#include file = &#34;connection.asp&#34;<br /><br /><br />&#60;html&#62;<br />&#60;head&#62;<br />&#60;title&#62;Welcome To Registration&#60;/title&#62;<br />&#60;/head&#62;<br />&#60;body bgcolor=&#34;#E8E8E8&#34;&#62;<br /><br />&#60;center&#62;<br /><br />&#60;table border=&#34;1&#34; width=&#34;800&#34;&#62;<br />&#60;tr&#62;<br />&#60;td align=&#34;center&#34;&#62;&#60;font size =&#34;8&#34; color=&#34;purple&#34;&#62;Room <br /><br />Reservation System&#60;/font&#62;&#60;/td&#62;<br />&#60;/tr&#62;<br />&#60;/table&#62;<br />&#60;br&#62;<br />&#60;/center&#62;<br /><br /><br />&#60;p&#62;&#60;marquee&#62;&#60;b&#62;Register Form&#60;/b&#62;&#60;/marquee&#62;&#60;/p&#62;<br /><br />&#60;br&#62;<br />&#60;br&#62;<br /><br />&#60;center&#62;<br /><br />&#60;fieldset style= &#34;width&#58;500px&#34;&#62;<br />&#60;legend align=left&#62;&#60;font color=&#34;blue&#34; <br /><br />face=&#34;verdana&#34;&#62;Register Form&#60;/font&#62;&#60;img border =&#34;0&#34; src <br /><br />=&#34;reg1.png&#34;&#62;&#60;/legend&#62;<br /><br />&#60;form name =&#34;register&#34; method=&#34;post&#34; action=&#34;register <br /><br />done.asp&#34;&#62;<br />&#60;br&#62;<br />&#60;font color=&#34;orange&#34;&#62;&#60;b&#62;Registration <br /><br />Information&#60;/b&#62;&#60;/font&#62;<br />&#60;br&#62;<br />&#60;table border=&#34;0&#34;&#62;<br />&#60;center&#62;<br />&#60;tr&#62;<br />&#60;td&#62;Username&#60;/td&#62;<br />&#60;td&#62;&#58;&#60;/td&#62;<br />&#60;td&#62;&#60;input type =&#34;text&#34; name=&#34;user&#34; &#62;&#60;/input&#62;&#60;/td&#62;<br />&#60;/tr&#62;<br /><br />&#60;tr&#62;<br />&#60;td&#62;Password&#60;/td&#62;<br />&#60;td&#62;&#58;&#60;/td&#62;<br />&#60;td&#62;&#60;input type =&#34;password&#34; name=&#34;password&#34; &#62;&#60;/input&#62;&#60;/td&#62;<br />&#60;/tr&#62;<br /><br />&#60;tr&#62;<br />&#60;td&#62;Re Type Password&#60;/td&#62;<br />&#60;td&#62;&#58;&#60;/td&#62;<br />&#60;td&#62;&#60;input type =&#34;password&#34; name=&#34;repassword&#34; <br /><br />&#62;&#60;/input&#62;&#60;/td&#62;<br />&#60;/tr&#62;<br /><br />&#60;tr&#62;<br />&#60;td&#62;E-mail Address&#60;/td&#62;<br />&#60;td&#62;&#58;&#60;/td&#62;<br />&#60;td&#62;&#60;input type =&#34;text&#34; name=&#34;email&#34; &#62;&#60;/input&#62;&#60;/td&#62;<br />&#60;/tr&#62;<br /><br />&#60;tr&#62;<br />&#60;td&#62;Re Type E-mail Address&#60;/td&#62;<br />&#60;td&#62;&#58;&#60;/td&#62;<br />&#60;td&#62;&#60;input type =&#34;text&#34; name=&#34;remail&#34; &#62;&#60;/input&#62;&#60;/td&#62;<br />&#60;/tr&#62;<br />&#60;/table&#62;<br /><br />&#60;br&#62;<br /><br /><br />&#60;font color=&#34;orange&#34;&#62;&#60;b&#62;Profile Information&#60;/b&#62;&#60;/font&#62;<br /><br /><br />&#60;table border=&#34;0&#34;&#62;<br /><br />&#60;tr&#62;<br />&#60;td&#62;&#60;/td&#62;<br />&#60;/tr&#62;<br /><br />&#60;tr&#62;<br />&#60;td width=&#34;150&#34;&#62;Real Name&#60;/td&#62;<br />&#60;td&#62;&#58;&#60;/td&#62;<br />&#60;td&#62;&#60;input type =&#34;text&#34; name=&#34;real&#34; &#62;&#60;/td&#62;<br />&#60;/tr&#62;<br /><br />&#60;tr&#62;<br />&#60;td width=&#34;150&#34;&#62;Department&#60;/td&#62;<br />&#60;td&#62;&#58;&#60;/td&#62;<br />&#60;td&#62;&#60;input type =&#34;text&#34; name=&#34;department&#34; &#62;&#60;/td&#62;<br />&#60;/tr&#62;<br /><br />&#60;tr&#62;<br />&#60;td width=&#34;150&#34;&#62;Tel&#60;/td&#62;<br />&#60;td&#62;&#58;&#60;/td&#62;<br />&#60;td&#62;&#60;input type =&#34;text&#34; name=&#34;tel&#34; &#62;&#60;/td&#62;<br />&#60;/tr&#62;<br /><br />&#60;tr&#62;<br />&#60;td&#62;&#60;/td&#62;<br />&#60;/tr&#62;<br /><br />&#60;tr&#62;<br />&#60;td&#62;&#60;/td&#62;<br />&#60;/tr&#62;<br /><br />&#60;tr&#62;<br />&#60;td&#62;&#60;/td&#62;<br />&#60;/tr&#62;<br /><br /><br />&#60;tr&#62;<br />&#60;td&#62;&#60;input name=&#34;regbtn&#34; type =&#34;submit&#34; <br /><br />value=&#34;Register&#34;&#62;&#60;/td&#62;<br />&#60;td&#62;&#60;/td&#62;<br />&#60;td&#62;&#60;input type=&#34;reset&#34; onClick=&#34;return confirm&#40;&#39;Reset <br /><br />Form ?&#39;&#41;&#34;&#62;&#60;/td&#62;<br />&#60;/tr&#62;<br /><br /><br />&#60;/table&#62;<br />&#60;/form&#62;<br />&#60;/fieldset&#62;<br />&#60;/body&#62;<br />&#60;/html&#62;<br /><br />&#60;%<br /><br />if request.form&#40;&#34;regbtn&#34;&#41; = &#34;Register&#34; then <br /> <br />uname = <br /><br />request.form&#40;&#34;uname&#34;&#41;<br />pword = request.form&#40;&#34;pword&#34;&#41;<br />repword <br /><br />= request.form&#40;&#34;repword&#34;&#41;<br />email = request.form&#40;&#34;email&#34;&#41;<br />remail = request.form&#40;&#34;remail&#34;&#41;<br />real_name = request.form<br /><br />&#40;&#34;real&#34;&#41;<br />department = request.form&#40;&#34;department&#34;&#41;<br />tel = <br /><br />request.form&#40;&#34;tel&#34;&#41;<br /><br /> <br /> <br />connection.Execute &#34;Insert into <br /><br />register <br /><br />&#40;uname,pword,repword,email,remail,realname,department,tel&#41;<br /><br />&#34; &amp; _<br />&#34; values &#40;&#39;&#34; &amp; uname &amp; &#34;&#39;,&#39;&#34; &amp; pword &amp; &#34;&#39;,&#39;&#34; &amp; <br /><br />repword &amp; &#34;&#39;,&#39;&#34; &amp; email &amp; &#34;&#39;,&#39;&#34; &nbsp;&amp; remail &amp; &#34;&#39;,&#39;&#34; &amp; <br /><br />real_name &amp; &#34;&#39;,&#39;&#34; &amp; department &amp; &#34;&#39;,&#39;&#34; &amp; tel &amp; &#34;&#39;&#41;&#34; <br /><br /><br /><br /><br /><br />response.redirect &#34;register done.asp&#34;<br /><br /><br />end if<br /><br /><br /><br />%&#62;<br /><!--c2--></div><!--ec2--><!--SPOILER DIV--></div><!--SPOILER DIV--><br /><br /><br />tq for ur help . .<br /><br /> cdrw87 Codemasters Thu, 30 Jul 2009 15:42:58 +0800 K800i http://forum.lowyat.net/topic/526608 i&#39;ve just bought new ap set K800i,<br />but i can&#39;t copy my contacs from sim to internal phone book . .<br />whats the problem ?<br />anyone ?<br /><br /> <!--emo&:help:--><img src='http://static.lowyat.net/style_emoticons/default/icon_question.gif' border='0' style='vertical-align:middle' alt='icon_question.gif' /><!--endemo--> cdrw87 Mobile Phones and Tablets Wed, 26 Sep 2007 02:09:07 +0800 K800i or K810i http://forum.lowyat.net/topic/525585 <br />is it <b>k800i</b> or <b>k810i</b> is the best ?<br /> <!--emo&:thumbs:--><img src='http://static.lowyat.net/style_emoticons/default/thumbup.gif' border='0' style='vertical-align:middle' alt='thumbup.gif' /><!--endemo--> cdrw87 Mobile Phones and Tablets Mon, 24 Sep 2007 13:24:34 +0800 any Desktop Customization for vista ? http://forum.lowyat.net/topic/523514 <!--emo&:o--><img src='http://static.lowyat.net/style_emoticons/default/yawn.gif' border='0' style='vertical-align:middle' alt='yawn.gif' /><!--endemo--> <br />any one know where to get vista themes ?<br />might be Desktop Customization also . . <!--emo&:drool:--><img src='http://static.lowyat.net/style_emoticons/default/drool.gif' border='0' style='vertical-align:middle' alt='drool.gif' /><!--endemo--> cdrw87 Desktop Customization Thu, 20 Sep 2007 13:01:09 +0800