PHP - Show Results From Database

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=329323.0

Hello,

Here's the weird thing, some of the pages shows the results, and some pages just won't show results at all, and I'm not getting any errors

here is the one that doesn't

Code: [Select]
<?
function display_mptt($user) {
global $db;
// retrieve the left and right value of the $root node

$sql2 = "SELECT * from mptt where id='25'";

$result2 = mysql_query($sql2 ,$db);
if(!$row2 = mysql_fetch_array($result2)) echo mysql_error();
echo '<h1>Users List</h1>';

// start with an empty $right stack
$right = array();

// now, retrieve all descendants of the $root node
  $sql = "SELECT * from mptt WHERE 'left' BETWEEN '".$row2['left']."' AND '".$row2['right']."' ORDER BY 'left' ASC";
 $result = mysql_query($sql ,$db);

 // display each row
  while ($row = mysql_fetch_array($result)or die(mysql_error())) {
  // only check stack if there is one
  $count = mysql_num_rows($result);
  if (count($right)>0) {
  // check if we should remove a node from the stack
  while ($right[count($right)-1]<$row['right']) {
  array_pop($right);
  }
  }
 // display indented node title
 
 // add this node to the stack

 
  $var3 = '10';
    echo "<table width='589' border='1'>
<tr>
<th>ID</th>
<th>Name</th>
</tr>";
 
 echo  "<tr><td><a href=\"user.php?id=".$row['id']."\">".$row['id']."</a></td>";
echo "<td>" . $row['title'] ." </td>";

echo   "</tr>";
 
 echo "</table>";
  $right[] = $row['right'];
  }
 }
 
 

   display_mptt(1);     ?> 

and here is the page that does

Code: [Select]
<?
function display_mptt($user) {
global $db;
$id = $_GET['id'];
// retrieve the left and right value of the $root node
$sql2 = "SELECT * from mptt where id= ".$id."";

$result2 = mysql_query($sql2 ,$db);
if(!$row2 = mysql_fetch_array($result2)) echo mysql_error();
echo '<h1>Your Tree</h1>';

// start with an empty $right stack
$right = array();

// now, retrieve all descendants of the $root node
  $sql = "SELECT * from mptt WHERE `left` BETWEEN ".$row2['left']." AND ".$row2['right']." ORDER BY 'left' ASC";
 $result = mysql_query($sql ,$db);

 // display each row
  while ($row = mysql_fetch_array($result)) {
  // only check stack if there is one
  if (count($right)>0) {
  // check if we should remove a node from the stack
  while ($right[count($right)-1]<$row['right']) {
  array_pop($right);
  }
  }
 // display indented node title
  echo str_repeat('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;',count($right)).$row['title']."<br>";
 // add this node to the stack
  $right[] = $row['right'];
  }
 }
 
  display_mptt(1);
  ?>

I have a script that runs a MySQL query and loops through a bunch of results.   For each person's name, I have a short bio that I want to show/hide by clicking on the person's name.  I have a basic start, but I can't figure out how to show/hide them individually. When I click on someone's name, it shows/hides all of the bio's.  I do have an individual ID for each person, and could use that somehow, but I'm scratching my head trying to figure out how to accomplish that.  Any ideas?   http://jsfiddle.net/APA2S/3644/  

Hello:

I'm trying to figure out how to NOT show emailed results if the checkbox is empty (not checked).

I only want it included in the message of the email if the checkbox was checked.

It is writing the data to the email properly, but it is including some of the code as well.

This is my email code:
Code: [Select]
mail( "me@digital.com", "Sign-up Sheet Request",


"Date Sent: $myDate\n

Parent's Name: $ParentsName
Best Phone: $BestPhone
Email: $Email
Student's Name: $StudentsName
Student's School: $StudentsSchool\n\n



if(trim($SATTest1) != \"\" ) {
echo \"$SATTest1\";
}



",

"From: $Email"


);

