PHP - Undefined Variable!! New To Php! Could Someone Help Please?

When I run the MySQL queries in the code below in SQLyog, the $pokemon_pos in the "SELECT max(pokemon_pos)" part of the statement is always correct (i.e. alias "x" is correct). Yet when wrapped up in PHP, $newpos, which relies on "x" is always undefined.

I'd greatly appreciate any help in troubleshooting this code -

Code: [Select]
$getdeclined="SELECT *
      FROM trade_offers
      WHERE pokemon_trade_id=$_GET[id]";
$declined=mysql_query($getdeclined);
while ($row = mysql_fetch_array($declined)){
$getdecusername="SELECT MAX(pokemon_pos)
                                     FROM (
                                      SELECT pokemon_pos
                                      FROM pokemon_trainer
                                      WHERE pokemon_trainer = '$row[pokemon_trainer]'
                                      UNION
                                      SELECT pokemon_pos
                                      FROM trade_offers
                                              WHERE pokemon_trainer = '$row[pokemon_trainer]' AND pokemon_trade_id = $_GET[id]
                                             ) AS x";
$decusername=mysql_query($getdecusername);
while($row2 = mysql_fetch_array($decusername)){
          $newpos = $row2['x'];}
          echo $newpos;
          $newpos +=1;
         }
}

I had some help righting this query and the extensive coding here and most of it I understand however when i run this it gives me an undefined variable charname error and I'm trying to understand why. Does the coding make sense to anyone?


<?php
$query = "SELECT ecm.name AS fighters, ecb.id AS showid, ecm.id AS matchid, ecb.bookingdate AS bookingdate, ecb.event_id AS event_id, els.name AS name, ecb.label AS label FROM `efed_content_appearances` AS eca INNER JOIN `efed_content_matchseg` AS ecm ON eca.content_id = ecm.id INNER JOIN `efed_content_booking` AS ecb ON ecm.booking_id = ecb.id INNER JOIN `efed_list_shownames` AS els ON ecb.event_id = els.id WHERE eca.bio_id = '$id' AND eca.type = 'match' ORDER BY ecb.bookingdate DESC, ecm.sortorder ASC";
$result = mysql_query($query);
if(mysql_num_rows($result) == 0){ echo '<td colspan="3" class="noseg">This wrestler has never been in an event match.</td>' ; }
else{
$count = 1;
while($row = mysql_fetch_assoc($result)){
$fighter = explode(' vs. ', $row['fighters']);
$opponents = '';
for($i = 0; $i < count($fighter); $i++){
if($fighter[$i] != $charname){
if($opponents != ''){ $opponents .= ', '; }
$opponents .= $fighter[$i];
}
}
echo '<table cellspacing="0px" style="text-align: center;"><tr class="titlebar"><td>Date</td><td>Show</td><td>Opponent/s</td></tr>';
echo '<tr class="row' . $count . '"><td>' . convertdate($row['bookingdate']) . '</td><td><a href="content.php?p=results&show=' . $row['event_id'] . '&amp;id=' . $row['showid'] . '#' . $row['matchid'] . '">' . $row['name'] . ' ' . $row['label'] . '</a></td><td>' . $opponents . '</td></tr>';
echo '</table>';
if($count == 1){ $count = 2; } else { $count = 1; }
}
}
?>

Hi all,

When i run the code below he gives the variable $naantal below he got the number i put in with ?undefined after it.

Code: [Select]
<?php
$id = $_GET["id"];
$naantal = $_GET["aantal"];

$wijzig ="UPDATE care_medicijnen SET aantal=$naantal WHERE $id=id"; echo $wijzig;
if(isset($_GET["id"])) { 
mysql_query($wijzig); 
}
?>


When my input is the number 8 he gives this as output: Quote

UPDATE care_medicijnen SET aantal=8?undefined WHERE 4160962=id



How can i fix this that i only got the number 8 without ?undefined after it.

already thanks

Hi,

Getting this error message but I know that it is defined just for some reason it won't pick it up.  Taken the url out so the site can't be accessed.

An error occurred in script 'example/register.php' on line 101: Undefined variable: message
Date/Time: 7-Feb-2011 18:32:10

Code: [Select]
<?php # Script 16.6 - register.php
// This is the registration page for the site.
 require_once("includes/functions.php"); 
 include("includes/header.php"); 
 require_once("includes/connection.php"); 

require_once ('includes/config.inc.php');
$page_title = 'Register';
//include ('includes/header.html');

