Please help with echoing results

[lingo5]

Hi,

this is how I echo some results from my DB:

 

<?php if(mysql_num_rows($execute)>0){
do{
echo "
" .$result['id_cliente']. " " .$result['company_name']. " " .$result['cliente_tel']. "
" ;
}while($result = mysql_fetch_assoc($execute));
}else{
echo "
No customer found.
" ;
}
?>

 

and this echoes the results in one paragraph.

I need to print the results in rows...and I need help with that.

:shy:Thanks

[canabatz]

<?php if(mysql_num_rows($execute)>0){
do{
echo "
" .$result['id_cliente']. " " .$result['company_name']. " " .$result['cliente_tel']. "
"."<br>" ;
}while($result = mysql_fetch_assoc($execute));
}else{
echo "
No customer found.
" ;
}
?>

[lingo5]

thanks canabatz, but I mean table rows sorry.

[canabatz]

<table width="400" border="1">
  <tr>
    <td>client</td>
    <td>company name</td>
    <td>Phone</td>
  </tr>



<?php if(mysql_num_rows($execute)>0){
do{

}while($result = mysql_fetch_assoc($execute));

?>
    
   <tr>
    <td><?=$result['id_cliente'] ?></td>
    <td><?=$result['company_name'] ?></td>
    <td><?=$result['cliente_tel']?></td>
  </tr>
  
   
    <?

}else{
echo "
No customer found.
" ;
}
?>

</table>

try that , i hope this is what you want

[lingo5]

thanks again,,,now a table prints with column headers...but empty rows

[canabatz]

try that:

 

<table width="400" border="1">
  <tr>
    <td>client</td>
    <td>company name</td>
    <td>Phone</td>
  </tr>



<?php if(mysql_num_rows($execute)>0){



while($result = mysql_fetch_assoc($execute));
{
?>
    
   <tr>
    <td><?=$result['id_cliente'] ?></td>
    <td><?=$result['company_name'] ?></td>
    <td><?=$result['cliente_tel']?></td>
  </tr>
  
   
    <?

}

}else{
echo "
No customer found.
" ;
}
?>

</table>

[lingo5]

nope...no results displayed, just column headers

[canabatz]

try this:

<table width="400" border="1">
  <tr>
    <td>client</td>
    <td>company name</td>
    <td>Phone</td>
  </tr>



<?php if(mysql_num_rows($execute)>0){



while($result = mysql_fetch_assoc($execute));
{
?>
    
   <tr>
    <td><?php echo $result['id_cliente']; ?></td>
    <td><?php echo $result['company_name']; ?></td>
    <td><?php echo $result['cliente_tel'];?></td>
  </tr>
  
   
    <?

}

}else{
echo "
No customer found.
" ;
}
?>

</table>

[lingo5]

sorry but still no change...

[lingo5]

This is the complete code:

 

/* Get the letter user clicked on and assign it a variable called $sort */
$sort = $_REQUEST['letter'];
/* Let's check if variable $sort is empty. If it is we will create a query to display all customers alphabetically ordered by last name. */
if($sort == ""){
$qry= "SELECT * FROM myDatabase.t_clientes ORDER BY company_name ASC " ;
}else{
/* if varible $sort is not empty we will create a query that sorts out the customers by their last name, and order the selected records ascendingly. */
$qry = "SELECT * FROM myDatabase.t_clientes WHERE company_name LIKE '$sort%' ORDER BY company_name ASC" ;
}
/* Notice the use of '%' wilde card in the above query "LIKE '$sort%'". */
//next step is to execute the query.
$execute = mysql_query($qry) or die(mysql_error());
/* Before we display results let's create our alphabetical navigation. 
for ($i = 65; $i < 91; $i++) {
printf('<a href="%s?letter=%s">%s</a> | ',
$PHP_SELF, chr($i), chr($i));
}
echo "
" ;
/* now we are ready to display the results. 
if(mysql_num_rows($execute)>0){
do{
echo "
" .$result['id_cliente']. " " .$result['company_name']. " " .$result['cliente_tel']. "
" ;
}while($result = mysql_fetch_assoc($execute));
}else{
echo "
No customer found.
" ;
}
?>

[canabatz]

please show the all code to see where the problem is.

[canabatz]

i dont see any thing wrong , jus a missing */ in your code.

 

