PHP - Undefined Index And Selecting Max Date

I am getting the following error when I try to run my php script:

Notice: Undefined index: MAX(Date) in D:\Pricing\EasyPHP-5.3.9\www\FT9 05-16-12.php on line 21
The most recent date is:

The most recent or MAX Date should be returned after the echo statement "The most recent date is:"

Here is my code:

Code: [Select]
<?php


        $conn=odbc_connect("XXX","xxx|xxx","xxx");
        if (!$conn)
        { exit("Connection Failed: " . $conn);
}

// Get a specific result from the "FT9_FUEL_TAX_PRICE_LINES" table
$query =("SELECT ItemNumber,MAX(Date) FROM 'FT9_FUEL_TAX_PRICE_LINES'
         WHERE ItemNumber = 'E-10 NL GAS'AND TableCode = 'CITA'
         GROUP BY 'ItemNumber'");
 
$result = odbc_exec($conn, $query) or die(odbc_errormsg());


// keeps getting the next row until there are no more to get
while($row=odbc_fetch_array($result))
{
// Print out result
echo "The most recent date is: " .$row['MAX(Date)']; 
        echo "<br />";

} 

?>
Can anyone help me with this?  Any help would be much appreciated.

I really dont no what the problem is and im new here so i dont no if this is the right place to put this but im trying to make a registration page for my server and when i bring it up it says Undefined index: action in C:\xampp\htdocs\index.php on line 56   and idk what to do >.<
this is the line that has the problem

if($_POST['action']!="signup")

so hopefully u guys could help me :/ Im using xampp btw

Hello,

I have just upgraded my wampserver and with it MySQL, PHP and PhpMyAdmin versions. And my scripts, which ran normally before, not burst hundreds of undefined variable and undefined index notices. I realize it's "notices", not "errors" but this is quite irritating. I believe it might be due to some upgrade in PHP scripting rules or something but I don't know what. I hope you can help me.

The first type of notice is "undefined variable". This function will return the notice if I remove the bold red line, where I define the variable as empty before I use it in the loop. I didn't need to do this before.
function statistics($array) {

[color=red][b]$list = '';[/b][/color]

if(is_array($array)) {
foreach($array as $name => $value) {
// Rip out the name of the client.
$list .= "<li>".$name." - ";
// set an integer so we know how many tier2 values we have read.
$x = 0;
foreach($value as $difference => $sum_total) {
// if this is the more than the first tier2 values, use a '+' between the units.
$list .= (++$x > 1) ? " + ".$sum_total." ".$difference : $sum_total." ".$difference;
}
// close the line out.
$list .= "</li>";
}
}
return $list;
}

To avoid the 10+ like notices on the page I declare them empty before the variable's first occurrence. But this sounds stupid to me. Wasn't this one of PHP's benefits, not to have to declare the variable before using it?

I also get about 30+ undefined index notices, e.g.
Quote

Notice: Undefined index: COMPANY XXX in F:\wamp\www\Project Management\main.php on line 37

Notice: Undefined index: USD in F:\wamp\www\Project Management\main.php on line 37

Notice: Undefined index: USD in F:\wamp\www\Project Management\main.php on line 41


Here are those lines:
$income_total = calculate("income");
foreach($income_total as $row) {
$clientID = $row['clientID'];
$clientname = $row['clientname'];
//$client = "<a href=\"index.php?page=Client&amp;do=view&amp;clientID=$clientID\">".$clientname."</a>";
$client = "<a href=\"index.php?page=Project&amp;do=view&amp;sortby=$clientID\">".$clientname."</a>";
$currency = $row['currency'];
$client_sum = $row['client_sum'];
$year_sum = '';
$year_sum  += $client_sum;
$income = '';
$income[$client][$currency] += $client_sum;

$income_list = statistics($income);
$income_all = '';
$income_all[$currency] += $client_sum;
}


Line 37 is: Quote

$income[$client][$currency] =

It's the values assigned to $client and to $currency that seem to cause the notice.

How do I deal with this? I don't just want to turn error/notice display off, I want to resolve this issue.

please help!

I am getting undefined index and offset when I duplicated my SEARCH page for when logged in

here is my code

Code: [Select]
<?php
include_once("config.php");
include_once("functions.php");
// Check user logged in already:
checkLoggedIn("yes");
?>
<!doctype html>
<html>
<head>
<title>Retro and Vintage</title>
<meta name="description" content="xxx" />
<meta name="keywords" content="xxx" />
<meta name="Content-Language" content="en-gb" />
<meta name="robots" content="FOLLOW,INDEX" />
<meta name="revisit-after" content="2 days" />
<meta name="copyright" content="jbiddulph.com" />
<meta name="author" content="John Biddulph - Professional web site design and development in the south of england mainly worthing and brighton" />
<meta name="distribution" content="Global" />
<meta name="resource-type" content="document" />
<link rel="stylesheet" type="text/css" href="css/reset.css" />
<link rel="stylesheet" type="text/css" href="css/style.css" title="default" />
<link rel="alternate stylesheet" type="text/css" href="css/style1.css" title="1" />
<link rel="alternate stylesheet" type="text/css" href="css/style2.css" title="2" />
<script type="text/javascript" src="js/stylechanger.js"></script>
<script type="text/javascript" src="js/jquery-1.2.1.pack.js"></script>
<script type="text/javascript">
function lookup(inputString) {
if(inputString.length == 0) {
// Hide the suggestion box.
$('#suggestions').hide();
} else {
$.post("rpc.php", {queryString: ""+inputString+""}, function(data){
if(data.length >0) {
$('#suggestions').show();
$('#autoSuggestionsList').html(data);
}
});
}
} // lookup

function fill(thisValue) {
$('#inputString').val(thisValue);
setTimeout("$('#suggestions').hide();", 200);
}
</script>
</head>
<body>
<?php if($messages) { displayErrors($messages); }?>
<header>
<div id="title">
<h1>My Pub Space
<a href="#" onClick="setActiveStyleSheet('default'); return false;"><img src="images/0.gif" width="15" height="15" border="0" alt="css style" /></a>&nbsp;<a href="#" onClick="setActiveStyleSheet('1'); return false;"><img src="images/1.gif" width="15" height="15" border="0" alt="css style" /></a>&nbsp;<a href="#" onClick="setActiveStyleSheet('2'); return false;"><img src="images/2.gif" width="15" height="15" border="0" alt="css style" /></a>
<span>
<form method="post" class="textbox" action="search1.php">
City/Town:&nbsp;<input type="text" size="26" class="searchbox" value="" id="inputString" onKeyUp="lookup(this.value);" onBlur="fill();" />

<div class="suggestionsBox" id="suggestions" style="display: none;">
<img src="images/upArrow.png" style="position: relative; top: -36px; left: 105px; z-index:1;" alt="upArrow" />
<div class="suggestionList" id="autoSuggestionsList">
&nbsp; </div>
</div>
<input type="image" src="images/go.png" height="30" with="30" value="GO" />
</form>
</span> </h1>
</div>
</header>
<nav>
<ul>
<li class="selected"><a href="#">Home</a></li>
<li><a href="#">Pubs</a></li>
<li><a href="#">Members</a></li>
<li><a href="#">Events</a></li>
<li><a href="#">Register</a></li>
</ul>
</nav>
<section id="intro">
<header>
<h2>Your social guide to going down the pub, online!</h2>
</header>
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
<img src="images/pub.jpg" alt="pub" /> </section>
<div id="content">
<div id="mainContent">
<section>
<article class="blogPost">
<header>
<h2>This is the title of a blog post</h2>
<p>Posted on
<time datetime="2009-06-29T23:31+01:00">June 29th 2009</time>
by <a href="#">Mads Kjaer</a> - <a href="#comments">3 comments</a></p>
</header>
<?php
// drop out of PHP mode to display the plain HTML:
$Townsearch = $_GET['rsTown'];
echo $Townsearch;
// Delimiters may be slash, dot, or hyphen

list($Town, $County) = split('[,]', $Townsearch);

$tableName="pubs";
$targetpage = "search1.php"; 
$limit = 20; 

$query = "SELECT COUNT(*) as num FROM $tableName WHERE rsTown LIKE '$Town%'";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages['num'];

$stages = 3;
$page = mysql_escape_string($_REQUEST['page']);
if( isset($_REQUEST['page']) && ctype_digit($_REQUEST['page']) ) {
      $page = (int) $_GET['page'];
      $start = ($page - 1) * $limit;
}else{
      $start = 0;   
}

    // Get page data
$query1 = "SELECT * FROM $tableName WHERE rsTown LIKE '$Town%' LIMIT $start, $limit";
$result = mysql_query($query1);

// Initial page num setup
if ($page == 0){$page = 1;}
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total_pages/$limit);
$LastPagem1 = $lastpage - 1;