if (isset($_POST['submitted'])) { // Handle the form.

require_once ('mysqli_connect.php');

// Trim all the incoming data:
$trimmed = array_map('trim', $_POST);

// Assume invalid values:
$fn = $ln = $e = $p = FALSE;

// Check for a first name:
if (preg_match ('/^[A-Z \'.-]{2,20}$/i', $trimmed['first_name'])) {
$fn = mysqli_real_escape_string ($dbc, $trimmed['first_name']);
} else {
echo '<p class="error">Please enter your first name!</p>';
}

// Check for a last name:
if (preg_match ('/^[A-Z \'.-]{2,40}$/i', $trimmed['last_name'])) {
$ln = mysqli_real_escape_string ($dbc, $trimmed['last_name']);
} else {
echo '<p class="error">Please enter your last name!</p>';
}

// Check for an email address:
if (preg_match ('/^[\w.-]+@[\w.-]+\.[A-Za-z]{2,6}$/', $trimmed['email'])) {
$e = mysqli_real_escape_string ($dbc, $trimmed['email']);
} else {
echo '<p class="error">Please enter a valid email address!</p>';
}

// Check for a password and match against the confirmed password:
if (preg_match ('/^\w{4,20}$/', $trimmed['password1']) ) {
if ($trimmed['password1'] == $trimmed['password2']) {
$p = mysqli_real_escape_string ($dbc, $trimmed['password1']);
} else {
echo '<p class="error">Your password did not match the confirmed password!</p>';
}
} else {
echo '<p class="error">Please enter a valid password!</p>';
}

if ($fn && $ln && $e && $p) { // If everything's OK...

// Make sure the email address is available:
$q = "SELECT user_id FROM users WHERE email='$e'";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

if (mysqli_num_rows($r) == 0) { // Available.

// Create the activation code:
$a = md5(uniqid(rand(), true));

// Add the user to the database:
$q = "INSERT INTO users (email, pass, first_name, last_name, active, registration_date) VALUES ('$e', SHA1('$p'), '$fn', '$ln', '$a', NOW() )";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

if (mysqli_affected_rows($dbc) == 1) { // If it ran OK.

// Send the email:
$body = "Thank you for registering at. To activate your account, please click on this link:\n\n";
$body .= BASE_URL . 'activate.php?x=' . urlencode($e) . "&y=$a";
mail($trimmed['email'], 'Registration Confirmation', $body, 'From: ');

// Finish the page:
$message = '<h3>Thank you for registering! A confirmation email has been sent to your address. Please click on the link in that email in order to activate your account.</h3>';

} else { // If it did not run OK.
echo '<p class="error">You could not be registered due to a system error. We apologize for any inconvenience.</p>';
}

} else { // The email address is not available.
echo '<p class="error">That email address has already been registered. If you have forgotten your password, use the link at right to have your password sent to you.</p>';
}

} else { // If one of the data tests failed.
echo '<p class="error">Please re-enter your passwords and try again.</p>';
}

mysqli_close($dbc);

} // End of the main Submit conditional.
?>
<div id="content">
        <div class="paddingContent">
            <h3>
                Register
            </h3>
<br />
<form action="register.php" method="post" class="contact">
<?php echo $message; ?>

<div class="registerForm">
            <label for="first_name" class="fixedwidth">First Name:</label>
            <input type="text" name="first_name" id="first_name" value="<?php if (isset($trimmed['first_name'])) echo $trimmed['first_name']; ?>"/>
        </div>
  <br />
<div class="registerForm">
            <label for="last_name" class="fixedwidth">Last Name:</label>
            <input type="text" name="last_name" id="last_name" value="<?php if (isset($trimmed['last_name'])) echo $trimmed['last_name']; ?>"/>
        </div>
  <br />
<div class="registerForm">
            <label for="email" class="fixedwidth">Email Address:</label>
            <input type="text" name="email" id="email"value="<?php if (isset($trimmed['email'])) echo $trimmed['email']; ?>" />
        </div>
  <br />
<div class="registerForm">
            <label for="password1" class="fixedwidth">Password</label>
            <input type="password" name="password1" id="password1" value="" /> <small>Use only letters, numbers, and the underscore. Must be between 4 and 20 characters long.</small>
        </div>
  <br />
<div class="registerForm">
            <label for="password2" class="fixedwidth">Confirm Password:</label>
            <input type="password" name="password2" id="password"/>
        </div>
  <br />
<div class="submtForm"><input type="submit" name="submit" value="Register" /></div>
<input type="hidden" name="submitted" value="TRUE" />

