PHP - Can Someone Tell Me Why My Php Code Wont Process

I am not getting the result I am hoping for. The code below is full code after a form has been submitted containing a member name and amount of credits:

Code: [Select]
<?php
if (isset($t)){
$t = $_GET['t'];}
?>
<?php
$amount = $_POST['amount'];
$member = $_POST['member'];

$sql = ("SELECT vtp_members.name, vtp_members.team_id FROM vtp_members WHERE vtp_members.team_id=".$_GET['t']." AND vtp_members.name='$member' AND teams.team_treasure >= '$amount' ");
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);
if($numrows == '1')
{
  $sql2 = "UPDATE vtp_members, teams SET vtp_members.hits=(vtp_members.hits + '$amount'), teams.team_treasure=(teams.team_treasure - '$amount')
WHERE vtp_members.name='$member' AND teams.team_id=".$_GET['t']." ";
$results2 = mysql_query($sql2);
$row2 = mysql_fetch_row($results2);
$tmap2 = $row2[0];

echo "You sent ". $amount . "credits to " . $member . ". ";
}
else
{
echo "The treasure holdings are too low for this transfer<br>(or an error occured)";}

?>
Problem; it returns the else statement although the "teams.team_treasure" is higher or equal to  "$amount"

mysql_connect('', '', '');
mysql_select_db('');

if (isset($_POST['submit'])) {
  $user = mysql_real_escape_string($_POST['user']);
  $pass = mysql_real_escape_string($_POST['pass']);
  $sql = "SELECT id FROM login WHERE username = '$user' && `password` = MD5('$pass')";
  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
      // $user & $pass are valid
               echo "You Logged In $user";
    } else {
      // $user || $pass invalid
                echo "Invalid Login";
    }
  }
}

Somebody please tell me why this wont work. Didnt wont to put my email in their.

<?php

$user = $_POST['subject'];
$email = $_POST['email'];
$message = $_POST['message'];

//To, Subject, Message
mailto(''); 
mailsubject('$user Sent you a message');
mailfrom('From: ' . $user . ' <' . $email . '>');

?>

Hi guys,

this is the geocoding part of the code.

I ran this ion my localhost and it runs ok. Then when i uploaded it to my server i got

500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed.

When i take out the php the html code run ok... so its not that. Can anyone help?

I have taken out my key and db connection.

Im hosted on black knight if thats any help

Code: [Select]
<?php
require("config.php");

define("MAPS_HOST", "maps.google.com");
define("KEY", "****");

// Opens a connection to a MySQL server
$connection = mysql_connect("localhost", "root", "password");
if (!$connection) {
  die("Not connected : " . mysql_error());
}

// Set the active MySQL database
$db_selected = mysql_select_db("database", $connection);
if (!$db_selected) {
  die("Can\'t use db : " . mysql_error());
}

// Select all the rows in the markers table
$query = "SELECT * FROM users WHERE 1";
$result = mysql_query($query);
if (!$result) {
  die("Invalid query: " . mysql_error());
}

// Initialize delay in geocode speed
$delay = 0;
$base_url = "http://" . MAPS_HOST . "/maps/geo?output=xml" . "&key=" . KEY;

// Iterate through the rows, geocoding each address
while ($row = @mysql_fetch_assoc($result)) {
  $geocode_pending = true;

  while ($geocode_pending) {
    $address = $row["address1"];
    $id = $row["id"];
    $request_url = $base_url . "&q=" . urlencode($address);
    $xml = simplexml_load_file($request_url) or die("url not loading");

    $status = $xml->Response->Status->code;
    if (strcmp($status, "200") == 0) {
      // Successful geocode
      $geocode_pending = false;
      $coordinates = $xml->Response->Placemark->Point->coordinates;
      $coordinatesSplit = explode(",", $coordinates);
      // Format: Longitude, Latitude, Al
  itude
      $lat = $coordinatesSplit[1];
      $lng = $coordinatesSplit[0];

      $query = sprintf("UPDATE users " .
             " SET lat = '%s', lng = '%s' " .
             " WHERE id = '%s' LIMIT 1;",
             mysql_real_escape_string($lat),
             mysql_real_escape_string($lng),
             mysql_real_escape_string($id));
      $update_result = mysql_query($query);
      if (!$update_result) {
        die("Invalid query: " . mysql_error());
      }
    } else if (strcmp($status, "620") == 0) {
      // sent geocodes too fast
      $delay += 100000;
    } else {
      // failure to geocode
      $geocode_pending = false;
      echo "Address " . $address . " failed to geocoded. ";
      echo "Received status " . $status . "
\n";
    }
    usleep($delay);
  }
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title>Your Profile Page</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/1.css" type="text/css" media="screen,projection" />

</head>
 
<body>

<div id="wrapper" class="fixed">

<div id="header">

<h1>Find A Tag Team</strong></h1>

<ul id="nav">

<li><a href="home.html">Home</a></li>

<li><a href="index.html"></a>Logout</li>

<li><a href="Links.php">Links</a></li>

<li><a href="Videos.php">Videos</a></li>



</ul>

</div>

<div id="sidebar_left">

<h2>Your Profile Page</h2>

<p>


</p>

<p>

From here you can ...<br />
-Edit all your information <br />
-Search for other users <br />
-View any emails you may have recieved</br />

</p>

<p>



</p>

</div>




<div id="content">

<h1>Profile</h1>
<div class ="message"> The map has been succesfully updated. <br />
<a href = "map.php">View the Map</div>

<div id="footer">


</div>
</div>

</body>
</html>

<html>
<?php

include connect.inc;

$id = $_GET['id'];

mysql_query("UPDATE count SET clicks=clicks+1 WHERE id='$id'");

$sql = mysql_query("SELECT link FROM count WHERE id='$id'");
$fetch = mysql_fetch_row($sql);

$result = mysql_query($sql);

while($row = mysql_fetch_array($result))
{
    echo "Name :{$row['id']} <br>" .
         "Subject : {$row['link']} <br>" .
         "Message : {$row['count']} <br><br>";
}

mysql_close();
?>

<a href='/index.php?id=1'>link1</a>
<a href='/index.php?id=2'>link2</a>
</html>