PHP - Echo Table Numbers

Please help, when I run this search and enter something in the search thats not in the database, it doesnt reply with "Your query returned 0 results" as it should. I tjust stays blank

Here's the section of code in question...

if ($search)   // perform search only if a string was entered. 
   { 
    mysql_connect($host, $user, $pass) or die ("Problem connecting to Database"); 

    $srch="%".$search."%";

    $query = "select * from tvads WHERE advert LIKE '$srch' ORDER BY advert, year DESC, details ASC LIMIT 0,30"; 

    $result = mysql_db_query("cookuk_pn", $query); 

    if  ($result) 
    { 

   $count = 1;   

   print "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"  bordercolor=\"#0000FF\" width=\"900\">";
   print "<tr><td width=\"200\" height=\"30\" align=\"left\"><u><b><font face=\"arial\" size=\"2\" color=\"#800080\">Advert / Description</font></b></u></td>";
   print "<td width=\"80\" align=\"left\"><u><b><font face=\"arial\" size=\"2\" color=\"#800080\">Year</font></b></u></td>";
   print "<td width=\"200\" align=\"left\"><u><b><font face=\"arial\" size=\"2\" color=\"#800080\">Artist</font></b></u></td>";
   print "<td width=\"200\" align=\"left\"><u><b><font face=\"arial\" size=\"2\" color=\"#800080\">Track</font></b></u></td>";
   print "<td width=\"80\" align=\"left\"><u><b><font face=\"arial\" size=\"2\" color=\"#800080\">Buy Album</font></b></u></td>";
   print "<td width=\"100\" align=\"left\"><u><b><font face=\"arial\" size=\"2\" color=\"#800080\">Download MP3</font></b></u></td></tr>";

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


$data .= "<td width=\"200\" height=\"30\" align=\"left\"><font face=\"arial\" size=\"1\">" .$row['advert']. "</font><br>";

$data .= "<font face=\"arial\" size=\"1\" color=\"#000080\"><i>" .$row['details']. "</i></font></td>";

$data .= "<td width=\"80\" height=\"30\" align=\"left\"><font face=\"arial\" size=\"1\">" .$row['year']. "</font></td>";

$data .= "<td width=\"200\" height=\"30\" align=\"left\"><font face=\"arial\" size=\"1\">" .$row['artist']. "</font></td>";

$data .= "<td width=\"200\" height=\"30\" align=\"left\"><font face=\"arial\" size=\"1\">" .$row['track']. "</font></td>";

$data .= "<td width=\"80\" height=\"30\" align=\"left\"><font face=\"arial\" size=\"1\">" .$row['asin_ref']. "</font></td>";

$data .= "<td width=\"100\" height=\"30\" align=\"left\"><font face=\"arial\" size=\"1\">" .$row['mp3_ref']. "</font></td></tr>";

$count++;
 
        }                  // end while 
        $data .="</table>"; 
   echo $data;
     } else { echo "problems...."; } 
   } else { echo "Your query returned 0 Results"; } 
?> 

for some reason it will not render to the row... ive added the php echo to the row in question and it runs with the top row... can someone take a look and let me know what i am doing wrong...

thanks
trey

here is the code... the php echo in bold red should show up on the next row; but, it doesnt...

<?php
/**
* @version $Id: mod_gridiron_game_results.php, v1.5.0 March 2011 01:32:15
* @author Fastball Productions
* @package Gridiron
* @copyright Copyright (C) 2011 Fastball Productions
* @license http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
*/

// no direct access
defined('_JEXEC') or die('Restricted access');

$db =& JFactory::getDBO();

// get the module parameters
$heading = $params->get( 'heading', '' );
$showpast = $params->get( 'showpast', '1' );
$numberpast = $params->get( 'numberpast', '1' );
$linkboxscore = $params->get( 'linkboxscore', '1' );
$shownextgame = $params->get( 'nextgame', '1' );
$numbernext = $params->get( 'numbernext', '1' );
$linknext = $params->get( 'linknext', '1' );
$seasonid = $params->get( 'seasonid', '1' );
$gametypes = $params->get( 'gametypes', '1' );
$teamids = $params->get( 'teamids', '' );
$leagueids = $params->get( 'leagueids', '' );
$divisionids = $params->get( 'divisionids', '' );

if (is_array($gametypes)) {
   $gametypes = implode(',', $gametypes);
}
if (is_array($teamids)) {
   $teamids = implode(',', $teamids);
}
if (is_array($leagueids)) {
   $leagueids = implode(',', $leagueids);
}
if (is_array($divisionids)) {
   $divisionids = implode(',', $divisionids);
}