</form>
        </div>
        </div>
<?php include("includes/footer.php"); ?>

<?php // Include the HTML footer.
//include ('includes/footer.html');
?>

Hey Guys. I Have a quick questions. I keep getting an "undefined variable" when php parses the following code

 echo "<div class='menu'>${$this->price}</div>"."<br>";

However when I put a space after the dollar sign it works fine...

 echo "<div class='menu'>$ {$this->price}</div>"."<br>";

Doesn't the curly braces tells php to seperate strings from variables? I'm a little bit confused. Thanks!

Hello,
I think there may be a simple answer but I have been staring at this code for the last couple for hours and cannot see the error. I am going cross eyed!

I have written a form that works apart from a bit where I have radio buttons for yes or no.

On the form I get the error:
Notice: Undefined variable... on line 134

for both the yes and no responses.

The rest of the code is fine and the functionality of uploading to the database works except for this part.

Any help would be much appreciated

Code:

<!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" xml:lang="en"
lang="en">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 
<title>Aliens Abducted Me - Report an Abduction</title>
 
<link rel="stylesheet" type="text/css" href="style.css" />

</head>

<body>
 
<h2>Aliens Abducted Me - Report an Abduction</h2>


<?php
 
require_once('connectvars3.php');

 
if (isset($_POST['submit'])) {
   

// Connect to the database
   
$dbc = mysqli_connect(DB_Host, DB_User, DB_Password, DB_Name);

   

// Grab the report data from the POST
   
$first_name = mysqli_real_escape_string($dbc, trim($_POST['firstname']));
   
$last_name = mysqli_real_escape_string($dbc, trim($_POST['lastname']));
   
$email = mysqli_real_escape_string($dbc, trim($_POST['email']));
   
$when_it_happened = mysqli_real_escape_string($dbc, trim($_POST['whenithappened']));
   
$how_long = mysqli_real_escape_string($dbc, trim($_POST['howlong']));
   
$how_many = mysqli_real_escape_string($dbc, trim($_POST['howmany']));
   
$alien_description = mysqli_real_escape_string($dbc, trim($_POST['aliendescription']));
   
$what_they_did = mysqli_real_escape_string($dbc, trim($_POST['whattheydid']));
   
$fang_spotted = mysqli_real_escape_string($dbc, trim($_POST['fangspotted']));
   
$other = mysqli_real_escape_string($dbc, trim($_POST['other']));

   
if (!empty($first_name) && !empty($last_name) && !empty($when_it_happened) && !empty($how_long) && !empty($what_they_did)) {
     

// Write the data to the database
     
$query = "INSERT INTO aliens_abduction (first_name, last_name, email, when_it_happened, how_long, how_many, alien_description, what_they_did,

fang_spotted, other) " .
        "VALUES ('$first_name', '$last_name', '$email', '$when_it_happened', '$how_long', '$how_many', '$alien_description',

'$what_they_did', '$fang_spotted', '$other')";
     
mysqli_query($dbc, $query);

     

// Confirm success with the user
      echo '<p>Thanks for adding your abduction.</p>';
     
echo '<p><a href="index4.php">&lt;&lt; Back to the home page</a></p>';

      mysqli_close($dbc);
     
exit();
   
}
    else {
     
echo '<p class="error">Please enter your full name, date of abduction, how long you were abducted, and a brief description of the aliens.</p>';
   
}
  }

?>

 

<p>Share your story of alien abduction:</p>
 
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
   
<label for="firstname">First name:</label>
   
<input type="text" id="firstname" name="firstname" value="
<?php
if (!empty($first_name)) echo $first_name;
?>" /> <br />
   
<label for="lastname">Last name:</label>
   
<input type="text" id="lastname" name="lastname" value="
<?php if (!empty($first_name)) echo $last_name; ?>" /><br />
   
<label for="email">What is your email address?</label>
    <input type="text" id="email" name="email" value="
<?php if (!empty($email)) echo $email; ?>" />
<br />
   
<label for="whenithappened">When did it happen?</label>
    <input type="text" id="whenithappened" name="whenithappened" value="
<?php if (!empty($when_it_happened)) echo $when_it_happened; else echo 'YYYY-MM-DD'; ?>" /><br />
    <label for="howlong">How long were you gone?

</label>
    <input type="text" id="howlong" name="howlong" value="

<?php if (!empty($how_long)) echo $how_long; ?>" /><br />
    <label for="howmany">How many did you see?</label>
    <input type="text" id="howmany"

