Please suggest me where I am doing wrong? Its not searching at al. SEARCH FORM <html> <head> <title>Search the Database</title> </head> <body> <form action="print.php" method="post"> Search: <input type="text" name="term" /><br /> <input type="submit" name="submit" value="Submit" /> </form> </body> </html> PHP: SEARCH CODE <?php mysql_connect ("localhost", "root","") or die (mysql_error()); mysql_select_db ("shipments"); $term = $_POST['term']; $sql = mysql_query("select * from info where user like '%$term%'"); while ($row = mysql_fetch_array($sql)){ $id = $result['id']; $to = $result['to']; $wgt = $result['wgt']; $user = $result['user']; $price = $result['price']; $item = $result['item']; $itemid = $result['itemid']; } ?> <style type="text/css"> <!-- .K { font-size: 14px; font-weight: normal; font-family: Tahoma, Geneva, sans-serif; } .bar { font:"Free 3 of 9 Extended"; font-size:14px; } .K2 { font-size: 14px; font-family: tahoma, Geneva, sans-serif; } .ff { font-family: "Courier New", Courier, monospace; } --> </style> <table align="left"> <tr> <td> <table width="97%" align="center" background="ss.jpg"> <tr> <td width="68%">SHIPID: <?php echo $id ;?></td> <td width="32%" class="ff">CONTENTS:<?php echo $item ;?></td> </tr> </table> <table> <tr> <td> </td> </tr> </table> <table width="800" align="center"> <tr> <td class="K"><strong><U>SEND TO :</U></strong></td> <td class="K2"> </td> <td class="K" align="right"><strong>FROM :</strong></td> <td class="K2"> </td> </tr> <tr> <td width="12%" height="131" class="K"> </td> <td align="justify" width="34%" class="K2"><table width="250"> <tr> <td class="K2" style="text-transform:uppercase"><strong><br /><?php echo ( nl2br ($to ));?></strong></td> </tr> </table> </td> <td width="14%" class="K" align="center"><p>::</p> <p>::</p> <p>::</p> <p>::</p></td> <td align="justify" width="40%" class="K2"> </td> </tr> <tr> <td height="16" class="K">------------------</td> <td class="K2">--------------------------------------------------</td> <td class="K">---------------------</td> <td class="K">--------------------------------------------------------</td> </tr> </table> <table width="72%" align="center"> <tr> <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td> </tr> </table> <table width="72%" align="center" > <tr align="left"> <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td> <td width="28%" class="K2">SPOAcc.</td> <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td> <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><?php echo $wgt ;?> grams</td> <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;"><?php echo $price ;?> USD</span></td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong><?php echo $user ;?>;</strong></td> </tr> </table> <hr color="#CCCCCC" /> <table width="100%"> <tr> <td width="57%" height="67"><p>Item ID:</p> <?php echo $itemid ;?></td> <td width="43%"><p>Tracking Code:</p> <p> </p></td> </tr> </table></td> </tr> </table> PHP:
what's your problem? However' this code can show you ONLY one result, because you're filling same variable with diifferent data in while(){}
I did the following changes but it still does not work <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("shipments", $con); $term = $_POST['term']; $results = mysql_query("select * from info where user like '%$term%'"); while ($result = mysql_fetch_array($results)) { $id = $result['id']; $to = $result['to']; $wgt = $result['wgt']; $user = $result['user']; $price = $result['price']; $item = $result['item']; $itemid = $result['itemid']; } ?> <style type="text/css"> <!-- .K { font-size: 14px; font-weight: normal; font-family: Tahoma, Geneva, sans-serif; } .bar { font:"Free 3 of 9 Extended"; font-size:14px; } .K2 { font-size: 14px; font-family: tahoma, Geneva, sans-serif; } .ff { font-family: "Courier New", Courier, monospace; } --> </style> <table align="left"> <tr> <td> <table width="97%" align="center" background="ss.jpg"> <tr> <td width="68%">SHIPID: <?php echo $id ;?></td> <td width="32%" class="ff">CONTENTS:<?php echo $item ;?></td> </tr> </table> <table> <tr> <td> </td> </tr> </table> <table width="800" align="center"> <tr> <td class="K"><strong><U>SEND TO :</U></strong></td> <td class="K2"> </td> <td class="K" align="right"><strong>FROM :</strong></td> <td class="K2"> </td> </tr> <tr> <td width="12%" height="131" class="K"> </td> <td align="justify" width="34%" class="K2"><table width="250"> <tr> <td class="K2" style="text-transform:uppercase"><strong><br /><?php echo ( nl2br ($to ));?></strong></td> </tr> </table> </td> <td width="14%" class="K" align="center"><p>::</p> <p>::</p> <p>::</p> <p>::</p></td> <td align="justify" width="40%" class="K2"> </td> </tr> <tr> <td height="16" class="K">------------------</td> <td class="K2">--------------------------------------------------</td> <td class="K">---------------------</td> <td class="K">--------------------------------------------------------</td> </tr> </table> <table width="72%" align="center"> <tr> <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td> </tr> </table> <table width="72%" align="center" > <tr align="left"> <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td> <td width="28%" class="K2">PhotoGraphy Acc.</td> <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td> <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><?php echo $wgt ;?> grams</td> <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;"><?php echo $price ;?> USD</span></td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong><?php echo $user ;?>;</strong></td> </tr> </table> <hr color="#CCCCCC" /> <table width="100%"> <tr> <td width="57%" height="67"><p>Item ID:</p> <?php echo $itemid ;?></td> <td width="43%"><p>Tracking Code:</p> <p> </p></td> </tr> </table></td> </tr> </table> PHP: It sayd undefined variables on all the places where its <?php echo $id ;?> PHP:
Just at a glance try this... its not tested, but basically you need to put your table into the while loop <style type="text/css"> <!-- .K { font-size: 14px; font-weight: normal; font-family: Tahoma, Geneva, sans-serif; } .bar { font:"Free 3 of 9 Extended"; font-size:14px; } .K2 { font-size: 14px; font-family: tahoma, Geneva, sans-serif; } .ff { font-family: "Courier New", Courier, monospace; } --> </style> <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("shipments", $con); $term = $_POST['term']; $results = mysql_query("select * from info where user like '%$term%'"); while ($result = mysql_fetch_array($results)) { $id = $result['id']; $to = $result['to']; $wgt = $result['wgt']; $user = $result['user']; $price = $result['price']; $item = $result['item']; $itemid = $result['itemid']; echo ' <table align="left"> <tr> <td> <table width="97%" align="center" background="ss.jpg"> <tr> <td width="68%">SHIPID: <?php echo $id ;?></td> <td width="32%" class="ff">CONTENTS:<?php echo $item ;?></td> </tr> </table> <table> <tr> <td> </td> </tr> </table> <table width="800" align="center"> <tr> <td class="K"><strong><U>SEND TO :</U></strong></td> <td class="K2"> </td> <td class="K" align="right"><strong>FROM :</strong></td> <td class="K2"> </td> </tr> <tr> <td width="12%" height="131" class="K"> </td> <td align="justify" width="34%" class="K2"><table width="250"> <tr> <td class="K2" style="text-transform:uppercase"><strong><br /><?php echo ( nl2br ($to ));?></strong></td> </tr> </table> </td> <td width="14%" class="K" align="center"><p>::</p> <p>::</p> <p>::</p> <p>::</p></td> <td align="justify" width="40%" class="K2"> </td> </tr> <tr> <td height="16" class="K">------------------</td> <td class="K2">--------------------------------------------------</td> <td class="K">---------------------</td> <td class="K">--------------------------------------------------------</td> </tr> </table> <table width="72%" align="center"> <tr> <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td> </tr> </table> <table width="72%" align="center" > <tr align="left"> <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td> <td width="28%" class="K2">PhotoGraphy Acc.</td> <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td> <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><?php echo $wgt ;?> grams</td> <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;"><?php echo $price ;?> USD</span></td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong><?php echo $user ;?>;</strong></td> </tr> </table> <hr color="#CCCCCC" /> <table width="100%"> <tr> <td width="57%" height="67"><p>Item ID:</p> <?php echo $itemid ;?></td> <td width="43%"><p>Tracking Code:</p> <p> </p></td> </tr> </table></td> </tr> </table> '; } ?> PHP:
MyVodaFone -> sorry but wrong, ou forgot there are <?php ?> tags in that tables <style type="text/css"> <!-- .K { font-size: 14px; font-weight: normal; font-family: Tahoma, Geneva, sans-serif; } .bar { font:"Free 3 of 9 Extended"; font-size:14px; } .K2 { font-size: 14px; font-family: tahoma, Geneva, sans-serif; } .ff { font-family: "Courier New", Courier, monospace; } --> </style> <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("shipments", $con); $term = $_POST['term']; $results = mysql_query("select * from info where user like '%$term%'"); while ($result = mysql_fetch_array($results)) { $id = $result['id']; $to = $result['to']; $wgt = $result['wgt']; $user = $result['user']; $price = $result['price']; $item = $result['item']; $itemid = $result['itemid']; echo ' <table align="left"> <tr> <td> <table width="97%" align="center" background="ss.jpg"> <tr> <td width="68%">SHIPID: '.$id.'</td> <td width="32%" class="ff">CONTENTS:'.$item.'</td> </tr> </table> <table> <tr> <td> </td> </tr> </table> <table width="800" align="center"> <tr> <td class="K"><strong><U>SEND TO :</U></strong></td> <td class="K2"> </td> <td class="K" align="right"><strong>FROM :</strong></td> <td class="K2"> </td> </tr> <tr> <td width="12%" height="131" class="K"> </td> <td align="justify" width="34%" class="K2"><table width="250"> <tr> <td class="K2" style="text-transform:uppercase"><strong><br />'.nl2br ($to).'</strong></td> </tr> </table> </td> <td width="14%" class="K" align="center"><p>::</p> <p>::</p> <p>::</p> <p>::</p></td> <td align="justify" width="40%" class="K2"> </td> </tr> <tr> <td height="16" class="K">------------------</td> <td class="K2">--------------------------------------------------</td> <td class="K">---------------------</td> <td class="K">--------------------------------------------------------</td> </tr> </table> <table width="72%" align="center"> <tr> <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td> </tr> </table> <table width="72%" align="center" > <tr align="left"> <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td> <td width="28%" class="K2">PhotoGraphy Acc.</td> <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td> <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2">'.$wgt.' grams</td> <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">'.$price.' USD</span></td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user'</strong></td> </tr> </table> <hr color="#CCCCCC" /> <table width="100%"> <tr> <td width="57%" height="67"><p>Item ID:</p> '.$itemid.'</td> <td width="43%"><p>Tracking Code:</p> <p> </p></td> </tr> </table></td> </tr> </table> '; } ?> PHP:
Thanx, it now gives me an error Parse error: parse error, expecting `','' or `';'' in C:\wamp\www\print.php on line 78 Code (markup):
If that line is wrong, sorry for that... try this <style type="text/css"> <!-- .K { font-size: 14px; font-weight: normal; font-family: Tahoma, Geneva, sans-serif; } .bar { font:"Free 3 of 9 Extended"; font-size:14px; } .K2 { font-size: 14px; font-family: tahoma, Geneva, sans-serif; } .ff { font-family: "Courier New", Courier, monospace; } --> </style> <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("shipments", $con); $term = $_POST['term']; $results = mysql_query("select * from info where user like '%$term%'"); while ($result = mysql_fetch_array($results)) { $id = $result['id']; $to = $result['to']; $wgt = $result['wgt']; $user = $result['user']; $price = $result['price']; $item = $result['item']; $itemid = $result['itemid']; echo ' <table align="left"> <tr> <td> <table width="97%" align="center" background="ss.jpg"> <tr> <td width="68%">SHIPID: '.$id.'</td> <td width="32%" class="ff">CONTENTS:'.$item.'</td> </tr> </table> <table> <tr> <td> </td> </tr> </table> <table width="800" align="center"> <tr> <td class="K"><strong><U>SEND TO :</U></strong></td> <td class="K2"> </td> <td class="K" align="right"><strong>FROM :</strong></td> <td class="K2"> </td> </tr> <tr> <td width="12%" height="131" class="K"> </td> <td align="justify" width="34%" class="K2"><table width="250"> <tr> <td class="K2" style="text-transform:uppercase"><strong><br />'.(nl2br ($to)).'</strong></td> </tr> </table> </td> <td width="14%" class="K" align="center"><p>::</p> <p>::</p> <p>::</p> <p>::</p></td> <td align="justify" width="40%" class="K2"> </td> </tr> <tr> <td height="16" class="K">------------------</td> <td class="K2">--------------------------------------------------</td> <td class="K">---------------------</td> <td class="K">--------------------------------------------------------</td> </tr> </table> <table width="72%" align="center"> <tr> <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td> </tr> </table> <table width="72%" align="center" > <tr align="left"> <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td> <td width="28%" class="K2">PhotoGraphy Acc.</td> <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td> <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2">'.$wgt.' grams</td> <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">'.$price.' USD</span></td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user'</strong></td> </tr> </table> <hr color="#CCCCCC" /> <table width="100%"> <tr> <td width="57%" height="67"><p>Item ID:</p> '.$itemid.'</td> <td width="43%"><p>Tracking Code:</p> <p> </p></td> </tr> </table></td> </tr> </table> '; } ?> PHP:
sorry. find line <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user'</strong></td> PHP: and replace that line with <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user.'</strong></td> PHP: dot missing
I did that already, before you replied Anyways, but now I am facing another problem. When I search for something which is not present in DB, it simply give me a blank page and not an error. I know that we require to put some code to show error, but since I no know PHP asking your help once again, please
Replace this: <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("shipments", $con); $term = $_POST['term']; $results = mysql_query("select * from info where user like '%$term%'"); while ($result = mysql_fetch_array($results)) { $id = $result['id']; $to = $result['to']; $wgt = $result['wgt']; $user = $result['user']; $price = $result['price']; $item = $result['item']; $itemid = $result['itemid']; echo ' <table align="left"> <tr> <td> <table width="97%" align="center" background="ss.jpg"> <tr> <td width="68%">SHIPID: '.$id.'</td> <td width="32%" class="ff">CONTENTS:'.$item.'</td> </tr> </table> <table> <tr> <td> </td> </tr> </table> <table width="800" align="center"> <tr> <td class="K"><strong><U>SEND TO :</U></strong></td> <td class="K2"> </td> <td class="K" align="right"><strong>FROM :</strong></td> <td class="K2"> </td> </tr> <tr> <td width="12%" height="131" class="K"> </td> <td align="justify" width="34%" class="K2"><table width="250"> <tr> <td class="K2" style="text-transform:uppercase"><strong><br />'.(nl2br ($to)).'</strong></td> </tr> </table> </td> <td width="14%" class="K" align="center"><p>::</p> <p>::</p> <p>::</p> <p>::</p></td> <td align="justify" width="40%" class="K2"> </td> </tr> <tr> <td height="16" class="K">------------------</td> <td class="K2">--------------------------------------------------</td> <td class="K">---------------------</td> <td class="K">--------------------------------------------------------</td> </tr> </table> <table width="72%" align="center"> <tr> <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td> </tr> </table> <table width="72%" align="center" > <tr align="left"> <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td> <td width="28%" class="K2">PhotoGraphy Acc.</td> <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td> <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2">'.$wgt.' grams</td> <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">'.$price.' USD</span></td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user'</strong></td> </tr> </table> <hr color="#CCCCCC" /> <table width="100%"> <tr> <td width="57%" height="67"><p>Item ID:</p> '.$itemid.'</td> <td width="43%"><p>Tracking Code:</p> <p> </p></td> </tr> </table></td> </tr> </table> '; } ?> Code (markup): with this: <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("shipments", $con); $term = $_POST['term']; $results = mysql_query("select * from info where user like '%$term%'"); $found = 0; while ($result = mysql_fetch_array($results)) { $found = 1; $id = $result['id']; $to = $result['to']; $wgt = $result['wgt']; $user = $result['user']; $price = $result['price']; $item = $result['item']; $itemid = $result['itemid']; echo ' <table align="left"> <tr> <td> <table width="97%" align="center" background="ss.jpg"> <tr> <td width="68%">SHIPID: '.$id.'</td> <td width="32%" class="ff">CONTENTS:'.$item.'</td> </tr> </table> <table> <tr> <td> </td> </tr> </table> <table width="800" align="center"> <tr> <td class="K"><strong><U>SEND TO :</U></strong></td> <td class="K2"> </td> <td class="K" align="right"><strong>FROM :</strong></td> <td class="K2"> </td> </tr> <tr> <td width="12%" height="131" class="K"> </td> <td align="justify" width="34%" class="K2"><table width="250"> <tr> <td class="K2" style="text-transform:uppercase"><strong><br />'.(nl2br ($to)).'</strong></td> </tr> </table> </td> <td width="14%" class="K" align="center"><p>::</p> <p>::</p> <p>::</p> <p>::</p></td> <td align="justify" width="40%" class="K2"> </td> </tr> <tr> <td height="16" class="K">------------------</td> <td class="K2">--------------------------------------------------</td> <td class="K">---------------------</td> <td class="K">--------------------------------------------------------</td> </tr> </table> <table width="72%" align="center"> <tr> <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td> </tr> </table> <table width="72%" align="center" > <tr align="left"> <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td> <td width="28%" class="K2">PhotoGraphy Acc.</td> <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td> <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2">'.$wgt.' grams</td> <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">'.$price.' USD</span></td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user'</strong></td> </tr> </table> <hr color="#CCCCCC" /> <table width="100%"> <tr> <td width="57%" height="67"><p>Item ID:</p> '.$itemid.'</td> <td width="43%"><p>Tracking Code:</p> <p> </p></td> </tr> </table></td> </tr> </table> '; } if($found == 0) { echo 'No result found'; } ?> Code (markup):
drtaccess why so hard? Just replace whole given code with this <style type="text/css"> <!-- .K { font-size: 14px; font-weight: normal; font-family: Tahoma, Geneva, sans-serif; } .bar { font:"Free 3 of 9 Extended"; font-size:14px; } .K2 { font-size: 14px; font-family: tahoma, Geneva, sans-serif; } .ff { font-family: "Courier New", Courier, monospace; } --> </style> <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("shipments", $con); $term = $_POST['term']; $results = mysql_query("select * from info where user like '%$term%'"); if (mysql_num_rows($results) == 0)Â {echo "No results";} while ($result = mysql_fetch_array($results)) { $id = $result['id']; $to = $result['to']; $wgt = $result['wgt']; $user = $result['user']; $price = $result['price']; $item = $result['item']; $itemid = $result['itemid']; echo ' <table align="left"> <tr> <td> <table width="97%" align="center" background="ss.jpg"> <tr> <td width="68%">SHIPID: '.$id.'</td> <td width="32%" class="ff">CONTENTS:'.$item.'</td> </tr> </table> <table> <tr> <td> </td> </tr> </table> <table width="800" align="center"> <tr> <td class="K"><strong><U>SEND TO :</U></strong></td> <td class="K2"> </td> <td class="K" align="right"><strong>FROM :</strong></td> <td class="K2"> </td> </tr> <tr> <td width="12%" height="131" class="K"> </td> <td align="justify" width="34%" class="K2"><table width="250"> <tr> <td class="K2" style="text-transform:uppercase"><strong><br />'.(nl2br ($to)).'</strong></td> </tr> </table> </td> <td width="14%" class="K" align="center"><p>::</p> <p>::</p> <p>::</p> <p>::</p></td> <td align="justify" width="40%" class="K2"> </td> </tr> <tr> <td height="16" class="K">------------------</td> <td class="K2">--------------------------------------------------</td> <td class="K">---------------------</td> <td class="K">--------------------------------------------------------</td> </tr> </table> <table width="72%" align="center"> <tr> <td align="center"><span style="font:Verdana, Geneva, sans-serif; font-size: 10px;"> :: Package Information :: </span></td> </tr> </table> <table width="72%" align="center" > <tr align="left"> <td width="11%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" height="20">*Content:</td> <td width="28%" class="K2">PhotoGraphy Acc.</td> <td width="8%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">*Weight:</td> <td width="31%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2">'.$wgt.' grams</td> <td width="9%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K"><p>*Price:</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><span class="K2" style="font:Verdana, Geneva, sans-serif; font-size: 10px;">'.$price.' USD</span></td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2" align="right">UID</td> <td width="13%" style="font:Verdana, Geneva, sans-serif; font-size: 10px;" class="K2"><strong>'.$user.'</strong></td> </tr> </table> <hr color="#CCCCCC" /> <table width="100%"> <tr> <td width="57%" height="67"><p>Item ID:</p> '.$itemid.'</td> <td width="43%"><p>Tracking Code:</p> <p> </p></td> </tr> </table></td> </tr> </table> '; } ?> PHP: