0

So i have this script, instead of having the output as what is in th script below, i would like to have it in a table i have had a couple of gos at this and failed......MISERABLY!!!. Could anyone help me out with an example. ps there are more fields to add but once i have an example i coulf figure it out from that maybe?<i have left out the top of the script for obviuos reasons> Thanx everydude!!
---------------------------------------------------------------------------------------

echo("<li>Can't connect to $HOST as $USER");
echo("<li>mysql Error: ".mysql_error());
die;
}

// select database
if (!mysql_select_db($DATABASE,$conn)) {
echo("<li>We were unable to select database $DATABASE");
die;
}

// if everything successful create query
// this selects all rows where the type is the one you chose in the dropdown
// * means that it will select all columns, ie name and type as i said above
echo "<table>";
$sql_query = "SELECT * FROM base_data WHERE ParishName LIKE '$chooser'";

// get the data from the database
$result = mysql_query($sql_query,$conn) or die('Invalid query: ' . mysql_error());

// output data
while ($details = mysql_fetch_array($result, MYSQL_ASSOC)) {
// print out the name
echo('Parish: '.$details['ParishName'].' - ');
// print out the type
echo('Owner Occupier Household: '.$details['OwnerOccupierHousehold'].'<br>');
}

// close mysql connection
mysql_close($conn);

}

?>
3
Contributors
7
Replies
8
Views
8 Years
Discussion Span
Last Post by Devendar Singh
0

There is a "table" started already and I think it doesn't belong...

// if everything successful create query
// this selects all rows where the type is the one you chose in the dropdown
// * means that it will select all columns, ie name and type as i said above
echo "<table>"; //<----------------------------------DELETE!!!
$sql_query = "SELECT * FROM base_data WHERE ParishName LIKE '$chooser'";

Hope this helps:

<?

/*Single result per table*/
// output data
while ($details = mysql_fetch_array($result, MYSQL_ASSOC)) {
	//start table
	echo "<table>";
	
	//start row and column
	echo "<tr><td>";
		//print out name
		echo('Parish: '.$details['ParishName'].' - ');
	//end column and row
	echo "</td></tr>";
	
	//start row and column
	echo "<tr><td>";
		// print out the type
		echo('Owner Occupier Household: '.$details['OwnerOccupierHousehold'].'<br>');
	//end column and row
	echo "</td></tr>";
	
	//end table
	echo "</table>";
}

/************************************************************/

/*Multple results per table(each in a row)*/
	
//start table
echo "<table>";

// output data
while ($details = mysql_fetch_array($result, MYSQL_ASSOC)) {
	
	//start row and column
	echo "<tr><td>";
		//print out name
		echo('Parish: '.$details['ParishName'].' - ');
	//end column and start new column
	echo "</td><td>";
		// print out the type
		echo('Owner Occupier Household: '.$details['OwnerOccupierHousehold'].'<br>');
	//end column and row
	echo "</td></tr>";
}