name="howmany" value="
<?php
if (!empty($how_many)) echo $how_many; ?>" /><br />
    <label for="aliendescription">Describe them:</label>
    <input type="text"

id="aliendescription" name="aliendescription" size="32" value="<?php if (!empty($alien_description)) echo $alien_description; ?>" /><br />
   
<label for="whattheydid">What did they do to you?</label>
   
<input type="text" id="whattheydid" name="whattheydid" size="32" value="<?php if (!empty($what_they_did))
echo $what_they_did; ?>" /><br />
   
<label for="fang_spotted">Have you seen my dog Fang?</label>
   
Yes <input id="fang_spotted" name="fang_spotted" type="radio" value="yes"
<?php echo ($fang_spotted == 'yes' ? 'checked="checked"' : ''); ?>
   
No <input id="fang_spotted" name="fang_spotted" type="radio" value="no"  
<?php echo ($fang_spotted == 'no' ? 'checked="checked"' : ''); ?> /><br />
  <br />
    <label for="other">Anything else you want to add?</label>
   

<textarea id="other" name="other"><?php if (!empty($other)) echo $other; ?></textarea><br />
    <input type="submit" value="Report Abduction"

name="submit" />
 
</form>

</body>

</html>[u][/u]

Notice: Undefined variable: quantity_row in C:\xampp\htdocs\cart\cart.php on line 12

Notice: Undefined index: cart_1 in C:\xampp\htdocs\cart\cart.php on line 12

Notice: Undefined index: cart_1 in C:\xampp\htdocs\cart\cart.php on line 30

Help me guys

Code: [Select]
<?php 
session_start();

$page = 'index.php';

mysql_connect('localhost','root','')or die(mysql_error());
mysql_select_db('cart') or die(mysql_error());

if (isset ($_GET['add'])){
     $quantity = mysql_query('SELECT id, quantity FROM products WHERE id ='.mysql_real_escape_string( (int)$_GET['add']));
 while($quantity_rows = mysql_fetch_assoc($quantity)) {
     if ($quantity_row['quantity'] != $_SESSION['cart_'.$_GET['add']]) {
     $_SESSION['cart_'.$_GET['add']] += '1';
 }
 }
 
}

function products() {
$get = mysql_query('SELECT id, name, description, price FROM products WHERE quantity > 0 ORDER BY id DESC') or die(mysql_error());
 if (mysql_num_rows($get) == 0) {
     echo 'There are no products to display!';
 } else {
     while ($get_row = mysql_fetch_assoc($get)) {
     echo '<p>'.$get_row['name']. '<br />' .$get_row['description']. '<br />'.number_format( $get_row['price'], 2) . '<a href="cart.php?add='.  $get_row['id'].'">Add</a></p>';
 }
 }
}

echo $_SESSION['cart_1'];
?>

I'd appreciate any assistance with the following code. When I echo the output, all the variables are correct, except that pokemon_pos is always 1, whereas it should be something like 49, which is the highest value in either tables trade_offers or pokemon_trainer for a given pokemon_trade_id.

Code: [Select]
$getdeclined="SELECT *
      FROM trade_offers
      WHERE pokemon_trade_id=$_GET[id]";
$declined=mysql_query($getdeclined);

while ($row = mysql_fetch_array($declined)){
$getdecusername="select max(pokemon_pos)
from
(
select max(pokemon_pos) as pokemon_pos
from pokemon_trainer
WHERE pokemon_trainer = '$row[pokemon_trainer]'
union all
select max(pokemon_pos)
from trade_offers
WHERE pokemon_trainer = '$row[pokemon_trainer]' AND pokemon_trade_id = $_GET[id]
) as x";
$decusername=mysql_query($getdecusername);
while ($row2 = mysql_fetch_array($decusername)){
$newpos = $row2['pokemon_pos'];
$newpos +=1;
}
$update="UPDATE trade_offers
SET pokemon_pos = $newpos
WHERE pokemon_id = $row[pokemon_id]";
$result=mysql_query($update);
}

I am following this tutorial here http://youtu.be/WrbaISEEihM. When i try to edit a product in my inventory i get an error "Undefined variable: product_list in /home/a7064593/public_html/storeadmin/inventory_edit.php on line 85" and i cant work out how to fix it. here is my code http://pastebin.com/k36tBjEL.

Thanks

can anyone help with this function. i keep getting undefined variable: link error.

