Help putting mySQL DB in pulldown menu!

Anon

I have a script that I am trying run with PHP, that gets the contents of a database, and then arrange them in a pulldown menu. I then have that selected Name, for instance, and then I can choose between 2 Buttons. Edit and Delete.

Well.. Here is the code that I have so far:

<?php

include(connect.php);

$result = mysql_query('SELECT * FROM table');

echo "<h2>Current Database</h2>";
echo "<FORM ACTION=getlist.php TARGET="NEWWINDOW" METHOD=post>";

While ($row = mysql_fetch_array($result))
{
echo "<OPTION VALUE={$row['ID']}>{$row['FirstName']}{$row['LastName']}";
}

echo "</select>" .
         "<INPUT TYPE=submit VALUE="Go!">" .
          "</FORM>";
?>

When I take this and save it as getlist.php, it returns me with a :
Parse error: parse error, expecting ','' or';'' on line ... blah blah blah.

The line error is different no matter how I try and edit this, but it is geting stuck on echo "<FORM ACTION=getlist.php...", continually talking about the Parse Error (above).

I am trying to take this code (which works just fine for an html page) and make it work with my database information:

<FORM ACTION=getlist.php TARGET="NEWWINDOW" METHOD=post>
<SELECT NAME=location>
<OPTION VALUE="cactus">Cactus
<OPTION VALUE="iron">Iron
<OPTION VALUE="panther">Panther
<OPTION VALUE="sunrise">Sunrise
</SELECT>
<INPUT TYPE=submit VALUE="Go!">
</form>

I don't know what to do! Please help! Any, and ALL help will be much appriciated. Is this even possible? Help!!!

Thanks,
Danno~

fintan

If you look at this like a server:

echo "<FORM ACTION=getlist.php TARGET="NEWWINDOW" METHOD=post>";
c
it sees:
echo "stuff"NEWWINDOW"stuff";

the quotes inside are confusing it.

I use this:

echo '<FORM ACTION=getlist.php TARGET="NEWWINDOW" METHOD=post>';

for HTML, cos you tend to use the " a lot...

Hope this helps.

Fintan

horza

in the echo function you should not use "" . use ''.

Let me now if it still doesn't work.

Good luck!

gheorghiu

When you save the file as getlist.php it gets parsed as PHP code. The problem is that the string that echo takes as a parameter is ending at the first double-quote, after NEWWINDOW. Every function in PHP needs to end with ; and the parser can't find one.

The solution is to use different styles of quoting on the edge (beginning and ending) of the string and inside. For example you can write: echo "<FORM ACTION=getlist.php TARGET='NEWWINDOW' METHOD=post>"; or
echo '<FORM ACTION=getlist.php TARGET="NEWWINDOW" METHOD=post>';

If you realy need to use the same quotation inside you can escape it with backslash. So this is correct, too:
echo "<FORM ACTION=getlist.php TARGET=\"NEWWINDOW\" METHOD=post>";

You have other errors of this type in the code.
Good luck!

Anon

You all rock, very hard!

I appriciate everything you guys helped me with, and now it is working!

Hopefully, If I need any help with something else, you guys can be there!

Danno~ =D