//end table
echo "</table>";
?>
0
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<form action="scdc.php" method="post" name="chooser">
  <label>Select Parish </label>     
  <select name="chooser" id="chooser">
    <option value="Abington Pigotts">Abington Pigotts</option>
    <option value="Arrington">Arrington</option>

    <option value="Barbraham">Barbraham</option>
    <option value="Balsam">Balsam</option>
    <option value="Bar Hill">Bar Hill</option>
    <option value="Barrington">Barrington</option>
    <option value="Barton">Barton</option>
    <option value="Bassinbourn-Cum-Kneesworth">Bassingbourn-Cum-Kneesworth</option>

    <option value="Bourne">Bourne</option>
    <option value="Boxorth">Boxworth</option>
    <option value="Caldecote">Caldecote</option>
    <option value="Carlton">Carlton</option>
    <option value="Castle Camps">Castle Camps</option>
    <option value="Caxton">Caxton</option>

    <option value="Comberton">Comberton</option>
    <option value="Conington">Conington</option>
    <option value="Coton">Coton</option>
    <option value="Cottenham">Cottenham</option>
    <option value="Croxton">Croxton</option>
    <option value="Croydon">Croydon</option>

    <option value="Dry Draton">Dry Draton</option>
    <option value="Duxford">Duxford</option>
    <option value="Elsworth">Elsworth</option>
    <option value="Eltisley">Eltisley</option>
    <option value="Fen Ditton">Fen Ditton</option>
    <option value="Fen Drayton">Fen Drayton</option>

    <option value="Fowlmere">Fowlmere</option>
    <option value="Foxton">Foxton</option>
    <option value="Fulbourn">Fulbourn</option>
    <option value="Gamlingay">Gamlingay</option>
    <option value="Girton">Girton</option>
    <option value="Grantchester">Grantchester</option>

    <option value="Graveley">Graveley</option>
    <option value="Great Abinton">Great Abington</option>
    <option value="Great Eversden">Great Eversden</option>
    <option value="Great Shelford">Great Shelford</option>
    <option value="Great Wilbraham">Great Wilbraham</option>
    <option value="Guilden Morden">Guilden Morden</option>

    <option value="Hardwick">Hardwick</option>
    <option value="Harlton">Harlton</option>
    <option value="Harston">Harston</option>
    <option value="Haslingfield">Haslingfield</option>
    <option value="Hatley">Hatley</option>
    <option value="Hauxton">Hauxton</option>

    <option value="Heydon">Heydon</option>
    <option value="Hildersham">Hildersham</option>
    <option value="Hinxton">Hinxton</option>
    <option value="Histon">Histon</option>
    <option value="Horningsea">Horningsea</option>
    <option value="Horseheath">Horseheath</option>

    <option value="Ickleton">Ickleton</option>
    <option value="Impington">Impington</option>
    <option value="Kingston">Kingston</option>
    <option value="Landbeach">Landbeach</option>
    <option value="Linton">Linton</option>
    <option value="Litlington">Litlington</option>

    <option value="Little Abington">Little Abington</option>
    <option value="Little Chishill">Little Chishill</option>
    <option value="Little Eversden">Little Eversden</option>
    <option value="Little Gransden">Little Gransden</option>
    <option value="Little Shelford">Little Shelford</option>
    <option value="Little Wilbraham &amp; Six Mile Bottom">Little Wilbraham &amp; Six Mile Bottom</option>

    <option value="Lolworth">Lolworth</option>
    <option value="Longstanton">Longstanton</option>
    <option value="Longstowe">Longstowe</option>
    <option value="Madingley">Madingley</option>
    <option value="Melbourne">Melbourne</option>
    <option value="Meldreth">Meldreth</option>

    <option value="Milton">Milton</option>
    <option value="Newton">Newton</option>
    <option value="Oakington">Oakington</option>
    <option value="Orwell">Orwell</option>
    <option value="Over">Over</option>
    <option value="Pampisford">Pampisford</option>

    <option value="Papwoerth Everard">Papworth Everard</option>
    <option value="Rampton">Rampton</option>
    <option value="Sawston">Sawston</option>
    <option value="Shepreth">Shepreth</option>
    <option value="Shingay-Cum-Wendy">Shingay-Cum-Wendy</option>
    <option value="Shudy Camps">Shudy Camps</option>

    <option value="Stapleford">Stapleford</option>
    <option value="Steeple Morden">Steeple Morden</option>
    <option value="Swavesey">Swavesey</option>
    <option value="Tadlow">Tadlow</option>
    <option value="Teversham">Teversham</option>
    <option value="Thriplow">Thriplow</option>

    <option value="Toft">Toft</option>
    <option value="Waterbeach">Waterbeach</option>
    <option value="Westwick">Westwick</option>
    <option value="West Wickham">West Wickham</option>
    <option value="West Wratting">West Wratting</option>
    <option value="Weston Colville">Weston Colville</option>

    <option value="Whaddon">Whaddon</option>
    <option value="Whittlesford">Whittlesford</option>
    <option value="Willingham">Willingham</option>
    <option value="Wimpole">Wimpole</option>
  </select>
  <input type="Submit" name="select" value="select"> 
</form>


<?php

// get variable after selecting something from the dropdown with name 'chooser'
$select = $_POST['select'];