The "$SATTest1" data is displaying properly in the emails, but so is some of the code.
Like this:
Code: [Select]
if(trim(Reading and Math Classes for March 10) != "" ) { echo "Reading and Math Classes for March 10"; }

Any idea how to correct this?

Thanks!

Hi again PhpFreaks, yet again I got a problem regarding coding.

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=333337.0

Hi,

my page is currently up at brewhas.org/transactions.php.  When I retrieve a set of results > the defined # per page (such as entering 'WI' for last name), I see the first page correctly, and see the links to next pages, but when I go to the next page there are no results displayed.  Same for p.3, etc.

So I've looked around enough to know that I need to pass a variable to the subsequent pages, either via a session variable or the URL.  I have 2 fields input on the form, as well as a limit and offset.  My questions are 1) do I need to pass all 4 and if so then should I use a session variable so the URL does not get too long, and 2) can anyone provide any help with setting session variables and including them to be passed?

I'm a newbie and have grabbed some code where I can but this is where i'm stuck.  thanks in advance.
Code: [Select]
         <?php
               include 'config.php';
               include 'opendb.php';
               $rows_per_page = 20;

                  //Get the values from the text boxes         
                  $fnamesearch = $_POST["fnamesearch"];
                  $lnamesearch = $_POST["lnamesearch"];

                  //These trim and convert the name fields to upper case.
                  $fnamesearch=strtoupper($fnamesearch);
                  $lnamesearch=strtoupper($lnamesearch);
                  $fnamesearch=trim($fnamesearch);
                  $lnamesearch=trim($lnamesearch);
            
                  // Count how many rows are coming back for the query
                  //This checks to see if there are at least 2 chars in the last name.
                  if (strlen($lnamesearch)<2)
                     {
                        echo "<p class='style7'>Please enter at least 2 letters of the last name.</p>";
                        exit;
                     }
                  else  //sets the query to get the number of rows
                     {
                        $query = "SELECT COUNT(*) FROM BKL_TRANSACTIONS WHERE((PLAYER_LNAME LIKE '$lnamesearch%')& (PLAYER_FNAME LIKE '$fnamesearch%'))";
                     }

                  $result = mysql_query($query) or die ("Could not execute the query");   //executes the get count query
                  $query_data = mysql_fetch_row($result);
                  $numrows = $query_data[0];
                  echo "count: ".$numrows;   
                  $lastpage = ceil($numrows/$rows_per_page);      //determines how many pages based on rows divided by rows per page
                  echo "pages: ".$lastpage;

                  // Get required page number.  If not present, default to 1.
                  if (isset($_GET['pageno']) && is_numeric($_GET['pageno'])) 
                     {$pageno = $_GET['pageno'];
                     } 
                  else 
                     {$pageno = 1;
                     } 
                  
                  //Checks that the value of $pageno is an integer between 1 and $lastpage.
                  $pageno = (int)$pageno;
                  if ($pageno > $lastpage) 
                     {$pageno = $lastpage;
                     } 
                  if ($pageno < 1) 
                     {$pageno = 1;
                     }                  
               
                  //constructs OFFSET for the sql SELECT statement
                  $offset = ($pageno - 1) * $rows_per_page;
                  
                  //This checks to see if there are at least 2 chars in the last name.
                  if (strlen($lnamesearch)<2)
                     {
                        echo "<p class='style7'>Please enter at least 2 letters of the last name.</p>";
                        exit;
                     }
                  else  //sets the query to get the number of rows
                     {
                        $query = "SELECT * FROM BKL_TRANSACTIONS WHERE((PLAYER_LNAME LIKE '$lnamesearch%')& (PLAYER_FNAME LIKE '$fnamesearch%')) LIMIT $offset, $rows_per_page";
                     }
      
                  $result = mysql_query($query) or die ("Could not execute the query");   //executes the query
                  //Count the number of results 
                  $numrows=mysql_num_rows($result);
                  
                  echo "<p class='style7'>Your search: &quot;".$fnamesearch." ".$lnamesearch."&quot; returned <b>".$numrows."</b> results.</p>";
                  
                  if ($numrows == 0)  //if no matches, don't display the table 
                        exit;
                  else            //build the table and insert rows 
                     {
                              echo "<table border=1 cellspacing=0 cellpadding=1 width='77%' align=left bordercolor=#666666>";
                              echo "<tr bgcolor=#cccc99 class='style5'><th width='10%' class='style5'>Date</th>";
                              echo "<th width='10%' class='style5'>Action</th>";
                              echo "<th width='12%' class='style5'>From</th>";
                              echo "<th width='12%' class='style5'>To</th>";
                              echo "<th width='5%' class='style5'>Pos</th>";
                              echo "<th width='18%' class='style5'>Name</th>";      
                              echo "<th width='5%' class='style5'>Round</th></tr>";                     
      
                           while ($row = mysql_fetch_array($result))
                           {
                              echo "<tr><td width='10%' class='style6'>".$row['TRANS_DT']."</td>";
                              echo "<td width='10%' class='style6'>".$row['TRANS_ACTION']."</td>";
                              echo "<td width='12%' class='style6'>".$row['FROM_OWNER']."</td>";
                              echo "<td  width='12%' class='style6'>".$row['TO_OWNER']."</td>";
                              echo "<td  width='5%' class='style6'>".$row['POSITION']."</td>";
                              echo "<td  width='18%' class='style6'>".$row['PLAYER_FNAME']." ".$row['PLAYER_LNAME']."</td>";
                              echo "<td  width='5%' class='style6'>".$row['DRAFT_RND']."</td></tr>";
                           }
               
                           /******  build the pagination links ******/   
                           // if not on page 1, don't show back links
                           if ($pageno > 1) {
                              // show << link to go back to page 1
                              echo " <a href='{$_SERVER['PHP_SELF']}?pageno=1'><<</a> ";
                              // get previous page num
                              $prevpage = $pageno - 1;
                              // show < link to go back to 1 page
                              echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage'><</a> ";
                           }
                           // range of num links to show
                           $range = 3;

                           // loop to show links to range of pages around current page
                           for ($x = ($pageno - $range); $x < (($pageno + $range)  + 1); $x++) {
                              // if it's a valid page number...
                              if (($x > 0) && ($x <= $lastpage)) {
                                // if we're on current page...
                                if ($x == $pageno) {
                                  // 'highlight' it but don't make a link
                                  echo " [<b>$x</b>] ";
                                // if not current page...
                                } else {
                                  // make it a link
                                  echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$x'>$x</a> ";
                                } // end else
                              } // end if 
                           }
                           // if not on last page, show forward and last page links        
                        if ($pageno != $lastpage) {
                           // get next page
                           $nextpage = $pageno + 1;
                           // echo forward link for next page 
                           echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage'>></a> ";
                           // echo forward link for lastpage
                           echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$lastpage'>>></a> ";
                        } // end if
                        /******  end build pagination links ******/               
                        echo "</table>";
                     }      
                  mysql_free_result($result);    //release the result set from the table
                  mysql_close($conn);          //close the connection to the db
               ?>

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