try this one again:

 

<?php

/* Get the letter user clicked on and assign it a variable called $sort */
$sort = $_REQUEST['letter'];
/* Let's check if variable $sort is empty. If it is we will create a query to display all customers alphabetically ordered by last name. */
if($sort == ""){
$qry= "SELECT * FROM myDatabase.t_clientes ORDER BY company_name ASC " ;
}else{
/* if varible $sort is not empty we will create a query that sorts out the customers by their last name, and order the selected records ascendingly. */
$qry = "SELECT * FROM myDatabase.t_clientes WHERE company_name LIKE '$sort%' ORDER BY company_name ASC" ;
}
/* Notice the use of '%' wilde card in the above query "LIKE '$sort%'". */
//next step is to execute the query.
$execute = mysql_query($qry) or die(mysql_error());
/* Before we display results let's create our alphabetical navigation. 
for ($i = 65; $i < 91; $i++) {
printf('<a href="%s?letter=%s">%s</a> | ',
$PHP_SELF, chr($i), chr($i));
}
echo "
" ;
/* now we are ready to display the results. */
?>
<table width="400" border="1">
  <tr>
    <td>client</td>
    <td>company name</td>
    <td>Phone</td>
  </tr>



<?php if(mysql_num_rows($execute)>0){



while($result = mysql_fetch_assoc($execute));
{
?>
    
   <tr>
    <td><?php echo $result['id_cliente']; ?></td>
    <td><?php echo $result['company_name']; ?></td>
    <td><?php echo $result['cliente_tel'];?></td>
  </tr>
  
   
    <?

}

}else{
echo "
No customer found.
" ;
}
?>

</table>

[lingo5]

no...not printing any results...weird

[lingo5]

This is very weird...the script works perfect without the table rows.

Can anyone spot what I'm doing wrong?

Thanks

[canabatz]

from your first code:

<?php if(mysql_num_rows($execute)>0){
do{
echo "
" .$result['id_cliente']. " " .$result['company_name']. " " .$result['cliente_tel']. "
" ;
}while($result = mysql_fetch_assoc($execute));
}else{
echo "
No customer found.
" ;
}
?>

 

does it display all records? or just one?

 

how many records there is?

[lingo5]

all records under one letter

[canabatz]

try that:

 

<?php

/* Get the letter user clicked on and assign it a variable called $sort */
$sort = $_REQUEST['letter'];
/* Let's check if variable $sort is empty. If it is we will create a query to display all customers alphabetically ordered by last name. */
if($sort == ""){
$qry= "SELECT * FROM myDatabase.t_clientes ORDER BY company_name ASC " ;
}else{
/* if varible $sort is not empty we will create a query that sorts out the customers by their last name, and order the selected records ascendingly. */
$qry = "SELECT * FROM myDatabase.t_clientes WHERE company_name LIKE '$sort%' ORDER BY company_name ASC" ;
}
/* Notice the use of '%' wilde card in the above query "LIKE '$sort%'". */
//next step is to execute the query.
$execute = mysql_query($qry) or die(mysql_error());
/* Before we display results let's create our alphabetical navigation. 
for ($i = 65; $i < 91; $i++) {
printf('<a href="%s?letter=%s">%s</a> | ',
$PHP_SELF, chr($i), chr($i));
}
echo "
" ;
/* now we are ready to display the results. */
?>
<table width="400" border="1">
  <tr>
    <td>client</td>
    <td>company name</td>
    <td>Phone</td>
  </tr>

<?php if(mysql_num_rows($execute)>0){
do{
?>

<tr>
    <td><?php echo $result['id_cliente']; ?></td>
    <td><?php echo $result['company_name']; ?></td>
    <td><?php echo $result['cliente_tel'];?></td>
  </tr>

<?php
}while($result = mysql_fetch_assoc($execute));
}else{
echo "
No customer found.
" ;
}
?>

