Could be a simple form fillin ...

Gil

Here is my sample code in which I would like an example of how PHP will fill types of form objects. I would like to select an ID and have the entries returned from a table in a MySQL database.The quote id works fine, however I can not get the data that I looped through to show in any of the subsquent text input or textarea.
Thanks for the Help on this.
Gil

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/2000/REC-xhtml1-20000126/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Enter An Quote</title>
</head>
<body>
<?php

// ** add_Quote.php
// Script 6.3 **
// This page displays and handles a form for inserting records into the Quotes table.

// Include the MySQL information:
require_once ("../db.php");

echo 'Enter a Quote:<br />
<form action="script_6_3.php" method="post">
Quote ID: <select name="Quote_category_id">';

// Display the Quote categories:
$query_result = mysql_query ('SELECT * FROM tblquotes ORDER BY quotes_id LIMIT 1');
while ($row = mysql_fetch_array ($query_result, MYSQL_BOTH)) {
	echo "<option value=\"$row[0]\">$row[0]</option>\n";
}

// Tidy up (not required):
mysql_free_result($query_result);
mysql_close();

// Finish the form:
echo '</select><p />
Quote Author: <input type="text" name="Quote_amount" size="10" maxlength="10" /><p />
Quote: <textarea name="Quote_description" rows="5" cols="40"></textarea>	<p />
<input type="submit" name="submit" value="Submit!" />
</form>';

?>
</body>
</html>

bastien

// ** add_Quote.php
// Script 6.3 **
// This page displays and handles a form for inserting records into the Quotes table.

// Include the MySQL information:
require_once ("../db.php");
if (!$_POST['submit']){ //no data so show the request quote form
echo 'Enter a Quote:<br />
<form action="script_6_3.php" method="post">
Quote ID: <select name="Quote_category_id">';

// Display the Quote categories:
$query_result = mysql_query ('SELECT quotes_id FROM tblquotes ORDER BY quotes_id');
while ($rows = mysql_fetch_array ($query_result, MYSQL_BOTH)) {
echo "<option value=\"$rows[0]\">$rows[0]</option>\n";
}

echo '<input type="submit" name="submit" value="Submit!" />
</form>';

}else{ //form submitted and now request the quote

$result = mysql_query("select * from tblquotes where quote_id = $_POST['Quote_category_id']");
do while ($row=mysql_fetch_array($result)){

//included for simplicity and clarity but not really needed
$quote=$row['quote'];
$author=$row['author'];

// Finish the form:
echo '</select><p />
Quote Author: <input type="text" name="Quote_amount" size="10" maxlength="10" value=\'$author''\'/><p />
Quote: <textarea name="Quote_description" rows="5" cols="40">$quote</textarea> <p />

</form>';

}

// Tidy up (not required):
mysql_free_result($query_result);
mysql_close();

?>
</body>
</html>

hth

Gil

This is what I get. I am using php version 4.23.
Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /Library/WebServer/Documents/company_stuff/script_6_3.php on line 21