I've got a page with pagination set up, but I can't figure out where I went wrong with the links at the bottom.

When I do a search, it generates the proper number of links, but clicking on the links goes to a page with a whole row of 20 links at the bottom and no results on the page. (my search should show 3 pages with 2 records on each page)

I've looked through the tutorial here and one in a book on pagination. Not seeing what's wrong. I'd narrow this down if I knew where it was causing the problem. pagination links are at the very bottom of the code.

Code: [Select]


<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html><head>
<meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"><title>search.html</title></head>
<body>
<center>
<p>The results of your search:</p>
<br>
</center>
require ('databaseconnect.php');

$select = mysql_select_db($db, $con);
if(!$select){
die(mysql_error());
}

$display = 2;

if (isset($_GET['np'])) {
   $num_pages = $_GET['np'];
} else {
$data = "SELECT COUNT(*)
                    FROM
                        descriptors
                    LEFT JOIN
                        plantae ON (descriptors.plant_id = plantae.plant_name)
                    WHERE
                        `leaf_shape` LIKE '%$select1%'
                        AND `leaf_venation` LIKE '%$select3%'
                        AND `leaf_margin` LIKE '%$select4%'";
                   
 
$result = mysql_query ($data);
if (!$result) {
    die("Oops, my query failed.  The query is: <br>$data<br>The error is:<br>".mysql_error());
}


$row = mysql_fetch_array($result, MYSQL_NUM);
// row 41
$num_records = $row[0];

if ($num_records > $display) {
   $num_pages = ceil ($num_records/$display);
} else {
$num_pages = 1;
}
}
if (isset($_GET['s'])) {
   $start = $_GET['s'];
} else {
    $start = 0;
}

