I first posted this on the php-db list, but am not getting the proper results yet, so I am copying here, hopefully someone can help me figure this one out...
I have a form with a select list and a hidden field to save the selected item. On submit another page is loaded with a few fields to be filled in and submitted to a table. Using get I see the data is being passed from the first page to the second properly, and the second page sends its data properly. The hidden field from the first page is to be used by the second page as the name of the table in the query. I have a place where I echo the contents of the hidden field just to be sure it is correct, and that does indeed show what I expect. I then make the query statement point to the variable but it always responds that it cannot find the table. The table does exist, the variable does contain the appropriate table name, but is not being replaced by the name. What am I doing wrong? On Sat, 2002-08-03 at 06:05, Rich Hutchins wrote: > Try referencing the $listbox variable in you SQL statement like this: > > $sql = "insert into ".$listbox." > values(NULL,'$date','$exercise','$reps','$comments')"; > > I'm guessing that it might also work like this: > > $sql = "insert into '$listbox' > values(NULL,'$date','$exercise','$reps','$comments')"; > > I think your core problem is that the $listbox variable is not being > evaluated properly in the SQL statement. Once you solve that, you're good to > go. > > Hope this helps. > > Rich I tried both suggestions and neither are working. I am using the get format for the form so I can see what is being sent, and I am getting this: http://192.168.1.53/workout-absflexor.php?exerciselist=%24listbox&exercise=80 &reps=12&comments=&submit=Send+Data Notice that the $listbox variable is still not being sent. Notice the two echo statements both of which shows what's in that variable, and it displays the expected result (see code below). I am at a loss as to why the one in the sql insert statement is not working. If I replace the $listbox variable with the table name shown in the echo statement, a connection is made and the query is completed. -- Chip W www.wiegand.org [EMAIL PROTECTED] Below is the code for the first page -- <html> <head> <title></title> </head> <body> <div align="center"> <? $exercises=array("absflexor","absmachine","leglifts"); echo "<form action='workout-absflexor.php' method='get'>"; echo "<table width='70%' border='0' align='center'>"; echo "<tr><th align='center'><h2>Exercise Data Input</h2></th></tr>"; echo "<tr><th align='center'><select name='listbox'>"; echo "<option>$exercises[0]</option>"; echo "<option>$exercises[1]</option>"; echo "<option>$exercises[2]</option>"; echo "</select><br><br>"; echo "</th></tr></table>"; echo "<input type='hidden' name='exerciselist' value='$listbox'>"; echo "<input type='submit'>"; echo "</form>"; ?> </div> </body> </html> And below is the code for the second page (the form hidden field was later added, but still no good) (the echo statement at the bottom was later added to verify the variable) -- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> <html xmlns="http://www.w3.org/1999/xhtml";> <head> <title>Workout Data Entry Form</title> <style type="text/css"> body { background-color: aqua; } div.c1 {text-align: center} </style> </head> <body> <div class="c1"> <h2>Work-Out Data Entry Screen</h2> <form action="<? PHP_SELF ?>" method="get"> <input type='hidden' name='exerciselist' value='$listbox'> <table summary="" width="60%" border="1" align="center" bgcolor="green"> <tr> <th>Weight</th> <td align="left"><input type="text" name="exercise" maxlength="4"></td> </tr> <tr> <th>Reps</th> <td align="left"><input type="text" name="reps" maxlength="4"></td> </tr> <tr> <th>Comments</th> <td colspan="2"><textarea cols="50" rows="3" name="comments"> </textarea></td> </tr> <tr><td><? echo $listbox; ?></td></tr> </table> <br /> <input type="submit" name="submit" value="Send Data" /> <input type="reset" /> </form> </div> <? if(isset($submit)): $db = mysql_connect("localhost","root","carvin"); if(!$db) error_message(sql_error()); mysql_select_db("workout",$db) or die ("Ack! Where's the database?"); $date = date("m-d"); $sql = "insert into ".$listbox." values(NULL,'$date','$exercise','$reps','$comments')"; mysql_query($sql) or die ("Ack! No response when I queried the server!"); endif; echo $listbox; ?> </body> </html> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