function simple_query($fields, $table, $clause, $order)
{
    if (empty($config))
    {
        require("./config/config.php");
    }    
    if(!empty($clause))
    {
        $clause = "WHERE $clause";
    }
    if(!class_exists('db_mysqli'))
    {
        include('./includes/db_mysqli.php');
        $link = new db_mysqli;
        $link->connect($config['database']);
    }
    if(!empty($order))
    {
        $direction = $order[0];
        
        switch($direction)
        {
            case "0":
            $direction = "ASC";
            break;
            case "1":
            $direction = "DESC";
            break;
        }
        
        $order = substr($order, 1, strlen($order));
        $order = "ORDER BY $order $direction";
    }
    
    $query = $link->query("SELECT $fields //THIS LINE THROWS THE ERROR
            FROM ".TBL_PREFIX."$table
            $clause
            $order")or die(mysqli_error($link));
    
    return $query;
}

database class:


class db_mysqli
{
    public $link;
    
    function connect($settings)
    {
        require_once(dirname(dirname(__FILE__)).'/config/config.php');

        $link = new mysqli($settings['hostname'],
                            $settings['username'],
                            $settings['password'],
                            $settings['database']);
        $this->link = $link;
    }
}


thanks.

Hi there im left joining 3 tables and outputting the results..

Nothing is being out;putputted and Im getting an error:
Notice: Undefined variable: row_Test in C:\wamp\www\SWB\ship.php on line 136
Call Stack
#   Time   Memory   Function   Location
1   0.0014   408608   {main}( )   ..\ship.php:0

Ive tested the join in mysql and it works fine. Its just that on my webpage Nothing is outputted and only this one notice error appears.

heres my join:

Code: [Select]
<?php $colname_Test = "-1";
if (isset($_GET['recordID'])) {
  $colname_Test = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
}
mysql_select_db($database_swb, $swb);
$query_Test = sprintf("SELECT s.ShipID, s.FleetName, f.FleetName, f.PlanetName, p.PlanetName, p.PlayerName FROM Ships s

LEFT JOIN Fleet f ON (s.FleetName = f.FleetName)
LEFT JOIN Planet p ON (f.PlanetName = p.PlanetName)
WHERE s.ShipID = '$colname_Ship'");
$Test = mysql_query($query_Test, $swb) or die(mysql_error());
$totalRows_Test = mysql_num_rows($Test); ?>


echo $row_Test['PlanetName']; ?>
Heres how my tables connect: ShipID (FleetName) ---> FleetName (PlanetName) ---> PlanetName, so im trying to detemine the fleet and planet the ship is on.

Any ideas why its not working??

Thanks

Why does php show undefined variable? I researched and found out that if the variables aren't set then they will likely show undefined variable. However, I used the isset function to check if the variable is undefined and if it is then set it to $varaible ="" . That didn't work and then later i tried $variable =  NULL. What should I do Can you please see the code and tell me what shall i do. Thanks a million 

<?php require_once("includes/connection.php")?>
<?php require_once("includes/function.php") ?> 
<?php require_once("includes/header.php") ?>
<?php
    if(isset($_GET['subj'])){
        $sel_subj = NULL;
        $sel_subj = $_GET['subj'];
   
    } elseif (isset($_GET['page'])){
        $sel_page = NULL; 
        $sel_page = $_GET['page'] ;
        
    } else {
        $sel_subj= NULL;
        $sel_page =NULL; 
    }
?>

    <table id = "structure" >
        <tr> 
            <td id = "navigation" >
                <ul class= "subjects" > 
            <?php
                $subject_set = get_all_subjects();
                while ($subject = mysql_fetch_array($subject_set)){ // <a href = "content.php?subj=1" >
                    if ($sel_subj == $subject["id"]){
                        echo "<li class = \"selected\" ";
                    }else{
                        echo "<li> ";
                    }
                    "<a href = \"content.php?subj=" . urlencode($subject["id"]) . "\">" . $subject["menu_name"]. "</a></li>" ;
                    
                    
                    $page_set = get_pages_for_subjects( $subject["id"] ) ; 
                    echo " <ul class = \"pages\"> ";
                    while ($page = mysql_fetch_array($page_set)){
                        echo "<li><a href = \"content.php?page=" . urlencode($page["id"]) . "\">" . $page["menu_name"] . "</a></li>" ; 
                    }
                    echo "</ul>" ; 
                }
            
            ?>
                </ul>
            </td>
            
            <td id= "page" >
                <h1> Main Area To Get Your Information </h1>
                <?php echo $sel_subj ; ?> <br/>
                <?php echo $sel_page ; ?> <br/> 
                
            </td>    
        </tr>
    </table>
<?php include ("includes/footer.php") ?> 

The variable im refering to is $sel_subj and $sel_page at the top of the code. Here is an attachment of the error  Attached Files  Capture.PNG   275.47KB   0 downloads

I'm getting:
Quote

PHP Notice:  Undefined variable: carttotal


... for this:

$idtotal = $sizestotal + $sizemtotal + $sizeltotal + $sizexltotal;
$carttotal += $idtotal;


Why?

Hi guys, hope someone can help? I noticed an error in my logs & upon digging it seems this script is causing the issue:-

 

<?php
error_reporting(E_ALL);

//$IPaddress=$_SERVER['REMOTE_ADDR'];
$IPaddress='45.152.180.38';
$two_letter_country_code=iptocountry($IPaddress);
 
include("ip_files/countries.php");
$three_letter_country_code=$countries[ $two_letter_country_code][0];
$country_name=$countries[$two_letter_country_code][1];

print "Two letters code: $two_letter_country_code<br>";
print "Three letters code: $three_letter_country_code<br>";
print "Country name: $country_name<br>";

// To display flag
$file_to_check="flags/$two_letter_country_code.gif";
if (file_exists($file_to_check)){
                print "<img src=$file_to_check width=30 height=15><br>";
                }else{
                print "<img src=flags/noflag.gif width=30 height=15><br>";
                }

function iptocountry($ip) {
    $numbers = preg_split( "/\./", $ip);
    include("ip_files/".$numbers[0].".php");
    $code=($numbers[0] * 16777216) + ($numbers[1] * 65536) + ($numbers[2] * 256) + ($numbers[3]);
    foreach($ranges as $key => $value){
        if($key<=$code){
            if($ranges[$key][0]>=$code){$two_letter_country_code=$ranges[$key][1];break;}
            }
    }
    if ($two_letter_country_code==""){$two_letter_country_code="UNKNOWN";}
    return $two_letter_country_code;
}
?> 

This script was originally from here http://phptutorial.info/iptocountry/the_script.html

The error I'm getting is :-

[28-Nov-2019 16:57:56 UTC] PHP Notice: Undefined variable: two_letter_country_code in /home/drgl1966/testing.site/testinguser/test.php on line 35


I'm ***guessing*** this may be caused by my newer version of PHP (7.3, although I must admit I didn't look at old logs to see if the problem exists with older PHP version).

I hard coded the made up IP in the code above as the problem only happens if the IP address is not known.

Any idea's how to fix? As you can probably gather I'm not a PHP coder! I've searched online for answers but all the things I've found & tried have failed

Thanks in advance for any help with this...

Hi guys.   why is my function error: undefined varable pdo?   Thanks  

function referralCount($uid,$reflvl)
{

$stmt= $pdo->query("SELECT * FROM scraffiliateusr WHERE usrinvby='$uid'");
$nusrref1 = $stmt->rowCount();
//$arrusrref1 = $stmt->fetch(PDO::FETCH_LAZY);

$reflvl1=$nusrref1;
$ttlreflvl2="0";
$ttlreflvl3="0";

for ($i=0; $i<$nusrref1; $i++)
{
$arrusrref1 = $stmt->fetch(PDO::FETCH_LAZY);
    $stmt= $pdo->query("SELECT * FROM scraffiliateusr WHERE usrinvby='$arrusrref1[0]'");
    $nusrref2 = $stmt->rowCount();
    //$arrusrref2 = $stmt->fetch(PDO::FETCH_LAZY);
    $ttlreflvl2=$ttlreflvl2+$nusrref2;


        for ($j=0; $j<$nusrref2; $j++)
        {
        $arrusrref2 = $stmt->fetch(PDO::FETCH_LAZY);

        $stmt= $pdo->query("SELECT * FROM scraffiliateusr WHERE usrinvby='$arrusrref2[0]'");
        $nusrref3 = $stmt->rowCount();
        //$arrusrref3 = $stmt->fetch(PDO::FETCH_LAZY);

        $ttlreflvl3=$ttlreflvl3+$nusrref3;
        }
}
$reflvl2=$ttlreflvl2;
$reflvl3=$ttlreflvl3;
if($reflvl=='1')
{
return($reflvl1);
}
elseif($reflvl=='2')
{
return($reflvl2);
}
elseif($reflvl=='3')
{
return($reflvl3);
}

}