[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
07/04/2009 at 12:57PM PDT, ID: 24544164
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
9.4

mysql insert problem via php

Asked by jpve in PHP and Databases, MySQL Server

Tags: mysql php sql

Hey experts,

I don't think this particular problem should pose much of a problem for many of you, but it has for me.  I've been trying to get this working for hours.  Basically I'm trying to insert a new row into the table tbFindNLdirectory.  iID is the pk and it's set to auto_increment.  I'm pretty sure you don't need to reference the auto pk in your sql, but I did it anyway here 'cuz like I said, this thing is driving me up the wall.

I think I've got the problem narrowed down to the variable $strStepSixAmountToStartBilling.  I've got the sql syntax showing up in the action page.  Help experts, it's driving me nuts.  I haven't added js validation yet to take care of that possible problem but I'm only using dummy data for the time being. 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
370:
371:
372:
373:
374:
375:
376:
377:
378:
379:
380:
381:
382:
383:
384:
385:
386:
387:
388:
389:
390:
391:
392:
393:
394:
395:
396:
397:
398:
399:
400:
401:
402:
403:
404:
405:
406:
407:
408:
409:
410:
411:
412:
413:
414:
415:
416:
417:
418:
419:
420:
421:
422:
423:
424:
425:
426:
427:
428:
429:
430:
431:
432:
433:
434:
435:
436:
437:
438:
439:
440:
441:
442:
443:
444:
445:
446:
447:
448:
449:
450:
451:
452:
453:
454:
455:
456:
457:
458:
459:
460:
461:
462:
463:
464:
465:
466:
467:
468:
469:
470:
471:
472:
473:
474:
475:
476:
477:
478:
479:
480:
481:
482:
483:
484:
485:
486:
487:
488:
489:
490:
491:
492:
493:
494:
495:
496:
497:
498:
499:
500:
501:
502:
503:
504:
505:
506:
507:
508:
509:
510:
511:
512:
513:
514:
515:
516:
517:
518:
519:
520:
521:
522:
523:
524:
525:
526:
527:
528:
529:
530:
531:
532:
533:
534:
535:
536:
537:
538:
539:
540:
541:
542:
543:
544:
545:
546:
547:
548:
549:
550:
551:
552:
553:
554:
555:
556:
557:
558:
559:
560:
561:
562:
563:
564:
565:
566:
567:
568:
569:
570:
571:
572:
573:
574:
575:
576:
577:
578:
579:
580:
581:
582:
583:
584:
585:
586:
587:
588:
589:
590:
591:
592:
593:
594:
595:
596:
597:
598:
599:
600:
601:
602:
603:
604:
605:
606:
607:
608:
609:
610:
611:
612:
613:
614:
615:
616:
617:
618:
619:
620:
621:
622:
623:
624:
625:
626:
627:
628:
629:
630:
631:
632:
633:
634:
635:
636:
637:
638:
639:
640:
641:
642:
643:
644:
645:
646:
647:
648:
649:
650:
651:
652:
653:
654:
655:
656:
657:
658:
659:
660:
661:
662:
663:
664:
665:
666:
667:
668:
669:
670:
671:
672:
673:
674:
675:
676:
677:
678:
679:
680:
681:
682:
683:
684:
685:
686:
687:
688:
689:
690:
691:
692:
693:
694:
695:
696:
697:
698:
699:
700:
701:
702:
703:
704:
705:
706:
707:
708:
709:
710:
711:
712:
713:
714:
715:
716:
717:
718:
719:
720:
721:
722:
723:
724:
725:
726:
727:
728:
729:
730:
731:
732:
733:
734:
735:
736:
737:
738:
739:
740:
741:
742:
743:
744:
745:
746:
747:
748:
749:
750:
751:
752:
753:
754:
755:
756:
757:
758:
759:
760:
761:
762:
763:
764:
765:
766:
767:
768:
769:
770:

*********************************** FORM PAGE **********************************
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>FindNL Business Test Thing</title>
<? include("includes/dbConnect.php"); ?>
<style type="text/css">
<!--
.style5 {
	color: #FFFFFF;
	font-weight: bold;
}
.style7 {color: #FFFF00}
-->
</style>
</head>
 
<body>
 
<?	$qsID	= $HTTP_GET_VARS['id'];	?>
<?	$qsPS	= $HTTP_GET_VARS['ps'];	?>
 
<?	if($qsPS = "bodyShop") {
		$sqlPS = "SELECT * FROM tbFindNLpsBodyShop ORDER BY iID ASC";
		$runSQLPS = mysql_query($sqlPS, $connDB);
	}
	
	if($qsPS = "Daycare") {
		$sqlPS = "SELECT * FROM tbFindNLpsDaycare ORDER BY iID ASC";
		$runSQLPS = mysql_query($sqlPS, $connDB);
	}
	
	if($qsPS = "DJservices") {
		$sqlPS = "SELECT * FROM tbFindNLpsDJservices ORDER BY iID ASC";
		$runSQLPS = mysql_query($sqlPS, $connDB);
	}
	
	if($qsPS = "Roofing") {
		$sqlPS = "SELECT * FROM tbFindNLpsRoofing ORDER BY iID ASC";
		$runSQLPS = mysql_query($sqlPS, $connDB);
	}
?>
 
<?
	#$sql = "SELECT * FROM tbFindNLdirectory WHERE iID = " . $qsID;
	#$runSQL = mysql_query($sql, $connDB);
 
	#$sqlPS = "SELECT * FROM tbFindNLpsBodyShop ORDER BY iID ASC";
	#$runSQLPS = mysql_query($sqlPS, $connDB);
?>
 
<?	#while($display_info = mysql_fetch_array($runSQL)) { ?>
<table align="center" cellpadding="0" cellspacing="0" border="0">
<tr>
    	<td width="150" align="right" valign="top"><a href="index.php" name="top">back to bidness'es'es'es</a></td>
  	  <td width="150" valign="top">&nbsp;&nbsp;</td>
	<td width="150"></td>
  </tr>
    <tr>
    	<td colspan="3" height="10"></td>
    </tr>
    <tr>
    	<td valign="top" colspan="3">
        	<div align="center">
        		<strong>Get Listed Into The FindNL Directory.</strong><br />
            	<strong>Get Traffic to Newfoundland Based Business from Local and Worldwide Internet Users.</strong><br />
			</div>
        	<br />
        	<strong>Why Get Listed?</strong>
			<ol>
       	  	<li>We Are On The <strong>First Page of Google</strong> for over 1000 different keywords and growing.</li>
       	  	<li>We <strong>Add Google Maps</strong> to your business location for users to find you with ease.</li>
       	  	<li>Users can <strong>Rate Your Business</strong> against Your Competitors.</li>
       	  	<li>Users can <strong>Discuss Your Business</strong> to let others know how good you are. (Admin Approved Comments Only)</li>
       		</ol>
            <strong>We are Search Engine Specialists</strong> and can get your business listed on the first page<br />of Google as well. We are putting Newfoundland on the map, let us send you potential customers today.
    	</td>
  	</tr>
    <tr>
    	<td colspan="3" valign="top" style="font-size:24px; font-weight:bold; color:#330099;">
			<?	echo $display_info['sCompanyBusinessName'];	?>
        </td>
    </tr>
    <tr>
    	<td colspan="3" height="5"></td>
    </tr>
    <tr>
    	<td colspan="3" bgcolor="#ffffff" align="center">
        	<!-- START: Table -->
          <form name="frmBusinessAddNew" enctype="multipart/form-data" method="post" action="businessAdded.php">
            <table cellpadding="2" cellspacing="2" border="1" align="center" style="font-family:Arial, Tahoma, Verdana, sans-serif; font-size:11px; font-weight:bold;">
            	<tr>
                	<td colspan="2" align="center" bgcolor="#000033"><span class="style5"><a name="stepOne">Step 1: Contact Details - About You</a></span></td>
                </tr>
                <tr>
                	<td width="160" valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Your Full Name:</td>
           	  	  	<td valign="top" width="157" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepOneYourFullName" size="42" /></td>
       	  	  	</tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Email Address:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepOneEmailAddress" size="42" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Position in Company:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepOnePositionInCompany" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
                	<td colspan="2" align="center" bgcolor="#000033"><span class="style5"><a name="stepTwo">Step 2: Company Details - About Your Business</a></span></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Business Name:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoBusinessName" size="42" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Website Address:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoWebsiteAddress" size="42" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Phone Number:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoPhoneNumber" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Fax Number:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoFaxNumber" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Street Number:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoStreetNumber" size="12" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Street Address:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoStreetAddress" size="42" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Postal Code:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoPostalCode" size="12" /></td>
              	</tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">City/Town:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoCityTown" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Province:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left">
                    	<select name="selectStepTwoProvince">
                        	<option value="NL" selected="selected">Newfoundland &amp; Labrador</option>
                            <option value="null">========================</option>
                            <option value="Alberta">Alberta</option>
                            <option value="British Columbia">British Columbia</option>
                            <option value="Manitoba">Manitoba</option>
                            <option value="New Brunswick">New Brunswick</option>
                            <option value="Nova Scotia">Nova Scotia</option>
                            <option value="Ontario">Ontario</option>
                            <option value="Saskatchewan">Saskatchewan</option>
                            <option value="Prince Edward Island">Prince Edward Island</option>
                            <option value="Quebec">Quebec</option>
                        </select>
                    </td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Latitude:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoLatitude" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Longitude:</td>
                  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoLongitude" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Hours of operation on Monday:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoHoursOfOperationMonday" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Hours of operation on Tuesday:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoHoursOfOperationTuesday" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Hours of operation on Wednesday:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoHoursOfOperationWednesday" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Hours of operation on Thursday:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoHoursOfOperationThursday" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Hours of operation on Friday:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoHoursOfOperationFriday" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Hours of operation on Saturday:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoHoursOfOperationSaturday" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Hours of operation on Sunday:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepTwoHoursOfOperationSunday" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Wheelchair Accessible:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left">
                    	<input type="radio" value="yes" checked="checked" name="radStepTwoWheelchairAccessible" /> yes
                   		<input type="radio" value="no" name="radStepTwoWheelchairAccessible" style="margin-left:15px;" />no
                    </td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Payment Type:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left">
                    	<input type="checkbox" name="chkStepTwoPaymentTypeVisa" value="yes" />VISA <input type="checkbox" name="chkStepTwoPaymentTypeMastercard" value="yes" style="margin-left:54px;"/>Mastercard
                        <br />
                        <input type="checkbox" name="chkStepTwoPaymentTypeAmex" value="yes" />AMEX <input type="checkbox" name="chkStepTwoPaymentTypeDiners" value="yes" style="margin-left:50px;"/>Diners
                        <br />
                        <input type="checkbox" name="chkStepTwoPaymentTypePaypal" value="yes" />Paypal
                        <br />
                        <div style="margin-left:5px;">Other: <input type="text" name="txtStepTwoHoursPaymentTypeOther" size="42" /></div>
                    </td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Accept Debit Cards:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left">
                    	<input type="radio" value="yes" name="radStepTwoAcceptDebitCards" checked="checked" /> yes
                    	<input type="radio" value="no" name="radStepTwoAcceptDebitCards" style="margin-left:15px;" /> no
                    </td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">ATM on site:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left">
                    	<input type="radio" value="yes" name="radStepTwoAtmOnSite" checked="checked" />	yes
                    	<input type="radio" value="no" name="radStepTwoAtmOnSite" style="margin-left:15px;" /> no
                    </td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
                	<td colspan="2" align="center" bgcolor="#000033" style="color:#ffffff;">
                    	<span class="style7">*</span> OPTIONAL - GET LISTED FREE FOR LIFE <span class="style7">*</span>
                        <br /><br />
                        <span class="style5"><a name="stepThree">Step 3 - DISCOUNT DETAILS </a> - GET FREE LIFETIME INCLUSION INTO FINDNL</span><br />
                        <br />
                        If you would like to offer a discount to people that we refer to you, we will include your business<br />
                        into our directory free of charge, for LIFE! As long as your business honors the discount you offer<br />
                        below to OUR FINDNL MEMBERS, we will promote your business free of charge as a token of our appreciation<br />
                        to helping our members save money.
                    </td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Discount Amount:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepThreeDiscountAmount" size="12" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Discount is on this Item:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepThreeDiscountItem" size="42" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Restrictions on Discount:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepThreeDiscountRestrictions" size="42" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Describe your Discount:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><textarea name="txtStepThreeDiscountDescription" rows="5" cols="32"></textarea></td>
                </tr>
                <!-- START STEP 4 STUFF -->
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
                	<td colspan="2" align="center" bgcolor="#000033"><span class="style5"><a name="stepFour">Step 4 - PRODUCTS &amp; SERVICES</a></span></td>
                </tr>
                <tr>
               	 	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="center">Special Promotions Offers and More About Your Business<br /><br />Please provide as much information and details about your business as possible.</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><textarea name="txtStepFourSpecialPromotionsOffers" rows="5" cols="32"></textarea></td>
                </tr>
                <tr>
                	<td colspan="2" align="center" bgcolor="#000033"></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
                	<td colspan="2" align="center" bgcolor="#000033">
                    	<span class="style5"><a name="stepFive">Step 5 - UPGRADE LISTING OPTIONS</a></span>
                        <br /><br />
                        <span style="color:#ffffff;">Add more photos and text to help promote your business.  Get a link to your site from ours, to help<br />increase the traffic and exposure to your website.</span>
                    </td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Business Photo One:<br />$5.00</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="file" name="txtStepFiveBusinessPhotoOne" value="txtStepFiveBusinessPhotoOne" size="30" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Business Photo Two:<br />$5.00</td>
                  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="file" name="txtStepFiveBusinessPhotoTwo" value="txtStepFiveBusinessPhotoTwo" size="30" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Business Photo Three:<br />$5.00</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="file" name="txtStepFiveBusinessPhotoThree" value="txtStepFiveBusinessPhotoThree" size="30" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Business Photo Four:<br />$5.00</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="file" name="txtStepFiveBusinessPhotoFour" value="txtStepFiveBusinessPhotoFour" size="30" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Business Photo Five:<br />$5.00</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="file" name="txtStepFiveBusinessPhotoFive" value="txtStepFiveBusinessPhotoFive" size="30" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">1000 words to explain and promote your business:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><textarea name="txtStepFive1000words" rows="5" cols="39"></textarea></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Back Link to your Website With Tracking of Clicks:<br />$10.00</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepFiveBackLink" size="42" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">
                    	Link to Your Website On All Internet Pages In Your Industry.
                    	<br />$100.00
                	</td>
                    <td valign="middle" bordercolor="#000066" bgcolor="#FFFF99" align="left">
                    	<input type="text" name="txtStepFiveInternalLink" size="42" />
                        <br /><br />
                        We put a link to your website from ours on every page of the category<br />
                        you're listed in. This gets your site maximum exposure and traffic to your own website.<br />
                        Your site is listed above all the other competitors and gets seen first!<br /><br />
                        Ex. If you have Pet Supplies you will have a link to "Pet Supplies" that<br />
                        directs to your website.
                    </td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
                	<td colspan="2" align="center" bgcolor="#000033"><span class="style5"><a name="stepSix">PAYMENT DETAILS (STEP 6)</a></span></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Setup Fee:</td>
					<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="center">
           	  			<input type="radio" value="$49.00" name="radStepSixSetupFee" />	$49.00
                        <br /><br />
                        ~~~ or ~~~
                        <br /><br />
                      	<input type="radio" value="listing" checked="checked" name="radStepSixSetupFee" /> FREE LIFE LISTING
                   </td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Yearly Fee:</td>
					<td align="center" valign="top" bordercolor="#000066" bgcolor="#FFFF99">
           	  			<input type="radio" value="$199.00" name="radStepSixYearlyFee" /> $199.00
                        <br /><br />
                        ~~~ or ~~~
                        <br /><br />
                        <input type="radio" value="listing" checked="checked" name="radStepSixYearlyFee" /> FREE LIFE LISTING
                   	</td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="center">
                    	FREE LIFETIME LISTING:
                        <br /><br />
                        <span style="font-size:11px;">Offered if you offer a discount to our members as outlined in <a href="#stepThree">Step 3</a>.</span>
                    </td>
					<td align="center" valign="top" bordercolor="#000066" bgcolor="#FFFF99">
                    	If the <a href="#stepThree">Optional Step 3</a> is completed, then they get a free lifetime listing. If it is not and they would like a Free Lifetime Listing, please complete Step 3 before Submitting this Document.
                        <br />
                    <br />
                      	<input type="radio" value="yes" checked="checked" name="radStepSixFreeLifetimeListing" /> Yes
						<input type="radio" value="no" name="radStepSixFreeLifetimeListing" style="margin-left:15px;" /> No
                    </td>
              </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Employee:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepSixEmployee" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Setup Fee:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepSixSetupFee" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Yearly Fee:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepSixYearlyFee" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Number of Discount Years:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepSixNumbersOfDiscountYears" size="12" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Date to start billing:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtStepSixDateToStartBilling" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Amount to start billing:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left"><input type="text" name="txtBillingAmount" size="22" /></td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="right">Payment Method:</td>
                    <td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left">
                    	<input type="checkbox" name="chkStepSixPaymentMethodCash" value="yes" />Cash <input type="checkbox" name="chkStepSixPaymentMethodCreditCard" value="yes" style="margin-left:58px;"/>Credit Card
                        <br />
                        <input type="checkbox" name="chkStepSixPaymentMethodCheck" value="yes" />Check <input type="checkbox" name="chkStepSixPaymentMethodPaypal" value="yes" style="margin-left:50px;"/>Paypal
                        <br />
                        <input type="checkbox" name="chkStepSixPaymentMethodEmailMoneyTransfer" value="yes" />Email Money Transfer
                    </td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
               	  	<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="center">
                  		Payment Details:
                        <br /><br />
                        If Using a Credit Card - Please go Here to Complete Payment:
                        <br />
                        <a href="http://www.findnl.com/pay/" target="_blank">http://www.findnl.com/pay/</a>
                    </td>
					<td valign="top" bordercolor="#000066" bgcolor="#FFFF99" align="left">
                    	<textarea name="txtStepSixPaymentDetails" rows="5" cols="39"></textarea>
                    </td>
                </tr>
                <tr>
                	<td colspan="2" height="5"></td>
                </tr>
                <tr>
                	<td colspan="2" height="5" align="center"><input type="submit" value="Add Business" /></td>
                </tr>
          </table>
          </form>
          <!-- END: Table -->
        </td>
  </tr>
  	<tr>
  		<td colspan="3" height="5"></td>
  	</tr>
  	<tr>
  		<td colspan="3" align="right"><div align="center"><a href="#top">Back to Top</a></div></td>
  	</tr>
</table>
<br /><br />
 
</body>
</html>
*************************** END FORM PAGE **************************************
 
*************************** ACTION PAGE *************************************
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>FindNL Business Test Thing</title>
<? include("includes/dbConnect.php"); ?>
</head>
 
<body>
 
<?
	# STEP 1
	$strStepOneFullName						=	nl2br($_POST['txtStepOneYourFullName']);
	$strStepOneEmailAddress					=	nl2br($_POST['txtStepOneEmailAddress']);
	$strStepOnePositionInCompany			=	nl2br($_POST['txtStepOnePositionInCompany']);
	
	# STEP 2
	$strStepTwoBusinessName					=	nl2br($_POST['txtStepTwoBusinessName']);
	$strStepTwoWebsiteAddress				=	nl2br($_POST['txtStepTwoWebsiteAddress']);
	$strStepTwoPhoneNumber					=	nl2br($_POST['txtStepTwoPhoneNumber']);
	$strStepTwoFaxNumber					=	nl2br($_POST['txtStepTwoFaxNumber']);
	$strStepTwoStreetNumber					=	nl2br($_POST['txtStepTwoStreetNumber']);
	$strStepTwoStreetAddress				=	nl2br($_POST['txtStepTwoStreetAddress']);
	$strStepTwoCityTown						=	nl2br($_POST['txtStepTwoCityTown']);
	$optStepTwoProvince						=	nl2br($_POST['selectStepTwoProvince']);
	$intStepTwoLatitude						=	nl2br($_POST['txtStepTwoLatitude']);
	$intStepTwoLongitude					=	nl2br($_POST['txtStepTwoLongitude']);
	$strStepTwoHoursOfOperationMonday		=	nl2br($_POST['txtStepTwoHoursOfOperationMonday']);
	$strStepTwoHoursOfOperationTuesday		=	nl2br($_POST['txtStepTwoHoursOfOperationTuesday']);
	$strStepTwoHoursOfOperationWednesday	=	nl2br($_POST['txtStepTwoHoursOfOperationWednesday']);
	$strStepTwoHoursOfOperationThursday		=	nl2br($_POST['txtStepTwoHoursOfOperationThursday']);
	$strStepTwoHoursOfOperationFriday		=	nl2br($_POST['txtStepTwoHoursOfOperationFriday']);
	$strStepTwoHoursOfOperationSaturday		=	nl2br($_POST['txtStepTwoHoursOfOperationSaturday']);
	$strStepTwoHoursOfOperationSunday		=	nl2br($_POST['txtStepTwoHoursOfOperationSunday']);
	$strStepTwoWheelchairAccessible			=	nl2br($_POST['radStepTwoWheelchairAccessible']);
	$strStepTwoPaymentTypeVisa				=	nl2br($_POST['chkStepTwoPaymentTypeVisa']);
	$strStepTwoPaymentTypeMastercard		=	nl2br($_POST['chkStepTwoPaymentTypeMastercard']);
	$strStepTwoPaymentTypeAmex				=	nl2br($_POST['chkStepTwoPaymentTypeAmex']);
	$strStepTwoPaymentTypeDiners			=	nl2br($_POST['chkStepTwoPaymentTypeDiners']);
	$strStepTwoPaymentTypePaypal			=	nl2br($_POST['chkStepTwoPaymentTypePaypal']);
	$strStepTwoHoursPaymentTypeOther		=	nl2br($_POST['txtStepTwoHoursPaymentTypeOther']);
	$strStepTwoAcceptDebitCards				=	nl2br($_POST['radStepTwoAcceptDebitCards']);
	$strStepTwoAtmOnSite					=	nl2br($_POST['radStepTwoAtmOnSite']);
	
	# STEP 3
	$strStepThreeDiscountAmount				=	nl2br($_POST['txtStepThreeDiscountAmount']);
	$strStepThreeDiscountItem				=	nl2br($_POST['txtStepThreeDiscountItem']);
	$strStepThreeDiscountRestrictions		=	nl2br($_POST['txtStepThreeDiscountRestrictions']);
	$strStepThreeDiscountDescription		=	nl2br($_POST['txtStepThreeDiscountDescription']);
	
	# STEP 4
	$strtStepFourSpecialPromotionsOffers	=	nl2br($_POST['txtStepFourSpecialPromotionsOffers']);
	
	# STEP 5
	$uploaddir = "uploads/";
 
	$target_path 	= basename( $_FILES['txtStepFiveBusinessPhotoOne']['name']);
	$target_path2 	= basename( $_FILES['txtStepFiveBusinessPhotoTwo']['name']);
	$target_path3 	= basename( $_FILES['txtStepFiveBusinessPhotoThree']['name']);
	$target_path4 	= basename( $_FILES['txtStepFiveBusinessPhotoFour']['name']);
	$target_path5 	= basename( $_FILES['txtStepFiveBusinessPhotoFive']['name']); 
 
	move_uploaded_file($_FILES['txtStepFiveBusinessPhotoOne']['tmp_name'], "uploads/photoOne/" . $target_path);
	move_uploaded_file($_FILES['txtStepFiveBusinessPhotoTwo']['tmp_name'], "uploads/photoTwo/" . $target_path2);
	move_uploaded_file($_FILES['txtStepFiveBusinessPhotoThree']['tmp_name'], "uploads/photoThree/" . $target_path3);
	move_uploaded_file($_FILES['txtStepFiveBusinessPhotoFour']['tmp_name'], "uploads/photoFour/" . $target_path4);
	move_uploaded_file($_FILES['txtStepFiveBusinessPhotoFive']['tmp_name'], "uploads/photoFive/" . $target_path5);
	
	$strStepFive1000words		=	nl2br($_POST['txtStepFive1000words']);
	$strStepFiveBackLink		=	nl2br($_POST['txtStepFiveBackLink']);
	$strStepFiveInternalLink	=	nl2br($_POST['txtStepFiveInternalLink']);
	
	# STEP 6
	$strStepSixSetupFee							=	nl2br($_POST['radStepSixSetupFee']);
	$strStepSixYearlyFee						=	nl2br($_POST['radStepSixYearlyFee']);
	$strStepSixFreeLifetimeListing				=	nl2br($_POST['radStepSixFreeLifetimeListing']);
	$strStepSixEmployee							=	nl2br($_POST['txtStepSixEmployee']);
	$strStepSixSetupFee							=	nl2br($_POST['txtStepSixSetupFee']);
	$strStepSixYearlyFee						=	nl2br($_POST['txtStepSixYearlyFee']);
	$strStepSixNumbersOfDiscountYears			=	nl2br($_POST['txtStepSixNumbersOfDiscountYears']);
	$strStepSixDateToStartBilling				=	nl2br($_POST['txtStepSixDateToStartBilling']);
	$strStepSixAmountToStartBilling				=	nl2br($_POST['txtStepSixAmountToStartBilling']);
	$strStepSixPaymentMethodCash				=	nl2br($_POST['chkStepSixPaymentMethodCash']);
	$strStepSixPaymentMethodCreditCard			=	nl2br($_POST['chkStepSixPaymentMethodCreditCard']);
	$strStepSixAmountToStartBilling				=	$_POST['txtBillingAmount'];
	$strStepSixPaymentMethodPaypal				=	nl2br($_POST['chkStepSixPaymentMethodPaypal']);
	$strStepSixPaymentMethodEmailMoneyTransfer	=	nl2br($_POST['chkStepSixPaymentMethodEmailMoneyTransfer']);
	$strStepSixPaymentDetails					=	nl2br($_POST['txtStepSixPaymentDetails']);
	
	# static value of 5 has been added. It'll need to be pulled from the auto ID of the table, then +1 to line it up correctly.
	
	$insertSQL = 	"INSERT INTO tbFindNLdirectory (`iID`, `iBusinessType`, `sContactFullName`, `sContactEmailAddress`, `sContactCompanyPosition`, " . 
					"`sCompanyBusinessName`, `sCompanyWebsiteAddress`, `sCompanyPhoneNumber`, `sCompanyFaxNumber`, `sCompanyLocation`, `sCompanyProvince`, " . 
					"`sCompanyCity`, `iCompanyStreetNumber`, `sCompanyStreetAddress`, `sCompanyPostalCode`, `sCompanyLatitude`, `sCompanyLongitude`, " . 
					"`sCompanyHoursOfOperationMonday`, `sCompanyHoursOfOperationTuesday`, `sCompanyHoursOfOperationWednesday`, `sCompanyHoursOfOperationThursday`, " . 
					"`sCompanyHoursOfOperationFriday`, `sCompanyHoursOfOperationSaturday`, `sCompanyHoursOfOperationSunday`, `sCompanyWheelchairAccessible`, " . 
					"`sPaymentTypeVisa`, `sPaymentTypeMastercard`, `sPaymentTypeAmex`, `sPaymentTypeDiners`, `sPaymentTypePaypal`, `sCompanyPaymentTypesOther`, " . 
					"`sCompanyAcceptDebitCards`, `sCompanyAtmOnSite`, `iDiscountAmount`, `sDiscountItem`, `sDiscountRestrictions`, `sDiscountDescription`, " . 
					"`sUpgradePhotoOne`, `sUpgradePhotoTwo`, `sUpgradePhotoThree`, `sUpgradePhotoFour`, `sUpgradePhotoFive`, `sDiscount1000words, `sDiscountBacklink`, " . 
					"`sDiscountInternalLink`, `sPaymentSetupFee`, `sPaymentYearlyFee`, `sPaymentLifetimeListing`, `sDiscountEmployee`, `iDiscountAmountSetupFee`, " . 
					"`iDiscountAmountYearlyFee`, `iDiscountNumberOfYears`, `sDiscountStartBillingDate`, `sDiscountStartBillingAmount`, `sPaymentMethodCash`, " . 
					"`sPaymentMethodCreditCard`, `sPaymentMethodCheck`, `sPaymentMethodPaypal`, `sPaymentMethodEmailMoneyTransfer`, `sPaymentDetails`) " . 
					"VALUES ('5', '5', '" . 
					$strStepOneFullName . "', '" . 
					$strStepOneEmailAddress . "', '" . 
					$strStepOnePositionInCompany . "', '" . 																							
					$strStepTwoBusinessName . "', '" . 
					$strStepTwoWebsiteAddress . "', '" . 
					$strStepTwoPhoneNumber . "', '" . 
					$strStepTwoFaxNumber . "', '" . 
					$strStepTwoStreetNumber . "', '" . 
					$strStepTwoStreetAddress . "', '" . 
					$strStepTwoCityTown . "', '" . 
					$optStepTwoProvince . "', '" . 
					$intStepTwoLatitude . "', '" . 
					$intStepTwoLongitude . "', '" . 
					$strStepTwoHoursOfOperationMonday . "', '" . 
					$strStepTwoHoursOfOperationTuesday . "', '" . 
					$strStepTwoHoursOfOperationWednesday . "', '" . 
					$strStepTwoHoursOfOperationThursday . "', '" . 
					$strStepTwoHoursOfOperationFriday . "', '" . 
					$strStepTwoHoursOfOperationSaturday . "', '" . 
					$strStepTwoHoursOfOperationSunday . "', '" . 
					$strStepTwoWheelchairAccessible . "', '" . 	
					$strStepTwoPaymentTypeVisa . "', '" . 																							
					$strStepTwoPaymentTypeMastercard . "', '" . 
					$strStepTwoPaymentTypeAmex . "', '" . 
					$strStepTwoPaymentTypeDiners . "', '" . 
					$strStepTwoPaymentTypePaypal . "', '" . 
					$strStepTwoHoursPaymentTypeOther . "', '" . 
					$strStepTwoAcceptDebitCards . "', '" . 
					$strStepTwoAtmOnSite . "', '" . 
					$strStepThreeDiscountAmount . "', '" . 
					$strStepThreeDiscountItem . "', '" . 
					$strStepThreeDiscountRestrictions . "', '" . 
					$strStepThreeDiscountDescription . "', '" . 
					$target_path . "', '" . 
					$target_path2 . "', '" . 
					$target_path3 . "', '" . 
					$target_path4 . "', '" . 
					$target_path5 . "', '" . 
					$strStepFive1000words . "', '" . 
					$strStepFiveBackLink . "', '" . 
					$strStepFiveInternalLink . "', '" . 
					$strStepSixSetupFee . "', '" . 
					$strStepSixYearlyFee . "', '" . 
					$strStepSixFreeLifetimeListing . "', '" . 
					$strStepSixFreeLifetimeListing . "', '" . 
					$strStepSixEmployee . "', '" . 
					$strStepSixSetupFee . "', '" . 
					$strStepSixYearlyFee . "', '" . 
					$strStepSixNumbersOfDiscountYears . "', '" . 	
					$strStepSixDateToStartBilling . "', '" . 																							
					$_POST['txtBillingAmount'] . "', '" . 
					$strStepSixPaymentMethodPaypal . "', '" . 
					$strStepSixPaymentMethodEmailMoneyTransfer . "', '" . 
					$strStepSixPaymentDetails . "')";
	
	echo $insertSQL;
					
	$runInsertSQL = mysql_query($insertSQL, $connDB);
?>
 
<?
	$sql = "SELECT * FROM tbFindNLdirectory ORDER BY iID ASC";
	$runSQL = mysql_query($sql, $connDB);
?>
 
<table align="center" cellpadding="0" cellspacing="0" border="0">
	<tr>
    	<td valign="top"><strong>Business Name</strong></td>
        <td valign="top" align="right"><a href="businessAddNew.php">Add a New Business</a></td>
        <td valign="top">&nbsp;&nbsp;</td>
        <td valign="top"></td>
    </tr>
    <tr>
    	<td colspan="4" height="10"></td>
    </tr>
    <?	while($display_info = mysql_fetch_array($runSQL)) { ?>
    <tr>
    	<td colspan="4" valign="top" style="font-size:24px; font-weight:bold; color:#330099;">
			<a href="details.php?id=<? echo $display_info['iID']; ?>"><? echo $display_info['sCompanyBusinessName']; ?></a>
            <br />
            <br />        </td>
    </tr>
    <tr>
    	<td colspan="4" height="5"></td>
    </tr>
    <?	}	?>
    <tr>
    	<td colspan="2">
            The business <? echo $_POST['txtStepTwoBusinessName'];?> has been added to the FindNL directory. Whoo-hoo.  Now comes the stuff like nl2br and validation<br />
            of that form via javascript.  Just takes a bit of time.
        </td>
     </tr>
</table>
</body>
</html>
***************************************** END ACTION PAGE **********************************
Attachments:
 
businessAdded--replace-txt-with-.txt (13 KB) (File Type Details) 
action page
 
 
businessAddNew--replace-txt-with.txt (31 KB) (File Type Details) 
form page
 
[+][-]07/04/09 02:07 PM, ID: 24778024

View this solution now by starting your 30-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: PHP and Databases, MySQL Server
Tags: mysql php sql
Sign Up Now!
Solution Provided By: Ray_Paseur
Participating Experts: 2
Solution Grade: A
 
 
[+][-]07/04/09 01:01 PM, ID: 24777844

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07/04/09 01:12 PM, ID: 24777874

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07/04/09 01:21 PM, ID: 24777897

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07/04/09 01:26 PM, ID: 24777906

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 30-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07/05/09 07:29 AM, ID: 24780099

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07/05/09 07:42 AM, ID: 24780131

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07/05/09 01:11 PM, ID: 24781176

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091028-EE-VQP-86 - Hierarchy / EE_QW_3_20090701_SELECT_ZONES