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