MikeAuz1979
Programmer
Hi,
This may be a noob question so pls forgive.
Using PHP, Apache and MS_SQL2000 I have a page that has a text box, a select box and a submit button, this posts to another php file that then does a search using these parameters, the problem is that the select box's values have gaps and this field is being truncated to left of the first space when it arrives at the 2nd file. I tried post and get but to no avail.
An example is 'DVLA Team' is being truncated to 'DVLA'
I could convert any spaces to another set of characters and then re-convert back on this next page but I'm wondering if there's an easier in-built way to acheive this.
Thanks for any help
Mike
Input File
Searching File
This may be a noob question so pls forgive.
Using PHP, Apache and MS_SQL2000 I have a page that has a text box, a select box and a submit button, this posts to another php file that then does a search using these parameters, the problem is that the select box's values have gaps and this field is being truncated to left of the first space when it arrives at the 2nd file. I tried post and get but to no avail.
An example is 'DVLA Team' is being truncated to 'DVLA'
I could convert any spaces to another set of characters and then re-convert back on this next page but I'm wondering if there's an easier in-built way to acheive this.
Thanks for any help
Mike
Input File
Code:
<body>
<form action="ADOSearchPost.php" method="Get">
</label>Client ID
<input type="text" name="ClientID" />
<label>Assigned to Team
<select name="Team" id="Team" maxlength = "50"><option value='' selected='selected'>Select...</option>
<?php
include('../adodb5/adodb.inc.php');
$db = ADONewConnection('odbc_mssql');
$db->Connect('Driver={SQL Server};Server=localhost;Database=fb34_Dims', 'sa', 'potty');
$rs = $db->execute("Select distinct assignedtoteam from customer");
while (!$rs->EOF) {
$value = $rs->fields[0];
print ("<option value= $value>$value</option>");
$rs->MoveNext(); // Moves to the next row
} // end while
php?>
</select>
<input type="submit" />
</form></body>
</html>Searching File
Code:
<?php
include('../adodb5/adodb.inc.php');
echo $_GET['ClientID'];
echo $_GET['Team'];
//Other stuff....
//Search