// if there is a league configured, get the teams within the league/division;
if ($teamids == '' && ($divisionids || $leagueids)) {
   if ($divisionids) {
      // get a listing of all team ID's that belong in the league and division;
      $sql = "SELECT id FROM #__gridiron_team WHERE (FIND_IN_SET(divisionid, '$divisionids'))";
   }
   else {
      // get a listing of all team ID's that belong in the league;
      $sql = "SELECT id FROM #__gridiron_team WHERE (FIND_IN_SET(leagueid, '$leagueids'))";
   }
   $db->setQuery($sql);
   $rows = $db->loadResultArray();
   $teamids = implode(',', $rows);
}
else if ($teamids == '') {
   // get the default team (single team component only);
   $db->setQuery("SELECT id FROM #__gridiron_team WHERE (defaultteam = 1)");
   $teamids = $db->loadResult();
}

// get the last x number of games played and the results;
$db->setQuery("SELECT a.*, a.hometeam AS hometeamid, a.visitingteam AS visitingteamid,
   DATE_FORMAT(a.gamedatetime, '%a, %M %D') AS gamedate,
   DATE_FORMAT(a.gamedatetime, '%l:%i %p') As gametime,
   h.name AS hometeam,
   v.name AS visitingteam,
   b.finalv, b.finalh
   FROM #__gridiron_schedule AS a
   LEFT JOIN #__gridiron_team AS h ON a.hometeam = h.id
   LEFT JOIN #__gridiron_team AS v ON a.visitingteam = v.id
   LEFT JOIN #__gridiron_boxscore AS b ON a.id = b.gameid
   WHERE (a.scored = 1 AND a.season = {$seasonid} AND (FIND_IN_SET(a.gametype, '$gametypes')) AND (FIND_IN_SET(a.hometeam, '$teamids') OR FIND_IN_SET(a.visitingteam, '$teamids')) AND a.gamedatetime < now())
   GROUP BY a.id
   ORDER BY a.gamedatetime DESC LIMIT 0, {$numberpast}");
$pastgames = $db->loadObjectList();

// get the next x number of games scheduled;
$db->setQuery("SELECT a.*, a.hometeam AS hometeamid, a.visitingteam AS visitingteamid,
   DATE_FORMAT(a.gamedatetime, '%a, %M %D') AS gamedate,
   DATE_FORMAT(a.gamedatetime, '%l:%i %p') As gametime,
   h.name AS hometeam,
   v.name AS visitingteam,
   t.description AS gametype
   FROM #__gridiron_schedule AS a
   LEFT JOIN #__gridiron_team AS h ON a.hometeam = h.id
   LEFT JOIN #__gridiron_team AS v ON a.visitingteam = v.id
   LEFT JOIN #__gridiron_gametype AS t ON a.gametype = t.id
   LEFT JOIN #__gridiron_location AS l ON a.location = l.id
   WHERE (a.scored = 0 AND a.season = {$seasonid} AND (FIND_IN_SET(a.gametype, '$gametypes')) AND (FIND_IN_SET(a.hometeam, '$teamids') OR FIND_IN_SET(a.visitingteam, '$teamids')) AND DATE_ADD(a.gamedatetime, INTERVAL 3 HOUR) > now())
   GROUP BY a.id
   ORDER BY a.gamedatetime ASC LIMIT 0, {$numbernext}");
$nextgames = $db->loadObjectList();
?>
<table width="100%" border="0" align="center">
   <?php if ($showpast && $numberpast > 0) { ?>
   <tr>
      <td colspan="2" style="text-align:center;"><b><?php echo $heading;?></b></td>
   </tr>
   <tr>
      <td width="43%"><b><u>Matchup</u></b></td>
      <td width="57%" style="text-align:center;"><b><u>Result</u></b></td>
   </tr>
   <?php foreach ($pastgames as $past) { ?>
   <tr>
      <td>
         <?php echo $past->visitingteam;?> vs.<br /><?php echo $past->hometeam;?>
      </td>
      <td style="text-align:center;">
      <?php if ($linkboxscore) { ?>
      <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=boxscore&id=$past->id");?>"><?php echo $past->finalv;?><br /><?php echo $past->finalh;?></a>
      <?php } else { ?>
      <?php echo $past->finalv;?><br /><?php echo $past->finalh;?>
        </td>
      <?php } ?>
   </tr>
   <tr>
      <td colspan="2"></td>
   </tr>
   <?php } ?>
   <?php } ?>
   <?php if ($shownextgame && $numbernext > 0 && $nextgames) { ?>
   <tr>
      <td colspan="2"><b><u>Next Game</u></b></td>
       
   </tr>
   <?php foreach ($nextgames as $next) { ?>
   <?php $next->visitingteam == '' ? $next->visitingteam = 'TBA':$next->visitingteam = $next->visitingteam;?>
   <?php $next->hometeam == '' ? $next->hometeam = 'TBA':$next->hometeam = $next->hometeam;?>
   <tr>
      <td colspan="2">
      <?php if ($linknext) { ?>
      <?php if ($next->visitingteam == 'TBA') { ?>
      <?php echo $next->visitingteam;?>
      <?php } else { ?>
      <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=schedule&id=$next->visitingteamid");?>"><?php echo $next->visitingteam;?></a>
      <?php } ?>
       vs.
      <?php if ($next->hometeam == 'TBA') { ?>
      <?php echo $next->hometeam;?>
      <?php } else { ?>
      <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=schedule&id=$next->hometeamid");?>"><?php echo $next->hometeam;?></a>
      <?php } ?>
      <?php } else { ?>
      <?php echo $next->visitingteam;?> vs. <?php echo $next->hometeam;?>   
      </td>
   </tr>
   <tr>
     <td colspan="2"><?php } ?><?php echo $next->gamedate . ' ' . $next->gametime;?> </td> 
  </tr>
   <?php } ?>     
   <?php } ?>   
</table>

// Other code
//echo "<table border='10' cellpadding='3' cellspacing='2'>";  This works
echo "<table class="my-table">";                                     //This does not work
echo "<tr><th>First Name</th><th>Last Name</th><th>Home Phone</th><th>Cell Phone</th><th>email</th></tr>";

// keeps getting the next row until there are no more to get ================

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

// Print out the contents of each row into a table ==========================

echo "<tr><td>";

echo $row['first'];

echo "</td><td>";

echo $row['last'];

echo "</td><td>";

echo $row['phone'];

echo "</td><td>";

echo $row['cell'];

echo "</td><td>";

echo $row['email'];

echo "</td></tr>"; 
} 
echo "</table>";
?>

Error message:

Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/bayare27/public_html/content/pages/display_all_members1.php on line 29

Line 29 is:  echo "<table class="my-table">";                                     


<table class="my-table">" is a valid statement because It works in another program, but html not php                                   

hello,  im trying to add a hyperlink that launches in a new window to the following (in the last column)  any ideas?

Code: [Select]
  echo "<tr>";
  echo "<td align='center'>" . $row["ID"] . "</td>";
  echo "<td align='center'>" . $row["Name"] . "</td>";
  echo "<td align='center'>" . $row["jobNO"] . "</td>";
  echo "<td align='center'>" . $epn . "</td>";
  echo "<td align='center'>" . $cname . "</td>";
  echo "<td align='center'>" . $cadd . "</td>";  //want to add a hyperlink here
  echo "</tr>";
  }
