prepare("SELECT * FROM `supplier` WHERE Suppliername = '$str'"); //fetch the data $sth->setFetchMode(PDO:: FETCH_OBJ); $sth -> execute(); if($row = $sth->fetch()) { ?> Suppliers

Search for Supplier

Suppliername	Address1	Address2	Postcode	Telephone	Email
Suppliername; ?>	Address1;?>	Address2; ?>	Postcode;?>	Telephone; ?>	Email; ?>