[Jaslynne]

Hello All, I've been taking a PHP class for the past 7 weeks and are getting a little hard. This is the first time I have ever messed with PHP and i just don't seem to get it. I have the following assignment:

-Name a script solution09.php
-Wtihin the script construct a SELECT statement which will query the "expenses" table for all the purchases made.
-Process the resulting recordset with a while loop which will create a separate line for each expense.
-On each line display the category, date, and amount of expenses.
-Create an HTML form , provide the visitor with an input box so they may use it to enter an expenses ategory (THIS IS DONE)
-Modify the schript so that it retrieves the value entered by the visitor
-Modify the SELECT statement created within the script so thatit includes a WHERE clause which will test to make sure that the category column is equal to the valueentered by the visitor.

Now, I think I got the script pretty much done EXCEPT for hte last two steps. I don't understand what im supposed to do or where Im supporsed to start. Any help is greatly appreciated

[Jaslynne]

sorry i forgot to post my script:

<?php
$connection=mysql_connect ("localhost", "spike", "9sj7En4");
if (!$connection)
{
die  ('Could not Connect: '. mysql_error());
}
mysql_select_db ("My_DB", $connection) or die (mysql_error());
$result = mysql_query ("SELECT * FROM Expenses") or die (mysql_error());
echo "<table  border='2'>
<tr>
<th>Category</th>
<th>Date</th>
<th>Dollar Amount</th>
</tr>";
while ($row= mysql_fetch_array ($result))
{
echo  "<tr>";
echo  "<td>" .$row ['Category'] ."</td>" ;
echo  "<td>" .$row ['Date']  ."  </td>";
echo  "<td>" .$row ['Dollar Amount'] . "  </td>";
echo  "</tr>";
}
echo "</table>";
mysql_close ($connection);
?>

[angelg107]

PHP Code:

<?php
$connection=mysql_connect ("localhost", "spike", "9sj7En4");
if (!$connection)
{
die  ('Could not Connect: '. mysql_error());
}
mysql_select_db ("My_DB", $connection) or die (mysql_error());
if(!(isset($_POST['submit_button']))){
// they did not click the button
$result = mysql_query ("SELECT * FROM Expenses") or die (mysql_error());
echo "<table  border='2'>
<tr>
<th>Category</th>
<th>Date</th>
<th>Dollar Amount</th>
</tr>";
while ($row= mysql_fetch_array ($result))
{
echo  "<tr>";
echo  "<td>" .$row ['Category'] ."</td>" ;
echo  "<td>" .$row ['Date']  ."  </td>";
echo  "<td>" .$row ['Dollar Amount'] . "  </td>";
echo  "</tr>";
}
echo "</table>";
}else{
// the form was submitted
// retrieve all the values from the form here
}
mysql_close ($connection);
?>

Now, you only have to make sure the button name in the form
is 'submit_button' for example :

<form action="" method="post">
......
<input type="submit" value="GO" name="submit_button" />
</form>

Considering your new to PHP, I want to let you know using single-quotes instead
of double-quotes speeds up your script.

Regards.