// if something has been chosen
if (!empty($select)) {

// get the chosen value
$chooser = $_POST['chooser'];

// select the type from the database
// database connection details (change to whatever you need)
$HOST = 'localhost';
$DATABASE = '*****';
$USER = '*****';
$PASSWORD = '******';

// connect to database
if(!$conn=mysql_connect('localhost','*****','*****')) {
echo("<li>Can't connect to $HOST as $USER");
echo("<li>mysql Error: ".mysql_error());
die;
}

// select database
if (!mysql_select_db($DATABASE,$conn)) {
echo("<li>We were unable to select database $DATABASE");
die;
}

// if everything successful create query
// this selects all rows where the type is the one you chose in the dropdown
// * means that it will select all columns, ie name and type as i said above
$sql_query = "SELECT * FROM base_data WHERE ParishName LIKE '$chooser'";

// get the data from the database
$result = mysql_query($sql_query,$conn) or die('Invalid query: ' . mysql_error());

/*Multple results per table(each in a row)*/
//start table
echo "<table>";
// output data
while ($details = mysql_fetch_array($result, MYSQL_ASSOC)) {
//start row and column
echo "<tr><td>";
//print out name
echo('Parish: '.$details['ParishName'].' - ');
//end column and start new column
echo "</td><td>";
// print out the type
echo('Owner Occupier Household: '.$details['OwnerOccupierHousehold'].'<br>');
//end column and row
echo "</td></tr>";
//end table
}
echo "</table>";
?>

There you go keep looking at cant find it cause myresearch told me the same thing about the curly brackets pehaps it comes with experience.

0

you need an extra curly bracket at the bottom because this if (!empty($select)) { is still open

0

So i have this script, instead of having the output as what is in th script below, i would like to have it in a table i have had a couple of gos at this and failed......MISERABLY!!!. Could anyone help me out with an example. ps there are more fields to add but once i have an example i coulf figure it out from that maybe?<i have left out the top of the script for obviuos reasons> Thanx everydude!!
---------------------------------------------------------------------------------------
echo("<li>Can't connect to $HOST as $USER");
echo("<li>mysql Error: ".mysql_error());
die;
}

// select database
if (!mysql_select_db($DATABASE,$conn)) {
echo("<li>We were unable to select database $DATABASE");
die;
}

// if everything successful create query
// this selects all rows where the type is the one you chose in the dropdown
// * means that it will select all columns, ie name and type as i said above
echo "<table>";
$sql_query = "SELECT * FROM base_data WHERE ParishName LIKE '$chooser'";

// get the data from the database
$result = mysql_query($sql_query,$conn) or die('Invalid query: ' . mysql_error());

// output data
while ($details = mysql_fetch_array($result, MYSQL_ASSOC)) {
// print out the name
echo('Parish: '.$details.' - ');
// print out the type
echo('Owner Occupier Household: '.$details.'<br>');
}

// close mysql connection
mysql_close($conn);

}

?>

yes u can easily create table in php, I am explaing it below with some sort of codes...

<?php
...
some sort of codes here
...
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table> <!--table with 2 rows and 2 coloumns save this file with index.php-->
<?php
...
some sort of codes here
...
?>
0
<?php
{

    {
		echo("<li>Can't connect to $HOST as $USER");
		echo("<li>mysql Error: ".mysql_error());
		die;
    }

	// select database
	if (!mysql_select_db($DATABASE,$conn)) 
	   {
		  echo("<li>We were unable to select database $DATABASE");
		  die;
	   }
	
	// if everything successful create query
	// this selects all rows where the type is the one you chose in the dropdown
	// * means that it will select all columns, ie name and type as i said above
		echo "<table>";
		$sql_query = "SELECT * FROM base_data WHERE ParishName LIKE '$chooser'";
	
	// get the data from the database
		$result = mysql_query($sql_query,$conn) or die('Invalid query: ' . mysql_error());
	
	// output data
	while ($details = mysql_fetch_array($result, MYSQL_ASSOC))
		 {
			// print out the name
			echo('Parish: '.$details['ParishName'].' - ');
			// print out the type
			echo('Owner Occupier Household: '.$details['OwnerOccupierHousehold'].'<br>');
		 }
	
	// close mysql connection
	mysql_close($conn);

}

?>
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.