|
|
Posted by chrisollar on 01/05/07 20:28
sorry for me being such a newbie... but what is top post?
thanks,
chris
Paul Lautman wrote:
> chrisollar wrote:
> > Thanks for the help.
> > I checked it out and it worked great as you already knew.
> > I'm an industrial programmer turned web guy. The syntax always gets
> > me. Again, thanks for the assist.
> > chris
> >
> Also, please don't top post in the forum.
>
> > J.O. Aho wrote:
> >> chrisollar wrote:
> >>> I've got two files.
> >>> start.php and finish.php
> >>>
> >>> when I query the mysql database the combo box displays great. But
> >>> when I try to pass the information on to the next page I only get
> >>> the first word of the field if there are more than one words.
> >>> I'm sure that it's something to do with the white spaces. I'm
> >>> hoping to find some simple yet elegant help.
> >>>
> >>> Here's start.php
> >>>
> >>> <html>
> >>> <head>
> >>> <title>Radiator Part Number Search</title>
> >>> </head>
> >>> <body>
> >>> <h3>Start by selecting your Make and then clicking "Submit"</h3>
> >>>
> >>>
> >>> <?php
> >>> mysql_connect("localhost", "login", "password") or
> >>> die(mysql_error()); //echo "Connected to MySQL<br />";
> >>>
> >>> mysql_select_db("fotechtx_radiator") or die(mysql_error());
> >>> //echo "Connected to Radiator Database";
> >>>
> >>> $query="SELECT DISTINCT make FROM radiator ORDER BY make ASC";
> >>>
> >>>
> >>> $result = mysql_query ($query);
> >>> echo "<form name=form method=post action=finish.php>";
> >>>
> >>> echo "Make</br>";
> >>> echo "<select name=carmake value=''>Select Make</option>";
> >>> while($nt=mysql_fetch_array($result)){
> >>> echo "<option value=$nt[make]>[make]</option>";
> >>> //\"".$row["adres"]."\">,
> >>> }
> >>> echo "</select>";
> >>>
> >>> echo "<p> <input type=submit name=Submit value=Submit>";
> >>> echo "<input type=reset name=Reset value=Reset>
> >>> </p>";
> >>> echo "</form>";
> >>>
> >>>
> >>>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> </body>
> >>> </html>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> And here is finish.php:
> >>>
> >>> <html>
> >>> <head>
> >>> <title>Radiator Part Number Search</title>
> >>> </head>
> >>> <body>
> >>> <h3>Now Select your Model and press Submit</h3>
> >>>
> >>> <?php
> >>> // echo "<p>Make: " . $_POST['carmake']."</p>\n";
> >>> //echo "<p>listbox: " . $_POST['listbox'] . "</p>\n";
> >>> $make_value = $_POST["carmake"];
> >>> echo "$make_value";
> >>> //echo "$make_value ";
> >>> //foreach ($values as $a){
> >>> // echo $a;
> >>> //}
> >>> //echo "</p>\n";
> >>>>
> >>>
> >>> <?php
> >>> //echo "$make_value ";
> >>> mysql_connect("localhost", "login", "password") or
> >>> die(mysql_error()); //echo "Connected to MySQL<br />";
> >>>
> >>> mysql_select_db("fotechtx_radiator") or die(mysql_error());
> >>> //echo "Connected to Radiator Database";
> >>>
> >>> $query="SELECT DISTINCT HEADING FROM radiator WHERE MAKE=
> >>> '$make_value' ORDER BY HEADING";
> >>>
> >>> $result = mysql_query ($query);
> >>> echo "<form name=form method=post action=more.php>";
> >>>
> >>> echo "Make</br>";
> >>> echo "<select name=carmake value=''>Make Selected</option>";
> >>> echo "<option value=$make_value>$make_value</option>";
> >>> echo "</select>";
> >>>
> >>> echo "</br>";
> >>> echo "</br>";
> >>> echo "</br>";
> >>>
> >>> echo "Model</br>";
> >>> echo "<select name=carheading value=''>Select Model</option>";
> >>> while($nt=mysql_fetch_array($result)){
> >>> echo "<option value=$nt[HEADING]>$nt[HEADING]</option>";
> >>
> >> This has nothing to do with PHP, but bad HTML, you should always use
> >> quotes around HTML values
> >>
> >> echo "<select name=\"carmake\" value=\"\">Make Selected</option>";
> >> echo "<option value=\"$make_value\">$make_value</option>";
> >> echo "<select name=\"carheading\" value=\"\">Select Model</option>";
> >> echo "<option value=\"$nt[HEADING]\">$nt[HEADING]</option>";
> >> echo "<p> <input type=\"submit\" name=\"Submit\" value=\"Submit\">";
> >> echo "<input type=\"reset\" name=\"Reset\" value=\"Reset\">
> >>
> >>
> >> A whitespace is used in HTML to separate arguments
> >>
> >> example:
> >> <input type="text" name="something" value=Hello Big John>
> >> This makes the value to be 'Hello' and you will have two unknown
> >> arguments, 'Big' and 'John'
> >>
> >>
> >> <input type="text" name="something" value="Hello Big John">
> >> Here the value will be 'Hello Big John'.
> >>
> >> Why not use single quotes and don't have to use the backslash? There
> >> are browsers that have major problems with single quotes, even if
> >> single quotes are allowed in HTML.
> >>
> >> --
> >>
> >> //Aho
Navigation:
[Reply to this message]
|