PHP - [merged] Mysql Command

I am not very proficient at MySQL so this came as a shock today.  I have moved an entire set of scripts from one machine to another and after ironing out some of the kinks I was hit this error "The used command is not allowed with this MySQL version" and just when I thought it was all over with.  LOL   This is the command being run...   load data local infile './AM.dat' into table AM fields terminated by '|';

Hi I have tried the mysql forum but have had no joy with an answer to my problem so wondered if php would be better.

I want my users to be able to select from 5 different drop down lists where they can chose any combination from 1 up to all 5,  I have attached the front end.  These lists are being populated from mysql tables.

Code for the drop down lists is as follows
Code: [Select]
  <form action="horse-events-devon.php?url_countyid=<?php echo  urlencode ($url_countyid ['url_countyid'])  ; ?>&go" method="POST">
    <table id="searchtable">
      <tr>
        <th>Find By Discipline</th>
        <th>Find By Venue</th>
        <th>Find By Championship</th>
        <th>Find By Organiser</th>
        <th>Equine Association</th>
        <th>Submit Your Selections</th>
        </tr>
      <tr>
        <td><select name="dis_id">
                                    <?php 
                                        $upcomingdis = upcomingdis($url_countyid);
                                        $upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis);
                                    ?>
                                    <?php 
                                    do { 
       ?>   <option value="<?php echo $upcoming_dis_bycounty ['dis_id']; ?>" >
<?php echo $upcoming_dis_bycounty ['dis_description']; ?></option>
<?php 
                                    } while ($upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis)); 
                                    ?></select></td>
        <td><select name="ven_id">
                                    <?php 
                                        $upvenbycounty_set = upcoming_venevents_bycounty($url_countyid);
                                        $upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set);
                                    ?>
                                    <?php 
                                    do { 
       ?>   <option value="<?php echo $upcoming_ven_bycounty ['ven_id']; ?>" >
<?php echo $upcoming_ven_bycounty ['ven_name']; ?></option>
<?php 
                                    } while ($upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set)); 
                                    ?></select></td>
        <td><select name="champ_id">
                                    <?php 
                                        $championship_set = findchampionships();
                                        $champlist = mysql_fetch_assoc ($championship_set);
                                    ?>
                                    <?php 
do { 
?>   <option value="<?php echo $champlist ['champ_id']; ?>" >
<?php echo $champlist ['champ_description']; ?></option>
<?php 
} while ($champlist = mysql_fetch_assoc ($championship_set)); 
?></select></td>
        <td>
        <select name="org_id">
                        <?php 
                            $uporgbycounty_set = upcoming_organevents_bycounty($url_countyid);
                            $upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set);
                        ?>
                        <?php 
                        do { 
                        ?>   <option value="<?php echo $upcoming_org_bycounty ['org_id']; ?>" ><?php echo $upcoming_org_bycounty ['org_name']; ?></option>
                        <?php 
                        } while ($upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set)); 
                        ?></select>
       
        </td>
        <td><select name="ass_id">
                                    <?php
                                        $upassbycounty_set = upcoming_assevents_bycounty($url_countyid);
                                        $upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set);
                                    ?>
                                    <?php 
                                    do { 
                                    ?>   <option value="<?php echo $upcoming_assbycounty ['ass_id']; ?>" >
<?php echo $upcoming_assbycounty ['ass_description']; ?></option>
                                    <?php 
                                    } while ($upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set)); 
                                    ?></select></td>
      <td><input name="submit" type="submit" /><input name="countyid" type="hidden" value="<?php echo $url_countyid ['url_countyid']; ?>" /></td>
        </tr>
      </table>
  </form>
My search processing is as follows

Code: [Select]
  <?php
if (isset($_POST['submit'])){
if (isset($_GET['go'])){
$countyid = $_POST['countyid'];
$ven_id = $_POST['ven_id'];
$dis_id = $_POST['dis_id'];
$champ_id = $_POST['champ_id'];
$org_id = $_POST['org_id'];
$event_id = $row['event_id'];

$sql = "SELECT DATE_FORMAT (events.startdate, '%a, %d, %b') 
   AS stdate, events.event_id, events.title, events.ven_id, events.org_id,
   venue.county_id, venue.ven_id, eventdisciplines.event_id, eventdisciplines.dis_id, county.county_id, discipline.dis_id \n"
. "FROM events \n"
. "LEFT OUTER JOIN eventdisciplines \n"
. "ON events.event_id = eventdisciplines.event_id \n"
. "LEFT OUTER JOIN discipline \n"
. "ON eventdisciplines.dis_id = discipline.dis_id \n"
. "LEFT OUTER JOIN venue \n"
. "ON events.ven_id = venue.ven_id \n"
. "LEFT OUTER JOIN county \n"
. "ON venue.county_id = county.county_id \n"
. "WHERE events.ven_id = ({$ven_id} OR events.org_id = {$org_id})\n"
. "AND events.startdate > NOW()\n"
. "AND venue.county_id = {$countyid}  \n"
. "ORDER BY startdate ASC";

$result = mysql_query ($sql, $connection);
?>
How am I best to do this please?  my OR within the mysql does not work, should I not be doing this with php in the search processing?  someones help would really be appreciated, just to point me in the right direction.

[attachment deleted by admin]

how do i insert this into a database? i need the php code please.
Code: [Select]
<select class="select" name="sex" id="sex">
            <option value="0">Select Gender</option>
            <option value="1">Female</option>
            <option value="2">Male</option></select>I need it to insert what ever one they select
Thanks

finally got some time to code   anyway i cant figure out why this doesnt work, i think its an error in my logic...

<?php
$db = new PDO('mysql:host=localhost; dbname=test;', 'root', '');
$db2 = new PDO('mysql:host=localhost; dbname=test2;', 'root', '');
foreach($db->query('SELECT * FROM database1 LIMIT 1') as $row) {
$thing1 = $row['COL 1'];
$thing2 = $row['COL 2'];
$thing3 = $row['COL 4'];
$thing4 = $row['COL 6'];
$thing5 = $row['COL 7'];
$content = "\"big text with $things\"";
addslashes($content);
$db2->exec("INSERT INTO database2(col1,col2,col3) VALUES ('$thing1','text','$content')");
}
?>

my foreach command should read all lines from database one and write one by one on database two? thx in advance

I've created a login page in Dreamweaver and there is a redirect page for login success and login fail. What I want to have is a selection of screens based on a data field held in the user security table.
Each security record will have up to 5 different security codes e.g. code1, code2 etc. If a code e.g. TA40, appears in any of the 5 code fields then I want the user directed to one page, if code TA41 appears in any of the 5 code fields then I want them directed to another page.
The user code will only appear in one of the fields, but can appear in any of the 5 code fields.. How can I incorporate this in to the login screen logic, as currently it will just show the follwoing

if (isset($_POST['opno'])) {
  $loginUsername=$_POST['opno'];
  $password=$_POST['pass_word'];
  $MM_fldUserAuthorization = "";
  $MM_redirectLoginSuccess = "/menu.php";
  $MM_redirectLoginFailed = "/loginform.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_Hanson, $Hanson);