PHP - Moved: What Have I Done Wrong?

I am querying...

$sql  = "SELECT `messages_inbox`.`message_id`, `users`.`firstname`, `users`.`lastname`, `users`.`username` AS `from`, '${user_info['username']}' AS `to`, `subject`, LENGTH(`files`) AS `len`, 'inbox' AS `box`, DATE_FORMAT(`messages_inbox`.`time` ,'%T %D-%M-%Y') AS `time` ";
   
$sql .= "FROM `messages_inbox` INNER JOIN `users` ON `messages_inbox`.`from_id` = `users`.`id` WHERE `to_id` = ${user_info['uid']} AND `messages_inbox`.`deleted` = 0 ORDER BY `messages_inbox`.`message_id` DESC";

and I am trying to output

$displayName = ucwords("${message['firstname']} ${message['lastname']}");

by using

$messages = pm_fetch_all($_GET['box']);

I know my fetch works but for some reason firstname and lastname are only returning the logged in users first name and last name, not the person who sent the message.

Code: [Select]
<?php
include('connection.php');

$test1=$_POST('firstname');
$test2=$_POST('lastname');
$test3=$_POST('username');

if (!eregi("([^A-Za-z0-9]"),$test1)){

if (!eregi("([^A-Za-z0-9]"),$test2)){
if (!eregi("([^A-Za-z0-9]"),$test3)){
$query="SELECT * FROM vendors WHERE username = '$_POST(username)'"
$result=mysql_query($query);
$num=mysql_num_rows($result);
if ($num == 0) {
$query1="SELECT * FROM vendors WHERE email = '$_POST(email)'"
$result1=mysql_query($query2);
$num1=mysql_num_rows($result1)
if ($num1 == 0) {
if (($_POST['password']==$_POST['password1'])&&($_POST['email']==$_POST['email1']))
{
$name=strip_tags($_POST['username']);
$first=strip_tags($_POST['firstname']);
$last=strip_tags($_POST['lastname']);
$pass=strip_tags($_POST['password']);
$country=strip_tags($_POST['country']);
$address=strip_tags($_POST['address']);
$email=strip_tags($_POST['email']);
$city=strip_tags($_POST['city']);
$zip=strip_tags($_POST['zipcode']);
$state=strip_tags($_POST['state']);
$phone=strip_tags($_POST['phonenumber']);
$aql="INSERT INTO vendors SET username='$name', firstname='$first', lastname='$last', email='$email', Country='$country', zipcode='$zip', password='$pass', city='$city', state='$state', phonenumber='$phone', address='$address'"
$result=mysql_query($sql)
if ($result){
header(location:http://www.digitaldesignersmall.com/ffx.html)
}
else {
header(location:http://www.digitaldesignersmall.com/fff.html)
}

}
else(
header(location:http://www.digitaldesingersmall.com/afx.html)
}

}
else {
Header(location:http://www.digitaldesingersmall.com/afx.html)
}

}
else{
header("location:http://www.digitaldesignersmall.com/cxs.html")
}

}

else{

header("location:http://www.digitaldesignersmall.com/cxs.html")

}
}
else{
header("location:http://www.digitaldesignersmall.com/cxs.html")
}


?>

Can someone please take a look and see if you can point out what error i made. Everything on the form side is functioning except it doesn't seem to post since its looping back to the form rather than the redirect. Also, within the actual form table, i had to change the section that says Business Hours from a textarea because I couldn't get it to echo the data from the field in the database. Any ideas on that would be greatly appreciated. Sorry if its a bit sloppy, I'm no expert.

Code: [Select]
<?php
   include "config.php";
mysql_connect("$dbhost","$dbusr","$dbpass"); 
mysql_select_db("$dbname");
            
session_start();

if (isset($_SESSION['user'])) {
   
      } else {
    header ('location: login.php');
}

 // creates the edit record form
 // since this form is used multiple times in this file, I have made it a function that is easily reusable
 function renderForm($id, $username, $location, $address, $city, $zip, $county, $website, $map, $email, $phone, $bhours, $ptimes, $pspecials, $vspecials, $error)
 {

echo "<center><strong>Edit Location Information</strong></center>";
 
 // if there are any errors, display them
 if ($error != '')
 {
 echo '<div style="padding:4px; border:1px solid red; color:red;">'.$error.'</div>';
 }

 echo "
<center>

    <form action='' method='POST'>
   
      <table border='0' frame='box'>
            <tr>
              <td width='96'><div align='right'>Venue ID:</div></td>
              <td colspan='2'><input type='hidden' name='id' value='$id'>$id</td>
            </tr>
            <tr>
                <td><div align='right'><font size='2' face='arial'>Username:</font></div></td>
                <td colspan='2'><input type='text' name='r_username' value='$username'></td>
            </tr>
         <tr>
           <td>Business Name:</td>
           <td colspan='2'><input type='text' name='r_location' value='$location'></td>
        </tr>
         <tr>
                <td><div align='right'><font size='2' face='arial'>Address:</font></div></td>
                <td colspan='2'><input type='text' name='r_address' value='$address'></td>
            </tr>
         <tr>
           <td><div align='right'>City/State:</div></td>
           <td><input type='text' name='r_city' value='$city'></td>
           <td>Format = City, St</td>
         </tr>
         <tr>
                <td><div align='right'><font size='2' face='arial'>Zip:</font></div></td>
                <td colspan='2'><input type='text' name='r_zip'value='$zip'></td>
            </tr>
            <tr>
              <td><div align='right'>County:</div></td>
              <td colspan='2'><input type='text' name='r_county'value='$county'></td>
            </tr>
            <tr>
              <td><div align='right'>Website:</div></td>
              <td colspan='2'><input type='text' name='r_website' value='$website'></td>
            </tr>
            <tr>
              <td><div align='right'>Directions:</div></td>
              <td colspan='2'><input type='text' name='r_map' value='$map'></td>
            </tr>
            <tr>
              <td><div align='right'><font size='2' face='arial'>E-mail:</font></div></td>
              <td colspan='2'><input type='text' name='r_email' value='$email'></td>
            </tr>
            <tr>
                <td><div align='right'><font size='2' face='arial'>Phone #::</font></div></td>
                <td colspan='2'><input type='text' name='r_phone' value='$phone'></td>
            </tr>
            <tr>
                <td height='80'><div align='right'><font size='2' face='arial'>Business Hours:</font></div></td>
                <td width='287'><input type='text' name='r_bhours' cols='45' rows='3' value='$bhours'></td>
                <td width='244'><p>**You must enter &lt;/br&gt; after each line to display in rows:</p>
                <p>Mon - Fri 11am to 10pm&lt;/br&gt;</p>
                <p>Sat - Sun 1PM to 3am&lt;/br&gt;</p></td>
            </tr>
            <tr>
                <td><div align='right'><font size='2' face='arial'>Poker Times:</font></div></td>
                <td colspan='2'><input type='text' name='r_ptimes' value='$ptimes'></td>
            </tr>
            <tr>
              <td><div align='right'><font size='2' face='arial'>Poker Specials:</font></div></td>
              <td><input type='text' name='r_pspecials' value='$pspecials'></td>
              <td>&nbsp;</td>
            </tr>
            <tr>
              <td><div align='right'><font size='2' face='arial'>Location Specials:</font></div></td>
              <td><input type'text' name='r_vspecials' cols='45' rows='3' value='$vspecials'></td>
              <td><p>**You must enter &lt;/br&gt; after each line to display in rows:</p>
                <p>Mon - $0.10 Wings&lt;/br&gt;</p>
              <p>Fri - 2 for 1 Happy hour&lt;/br&gt;</p></td>
            </tr>
            <tr>
                <td></td>
                <td colspan='2'><div align='center'><font size='2' face='arial'><a href='edituser.php'>Cancel</a> - </font><input type='submit' value='Update Location'></div></td>
            </tr>
        </table>
</form>
    
</center>
";
 }

 // check if the form has been submitted. If it has, process the form and save it to the database
 if (isset($_POST['submit']))
 { 
 // confirm that the 'id' value is a valid integer before getting the form data
 if (is_numeric($_POST['id']))
 {
 // get form data, making sure it is valid
 $id = $_POST['id'];
 $username = mysql_real_escape_string(htmlspecialchars($_POST['username']));
 $location = mysql_real_escape_string(htmlspecialchars($_POST['loc_name']));
 $address = mysql_real_escape_string(htmlspecialchars($_POST['address']));
 $city = mysql_real_escape_string(htmlspecialchars($_POST['city']));
 $zip = mysql_real_escape_string(htmlspecialchars($_POST['zip']));
 $county = mysql_real_escape_string(htmlspecialchars($_POST['county']));
 $website = mysql_real_escape_string(htmlspecialchars($_POST['website']));
 $map = mysql_real_escape_string(htmlspecialchars($_POST['map']));
 $email = mysql_real_escape_string(htmlspecialchars($_POST['email']));
 $phone = mysql_real_escape_string(htmlspecialchars($_POST['phone']));
 $bhours = mysql_real_escape_string(htmlspecialchars($_POST['hours']));
 $ptimes = mysql_real_escape_string(htmlspecialchars($_POST['ptime']));
 $pspecials = mysql_real_escape_string(htmlspecialchars($_POST['pspecial']));
 $vspecials = mysql_real_escape_string(htmlspecialchars($_POST['vspecial']));
 // check that username field is filled in
 if ($username == '')
 {
 // generate error message
 $error = 'ERROR: Please fill in all required fields!';
 
 //error, display form
 renderForm($id, $username, $location, $address, $city, $zip, $county, $website, $map, $email, $phone, $bhours, $ptimes, $pspecials, $vspecials, $error);
 }
 else
 {
 // save the data to the database
 mysql_query("UPDATE vusr SET username='$username', loc_name='$location', address='$address', city='$city', zip='$zip', county='$county', website='$website', map='$map', email='$email', phone='$phone', hours='$bhours', ptime='$ptimes', pspecial='$pspecials', vspecial='$vspecials' WHERE id='$id'")
 or die(mysql_error()); 
 
 // once saved, redirect back to the view page
 header("Location: edituser.php"); 
 }
 }
 else
 {
 // if the 'id' isn't valid, display an error
 echo 'Error!';
 }
 }
 else
 // if the form hasn't been submitted, get the data from the db and display the form
 {
 
 // get the 'id' value from the URL (if it exists), making sure that it is valid (checing that it is numeric/larger than 0)
 if (isset($_GET['id']) && is_numeric($_GET['id']) && $_GET['id'] > 0)
 {
 // query db
 $id = $_GET['id'];
 $result = mysql_query("SELECT * FROM vusr WHERE id=$id")
 or die(mysql_error()); 
 $row = mysql_fetch_array($result);
 
 // check that the 'id' matches up with a row in the databse
 if($row)
 {
 
 // get data from db
 $id = $row['id'];
 $username = $row['username'];
 $location = $row['loc_name'];
 $address = $row['address'];
 $city = $row['city'];
 $zip = $row['zip'];
 $county = $row['county'];
 $website = $row['website'];
 $map = $row['map'];
 $email = $row['email'];
 $phone = $row['phone'];
 $bhours = $row['hours'];
 $ptimes = $row['ptime'];
 $pspecials = $row['pspecial'];
 $vspecials = $row['vspecial'];
 // show form
 renderForm($id, $username, $location, $address, $city, $zip, $county, $website, $map, $email, $phone, $bhours, $ptimes, $pspecials, $vspecials, '');
 }
 else
 // if no match, display result
 {
 echo "No results!";
 }
 }
 else
 // if the 'id' in the URL isn't valid, or if there is no 'id' value, display an error
 {
 echo 'Error!';
 }
 }


?>

MOD EDIT: code tags added.

I have all error reporting turned on. And no errors are showing. I've been  staring at this code for 2 hours and can't find the error. But the form is blank!  The form shows up with the radio buttons but is blank!

Heres the code...
<?php
error_reporting(E_ALL);
?>
<?php
include 'dbc.php';
//-----------------------------------------

$result = mysql_query("SELECT * FROM users ORDER BY nc_points DESC");
while ($row = mysql_fetch_object($result)) {
    $leaderboard[] =  $row->user_name;
$leaderboardPoints[] = $row->cfb_points;
}
$result1 = mysql_query("SELECT  CollegeFootballGames.ID, CollegeFootballGames.Week,  CollegeFootballGames.Away, CollegeFootballGames.Home, CollegeFootballTeams.Team
FROM CollegeFootballGames INNER JOIN CollegeFootballTeams
ON CollegeFootballGames.Away = CollegeFootballTeams.ID || CollegeFootballGames.Home=CollegeFootballTeams.ID");
while ($row = mysql_fetch_object($result1)) {
    $GameID[] = $row->ID;
     $Teams[] = $row->Team;
}

//----------------------------------------
$date =("now");
if ( strtotime($date) > strtotime('18 July 2010') && strtotime($date) < strtotime('2 September 2010')){$wknum = '1'; $wk = "Week";}
elseif ( strtotime($date) > strtotime('6 September 2010') && strtotime($date) < strtotime('11 September 2010')){$wknum = '2';  $wk = "Week";}
elseif ( strtotime($date) > strtotime('11 September 2010') && strtotime($date) < strtotime('16 September 2010')){$wknum = '3';  $wk = "Week";}
elseif ( strtotime($date) > strtotime('18 September 2010') && strtotime($date) < strtotime('23 September 2010')){$wknum = '4';  $wk = "Week";}
elseif ( strtotime($date) > strtotime('25 September 2010') && strtotime($date) < strtotime('2 October 2010')){$wknum = '5';  $wk = "Week";}
elseif ( strtotime($date) > strtotime('2 October 2010') && strtotime($date) < strtotime('9 October 2010')){$wknum = '6';  $wk = "Week";}
elseif ( strtotime($date) > strtotime('9 October 2010') && strtotime($date) < strtotime('16 October 2010')){$wknum = '7'; $wk = "Week";}
elseif ( strtotime($date) > strtotime('16 October 2010') && strtotime($date) < strtotime('23 October 2010')){$wknum = '8'; $wk = "Week";}
elseif ( strtotime($date) > strtotime('23 October 2010') && strtotime($date) < strtotime('28 October 2010')){$wknum = '9'; $wk = "Week";}
elseif ( strtotime($date) > strtotime('30 October 2010') && strtotime($date) < strtotime('4 November 2010')){$wknum = '10'; $wk = "Week";}
elseif ( strtotime($date) > strtotime('6 November 2010') && strtotime($date) < strtotime('13 November 2010')){$wknum = '11'; $wk = "Week";}
elseif ( strtotime($date) > strtotime('13 November 2010') && strtotime($date) < strtotime('20 November 2010')){$wknum = '12'; $wk = "Week";}
elseif ( strtotime($date) > strtotime('20 November 2010') && strtotime($date) < strtotime('27 November 2010')){$wknum = '13'; $wk = "Week";}
else{}

//Form 12
$form12 = ('<h3><em style="color: #F00"> <?php echo $wk;?> <?php echo $wknum;?> </em></h3>
            <form name="Picks" method="post" action="<?php echo $process; ?>">
              <p><br>
  <input name="P0" type="hidden" value="<?php echo ($p[0]); ?>">
                <label>
                  <input type="radio" name="game1" value="<?php echo ($away[0]);?>" >
                  <?php echo ($away[0]);?></label>
                at
                <label>
                  <input type="radio" name="game1" value="<?php echo ($home[0]);?>" >
                  <?php echo ($home[0]);?></label>
                <br>
  <input name="P1" type="hidden" value="<?php echo ($p[1]); ?>">
                <label>
                  <input type="radio" name="game2" value="<?php echo ($away[1]);?>" >
                  <?php echo ($away[1]);?></label>
                at
                <label>
                  <input type="radio" name="game2" value="<?php echo ($home[1]);?>" >
                  <?php echo ($home[1]);?></label>
  <br>
  <input name="P2" type="hidden" value="<?php echo ($p[2]); ?>">
                <label>
                  <input type="radio" name="game3" value="<?php echo ($away[2]);?>" >
                  <?php echo ($away[2]);?></label>
                at
                <label>
                  <input type="radio" name="game3" value="<?php echo ($home[2]);?>" >
                  <?php echo ($home[2]);?></label>
  <br>
  <input name="P3" type="hidden" value="<?php echo ($p[3]); ?>">
                <label>
                  <input type="radio" name="game4" value="<?php echo ($away[3]);?>" >
                  <?php echo ($away[3]);?> </label>
                at
                <label>
                  <input type="radio" name="game4" value="<?php echo ($home[3]);?>" >
                 <?php echo ($home[3]);?></label>
  <input name="P4" type="hidden" value="<?php echo ($p[4]); ?>">
                <br>
                <label>
                  <input type="radio" name="game5" value="<?php echo ($away[4]);?>" >
                  <?php echo ($away[4]);?></label>
                at
                <label>
                  <input type="radio" name="game5" value="<?php echo ($home[4]);?>" >
                 <?php echo ($home[4]);?></label>
                <br>
  <input name="P5" type="hidden" value="<?php echo ($p[5]); ?>">
                <label>
                  <input type="radio" name="game6" value="<?php echo ($away[5]);?>" >
                  <?php echo ($away[5]);?></label>
                at
                <label>
                  <input type="radio" name="game6" value="<?php echo ($home[5]);?>" >
                  <?php echo ($home[5]);?></label>
                <br>
  <input name="P6" type="hidden" value="<?php echo ($p[6]); ?>">
                <label>
                  <input type="radio" name="game7" value="<?php echo ($away[6]);?>" >
                  <?php echo ($away[6]);?></label>
                at
                <label>
                  <input type="radio" name="game7" value="<?php echo ($home[6]);?>" >
                 <?php echo ($home[6]);?></label>
                <br>
  <input name="P7" type="hidden" value="<?php echo ($p[7]); ?>">
                <label>
                  <input type="radio" name="game8" value="<?php echo ($away[7]);?>" >
                 <?php echo ($away[7]);?></label>
                at
                <label>
                  <input type="radio" name="game8" value="<?php echo ($home[7]);?>" >
                  <?php echo ($home[7]);?></label>
                <br>
  <input name="P8" type="hidden" value="<?php echo ($p[8]); ?>">
                <label>
                  <input type="radio" name="game9" value="<?php echo ($away[8]);?>" >
                  <?php echo ($away[8]);?> </label>
                at
                <label>
                  <input type="radio" name="game9" value="<?php echo ($home[8]);?>" >
                  <?php echo ($home[8]);?></label>
                <br>
  <input name="P9" type="hidden" value="<?php echo ($p[9]); ?>">
                <label>
                  <input type="radio" name="game10" value="<?php echo ($away[9]);?>" >
                  <?php echo ($away[9]);?> </label>
                at
                <label>
                  <input type="radio" name="game10" value="<?php echo ($home[9]);?>" >
                  <?php echo ($home[9]);?></label>
                <br>
  <input name="P10" type="hidden" value="<?php echo ($p[10]); ?>">
                <label>
                  <input type="radio" name="game11" value="<?php echo ($away[10]);?>" >
                  <?php echo ($away[10]);?></label>
                at
                <label>
                  <input type="radio" name="game11" value="<?php echo ($home[10]);?>" >
                  <?php echo ($home[10]);?></label>
               <br>
  <input name="P11" type="hidden" value="<?php echo ($p[11]); ?>">
                <label>
                  <input type="radio" name="game12" value="<?php echo ($away[11]);?>" >
                  <?php echo ($away[11]);?></label>
                at
                <label>
                  <input type="radio" name="game12" value="<?php echo ($home[11]);?>" >
                  <?php echo ($home[11]);?></label>
<br>
                <br>
                <label>
                  <input type="reset" name="button" id="button" value="Reset">
                </label>
                <label>
                  <input type="submit" name="button2" id="button2" value="Submit">
                </label>
                <br>
              </p>
            </form>');


if ( strtotime($date) > strtotime('18 July 2010') && strtotime($date) < strtotime('2 September 2010')){$wknum = '1'; $formDisplay = $form12; $wk = "Week"; $process = 'cfb_picks_process.php'; 
$away =array("$Teams[0]","$Teams[2]","$Teams[4]","$Teams[6]","$Teams[8]","$Teams[10]","$Teams[12]","$Teams[14]","$Teams[16]","$Teams[18]","$Teams[20]","$Teams[22]"); 
$home =array("$Teams[1]","$Teams[3]","$Teams[5]","$Teams[7]","$Teams[9]","$Teams[11]","$Teams[13]","$Teams[15]","$Teams[17]","$Teams[19]","$Teams[21]","$Teams[23]");
$p = array ("$GameID[0]","$GameID[2]","$GameID[4]","$GameID[6]","$GameID[8]","$GameID[10]","$GameID[12]","$GameID[14]","$GameID[16]","$GameID[18]","$GameID[20]","$GameID[22]");}

elseif ( strtotime($date) > strtotime('6 September 2010') && strtotime($date) < strtotime('11 September 2010')){$wknum = '2';$formDisplay = $form12; $wk = "Week";$process = 'cfb_picks_process.php';
$away =array("$Teams[24]","$Teams[26]","$Teams[28]","$Teams[30]","$Teams[33]","$Teams[34]","$Teams[36]","$Teams[38]","$Teams[40]","$Teams[42]","$Teams[44]","$Teams[46]"); 
$home =array("$Teams[25]","$Teams[27]","$Teams[29]","$Teams[31]","$Teams[32]","$Teams[35]","$Teams[37]","$Teams[39]","$Teams[41]","$Teams[43]","$Teams[45]","$Teams[47]");
$p = array ("$GameID[24]","$GameID[26]","$GameID[28]","$GameID[30]","$GameID[32]","$GameID[34]","$GameID[36]","$GameID[38]","$GameID[40]","$GameID[42]","$GameID[44]","$GameID[46]");
}


elseif ( strtotime($date) > strtotime('11 September 2010') && strtotime($date) < strtotime('16 September 2010')){$wknum = '3';$formDisplay = $form12; $wk = "Week";$process = 'cfb_picks_process.php';
$away =array("$Teams[49]","$Teams[50]","$Teams[52]","$Teams[55]","$Teams[56]","$Teams[58]","$Teams[61]","$Teams[62]","$Teams[64]","$Teams[66]","$Teams[68]","$Teams[70]"); 
$home =array("$Teams[48]","$Teams[51]","$Teams[53]","$Teams[54]","$Teams[57]","$Teams[59]","$Teams[60]","$Teams[63]","$Teams[65]","$Teams[67]","$Teams[69]","$Teams[71]");
$p = array ("$GameID[48]","$GameID[50]","$GameID[52]","$GameID[54]","$GameID[56]","$GameID[58]","$GameID[60]","$GameID[62]","$GameID[64]","$GameID[66]","$GameID[68]","$GameID[70]");
}

elseif ( strtotime($date) > strtotime('18 September 2010') && strtotime($date) < strtotime('23 September 2010')){$wknum = '4';$formDisplay = $form12; $wk = "Week";$process = 'cfb_picks_process.php';
$away =array("$Teams[72]","$Teams[74]","$Teams[76]","$Teams[78]","$Teams[80]","$Teams[83]","$Teams[85]","$Teams[87]","$Teams[88]","$Teams[91]","$Teams[92]","$Teams[94]"); 
$home =array("$Teams[73]","$Teams[75]","$Teams[77]","$Teams[79]","$Teams[81]","$Teams[82]","$Teams[84]","$Teams[86]","$Teams[89]","$Teams[90]","$Teams[93]","$Teams[95]");
$p = array ("$GameID[72]","$GameID[74]","$GameID[76]","$GameID[78]","$GameID[80]","$GameID[82]","$GameID[84]","$GameID[86]","$GameID[88]","$GameID[90]","$GameID[92]","$GameID[94]");
}

elseif ( strtotime($date) > strtotime('25 September 2010') && strtotime($date) < strtotime('2 October 2010')){$wknum = '5';$formDisplay = $form12; $wk = "Week";$process = 'cfb_picks_process.php';
/*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); 
$home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]");
$p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]");
*/}

elseif ( strtotime($date) > strtotime('2 October 2010') && strtotime($date) < strtotime('9 October 2010')){$wknum = '6';$formDisplay = $form12; $wk = "Week";$process = 'cfb_picks_process.php';
/*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); 
$home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]");
$p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]");
*/}

elseif ( strtotime($date) > strtotime('9 October 2010') && strtotime($date) < strtotime('16 October 2010')){$wknum = '7';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php';
/*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); 
$home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]");
$p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]");
*/}

elseif ( strtotime($date) > strtotime('16 October 2010') && strtotime($date) < strtotime('23 October 2010')){$wknum = '8';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php';
/*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); 
$home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]");
$p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]");
*/}

elseif ( strtotime($date) > strtotime('23 October 2010') && strtotime($date) < strtotime('28 October 2010')){$wknum = '9';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php';
/*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); 
$home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]");
$p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]");
*/}

elseif ( strtotime($date) > strtotime('30 October 2010') && strtotime($date) < strtotime('4 November 2010')){$wknum = '10';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php';
/*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); 
$home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]");
$p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]");
*/}

elseif ( strtotime($date) > strtotime('6 November 2010') && strtotime($date) < strtotime('13 November 2010')){$wknum = '11';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php';
/*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); 
$home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]");
$p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]");
*/}

elseif ( strtotime($date) > strtotime('13 November 2010') && strtotime($date) < strtotime('20 November 2010')){$wknum = '12';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php';
/*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); 
$home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]");
$p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]");
*/}

elseif ( strtotime($date) > strtotime('20 November 2010') && strtotime($date) < strtotime('27 November 2010')){$wknum = '13';$formDisplay = $form12;$wk = "Week";$process = 'cfb_picks_process.php';
/*$away =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]"); 
$home =array("$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]","$Teams[]");
$p = array ("$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]","$GameID[]");
*/}

else{$formDisplay = $wk = " "; $formDisplay = ("<br><br><h2>Picks For this week are final!</h2> <br><br><br> Check Back Later To Make Your Picks For Next Week");}




$result = mysql_query("SELECT * FROM users ORDER BY nc_points DESC");
while ($row = mysql_fetch_object($result)) {
    $leaderboard[] =  $row->user_name;
$leaderboardPoints[] = $row->cfb_points;
}
$result1 = mysql_query("SELECT  CollegeFootballGames.ID, CollegeFootballGames.Week,  CollegeFootballGames.Away, CollegeFootballGames.Home, CollegeFootballTeams.Team
FROM CollegeFootballGames INNER JOIN CollegeFootballTeams
ON CollegeFootballGames.Away = CollegeFootballTeams.ID || CollegeFootballGames.Home=CollegeFootballTeams.ID");
while ($row = mysql_fetch_object($result1)) {
    $GameID[] = $row->ID;
     $Teams[] = $row->Team;
}
?>

<?
echo $formDisplay;
?>

If you see what is wrong please tell me.

it's supposed to check the file, to see if it's available for download, the code below looks okay to me, what's wrong?

if($row[2]==2) // 4shared check
{
$row[1]="http://www.".$row[1];
$index=getpage($row[1]);
preg_match("/Download ([^<]+)<\/div>/",$index,$match);
if(strpos($index,"The file is shared for public access and download.")===false || !$match)
{
mysql_query("UPDATE `v2links` SET `checked`='-1',`lastcheck`=NOW() WHERE `id`=".$row[0]);
print "bad link\n";
logstr("log-c.txt","bad link\n");
}
else
{
$words=trim($match[1]);
$words=preg_split("/[_\.\-\s]/",$words);
$lastword=array_pop($words);
$words=implode(" ",$words);
$words=preg_replace("/\s{2,}/"," ",$words);
$caption=mysql_real_escape_string($words);
unset($words);
unset($match);
preg_match("/<td>Size\:<\/td><td>([^<]+)<\/td>/",$index,$match);
$fsize=$match[1];
unset($match);
print "$caption :: $fsize\n";
logstr("log-c.txt","$caption :: $fsize\n");
mysql_query("UPDATE `v2links` SET `checked`='1',`lastcheck`=NOW(),`fsize`='$fsize',`caption`='$caption' WHERE `id`=".$row[0]);
if(mysql_errno()) print mysql_error()."\n";
}
}


I'm wondering if the sharing website has changed anything, because for rapidshare it works fine, code:

if($row[2]==1) // rapidshare check
{
$index=getpage($row[1]);
if(strpos($index,"<p><script>alert(\"File not found.\")</script>File not found.</p>")===false && strpos($index,"This file has been deleted.")===false)
{
preg_match("/<form action=\"([^\"]+)\" method=\"post\">/",$index,$match);
//print $index;
if($match[1])
{
$fpath=$match[1];
$index=getpage($fpath,"dl.start=Free",$row[1]);
preg_match("/<\/font> \(([^\(]+)\)\.<\/p>/",$index,$match);
$fsize=0;
if($match[1]) $fsize=mysql_real_escape_string(strip_tags($match[1]));
print $fsize."\n";
logstr("log-c.txt",$fsize."\n");
mysql_query("UPDATE `v2links` SET `checked`='1',`fsize`='$fsize',`lastcheck`=NOW() WHERE `id`=".$row[0]);
if(mysql_errno()) print mysql_error()."\n";
}
else
{
print "bad link\n";
logstr("log-c.txt","bad link\n");
mysql_query("UPDATE `v2links` SET `checked`='-1',`lastcheck`=NOW() WHERE `id`=".$row[0]);
if(mysql_errno()) print mysql_error()."\n";
}
}
else
{
print "bad link\n";
logstr("log-c.txt","bad link\n");
mysql_query("UPDATE `v2links` SET `checked`='-1',`lastcheck`=NOW() WHERE `id`=".$row[0]);
if(mysql_errno()) print mysql_error()."\n";
}
}


any help would be appreciated!

Code: [Select]
<!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 content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Send Data Form</title>
</head>

<body>
<?php

if(!$_POST) exit;

$email = $_POST['Email'];
$name = $_POST['Name'];
$telephone = $_POST['Telephone'];
$comments = $_POST['Comments'];

//$error[] = preg_match('/\b[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}\b/i', $_POST['email']) ? '' : 'INVALID EMAIL ADDRESS';
if(!eregi("^[a-z0-9]+([_\\.-][a-z0-9]+)*" ."@"."([a-z0-9]+([\.-][a-z0-9]+)*)+"."\\.[a-z]{2,}"."$",$email )){
   $errors=1;
}
if($errors==1) echo $error;
else{
   $values = array ('Name','Email','Telephone','Comments');
   $required = array('Name','Email','Telephone','Comments');
   

   $your_email = "****************";
   $email_subject = "Comment posted from website:";
   
   
   foreach($values as $key => $value){
     if(in_array($value,$required)){
      if ($key != 'Name' && $key != 'Comments' && $key != 'Telephone') {
        if( empty($_POST[$value]) ) { echo 'Please go back and complete all fields, thank you.'; exit; }
      }
      $email_content .= $value.': '.$_POST[$value]."\n";
     }
   }
    
}
   
$headers = "From: $email\r\n"."Reply-To: $email\r\n".'X-Mailer: PHP/' . phpversion();
   

mail($your_email, $email_subject, $email_content, $headers);

if($send_contact){
echo "Thank you for your submission";
}
else {
echo "ERROR, your comment was not sent";

?>
</body>

</html>

MOD EDIT: [code] . . . [/code] tags added.

What an Earth is wrong with this code?

Code: [Select]
$query = "select sizes from products where id='$id'"; $result = mysql_query($query); $row = mysql_fetch_array($result); if ($row == 0) {echo "";} else {echo "Small - $row['sizes']";}
PHP Parse error:  syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

I am trying to create a very basic object but am having troubles.

Code: [Select]
<?php

class item{

public $name;
public $price;

function __construct($name,$price){
$this->name=$name;
$this->price=$price;}

function getName(){
return $this->name;
}

}


$object = new item("car",400);
echo $object->getName();


?>
The HTML output is:

name=$name; $this->price=$price;} function getName(){ return $this->name; } } $object = new item("car",400); echo $object->getName(); ?>


I'm sure that this code is clean but for some reason will not output the desired result! any help would be great. thanks.

Hi all.
I always create my sql queries like below.

        $user = "user";
$pass = "123456";
$host = "localhost";
$base = "test";

$cn = mysql_connect($host, $user, $pass) or trigger_error("SQL", E_USER_ERROR);
mysql_select_db($base,$cn) or trigger_error("SQL", E_USER_ERROR);

       $QUERY = mysql_query("SELECT id FROM someTable", [size=14pt][color=red][b]$cn[/b][/color][/size]) or die(mysql_error());

while ($list = mysql_fetch_assoc($QUERY)){
              echo "Some Text over loop";
        }


Okay here is the question (or problem). What if i have 5000 records in my Table. Doesn't this code connect DB 5000 times?
If yes, then how can i optimize it?

ok so before this.. if there isnt description for the company..the logo cant be click..only can be clicked if there is description added..im confused..


Code: [Select]


<?
if(isset($_GET[ttid])) {
$ttid = $_GET[ttid];
}

$connection=mysql_connect("$server", "$username", "$password")
or die("Could not establish connection");
mysql_select_db($database_name, $connection)
or die ("Could not select database");


$query = "select master_event.* ,
(DATE_FORMAT(event_datefrom, '%d %M %Y')) as datefrom,
(DATE_FORMAT(event_dateto, '%d %M %Y')) as dateto,
ucase(event_name) as eventname
from master_event
where master_event.event_id = '$ttid '";
$result=mysql_query($query);
while($row = mysql_fetch_array($result)){
$eventname = $row['eventname'];
$eventdesc = $row['event_desc'];
//$companydescription = $row['company_description'];
$eventvenue = $row['event_venue'];
$eventfee = $row['event_fee'];
$datefrom = $row['datefrom'];
$dateto = $row['dateto'];

echo "<font color='#000000'  face='arial' ><b> $eventname </b> </font> <br>";
echo "<font color='#000000'  face='arial' ><i>Date</i> : $datefrom - $dateto <br>";
echo "<i>Venue</i> : $eventvenue <br>";

$querypstype = "SELECT DISTINCT master_pstype.pstype_id,  pstype_desc FROM master_pstype
INNER JOIN master_psevent ON master_psevent.pstype_id= master_pstype.pstype_id
where master_psevent.event_id = '$ttid'
ORDER BY pstype_order";

$resultpstype=mysql_query($querypstype);
while($rowpstype = mysql_fetch_array($resultpstype)){
$pstypeid = $rowpstype['pstype_id'];
$pstypedesc = $rowpstype['pstype_desc'];
echo "<br><font color='#8B3A3A' size='1' face='georgia' ><b><i>$pstypedesc</i></b></font> <br>";

$queryps = "SELECT master_psevent.*, pstype_desc, company_name, company_link, company_description, logo_filename FROM master_psevent
LEFT JOIN master_pstype ON master_psevent.pstype_id = master_pstype.pstype_id
LEFT JOIN master_ps ON master_ps.ps_id = master_psevent.ps_id
WHERE master_psevent.event_id = '$ttid' and master_pstype.pstype_id= '$pstypeid'
ORDER BY pstype_desc,company_name ";

$resultps=mysql_query($queryps);
while($rowps = mysql_fetch_array($resultps)){
$companyname = $rowps['company_name'];
$companyid = $rowps['ps_id'];
$companylinkori = $rowps['company_link'];
$companydescription = $rowps['company_description'];
$logopath = $rowps['logo_filename'];


$describelink = "index.php?ttid=$ttid&content=describe&pstypeid=$pstypeid&psid=$companyid";

echo "<a href=\"$describelink\" target=\"_blank\"><img src=".$logo_dir."/".$logopath." width=\"15%\"></a>";
?>

<br>
<?
}
echo "<br>";
}

}



?>



im new..so to make it simple..the problem is ..i want it to be (if there is description = logo can be click, if no = otherwise)

Hello all,
I'm having trouble with the following code, it's supposed to go like this, you search for a hotel, choose a room, then it takes you to confirmation page before the paypal, but the problem is, in the confirmation page, it shows everything right, the number of nights, the number of guests, all except the number of rooms, it always give me 0 rooms

It's seperated into 3 files, hotelsmanager.php, bookingmanager.php, and book.php

here are the codes

Code: [Select]
while($row = @mysql_fetch_array($result))
{
echo "<tr>";
echo "<td class=\"text\" align=center>".$row['room_type']."</td>";
echo "<td class=\"text\" align=center>".$row['price_per_day']."</td>";
echo "<td class=\"text\" align=center>".$row['people']." People</td>";
echo "<td class=\"text\" align=center>";

?>

                        <select name="nrooms" id="nrooms" onchange="
                        //alert('<?php echo $row['id'] ; ?>');
                        //alert(this.value);
                        var exist = 0;
                        if(roomids.length > 0)
                        {
for(var hh = 0;hh < roomids.length; hh++)
{

if(roomids[hh] == <?php echo $row['id'] ; ?>)
{
exist = 1;
//alert(hh);
roomnumar[hh] = this.value;


}
}
if(exist == 0)
{
roomids.push(<?php echo $row['id'] ; ?>);
roomnumar.push(this.value);
}
                        }
                        else
                        {
                        roomids.push(<?php echo $row['id'] ; ?>);
                        roomnumar.push(this.value);
                        }
                       
                        document.bookingform.roomid.value = roomids;
                        document.bookingform.roomnum.value = roomnumar;
                       
                       
                       
                        ">
                        <option value=0>  0  </option>
                        <?php
                        for($i = 0; $i < $row['available_rooms']; $i++)
                         {
                         $nr = $i+1;
                         $pr=$nr * $row['price_per_day'];
                         echo "<option value=$nr>$nr ($pr\$)</option>";
                         }
                        echo "</select>
                        </td>";
                        echo "<td align=center>
                        &nbsp;
                        </td>";
echo "</tr>";
echo "<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>";

}
echo "<tr class=\"rooms\">
<td colspan=\"4\">&nbsp;</td>

<td align=center><input type=\"submit\" value=\"book\" id=\"bookroom\" name=\"bookroom\"/></td>
</tr>";
echo "</table>";
echo "</form>";
print_r($_SESSION['order']);

$_SESSION['order']=0;
unset($_SESSION['order']);

}

}


?>
then booking info

Code: [Select]
<?php include("hotelsManager.php"); ?>
<?php include("config.php"); ?>
<?php include("textManager.php"); ?>
<?php
 function echoPostedData()
 {
   
   $dbo = new DB();
   $hotelObj = new hotelManager();
   $hotelID = $_POST['hotelid'];
   $datein = $_POST['datein'];
   $dateout = $_POST['dateout'];
   $roomid = $_POST['roomid'];
   $pr = $_POST['tp'];
   
   $_SESSION['hotelID'] = isset($_POST['hotelid']) ? $_POST['hotelid'] : $_SESSION['hotelID'];
   $_SESSION['datein'] = isset($_POST['datein']) ? $_POST['datein'] : $_SESSION['datein'];
   $_SESSION['dateout'] = isset($_POST['dateout']) ? $_POST['dateout'] : $_SESSION['dateout'];
         $_SESSION['roomid'] = isset($_POST['roomid']) ? $_POST['roomid'] : $_SESSION['roomid'];   
   
   
   $roomsarray = explode(",",$_POST['roomid']);
   $_SESSION['roomsarray'] = isset($_POST['roomid']) ? explode(",",$_POST['roomid']) : $_SESSION['roomsarray'];
   $roonsNo = $_POST['nrooms'];
   $_SESSION['nrooms'] = isset($_POST['roomnum']) ? explode(",",$_POST['roomnum']) : $_SESSION['nrooms']; 
Then the confirmation page is

Code: [Select]
   <?php
   echoPostedData();
  ?>
                  </td>
                </tr>
                <tr>
                  <td valign="top">&nbsp;</td>
                </tr>
              </table>
             
             
              </td>
            </tr>
            <tr>
              <td valign="top"><img src="images/spacer.gif" width="28" height="10" /></td>
            </tr>
            <tr>
              <td valign="top">
              <?php
if(isset($_POST['bookroom']))
  {?>

mysql_query("UPDATE categories SET active=0 WHERE id=$id");

What am I doing wrong here to get: Parse error: syntax error, unexpected T_STRING

???