echo "</table>";


}

I am getting  the row results from mysql as called, but they appear as a straight line instead of new table row when I echo like:

echo "TABLETABLETABLETABLE";

I am looking for:

echo "TABLE
          TABLE
          TABLE
          TABLE";

Here is my code:
Code: [Select]

$brand = $_POST['brand'];
$city = stripslashes($_POST['city']);
$state = $_POST['state'];
$zip_code = stripslashes($_POST['zip_code']);


if($city !=""){
$query = "SELECT name, bus_type, street, city, state, zip_code, brand, quantity, price1, price2, date FROM `prices` WHERE city ='".$city."' AND state ='".$state."' AND brand = '".$brand."'";
}else{
$query = "SELECT name, bus_type, street, city, state, zip_code, brand, quantity, price1, price2, date FROM `prices` WHERE zip_code ='".$zip_code."'";
}
$result = mysql_query($query);
 
     $count=mysql_num_rows($result);
if($count==0 && $zip_code !=""){?>

    <td width="100%" class="style9">Sorry! There are no results for that city, state and brand.</td>
 
<?
}else{
   while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
?>
  <td width="100%" class="style9"><?php 
  echo "<table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">
  <tr>
     <td{$typ_image}</td>
<td><b><a href=\"\" title=\"{$row['street']} {$row['city']}, {$row['state']}. {$row['zip_code']}\" target=\"_blank\">{$row['name']}</a></b><br>Last Updated:{$row['date']}</td>
    <td><b>{$row['brand']} - {$row['quantity']}</b><br>Before Tax:\${$row['price1']} After Tax:\${$row['price2']}</td>
<td{$pago}</td>
  </tr>
</table><BR>";
  ?></td>
<?php
 }
} 
?></table>   
    <p>&nbsp;</p>
    </td>

This serves more or less a meaningless purpose for my testing, but I've been trying to echo out the names of the tables that are being used in my UPDATE and SELECT queries and I have yet found a way to do this.. Did some research on php.net and Google and did not find anything that seems to directly address this..