</table>

[lingo5]

Thanks a lot, i'm almost there...I have styled my table a bit, but for some reason I am getting an empty row at the top of ach result...

Here's my code

<?php
/* Get the letter user clicked on and assign it a variable called $sort */
$sort = $_REQUEST['letter'];
/* Let's check if variable $sort is empty. If it is we will create a query to display all customers alphabetically ordered by last name. */
if($sort == ""){
$qry= "SELECT * FROM myDatabase.t_clientes ORDER BY company_name ASC " ;
}else{
/* if varible $sort is not empty we will create a query that sorts out the customers by their last name, and order the selected records ascendingly. */
$qry = "SELECT * FROM myDatabase.t_clientes WHERE company_name LIKE '$sort%' ORDER BY company_name ASC" ;
}
/* Notice the use of '%' wilde card in the above query "LIKE '$sort%'". */
//next step is to execute the query.
$execute = mysql_query($qry) or die(mysql_error());
<td width="551" align="left" nowrap="nowrap" class="UsuarioNombreHeader">
<?php for ($i = 65; $i < 91; $i++) {
printf('<a href="%s?letter=%s">%s</a> | ',
$PHP_SELF, chr($i), chr($i));
}
echo "
" ; //print t alphabet */?>
</td>
<table width="850"  align="center" border="0" cellpadding="5" cellspacing="0" class="BottomLine">
          <tr>
    <td><?php if(mysql_num_rows($execute)>0){
do{?>
          <td width="27%" align="left" nowrap="nowrap" class="AddressTXT"><strong><?php echo $result['company_name']; ?></strong></td>
          <td width="20%" align="left" nowrap="nowrap" class="AddressTXT"><strong>tel.<?php echo $result['cliente_tel']; ?></strong></td>
          <td width="27%" align="left" nowrap="nowrap" class="AddressTXT"><?php echo $result['cliente_email'];?></td>
          <td width="2%" align="center" class="CP_errorLoginTxt"><a href="PC_contactos_sendmail.php?id_cliente=<?php echo $result['id_cliente']; ?>"><img src="CP_img/icono_email_reducido.png" alt="" width="15" height="10" border="0" /></a></td>
          <td width="2%" align="center" class="CP_errorLoginTxt"><a href="PC_contactos_update.php?id_cliente=<?php echo $result['id_cliente']; ?> "onclick="return confirm('¿Seguro que desea \n ELIMINAR PERMANENTEMENTE \n <?php echo $result['company_name']; ?>?');"><img src="CP_img/icono_editar_reducido.png" width="20" height="13" border="0" /></a></td>
          <td width="2%" align="center" class="CP_errorLoginTxt"><a href="PC_contactos_delete.php?id_cliente=<?php echo $result['id_cliente']; ?> "onClick="return confirm('¿Seguro que desea \n ELIMINAR PERMANENTEMENTE \n <?php echo $result['company_name']; ?>?');"><img src="CP_img/icono_borrar_reducido.png" width="15" height="10" border="0" /></a></td>
        </tr>


<?php
}while($result = mysql_fetch_assoc($execute));
}else{
echo "
No contacts found
" ;
}
?> 
</table>

[canabatz]

try now