if(isset($_POST[submitted])) {
// Now collect all info into $item variable
$shape = $_POST['select1'];
$color = $_POST['select2'];
$vein = $_POST['select3'];
$margin = $_POST['select4'];




// This will take all info from database where row tutorial is $item and collects it into $data variable row 55

$data = mysql_query("SELECT
                        `descriptors`.*
                        ,`plantae`.*
                    FROM
                        `descriptors`
                    LEFT JOIN
                        `plantae` ON (`descriptors`.`plant_id` = `plantae`.`plant_name`)
                    WHERE
                        `leaf_shape` LIKE '%$select1%'
                        AND `leaf_venation` LIKE '%$select3%'
                        AND `leaf_margin` LIKE '%$select4%'
                    ORDER BY `plantae`.`scientific_name` ASC LIMIT $start, $display");



//chs added this in... row 72
echo '<table align="center" cellspacing="0" cellpading-"5">
<tr>
<td align="left"><b></b></td>
<td align="left"><b></b></td>
<td align="left"><b>Leaf margin</b></td>
<td align="left"><b>Leaf venation</b></td>
</tr>
';

// This creates a loop which will repeat itself until there are no more rows to select from the database. We getting the field names and storing them in the $row variable. This makes it easier to echo each field.

while($row = mysql_fetch_array($data)){
echo '<tr>
<td align="left"> <a href="link.php">View plant</a> &nbsp; &nbsp;</td>
<td align="left"> <a href="link.php">unknown link</a>&nbsp; &nbsp;</td>
<td align="left">' . $row['scientific_name'] . '</td>
<td align="left">' . $row['common_name'] . '</td>
<td align="left">' . $row['leaf_shape'] . '</td>
</tr>';
}
echo '</table>';
}
if ($num_pages > 1) {
echo '<br /><p>';
$current_page = ($start/$display) + 1;
// row 100
if ($current_page != 1) {
echo '<a href="leafsearch2a.php?s=' . ($start - $display) . '&np=;' . $num_pages . '">Previous</a> ';
}

for ($i = 1; $i <= $num_pages; $i++) {
if($i != $current_page) {
echo '<a href="leafsearch2a.php?s=' . (($display * ($i - 1))) . '$np=' . $num_pages . '">' . $i . '</a>';
} else {
echo $i . ' ';
}
}

if ($current_page != $num_pages) {
 echo '<a href="leafsearch2a.php?s=' . ($start + $display) . '$np=' . "&nbsp;" . $num_pages . '">&nbsp; Next</a>';
}
}
?>

</body></html>

Ok, so I have a bit of code but it's not working as it should, would one of you guys have a look at it and let me know where I'm going wrong?

Basically I need to be able to input several words or terms into the text area, each on a separate line and have the results displayed something like:

hello: 23,000.000
hello world: 19,000,000
world: 278,000,000

I also see that the script is not searching the words / terms inside quotes (EG. "hello world")

TIA

Code: [Select]
<html>
<body>
<?php
function my_fetch($url,$user_agent='Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)')
{
$ch = curl_init();
curl_setopt ($ch, CURLOPT_URL, $url);
curl_setopt ($ch, CURLOPT_USERAGENT, $user_agent);
curl_setopt ($ch, CURLOPT_HEADER, 0);
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt ($ch, CURLOPT_REFERER, 'http://www.google.com/');
$result = curl_exec ($ch);
curl_close ($ch);
return $result;
}

$s = $_GET['s'];
if (isset($s))
{
echo "<p><i>Search for $s</i></p>";
    $s = urlencode($s);
    $data = my_fetch("http://www.google.com/search?hl=en&q=" . $s . "&btnG=Google+Search");

    $data = strip_tags($data);

    $find = 'Results 1 - 10 of about ';
    $find2 = ' for';

    $data = strstr($data, $find);

    $pos = strpos($data, $find2);


$search_number=substr($data,strlen($find), $pos-strlen($find));

echo "Total Results: $search_number";
}
else
{
?>

<form name="form1" id="form1" method="get" action="">
<div align="left">
<p>  <textarea name="s" type="text" id="s" rows="8" style="width:60%" /></textarea><br />
<input type="submit" name="Submit" value="Results" /></p>
Put "" around the string: <input type="checkbox" checked name="apos" value="true" /><br />
</div>
</form>
<p>
<?php
}
?>
</p>
</body>
</html>

I'm not looking for code, mostly just some direction, but I'm sure I'll be back as I try to shape the code.  Also, I know very little about coding jQuery, Ajax, etc.  Here is what I'm looking for:

Basketball coach enters a Page that only he (or admin) can see.  (I have that part figured out.)
Once there, he has a form to fill out with a player's name and other information.

I'd rather there not be 12 rows of empty cells.  (Coaches will view that as work)
I'd rather not have the Page reload on each "Add", but that would be the lesser of two evils.

Is there a way to keep a persistent connection so when a coach hits Add, the player gets added to the database, a new empty form shows up, and the player's information shows up below on a roster?

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=355144.0

Hoping someone can help me. I am trying to limit the number of results from a sql database and I assume that I should use pagination. How do I do this with the following code? Thanks in advance.

Code: [Select]
<?php 
if ($_GET[search] == 1) $qstring = "WHERE TITLE LIKE '%$_POST[search]%'";
if ($_GET[search] == 2) { 
        $qstring = "WHERE CATEGORY LIKE '%-$_POST[search_cat]-%'";
        $SQL3 = "SELECT * from CATEGORIES WHERE ID = '%-$_POST[search_cat]-%'"; $result3 = @mysql_query( $SQL3 ); $row3 = @mysql_fetch_array( $result3 );
}
if ($_GET[search] == 3) { 
        $qstring = "WHERE PACKAGE = '$_POST[search_package]'";
}
$setpage = 'add_listings';
$return = 'manage_listings';
$table = "LISTINGS";
if (empty($qstring)) $qstring = 'ORDER BY TITLE ASC';
$qstring = "$qstring";
?>
<?php if ($rowxxx[HELPBOX] == $nil || $rowxxx[HELPBOX] == Show) { ?>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="td3" colspan="2"><b> Tool Tips</b></td>
</tr>
<tr>
<td class="td4" valign="top">
<p><img src="../images/Help.png" width="64" height="64"></p>
</td>
<td class="td4" width="100%" valign="top">
<table width="100%" align="center" cellpadding="0" cellspacing="0" border="0">
<tr>
<td>
<div align="center"><img src="../images/edit_listing.jpg" border="0" alt="Edit this listing" width="22" height="22" /></div>
</td>
<td class="font1" width="100%"> Edit this listing.</td>
</tr>
<tr>
<td>
<div align="center"><img src="../images/delete-page-red.gif" alt="Delete this listing" border="0" width="14" height="14" /></div>
</td>
<td class="font1" width="100%"> Delete this listing.</td>
</tr>
<tr>
<td>
<div align="center"><img src="../images/user-group3.gif" width="14" height="14"></div>
</td>
<td class="font1" width="100%"> Duplicate this listing and edit its clone.</td>
</tr>
<tr>
<td><a href="?page=add_photos&id=<?php echo $row[ID]; ?>"><img src="../images/Iphoto.png" width="22" height="22" border="0"></a></td>
<td class="font1" width="100%"> Add photos.</td>
</tr>
<tr>
<td>&nbsp;</td>
<td class="font1" width="100%">
<?php $sql_active_accounts = "SELECT count(*) FROM LISTINGS";
$res_active_accounts = @mysql_query($sql_active_accounts);
$row_active_accounts = @mysql_fetch_row($res_active_accounts); ?>
<b> (
<?php echo " $row_active_accounts[0] "; if ($row_active_accounts == $nil) echo " 0 "; ?>
) </b>Listings in your database.</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<?PHP } ?>
<form action="?page=<?php echo $_GET[page]; ?>&amp;search=2" method="post" name="form1" id="form1">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="td3"> <b>Find Listings by Category</b></td>
</tr>
</table>
<table  width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="td4" nowrap width="100%"> Select Category</td>
<td class="td4">
<select name="search_cat">
<option selected>
<?PHP ECHO $row3[TITLE]; ?>
</option>
<?PHP
$SQLcaT = "SELECT * from CATEGORIES ORDER BY TITLE ASC";
$resultcaT = @mysql_query( $SQLcaT ); while( $rowcaT = @mysql_fetch_array( $resultcaT ) ) {

$sql2 = "SELECT count(*) FROM LISTINGS WHERE CATEGORY LIKE '%-$rowcaT[ID]-%'";
$res2 = @mysql_query($sql2); $row2 = @mysql_fetch_row($res2);
?>
<option value = "<?php echo $rowcaT[ID]; ?>">
<?php echo "$rowcaT[TITLE]"; if (empty($row2[0])) echo ' [ 0 ]'; else echo " [ $row2[0] ]"; ?>
</option>
<?PHP } ?>
</select>
</td>
<td class="td4">
<input type="submit" name="Submit" value="Search" />
</td>
</tr>
</table>
</form>
<br>
<form action="?page=<?php echo $_GET[page]; ?>&amp;search=3" method="post" name="form1" id="form1">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="td3"> <b>Find Listings by Package</b></td>
</tr>
</table>
<table  width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="td4" nowrap width="100%"> Select Package</td>
<td class="td4">
<select name="search_package" id="search_package">
<option selected value ="<?php echo $row[DEFAULTPACKAGE]; ?>">
<?PHP $SQLlu = "SELECT * from PACKAGES WHERE ID = '$row[DEFAULTPACKAGE]'"; $resultlu = @mysql_query( $SQLlu ); $rowlu = @mysql_fetch_array( $resultlu ); ?>
<?PHP echo $rowlu[NAME]; ?>
</option>
<?PHP
$SQL3            = "SELECT * from PACKAGES ORDER BY NAME ASC";
$result3         = mysql_query( $SQL3 );
while( $row3     = mysql_fetch_array( $result3 ) ) {

?>
<option value="<?php echo $row3[ID]; ?>">
<?php echo $row3[NAME]; ?>
</option>
<?PHP } ?>
</select>
</td>
<td class="td4">
<input type="submit" name="Submit" value="Search" />
</td>
</tr>
</table>
</form>
<br>
<form action="?page=<?php echo $_GET[page]; ?>&amp;search=1" method="post" name="form1" id="form1">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="td3"> <b>Find Listing by Name</b></td>
</tr>
</table>
<table  width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="td4" nowrap width="100%"> Listing Title</td>
<td class="td4">
<input type="text" name="search" value="<?php echo $_POST[search]; ?>" size="40" />
</td>
<td class="td4">
<input type="submit" name="Submit" value="Search" />
</td>
</tr>
</table>
</form>
<br>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="td3"> <b>Last Listing Added</b></td>
</tr>
</table>
<?php
$SQL = "SELECT * from $table ORDER BY ID DESC LIMIT 1";
$result = @mysql_query( $SQL ); while( $row = @mysql_fetch_array( $result ) ) {
$check = 1;
?>
<table  width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<?PHP
$filename = "$svr_rootscript/product_images/thumb/$row[IMAGENAME].jpg";
if (file_exists($filename)) {
?>
<td nowrap class="td4" align="center" valign="top"> <a href="?page=add_photos&id=<?php echo $row[ID]; ?>"><img src="../product_images/thumb/<?php echo "$row[IMAGENAME]"; ?>.jpg" border="1" /></a> </td>
<?PHP } ?>
<td class="td4"  colspan="2" width="100%"><b>
<?php echo "<a href = \"?page=$setpage&id=$row[ID]&qt=update\">$row[TITLE]</a>"; ?>
</b><br>
<span class="font3">Category(s):
<?PHP
$pieces = explode("-", $row[CATEGORY]);
foreach ($pieces as $cats => $value) {
if ($value != $nil && $value != '-' && $value != '--') {

$SQLCat = "SELECT * from CATEGORIES WHERE ID = '$value'";
$resultCat = @mysql_query( $SQLCat ); $rowCat = @mysql_fetch_array( $resultCat );

echo "$rowCat[TITLE], ";
}
}
?>
</span></td>
<td nowrap class="td4"><a href="?page=add_photos&id=<?php echo $row[ID]; ?>"><img src="../images/Iphoto.png" width="22" height="22" border="0"></a></td>
<td class="td4"><a href="<?php echo "?page=$setpage&id=$row[ID]&qt=insert&clone=1"; ?>"> <img src="../images/user-group3.gif" border="0" alt="Edit this listing" width="14" height="14" /></a> </td>
<td class="td4"><a href="<?php echo "?page=$setpage&id=$row[ID]&qt=update"; ?>"> <img src="../images/edit-comment-orange.gif" border="0" alt="Edit this listing" width="14" height="14" /></a> </td>
<td class="td4"><a href="../library/delete.php?id=<?php echo $row[ID]; ?>&amp;return=<?php echo $return; ?>&amp;type=<?php echo "$table"; ?>"> <img src="../images/delete-page-red.gif" alt="Delete this listing" border="0" width="14" height="14" /></a>
</td>
</tr>
</table>
<?php } ?>
<br>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td class="td3"> <b>Your Listings</b></td>
</tr>
</table>
<?php
$SQL = "SELECT * from $table $qstring";
$result = @mysql_query( $SQL ); while( $row = @mysql_fetch_array( $result ) ) {
$check = 1;
?>
<table  width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<?PHP
$filename = "$svr_rootscript/product_images/thumb/$row[IMAGENAME].jpg";
if (file_exists($filename)) {
?>
<td nowrap class="td4" align="center" valign="top"> <a href="?page=add_photos&id=<?php echo $row[ID]; ?>"><img src="../product_images/thumb/<?php echo "$row[IMAGENAME]"; ?>.jpg" border="1" /></a> </td>
<?PHP } ?>
<td class="td4"  colspan="2" width="100%"><b>
<?php echo "<a href = \"?page=$setpage&id=$row[ID]&qt=update\">$row[TITLE]</a>"; ?>
</b><br>
<span class="font3">Category(s):
<?PHP
$pieces = explode("-", $row[CATEGORY]);
foreach ($pieces as $cats => $value) {
if ($value != $nil && $value != '-' && $value != '--') {

$SQLCat = "SELECT * from CATEGORIES WHERE ID = '$value'";
$resultCat = @mysql_query( $SQLCat ); $rowCat = @mysql_fetch_array( $resultCat );

echo "$rowCat[TITLE], ";
}
}
?>
</span> </td>
<td nowrap class="td4"><a href="?page=add_photos&id=<?php echo $row[ID]; ?>"><img src="../images/Iphoto.png" width="22" height="22" border="0"></a></td>
<td class="td4"><a href="<?php echo "?page=$setpage&id=$row[ID]&qt=insert&clone=1"; ?>"> <img src="../images/user-group3.gif" border="0" alt="Edit this listing" width="14" height="14" /></a> </td>
<td class="td4"><a href="<?php echo "?page=$setpage&id=$row[ID]&qt=update"; ?>"> <img src="../images/edit-comment-orange.gif" border="0" alt="Edit this listing" width="14" height="14" /></a> </td>
<td class="td4"><a href="../library/delete.php?id=<?php echo $row[ID]; ?>&amp;return=<?php echo $return; ?>&amp;type=<?php echo "$table"; ?>"> <img src="../images/delete-page-red.gif" alt="Delete this listing" border="0" width="14" height="14" /></a>
</td>
</tr>
</table>
<?php } ?>
<?PHP if (empty($check)) { ?>
<table  width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td nowrap class="td4">No listings found.</td>
</tr>
</table>
<?PHP } ?>

Hi Guys

I have a product page in mysql as below:

id         itemnumber    order_id
1         348939012     2
2         535432454     1
3         543253424     4
4         987698769     3


I need to order this in my PHP mysql_fetch_assoc by order id.

What I mean is I need to list them by  order_id: 1,2,3,4

I have used ORDER BY order_id but still it wont work,

any ideas?

Hi

I have got results being displayed after clicking the search button in a form on my home page but it brings up all the results which is ok but how do I get onlt the results a user searches for for example a location or property type etc as its for a property website

The coding is below for the results page

Also sorry how do I add a background image to the php page, I tried using css but wouldn't work

Code: [Select]
<style type="text/css">
body {background-image:url('images/greybgone.png');}
</style>

<?php
 
mysql_connect ("2up2downhomes.com.mysql", "2up2downhomes_c","mD8GsJKQ")  or die (mysql_error());
mysql_select_db ("2up2downhomes_c");

echo $_POST['term'];

$sql = mysql_query("select * from properties where typeProperty like '%$term%' or location like '%$term%'");

while ($row = mysql_fetch_array($sql)){
    echo 'Type of Property: '.$row['typeProperty'];
    echo '<br/> Number of Bedrooms: '.$row['bedrooms'];
    echo '<br/> Number of Bathrooms: '.$row['bathrooms'];
echo '<br/> Garden: '.$row['garden'];
echo '<br/> Description: '.$row['description'];
echo '<br/> Price: '.$row['price'];
echo '<br/> Location: '.$row['location'];
echo '<br/> Image: '.$row['image'];
    echo '<br/><br/>';
    }
 
?>

How do I access objects inside an array of database results? I have a method that returns MySQL results as an array "$projects". Running print_r($projects) gives me this:

array(1) (
    "projects" => object Database_MySQL_Result(6) {
        protected _internal_row => integer 0
        protected _query => string(875) "SELECT [skipping remainder of long query]"
        protected _result => resource(mysql result)
        protected _total_rows => integer 53
        protected _current_row => integer 0
        protected _as_object => string(13) "Model_Project"
    }
)

If I do this: foreach($projects as $project)
{
   echo $project->PROJECT_NAME;
}

I get "Undefined property: Database_MySQL_Result::$PROJECT_NAME"

If I do this:

foreach($projects as $project)
{
   echo $project[0];
}

the browser will display projects.id for the first returned row *only*

echo $project[1] returns the project.id for the second row only. And so on.

Each returned row contains over a dozen cells.

It's almost as if I'm referring to the array incorrectly, or referring to the wrong array. I feel as though I'm making a very simple (and perhaps dumb) mistake here, but can't quite figure out what it is. Thanks.