arizonakid

October 4, 2012

I have read the forum guidelines and have several of Larry Ullmans books. The one I am currently using is the second edition of 'PHP andMYSQL For Dynamic Web'

I couldn't find the answer in this book so entered my question in this Forum. If I am wrong I can only apologise.

one of my programs is for a Single Fuchsia and the code is as follows:

<?php $dbh=mysql_connect ("localhost", "afs_tony", "suncity") or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ("afs_afs");

$id=$cname;

$query = "SELECT * FROM `reglist` where Cultivar = '$id'";

$result = mysql_query($query);

set_time_limit(0);

echo "<table border ='2'>";

echo "<table align = 'center'>";

echo " ";

echo "<tr><td>";

echo "Cultivar";

echo "</td><td>";

echo "Hybridizer";

echo "</td><td>";

echo "Year";

echo "</td><td>";

echo "Form";

echo "</td><td>";

echo "Growth";

echo "</td><td>";

echo "Corolla Color";

echo "</td><td>";

echo "Sepal Color";

echo "</td><td>";

echo "Tube Color";

echo "</td><td>";

echo "Parentage";

echo "</td><td>";

while ($row = mysql_fetch_array($result))

{

echo "</tr><td>";

echo $row['Cultivar'];

echo "</td><td>";

echo $row['Hybridizer'];

echo "</td><td>";

echo $row['Year'];

echo "</td><td>";

echo $row['Form'];

echo "</td><td>";

echo $row['Growth'];

echo "</td><td>";

echo $row['Corolla Color'];

echo "</td><td>";

echo $row['Sepal Color'];

echo "</td><td>";

echo $row['Tube Color'];

echo "</td><td>";

echo $row['Parentage'];

echo "</td><td>";

echo "<tr><td>";

echo "Click on Fuchsia Name to view image if available ";

?>

<?php

echo $row['Image'];

}

?>

</body></html>

Apologies for any confusion

kind regards

Tony Prodger

October 3, 2012

I have recently created a menu using php that gives several options for searching a database using mysql:-

1. display all records

2. display a particular record

3. display records beginning with a letter

this works correctly but if I select another option the first results still appear on my display and i cannot remember how to clear the display between searches.

Any advice please

kind regards

Tony

Sign In

arizonakid

Posts

Joined

Last visited

Content Type

Forums

Posts posted by arizonakid

Clearing Screen Display Of Data

Clearing Screen Display Of Data

Browse

Activity