[RESOLVED] Output Error

Table

hi, i have created a search page, and it looks for records of waht name is entered, a bit like the way google wearch works for my database, whoever, it calls up all the records before a search has been made, i think there is a problem with the the while loop i have created but i cant seem to work it out

this is my code

can some one please help me sort it out, so when a user opens this page it is empty and only produce records that they are looking for.

Blulagoon

Could you try to do it like this ?

echo "<tr valign=top>"; 
            echo "<td bgcolor=#FFFFFF colspan=6></td>"; 
            echo "</tr>"; 

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

echo "<tr valign=center>"; 
        echo "<td width=100 class=table><a href=\"viewsupplier2.php?id=".$row['supplier_id']."\">".$row['supplier_id']."</a></td>"; 
        echo "<td width=100 class=table>".'<p id="font">'.$row['supplier_name']." </p></td>"; 
        echo "<td width=100 class=table>".'<p id="font">'.$row['supplier_ref_number']." </p></td>"; 
        echo "<td width=100 class=table>".'<p id="font">'.$row['supplier_street_address']." </p></td>"; 
        echo "<td width=100 class=table>".'<p id="font">'.$row['supplier_tel']." </p></td>"; 
        echo "<td width=100 class=table>".'<p id="font">'.$row['supplier_of']."</pd></td>"; 
        echo "<td class=table></td>"; 
        echo "</tr>"; 

}

echo "<tr valign=bottom>"; 
        echo "<td bgcolor=#FFFFFF colspan=6 height=3></td>"; 
        echo "</tr>";

Does that work ?

scrupul0us

embedded html.. my eyes burn

dont EVER embed html in php where u dont have to

<?php 


 $conn = mysql_connect("localhost","root","") or die("Could Not Connect To The Database"); // Configuration Include 
 mysql_select_db("styledynamix",$conn) or die("Could Not Select The Database"); // Select the database 

 $result = mysql_query("SELECT * FROM suppliers WHERE supplier_name LIKE'%$name%'");// Request the table suppliers in styledynamix database 
       if (!$result) { 
             echo("<P>Error performing query: " . mysql_error() . "</P>"); 
        exit();  } 

// Display the text of each record. 
          $i=0; 
          while ( $row = mysql_fetch_array($result) ) 
{ 
        if($i>0) 
        {?>         

            <tr valign=top> 
            <td bgcolor=#FFFFFF colspan=6></td> 
            </tr> 
        <?php 
        }
        ?>  

        <tr valign=center>"; 
        <td width=100 class=table><a href="viewsupplier2.php?id=<?=$row['supplier_id'];?>"><?=$row['supplier_id'];?></a></td> 
        <td width=100 class=table><p id="font"><?=$row['supplier_name'];?></p></td> 
        <td width=100 class=table><p id="font"><?=$row['supplier_ref_number'];?></p></td> 
        <td width=100 class=table><p id="font"><?=$row['supplier_street_address'];?></p></td>
        <td width=100 class=table><p id="font"><?=$row['supplier_tel'];?></p></td> 
        <td width=100 class=table><p id="font"><?=$row['supplier_of'];?></pd></td> 
        <td class=table></td> 
        </tr>
        <?php 
        $i++; 

} 

echo "<tr valign=bottom>"; 
    echo "<td bgcolor=#FFFFFF colspan=6 height=3></td>"; 
    echo "</tr>"; 

?>

and ill be nice and not mention the use of tables for layout, let alone paragraph tags ::shutters::

hope this helps

Table

thanks for the help but i have sorted it out