<?php
/* Get the letter user clicked on and assign it a variable called $sort */
$sort = $_REQUEST['letter'];
/* Let's check if variable $sort is empty. If it is we will create a query to display all customers alphabetically ordered by last name. */
if($sort == ""){
$qry= "SELECT * FROM myDatabase.t_clientes ORDER BY company_name ASC " ;
}else{
/* if varible $sort is not empty we will create a query that sorts out the customers by their last name, and order the selected records ascendingly. */
$qry = "SELECT * FROM myDatabase.t_clientes WHERE company_name LIKE '$sort%' ORDER BY company_name ASC" ;
}
/* Notice the use of '%' wilde card in the above query "LIKE '$sort%'". */
//next step is to execute the query.
$execute = mysql_query($qry) or die(mysql_error());
?>
<td width="551" align="left" nowrap="nowrap" class="UsuarioNombreHeader">
<?php for ($i = 65; $i < 91; $i++) {
printf('<a href="%s?letter=%s">%s</a> | ',
$PHP_SELF, chr($i), chr($i));
}
echo "
" ; //print t alphabet */?>
</td>
<table width="850"  align="center" border="0" cellpadding="5" cellspacing="0" class="BottomLine">
         <?php if(mysql_num_rows($execute)>0){
do{?> <tr>
    <td>
          <td width="27%" align="left" nowrap="nowrap" class="AddressTXT"><strong><?php echo $result['company_name']; ?></strong></td>
          <td width="20%" align="left" nowrap="nowrap" class="AddressTXT"><strong>tel.<?php echo $result['cliente_tel']; ?></strong></td>
          <td width="27%" align="left" nowrap="nowrap" class="AddressTXT"><?php echo $result['cliente_email'];?></td>
          <td width="2%" align="center" class="CP_errorLoginTxt"><a href="PC_contactos_sendmail.php?id_cliente=<?php echo $result['id_cliente']; ?>"><img src="CP_img/icono_email_reducido.png" alt="" width="15" height="10" border="0" /></a></td>
          <td width="2%" align="center" class="CP_errorLoginTxt"><a href="PC_contactos_update.php?id_cliente=<?php echo $result['id_cliente']; ?> "onclick="return confirm('¿Seguro que desea \n ELIMINAR PERMANENTEMENTE \n <?php echo $result['company_name']; ?>?');"><img src="CP_img/icono_editar_reducido.png" width="20" height="13" border="0" /></a></td>
          <td width="2%" align="center" class="CP_errorLoginTxt"><a href="PC_contactos_delete.php?id_cliente=<?php echo $result['id_cliente']; ?> "onClick="return confirm('¿Seguro que desea \n ELIMINAR PERMANENTEMENTE \n <?php echo $result['company_name']; ?>?');"><img src="CP_img/icono_borrar_reducido.png" width="15" height="10" border="0" /></a></td>
        </tr>


<?php
}while($result = mysql_fetch_assoc($execute));
}else{
echo "
No contacts found
" ;
}
?> 
</table>

[lingo5]

canabatz, many thanks for your helpbut I can't get that code to work.

It must be something to do with the function that generates the letters.

Anyway, I have done it a different way and it works except for one thing....I need all the records to display intially when no letter is selected and I can't seem to work that out...

This is my new code:

$letter= $_GET['letter'];

if(!empty ($_GET['letter']) && ctype_alpha ($_GET['letter']))
{
$whereclause = "company_name LIKE '".$_GET[letter]."%'";
}
else {
$whereclause = "";
}
mysql_select_db($database_MySQLconnect, $MySQLconnect);
$query_letters_RS = "SELECT id_cliente,company_name,cliente_tel,cliente_email FROM t_clientes WHERE ".$whereclause." ORDER BY company_name ASC";
$letters_RS = mysql_query($query_letters_RS, $MySQLconnect) or die(mysql_error());
$row_letters_RS = mysql_fetch_assoc($letters_RS);
$totalRows_letters_RS = mysql_num_rows($letters_RS);
?>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="0" >
      <tr>
        <td width="551" align="left" nowrap="nowrap" class="UsuarioNombreHeader"><div class="letters"> 
          <span class="PClistItems"><a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=a">A</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=b">| B</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=c">| C</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=d">| D</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=e">| E</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=f">| F</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=g">| G</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=h">| H</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=i">| I</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=j">| J</a>
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=k">| K</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=l">| L</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=m">| M</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=n">| N</a>  
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=o">| O</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=p">| P</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=q">| Q</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=r">| R</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=s">| S</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=t">| T</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=u">| U</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=v">| V</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=w">| W</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=x">| X</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=y">| Y</a> 
          <a href="<?php echo $_SERVER["PHP_SELF"];?>?letter=z">| Z</a></span></div></td>
        <td align="right" nowrap="nowrap"><form action="searchFunction.php" method="post" name="formSearchClients" id="formSearchClients">
          <label>
            <input name="searchCriteria" id="searchCriteria" type="text" onfocus="this.value='';" class="SearchFieldTXT" value="<?=CNT_TXT_ETIQCLOUD_SEARCH?>" />
            <input type="hidden" name="WADbSearch1" value="Submit" />
          </label>
        </form></td>
      </tr>
    </table></td>
  </tr>
