Have you checked register_globals = on/off in your php.ini? If register_globals=off, then you must access your POST variables by:
$_POST['whatever']; and your get (the stuff you put at the end of your URL's): $_GET['whatever']; On Mon, 2003-06-30 at 15:48, Simon Chappell wrote: > Hi can anyone help me with this? > > I have been failing to get any forms working with PHP now I have run out of > ideas? Having bought 3 books the latest one being php & mysql for > dummies(which might be appropriate for me) I am still failing at this hurdle. > > the following script is a classic example taken straight out of the book, I > get round the $PHP_SELF problem ok but then all the script does is loop back > to itself? > > <!-- Program Name: mysql_send.php > Description: PHP program that sends an SQL query to the > MySQL server and displays the results. > --> > <html> > <head> > <title>SQL Query Sender</title> > </head> > <body> > <?php > $user="root"; > $host="localhost"; > $password=""; > > /* Section that executes query */ > if (@$form == "yes") > { > mysql_connect($host,$user,$password); > mysql_select_db($database); > $query = stripSlashes($query) ; > $result = mysql_query($query); > echo "Database Selected: <b>$database</b><br> > Query: <b>$query</b> > <h3>Results</h3> > <hr>"; > if ($result == 0) > echo("<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>"); > > elseif (@mysql_num_rows($result) == 0) > echo("<b>Query completed. No results returned.</b><br>"); > else > { > echo "<table border='1'> > <thead> > <tr>"; > for ($i = 0; $i < mysql_num_fields($result); $i++) > { > echo("<th>" . mysql_field_name($result,$i) . "</th>"); > } > echo " </tr> > </thead> > <tbody>"; > for ($i = 0; $i < mysql_num_rows($result); $i++) > { > echo "<tr>"; > $row = mysql_fetch_row($result); > for ($j = 0; $j < mysql_num_fields($result); $j++) > { > echo("<td>" . $row[$j] . "</td>"); > } > echo "</tr>"; > } > echo "</tbody> > </table>"; > } > echo "<hr><br> > <form action=$PHP_SELF method=post> > <input type=hidden name=query value=\"$query\"> > <input type=hidden name=database value=$database> > <input type=submit name=\"queryButton\" value=\"New Query\"> > <input type=submit name=\"queryButton\" value=\"Edit Query\"> > </form>"; > unset($form); > exit(); > } > > /* Section that requests user input of query */ > @$query = stripSlashes($query); > if (@$queryButton != "Edit Query") > { > $database = " "; > $query = " "; > } > ?> > > <form action=<?php echo $PHP_SELF ?>?form=yes method="post"> > <table> > <tr> > <td align="right"><b>Type in database name</b></td> > <td> > <input type=text name="database" value=<?php echo $database ?> > > </td> > </tr> > <tr> > <td align="right" valign="top"><b>Type in SQL query</b></td> > <td><textarea name="query" cols="60" rows="10"><?php echo $query > ?></textarea> > </td> > </tr> > <tr> > <td colspan="2" align="center"><input type="submit" value="Submit > Query"></td> > </tr> > </table> > </form> > > </body> > </html> > > Any ideas would be greatly appreciated as I am floundering badly! > > Simon > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php