Echo Table Problem

Question

ptara1 0 Junior Poster in Training

13 Years Ago

I have a php script that echoes results from a search. Generally I have no problem getting the results in a table but for some reason I can't get these scripts to do that. I figure its a small error. I'm going to put in the code but if you want to just suggest a good editor (as I am new to php) that would be helpful. Thanks.

<?php
  if(isset($_POST['submit'])){
  if(isset($_GET['go'])){
  if(preg_match("/^[  a-zA-Z0-9]+/", $_POST['search'])){
  $search=$_POST['search'];
  
  $db=mysql_connect  ("connection info") or die ('I cannot connect to the database  because: ' . mysql_error());
 
  $mydb=mysql_select_db("database name");
  
  $sql="SELECT  OrderID, Customer, Address, City, State, ZipCode, Telephone, ServiceCategory, DateCall, WStatus FROM C WHERE OrderID LIKE '%" . $search .  "%' OR Customer LIKE '%" . $search ."%' OR Address LIKE '%" . $search ."%' OR City LIKE '%" . $search ."%' OR State LIKE '%" . $search ."%' OR ZipCode LIKE '%" . $search ."%' OR Telephone LIKE '%" . $search ."%' OR ServiceCategory LIKE '%" . $search ."%' OR DateCall LIKE '%" . $search ."%' OR WStatus LIKE '%" . $search ."%'";
  
 $result=mysql_query($sql);
{
if (mysql_num_rows($result)>1) {

echo "<table border='1'>  
<tr>
<th>Order ID</th>
<th>Customer</th>
<th>Address</th>
<th>City</th>
<th>State</th>
<th>Zip Code</th>
<th>Telephone</th>
<th>Service Category</th>
<th>Date of Call</th>
<th>Order Status</th>
</tr>";  
}
  while($row=mysql_fetch_array($result)){
       echo "<tr>";
  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['OrderID'] . "</a></td>";
  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['Customer'] . "</a></td>";
  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['Address'] . "</a></td>";
  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['City'] . "</a></td>"; 
  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['State'] . "</a></td>";
  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['ZipCode'] . "</a></td>";
  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['Telephone'] . "</a></td>";
  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['ServiceCategory'] . "</a></td>";
  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['DateCall'] . "</a></td>";
  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['WStatus'] . "</a></td>";  
  echo "</tr>";  
    
}
}
echo "</table>";
if(mysql_num_rows($result)==0){
  echo "<p><a href='aworkorder.html'> No record Found. Add Work Order</a>"; }
  }
  else{
  echo  "<p>Please enter a search query</p>";
  }
  }
  }
mysql_close($db);
?>

I think it's something simple but I figured I'd just ask for some help rather than continue bashing my head against a wall...Thanks

mysql php

2 Contributors
9 Replies
266 Views
22 Hours Discussion Span
Latest Post 13 Years Ago Latest Post by ptara1

jogesh_p 6 Junior Poster in Training

13 Years Ago

what problem you have??, i can't understand what you want ??
which kind of editor??

jogesh_p 6 Junior Poster in Training

13 Years Ago

Try Now >>

