-
Notifications
You must be signed in to change notification settings - Fork 0
/
ride.php
103 lines (100 loc) · 4.02 KB
/
ride.php
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
<?php
$mod_id = 7;
$modid = 2;
include("AMP/BaseDB.php");
include("AMP/BaseTemplate.php");
include("AMP/BaseModuleIntro.php");
$have=$dbcon->CacheExecute("SELECT * FROM userdata Where custom6 = 'Have a Ride to Offer' and custom9='1' and modin=10 ORDER BY custom1 ASC");
$need=$dbcon->CacheExecute("SELECT * FROM userdata WHERE custom6 = 'Need a Ride' and custom9=1 and modin=10 ORDER BY custom1 ASC");
?>
<p class="text"><a href="#need">Need a Ride</a> | <a href="#have">Have a Ride
to Offer</a><a href="modinput4.php?modin=10"><br>
Add a Listing on the Ride Board</a> <br>
<a href="modinput4_login.php?modin=10">Edit Your Ride Board Posting</a></p>
<p class="title"><a name="have"></a>Have a Ride to Offer</p>
<table width="100%" border="0" cellspacing="0" cellpadding="2" align="center" class="boardbg">
<tr class=board>
<td class=board ><b>Departing From</b></td>
<td class=board><b>Departing Date</b></td>
<td class=board><b>Returning to</b></td>
<td class=board><b>Return Date</b></td>
<td class=board><b># of people</b></td>
<td class=board ><b>Contact</b></td>
<td class=board> </td>
</tr>
<?php
while ($have && !$have->EOF) {
?>
<tr>
<td valign="top" class="text"> <?php echo $have->Fields("custom1")?>
</td>
<td valign="top" class="text"> <?php echo $have->Fields("custom2")?>
</td>
<td valign="top" class="text"> <?php echo $have->Fields("custom3")?> </td>
<td valign="top" class="text"> <?php echo $have->Fields("custom4")?> </td>
<td valign="top" class="text"> <?php echo $have->Fields("custom5")?> </td>
<td valign="top" class="text"> <p> <?php echo $have->Fields("First_Name")?>
<?php echo $have->Fields("Last_Name")?> <br>
<a href="mailto:<?php echo $have->Fields("Email")?>">
<?php echo $have->Fields("Email")?> </a> <br>
<?php echo $have->Fields("Phone")?> </p></td>
<td valign="top" class="text"> </td>
</tr>
<tr>
<td valign="top" class="text"> </td>
<td valign="top" class="text" colspan="6"><b>Comments: </b> <?php echo nl2br( $have->Fields("custom8")) ?>
</td>
</tr>
<tr>
<td colspan="7" valign="top" class="board"><img src="img/spacer.gif" height="4"></td>
</tr>
<?php
$have->MoveNext();
}
?>
</table>
<p class="title"><a name="need"></a>Need a Ride</p>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="boardbg">
<tr class=board>
<td class=board><b>Departing From</b></td>
<td class=board><b>Departing Date</b></td>
<td class=board><b>Returning to</b></td>
<td class=board ><b>Return Date</b></td>
<td class=board><b># of people</b></td>
<td class=board><b>Contact</b></td>
<td class=board> </td>
</tr>
<?php
while ($need && !$need->EOF) {
?>
<tr>
<td valign="top" class="text"> <?php echo $need->Fields("custom1")?>
</td>
<td valign="top" class="text"> <?php echo $need->Fields("custom2")?>
</td>
<td valign="top" class="text"> <?php echo $need->Fields("custom3")?> </td>
<td valign="top" class="text"> <?php echo $need->Fields("custom4")?> </td>
<td valign="top" class="text"> <?php echo $need->Fields("custom5")?> </td>
<td valign="top" class="text"> <p> <?php echo $need->Fields("First_Name")?>
<?php echo $need->Fields("Last_Name")?> <br>
<a href="mailto:<?php echo $need->Fields("Email")?>">
<?php echo $need->Fields("Email")?> </a> <?php echo $need->Fields("Phone")?>
<br>
</p></td>
<td valign="top" class="text"> </td>
</tr>
<tr>
<td valign="top" class="text"> </td>
<td valign="top" class="text" colspan="6"><b>Comments: </b> <?php echo nl2br( $need->Fields("custom8")) ?></td>
</tr>
<tr class=board>
<td colspan="7" valign="top" ><img src="img/spacer.gif" width="1" height="4"></td>
</tr>
<?php
$need->MoveNext();
}
?>
</table>
<p> </p>
<?php
include("AMP/BaseFooter.php");?>