$paginate = '';
if($lastpage > 1)
{




$paginate .= "<div class='paginate'>";
// Previous
if ($page > 1){
$paginate.= "<a href='$targetpage?page=$prev'>previous</a>";
}else{
$paginate.= "<span class='disabled'>previous</span>"; }



// Pages
if ($lastpage < 7 + ($stages * 2)) // Not enough pages to breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
}
}
elseif($lastpage > 5 + ($stages * 2)) // Enough pages to hide a few?
{
// Beginning only hide later pages
if($page < 1 + ($stages * 2))
{
for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
}
$paginate.= "...";
$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
}
// Middle hide some front and some back
elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
{
$paginate.= "<a href='$targetpage?page=1'>1</a>";
$paginate.= "<a href='$targetpage?page=2'>2</a>";
$paginate.= "...";
for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
}
$paginate.= "...";
$paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
$paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
}
// End only hide early pages
else
{
$paginate.= "<a href='$targetpage?page=1'>1</a>";
$paginate.= "<a href='$targetpage?page=2'>2</a>";
$paginate.= "...";
for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= "<span class='current'>$counter</span>";
}else{
$paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
}
}
}

// Next
if ($page < $counter - 1){ 
$paginate.= "<a href='$targetpage?page=$next'>next</a>";
}else{
$paginate.= "<span class='disabled'>next</span>";
}