My guess is it's so stupid simple, I probably will have an answer by the time I wake up..

But id there are any suggestions on this, Id be glad to take.

Hi guys,

How do I call the 2nd row of 'TSuperQuestion'?
Code: [Select]
<?PHP 
$con = mysql_connect("localhost","ph6theo", "xxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error("oop"));
  }
mysql_select_db("ph6theo_testDB") or die(mysql_error());
$result = mysql_query("SELECT * FROM QANDATable ");
$row = mysql_fetch_array($result);
echo $row['TSuperQuestion'];
?>

Hi There,

I have an SQL query that returns 10 rows, which I want to echo over 2 columns and 5 rows, however, I want rows 1-5 on the left hand column and rows 6-10 on the right hand side.

Is there an easy way to do this? Normally I would do a fetch_array but, that would place the rows in order of, left, right, left, right - if that makes sense?

Table is a standard table with 2 columns and 5 rows.

Thanks
Matt

Hi,

I wonder if I somebody can help me

I have three drop down lists which are populated from data thats stored in my sql database. I also have a table which is echoed from the database all on the same page.


What i want to do is allow users to select values in the drop down lists which will then echo different results below in the table. Is this possible.

So on page load it will show all of the info in the html table. Then when the user changes the drop downs and clicks submit it will change the query to something SELECT dropdown1 value FROM users where Dropdown2 = 1 AND Dropdown3 = 2 etc.

Is this possible to display this information on the same page using the dropdown list or does it need to load a different page as the client side is trying to edit a server side script?

If its possible please can someone give me an example.

Thanks in advance

Edd

How do you do this? Thanks in advance.

I actually asked a question here yesterday and decided to try a different route with it.  What I am doing is passing an email variable entered from my home page on to www.dollapal.com/offerlist.php.  I'm wanting this page to be a complete list of all of my entries in my surveys table.  The email variable needs to be appended to the end of every link.  I got that to work, but what I want to do now is display that information for every record in my 'surveys' table.

Right now I am using the random function, which I'm sure is wrong, but I'm not sure what function to be looking for.

Is it possible to use a foreach function here to echo each record?  If so, I'm not sure how exactly to call the foreach() function in this case.

I believe my two problems lie in the random and foreach functions, but I'm not sure how to correct them.  I've attached a little chunk of code that I'm working with.  I'm not sure if I'm completely off base here, or if I'm close to achieving my desired result.  Please let me know if you require more information.

This forum has been amazing to me so far.  Thank you all for your help!

Here is one part of php code. Here I try to show in last 1 month which dates exactly user made orders. When I run the SQL code in command prompt it works. I think problem is in while loop.

Thanks beforhand for contribution.


$query = "SELECT Date FROM orders WHERE User='$username' and DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= Date;";
$result = mysql_query($query,$link_id) or die (mysql_error());

echo "<table border='1'>
        <tr>
          <td>&nbsp;Last 1 month's orders:</td>
        </tr>";
   
      while($order_date = mysql_fetch_row($result)) {
        echo "<tr>";
          echo "<td>" . $order_date[0] . "</td>";
        echo "</tr>";
      }
     
      echo "</table>

Hi,
I need to sort variables in groups of up to 15 and put it in an array. For example:
$exstract['center_tabOpBody_0'] =5
$exstract['center_tabOpBody_1'] =6
$exstract['center_tabOpBody_2'] =8
$exstract['center_tabOpBody_3'] =1


Should yield:
ARRAY(
          = center_tabOpBody_1,center_tabOpBody_2,center_tabOpBody_3 // <-----15 [1] = center_tabOpBody_0 //<----5
)

Is there some simple function do do the "efficiency" sort?

Thanks,
Vadim

OK, have no idea what's going on... I've done this a million times... why wont this output!??
I must have a major brain meltdown and dont know it yet!!!

Code: [Select]
<?php

// this echoes just fine:
echo $_POST['testfield'];


// but this wont echo:
echo 
if (isset($_POST['testfield']))
{
$_POST['testfield'] = $test;
}
echo $test;


/// or even this DOESNT echo either!:
$_POST['testfield'] = $test;
echo $test;

?>

Hi All,

I'm trying to echo the response from an SLA query, the query works and returns the data when I test it on an SQL application.. but when I run it on my webpage it won't echo the result.

Please help?

<?php   
$mysqli = mysqli_connect("removed", "removed", "removed", "removed");  
$sql = "SELECT posts.message FROM posts INNER JOIN threads ON posts.pid=threads.firstpost WHERE threads.firstpost='1'";  
$result = mysqli_query($mysqli, $sql);   
echo {$result['message']}; 
?>