</table>
<?php if ($totalRows_letters_RS == 0) { // Show if recordset empty ?>
  <table width="850" align="center" border="0" cellpadding="5" cellspacing="0" class="BottomLine">
    <tr>
      <td height="238" align="center" nowrap="nowrap" class="NoResultsTXT">No  hay contactos con la letra "<?php echo $letter;?>"</td>
    </tr>
  </table>
  <?php } // Show if recordset empty ?>
<?php do { ?>
  <?php if ($totalRows_letters_RS > 0) { // Show if recordset not empty ?>
  <table width="850" align="center" border="0" cellpadding="5" cellspacing="0" class="BottomLine">
    
    <tr>
      <td width="27%" align="left" nowrap="nowrap" class="AddressTXT"><?php echo $row_letters_RS['company_name']; ?></td>
      <td width="20%" align="left" nowrap="nowrap" class="AddressTXT"><strong>tel.<?php echo $row_letters_RS['cliente_tel']; ?></strong></td>
      <td width="27%" align="left" nowrap="nowrap" class="AddressTXT"><?php echo $row_letters_RS['cliente_email']; ?></td>
      <td width="2%" align="center" class="CP_errorLoginTxt"><a href="PC_contactos_sendmail.php?id_cliente=<?php echo $result['id_cliente']; ?>"><img src="CP_img/icono_email_reducido.png" alt="" width="15" height="10" border="0" /></a></td>
      <td width="2%" align="center" class="CP_errorLoginTxt"><a href="PC_contactos_update.php?id_cliente=<?php echo $result['id_cliente']; ?> "onclick="return confirm('¿Seguro que desea \n ELIMINAR PERMANENTEMENTE \n <?php echo $result['company_name']; ?>?');"><img src="CP_img/icono_editar_reducido.png" width="20" height="13" border="0" /></a></td>
      <td width="2%" align="center" class="CP_errorLoginTxt"><a href="PC_contactos_delete.php?id_cliente=<?php echo $result['id_cliente']; ?> "onclick="return confirm('¿Seguro que desea \n ELIMINAR PERMANENTEMENTE \n <?php echo $result['company_name']; ?>?');"><img src="CP_img/icono_borrar_reducido.png" width="15" height="10" border="0" /></a></td>
      </tr>
    
  </table>
  <?php } // Show if recordset not empty ?>
<?php } while ($row_letters_RS = mysql_fetch_assoc($letters_RS)); ?>
<table width="850" border="0" align="center" cellpadding="12" cellspacing="0" class="BottomLine">
  <tr>
    <td width="18" align="left" nowrap="nowrap"> </td>
    <td width="342" align="left" nowrap="nowrap" class="AddressTXT"> </td>
    <td width="315" align="right" class="AddressTXT"><table width="40%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="54%" align="right" class="CP_blueTXT"><?= CNT_TXT_ETIQCLOUD_NUMBEROFPAGES?>
          : </td>
        <td width="46%" align="right" nowrap="nowrap" class="CP_blueTXT"></td>
      </tr>
    </table></td>
    <td width="79" align="left" nowrap="nowrap" class="CP_SiNoText"><table width="100%" border="0" cellspacing="0" cellpadding="3">
      <tr>
        <td width="16%" align="left"><a href="javascript:history.go(-1)"><img src="CP_img/volver_button.png" alt="" width="20" height="20" border="0" /></a></td>
        <td width="84%" align="left" nowrap="nowrap" class="CP_blueTXT" ><a href="javascript:history.go(-1)">
          <?=CNT_TXT_ETIQCLOUD_VOLVERATRAS?>
        </a></td>
      </tr>
    </table></td>
  </tr>
</table>
<p> </p>
</body>
</html>
<?php
mysql_free_result($letters_RS);

mysql_free_result($navigation_RS);
?>