$paginate.= "</div>";


}
 echo $total_pages.' Results';
 // pagination
 echo $paginate;
?>

<ul>

<?php 
 

while($row = mysql_fetch_array($result))
{

echo '<li>'.$row['rsPubName'].', '.$row['rsTown'].', '.$row['rsCounty'].'</li>';
if ($_SESSION["rsUser"] == "admin")
{
echo "<a href=\"edit.php?PUBID=".$row['PubID']."\" class=\"small\">edit this pub</a>";
}

}

?>
</ul>
</article>
</section>
<section id="comments">
<h3>Comments</h3>
<article>
<header> <a href="#">George Washington</a> on
<time datetime="2009-06-29T23:35:20+01:00">June 29th 2009 at 23:35</time>
</header>
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
</article>
<article>
<header> <a href="#">Benjamin Franklin</a> on
<time datetime="2009-06-29T23:40:09+01:00">June 29th 2009 at 23:40</time>
</header>
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
</article>
<article>
<header> <a href="#">Barack Obama</a> on
<time datetime="2009-06-29T23:59:00+01:00">June 29th 2009 at 23:59</time>
</header>
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.</p>
</article>
</section>
<form action="#" method="POST" method="post">
<h3>Post a comment</h3>
<p>
<label for="name">Name</label>
<input name="name" id="name" type="text" required />
</p>
<p>
<label for="email">E-mail</label>
<input name="email" id="email" type="email" required />
</p>
<p>
<label for="website">Website</label>
<input name="website" id="website" type="url" />
</p>
<p>
<label for="comment">Comment</label>
<textarea name="comment" id="comment" required></textarea>
</p>
<p>
<input type="submit" value="Post comment" />
</p>
</form>
</div>
<aside>
<section>
<header>
<h3>Members Login Area</h3>
</header>
<h4>Welcome <? print($_SESSION["rsUser"]); ?></h4>
<a href="logout.php">Logout</a>
</section>
<section>
<header>
<h3>Archives</h3>
</header>
<ul>
<li><a href="#">December 2008</a></li>
<li><a href="#">January 2009</a></li>
<li><a href="#">February 2009</a></li>
<li><a href="#">March 2009</a></li>
<li><a href="#">April 2009</a></li>
<li><a href="#">May 2009</a></li>
<li><a href="#">June 2009</a></li>
</ul>
</section>
</aside>
</div>
<footer>
<div>
<section id="about">
<header>
<h3>About</h3>
</header>
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco <a href="#">laboris nisi ut aliquip</a> ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>
</section>
<section id="blogroll">
<header>
<h3>Blogroll</h3>
</header>
<ul>
<li><a href="#">NETTUTS+</a></li>
<li><a href="#">FreelanceSwitch</a></li>
<li><a href="#">In The Woods</a></li>
<li><a href="#">Netsetter</a></li>
<li><a href="#">PSDTUTS+</a></li>
</ul>
</section>
<section id="popular">
<header>
<h3>Popular</h3>
</header>
<ul>
<li><a href="#">This is the title of a blog post</a></li>
<li><a href="#">Lorem ipsum dolor sit amet</a></li>
<li><a href="#">Consectetur adipisicing elit, sed do eiusmod</a></li>
<li><a href="#">Duis aute irure dolor</a></li>
<li><a href="#">Excepteur sint occaecat cupidatat</a></li>
<li><a href="#">Reprehenderit in voluptate velit</a></li>
<li><a href="#">Officia deserunt mollit anim id est laborum</a></li>
<li><a href="#">Lorem ipsum dolor sit amet</a></li>
</ul>
</section>
</div>
</footer>
</body>
</html>

error lies on these lines
Code: [Select]
// drop out of PHP mode to display the plain HTML:
$Townsearch = $_GET['rsTown'];
echo $Townsearch;
// Delimiters may be slash, dot, or hyphen

list($Town, $County) = split('[,]', $Townsearch);

my current code:

Code: [Select]
$Townsearch = $_REQUEST['rsTown'];
list($Town, $County) = split('[,]', $Townsearch);
ltrim($County,1);

I am getting undefined index and undefined offset, so I tried this:

Code: [Select]
if $_REQUEST['rsTown'] == ''{
$Townsearch = '';
} else {
$Townsearch = $_REQUEST['rsTown'];
}
but this brought back: Parse error: syntax error, unexpected T_VARIABLE, expecting '(' in D:\retroandvintage.co.uk\wwwroot\main.php on line 6

Can someone please help?

thanks