I have a class that I created, halfway down my page I call a function from the class which prints some code and also changes a variable inside the class.

It's a search class basically it prints out the search results and saves the total amount of results into the variable.

I want to display the amount of results above the results like so:-

echo $Search->results;

$Search->GetResults('foo');

The problem is that $Search->results will be equal to NULL until the variable is updated in the function GetResults.

Hope that makes sense, am I going about this wrong?

Checking Variable For Null

Similar Tutorials

View Content

How can I check a variable to see if it is NULL and if so set to 0000-00-00?

I've tried:
if ($var IS NULL) THEN $var='0000-00-00'; to no avail.

Select * From $variable Instead Of The Tablename Possible?

Similar Tutorials

View Content

Hi guys, the following code gives the parsing error "unexpected T_VARIABLE":
Code: [Select]
<?php
$con = mysql_connect("localhost","XXX", "YYY");
if (!$con) {die('Could not connect: ' . mysql_error("oop"));}
mysql_select_db("XXX_testDB") or die(mysql_error());

$counter = 1;
$Tcounter = 1;
$Tresult = mysql_query("SELECT * FROM NameTable WHERE id = $Tcounter");
$Trow = mysql_fetch_array($Tresult);

$result = mysql_query("SELECT * FROM "$Trow['NameOfTable']" WHERE id = $counter");
$row = mysql_fetch_array($result);
echo $row['TQuestion'];
?>
So I have a Table in Mysql that is called 'NameTable'. From that table I am drawing an element in the 1st row under the column of NameOfTable. I want to call another element of another table through the table I described using a variable. Like this:
Code: [Select]
$result = mysql_query("SELECT * FROM "$Trow['NameOfTable']" WHERE id = $counter");
"$Trow['NameOfTable']": I also tried using single quotes or without and it doesn't work either.
What is wrong with this?

Asign A Variable To An Array Value

Similar Tutorials

View Content

i have the following array
$fruits = array("cherry" => "red", "apple" => "red", "kiwi" => "green", "strawberry" => "red", "pear" => "yellow", "melon" => "green",
"grapes" => "green", "watermelon" => "red", "banana" => "yellow")

using the array_count_values($fruits) i get
Array ( => 4 => 3 [yellow] => 2 )

how can i asign the value of each key to a variable?

Similar Tutorials

View Content

apparently I am doing this wrong. I want my string results from a form that searches DB content to appear within HTML table, tr, td tags. I get the results fine, but the HTML part isn't appearing. How should I be doing this?

<?php

$string = '';

$result = mysql_query($sql); /// This is the execution
if (mysql_num_rows($result) > 0){
while($row = mysql_fetch_object($result)){

echo "<table>";

  echo "<tr>";
    $string .= "<td>".$row->last_name."</td> ";
     $string .= "<td>".$row->first_name."</td>";

$string .= "<td>".$row->employee_id."</td>";

$string .= "<td>".$row->title."</b>";

$string .= "<td>".$row->territory."</td>";

$string .= "<td>".$row->district."</td>";

$string .= "<td>".$row->Phase1A_Score."</td>";

$string .= "<td>".$row->Phase1B_Score."</td>";

$string .= "<td>".$row->Phase1_Average."</td>";

$string .= "<td>".$row->Phase1A_HS_Exam."</td>";

$string .= "<td>".$row->Phase1A_HS_Exam_RT."</td>";

Similar Tutorials

View Content

Undefined variable: return line 38

that line is :

echo $return;

Below is a look at my full code.
Code: [Select]
<?php

class cms {

var $host;
var $username;
var $password;
var $db;

   function connect() {
      $con = mysql_connect($this->host, $this->username, $this->password) or die(mysql_error());
mysql_select_db($this->db, $con) or die(mysql_error());

}

function get_content($id = ''){
if($id !=""):
$id = mysql_real_escape_string($id);
$sql = "SELECT * FROM cms_content WHERE id = '$id'";

$return = '<a href="index.php">Go Back?</a>';
else:
$sql = "SELECT * FROM cms_content ORDER BY id DESC";
endif;

$res = mysql_query($sql) or die(mysql_error());

if(mysql_num_rows($res) != 0):
while($row = mysql_fetch_assoc($res)) {
   echo '<h1><a href="index.php?id=' . $row['id'] .'">' . $row['title'] .'</a></h1>';
   echo '<p>' . $row['body'] . '</p>';
   }
else:
    echo '<p> Sorry! This Page doesn\'t exist!</p>';

endif;

echo $return;

}

}//Ends our class

?>