2
Hello guys, this is my first post here. I tried searching for the answer, but I found out pretty quickly that I wouldnt find the perfect answer. I am pretty new to programming, but Im taking a class in c-programming and I am also trying to learn php and mysql on the side.
What I have done successfully is:
Get a server with mysql and php.
Getting mysql working, adding the database and the table.
Retrieving the information from the table and inserting it into a dropdownmenu(code will follow)
What i want:
When an item in the dropdownmenu(dpm) is selected, the user gets forwarded to a new page, where the result is displayed. If the user wishes to make more choices from the dpm , he can click on a button forwarding him back to the dpm. When he returns to the dpm the choices he has made previously has disappeared. When he makes a new choice, the new choice is listed on the resultpage with his previous choices, sorted by date.
My thoughts:
I have been thinking of a solution, and fact of the mather is I copied a working code from a guide, because I am pretty fresh to php. I think that the results from his choices in the dpm needs to be added to a new table in the database, and if i could get that to work, there wouldnt be any problems. :)
The code:
<?php
<form SRC="result.php">
/* this is something i have been trying, and it didnt work. It would solve my problem with retrieving the choice in the menu, but I still wouldnt know how to make the users previous choices disappear when he returns. */
print ("Please select your favorite clowns:");?><br><br><?
mysql_connect('xXxXx','xXxXxXx','veryxXxXxXx');
mysql_select_db('clowndatabase');
$sql = 'SELECT * FROM clowntable';
$res = mysql_query($sql) or die(mysql_error());
while ($rec = mysql_fetch_assoc($res)) $clowns[] = $rec;
//die('<pre>'.print_r($clowns,true));
echo '<SELECT name="dropdown">';
foreach ($clowns as $c)
{
if ($c['id'] == $_GET['id'])
echo "<OPTION value=\"{$c['id']}\" SELECTED>{$c['clowns']}</OPTION>\n";
else
echo "<OPTION value=\"{$c['id']}\">{$c['clowns']}</OPTION>\n";
}
echo '</SELECT>';
// </form>
?>
I hope I have made my post clean. And that my problem is easily understandable. Also, if anyone can tell me how to make a linechange in php, that would be great. Up to this point, I jump out of the php-tags and make a <br>. Its pretty ugly and not very good coding.