<?php
  if(isset($_POST['submit'])){
  if(isset($_GET['go'])){
  if(preg_match("/^[  a-zA-Z0-9]+/", $_POST['search'])){
  $search=$_POST['search'];
  
  $db=mysql_connect  ("connection info") or die ('I cannot connect to the database  because: ' . mysql_error());
 
  $mydb=mysql_select_db("database name");
  
  $sql="SELECT  OrderID, Customer, Address, City, State, ZipCode, Telephone, ServiceCategory, DateCall, WStatus FROM C WHERE OrderID LIKE '%" . $search .  "%' OR Customer LIKE '%" . $search ."%' OR Address LIKE '%" . $search ."%' OR City LIKE '%" . $search ."%' OR State LIKE '%" . $search ."%' OR ZipCode LIKE '%" . $search ."%' OR Telephone LIKE '%" . $search ."%' OR ServiceCategory LIKE '%" . $search ."%' OR DateCall LIKE '%" . $search ."%' OR WStatus LIKE '%" . $search ."%'";
  
 $result=mysql_query($sql);
//{
	if (mysql_num_rows($result)>1) {

	echo "<table border='1'>  
	<tr>
	<th>Order ID</th>
	<th>Customer</th>
	<th>Address</th>
	<th>City</th>
	<th>State</th>
	<th>Zip Code</th>
	<th>Telephone</th>
	<th>Service Category</th>
	<th>Date of Call</th>
	<th>Order Status</th>
	</tr>";  
	//}
		  while($row=mysql_fetch_array($result)){
			   echo "<tr>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['OrderID'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['Customer'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['Address'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['City'] . "</a></td>"; 
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['State'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['ZipCode'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['Telephone'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['ServiceCategory'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['DateCall'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['WStatus'] . "</a></td>";  
				  echo "</tr>";  
			
		}

		echo "</table>";
  }
//}

	if(mysql_num_rows($result)==0){
	  echo "<p><a href='aworkorder.html'> No record Found. Add Work Order</a>"; }
	  }
	  else{
	  echo  "<p>Please enter a search query</p>";
	  }
  }
  }
mysql_close($db);
?>

jogesh_p 6 Junior Poster in Training

13 Years Ago

if your problem get solved then let me now?? and Use Edit Plus editor,,
and do some necessary settings like match braces etc..

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

ptara1 0 Junior Poster in Training · Answer 1 · 2011-02-25T10:18:42+00:00

The table is not printing. The result is just displayed as one long hyperlink.

An editor that looks for minor problems like if you have a { but no }.

what problem you have??, i can't understand what you want ??
which kind of editor??

ptara1 0 Junior Poster in Training · Answer 2 · 2011-02-25T10:45:54+00:00

that didn't work but I'll continue checking. I know it's something simple

if your problem get solved then let me now?? and Use Edit Plus editor,,
and do some necessary settings like match braces etc..

jogesh_p 6 Junior Poster in Training · Answer 3 · 2011-02-25T10:51:56+00:00

try this and i think you need a best editor, cause you mismatched the parentheses braces

<?php
  if(isset($_POST['submit'])){
  if(isset($_GET['go'])){
  if(preg_match("/^[  a-zA-Z0-9]+/", $_POST['search'])){
  $search=$_POST['search'];
  
  $db=mysql_connect  ("connection info") or die ('I cannot connect to the database  because: ' . mysql_error());
 
  $mydb=mysql_select_db("database name");
  
  $sql="SELECT  OrderID, Customer, Address, City, State, ZipCode, Telephone, ServiceCategory, DateCall, WStatus FROM C WHERE OrderID LIKE '%" . $search .  "%' OR Customer LIKE '%" . $search ."%' OR Address LIKE '%" . $search ."%' OR City LIKE '%" . $search ."%' OR State LIKE '%" . $search ."%' OR ZipCode LIKE '%" . $search ."%' OR Telephone LIKE '%" . $search ."%' OR ServiceCategory LIKE '%" . $search ."%' OR DateCall LIKE '%" . $search ."%' OR WStatus LIKE '%" . $search ."%'";
  
 $result=mysql_query($sql);
//{
	if (mysql_num_rows($result)>1) {

	echo "<table border='1'>  
	<tr>
	<th>Order ID</th>
	<th>Customer</th>
	<th>Address</th>
	<th>City</th>
	<th>State</th>
	<th>Zip Code</th>
	<th>Telephone</th>
	<th>Service Category</th>
	<th>Date of Call</th>
	<th>Order Status</th>
	</tr>";  
	//}
		  while($row=mysql_fetch_array($result)){
			   echo "<tr>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['OrderID'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['Customer'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['Address'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['City'] . "</a></td>"; 
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['State'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['ZipCode'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['Telephone'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['ServiceCategory'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['DateCall'] . "</a></td>";
				  echo "<td><a href='http://websitename.com/admin/workorder/link.php?OrderID=" . $row['OrderID'] . "'>" . $row['WStatus'] . "</a></td>";  
				  echo "</tr>";  
			
		}

		echo "</table>";
  }
else
  {
	echo "<p><a href='aworkorder.html'> No record Found. Add Work Order</a>";
  }
//}
/*
	if(mysql_num_rows($result)==0){
	  echo "<p><a href='aworkorder.html'> No record Found. Add Work Order</a>"; }
	  //}
	  else{
	  echo  "<p>Please enter a search query</p>";
	  }
	  */
  }
  }
mysql_close($db);
?>

jogesh_p 6 Junior Poster in Training · Answer 4 · 2011-02-25T10:54:27+00:00

and let me know quickly if you not found solved>> :)

jogesh_p 6 Junior Poster in Training · Answer 5 · 2011-02-25T11:07:12+00:00

jogesh_p 6 Junior Poster in Training

13 Years Ago

mark solved if you find.

ptara1 0 Junior Poster in Training · Answer 6 · 2011-02-26T02:14:39+00:00

Thanks for your help but the solution did not have to do with brackets. The problem was with the if statement at this:

if (mysql_num_rows($result)>1)

it should be

if (mysql_num_rows($result)>0)

Do I get points for solving my own thread? LOL. But seriously thanks for your help!

mark solved if you find.