> Why'd you use it in the first place? Where does $row_rsID['userID'] get > set? Why is it in your script if you don't know where it is set and what > it is set to? It was generated by Dreamweaver, had it not been automatically generated code we wouldn't be having this conversation. See, I'm not in the habit of coding something that I don't know all the particulars of. I'm funny that way. Like I stated in a previous post I know I'm going to get razzed for using Dreamweaver, so I guess I'll just have to take my lumps and get over it. However, $row_rsID['userID'] is what should be the retrieval of the value of the field 'userID', from the connection rsID. The $row_rsID should have a value of the query of the database for the userID, (a unique value) that corresponds to the input values that the form is sending to the database. If I'm not mistaken it is being set with; $query_rsID = "SELECT * FROM `user`"; $rsID = mysql_query($query_rsID, $connHoganMain) or die(mysql_error()); $row_rsID = mysql_fetch_assoc($rsID); $totalRows_rsID = mysql_num_rows($rsID); I'm guessing that since I didn't declare 'userID' in the switch statement it isn't being recognized as an appropriate index. Thanks for the breakout on the arrays. alex > -----Original Message----- > From: Peter Beckman [mailto:beckman@purplecow.com] > Sent: Monday, October 28, 2002 10:20 AM > To: alex hogan > Cc: php-db@lists.php.net > Subject: RE: PHP/MySQL and passing url params > > Why'd you use it in the first place? Where does $row_rsID['userID'] get > set? Why is it in your script if you don't know where it is set and what > it is set to? > > You set it like this: > > $row_rsID['userID'] = "whatever you want here, probably an int like '0'"; > > Several ways to define arrays: > > $array = array(); // set empty array > > $hash = array("stuff"=>"foo"); // a hash effectively > > $array = array(); > array_push($array, "stuff to push onto the array"); > > $array[] = "foo"; // same as "array_push" > > $array[37] = "foo"; // set array index 37 to foo. > > $array['stuff'] = "foo"; // set "hash" (array using words) stuff to foo > > $array[0][0][stuff] = "foo"; //multidimensional array. > > $array[0][1][stuff] = array("stuff"=>"foo"); > > Peter > > On Mon, 28 Oct 2002, alex hogan wrote: > > > How do I set $row_rsID['userID']? > > > > Do I use (isset($row_rsID['userID']); or something similar? > > > > Would I define an array, $my_array[]; and then look to populate the > > array dynamically? > > $my_array[0] = "something"; > > $my_array[1] = "something else"; > > > > I've probably missed something in the docs but I don't seem to find any > > hard fast rules on defining arrays or rediminsioning them. > > > > alex > > > > > -----Original Message----- > > > From: Peter Beckman [mailto:beckman@purplecow.com] > > > Sent: Sunday, October 27, 2002 9:29 PM > > > To: alex hogan > > > Cc: php-db@lists.php.net > > > Subject: RE: PHP/MySQL and passing url params > > > > > > The first question is is $row_rsID actually an array when you run the > > > script? > > > > > > If it is, is $row_rsID['userID'] set? > > > > > > If it isn't, is $row_rsID['userid'] set? > > > > > > If you want to set the variable $row_rsID statically do this: > > > > > > $row_rsID = array("userID"=>1); > > > > > > Where does $row_rsID get set? Does it set $row_rsID['userID']? > > > > > > Peter > > > > > > On Sun, 27 Oct 2002, alex hogan wrote: > > > > > > > Sorry..., my bad. Too wrapped up in the problem. > > > > > > > > > > > > > > > > Notice: Undefined variable: row_rsID in > > > > D:\web\hogana\demo\login\TMPbl2tw4o24u.php on line 48 > > > > > > > > Warning: Cannot add header information - headers already sent by > > (output > > > > started at D:\web\hogana\demo\login\TMPbl2tw4o24u.php:48) in > > > > D:\web\hogana\demo\login\TMPbl2tw4o24u.php on line 53 > > > > > > > > <?php require_once('../../Connections/connReg.php'); ?> > > > > <?php > > > > function GetSQLValueString($theValue, $theType, $theDefinedValue = > > "", > > > > $theNotDefinedValue = "") > > > > { > > > > $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : > > > > $theValue; > > > > > > > > switch ($theType) { > > > > case "text": > > > > $theValue = ($theValue != "") ? "'" . $theValue . "'" : > > "NULL"; > > > > break; > > > > case "long": > > > > case "int": > > > > $theValue = ($theValue != "") ? intval($theValue) : "NULL"; > > > > break; > > > > case "double": > > > > $theValue = ($theValue != "") ? "'" . doubleval($theValue) . > > "'" : > > > > "NULL"; > > > > break; > > > > case "date": > > > > $theValue = ($theValue != "") ? "'" . $theValue . "'" : > > "NULL"; > > > > break; > > > > case "defined": > > > > $theValue = ($theValue != "") ? $theDefinedValue : > > > > $theNotDefinedValue; > > > > break; > > > > } > > > > return $theValue; > > > > } > > > > > > > > $editFormAction = $HTTP_SERVER_VARS['PHP_SELF']; > > > > if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) { > > > > $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING']; > > > > } > > > > > > > > if ((isset($HTTP_POST_VARS["MM_insert"])) && > > > > ($HTTP_POST_VARS["MM_insert"] == "frmReg")) { > > > > $insertSQL = sprintf("INSERT INTO user (username, fname, lname, > > > > address, city, `state`, zip, phone, email) VALUES (%s, %s, %s, %s, > > %s, > > > > %s, %s, %s, %s)", > > > > > > GetSQLValueString($HTTP_POST_VARS['txtUserName'], > > > > "text"), > > > > > > GetSQLValueString($HTTP_POST_VARS['txtFName'], > > > > "text"), > > > > > > GetSQLValueString($HTTP_POST_VARS['txtLName'], > > > > "text"), > > > > > > GetSQLValueString($HTTP_POST_VARS['txtAddress'], > > > > "text"), > > > > GetSQLValueString($HTTP_POST_VARS['txtCity'], > > > > "text"), > > > > > > GetSQLValueString($HTTP_POST_VARS['txtState'], > > > > "text"), > > > > GetSQLValueString($HTTP_POST_VARS['txtZip'], > > > > "text"), > > > > > > GetSQLValueString($HTTP_POST_VARS['txtPhone'], > > > > "text"), > > > > > > GetSQLValueString($HTTP_POST_VARS['txtEmail'], > > > > "text")); > > > > > > > > mysql_select_db($database_connHoganMain, $connHoganMain); > > > > $Result1 = mysql_query($insertSQL, $connHoganMain) or > > > > die(mysql_error()); > > > > > > > > //Line 48 below - > > > > > > > > $insertGoTo = "thanks.php?id=" . $row_rsID['userID'] . ""; > > > > if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) { > > > > $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; > > > > $insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING']; > > > > } > > > > > > > > //Line 53 below - > > > > header(sprintf("Location: %s", $insertGoTo)); > > > > } > > > > > > > > mysql_select_db($database_connHoganMain, $connHoganMain); > > > > $query_rsID = "SELECT * FROM `user`"; > > > > $rsID = mysql_query($query_rsID, $connHoganMain) or > > die(mysql_error()); > > > > $row_rsID = mysql_fetch_assoc($rsID); > > > > $totalRows_rsID = mysql_num_rows($rsID); > > > > ?> > > > > <html> > > > > <head> > > > > <title>User Registration</title> > > > > <meta http-equiv="Content-Type" content="text/html; > > charset=iso-8859-1"> > > > > </head> > > > > > > > > <body> > > > > <h1><strong><font size="6" face="Arial, Helvetica, sans-serif">Enter > > > > Registration > > > > Information </font></strong></h1> > > > > <form action="<?php echo $editFormAction; ?>" method="POST" > > > > name="frmReg" id="frmReg"> > > > > <p><font size="2" face="Arial, Helvetica, sans-serif">You must > > fill in > > > > all the > > > > required fields.</font></p> > > > > <table width="51%" border="1"> > > > > <tr> > > > > <td width="29%" bgcolor="#CCCCCC"> <div > > > > align="right"><strong><font size="2" face="Arial, Helvetica, > > > > sans-serif">First > > > > Name: </font></strong></div></td> > > > > <td width="71%"><div align="left"> > > > > <input name="txtFName" type="text" id="txtFName" size="30" > > > > maxlength="28"> > > > > </div></td> > > > > </tr> > > > > <tr> > > > > <td bgcolor="#CCCCCC"> <div align="right"><strong><font > > size="2" > > > > face="Arial, Helvetica, sans-serif">Last > > > > Name: </font></strong></div></td> > > > > <td><div align="left"> > > > > <input name="txtLName" type="text" id="txtLName" size="30" > > > > maxlength="28"> > > > > </div></td> > > > > </tr> > > > > <tr> > > > > <td bgcolor="#CCCCCC"> <div align="right"><strong><font > > size="2" > > > > face="Arial, Helvetica, sans-serif">Address: > > > > </font></strong></div></td> > > > > <td><div align="left"> > > > > <input name="txtAddress" type="text" id="txtAddress" > > size="40" > > > > maxlength="38"> > > > > </div></td> > > > > </tr> > > > > <tr> > > > > <td bgcolor="#CCCCCC"> <div align="right"><strong><font > > size="2" > > > > face="Arial, Helvetica, sans-serif">City: > > > > </font></strong></div></td> > > > > <td><div align="left"> > > > > <input name="txtCity" type="text" id="txtCity" size="25" > > > > maxlength="23"> > > > > </div></td> > > > > </tr> > > > > <tr> > > > > <td bgcolor="#CCCCCC"> <div align="right"><strong><font > > size="2" > > > > face="Arial, Helvetica, sans-serif">State: > > > > </font></strong></div></td> > > > > <td><div align="left"> > > > > <input name="txtState" type="text" id="txtState" size="28" > > > > maxlength="26"> > > > > </div></td> > > > > </tr> > > > > <tr> > > > > <td bgcolor="#CCCCCC"> <div align="right"><strong><font > > size="2" > > > > face="Arial, Helvetica, sans-serif">Zip: > > > > </font></strong></div></td> > > > > <td><div align="left"> > > > > <input name="txtZip" type="text" id="txtZip" size="12" > > > > maxlength="10"> > > > > </div></td> > > > > </tr> > > > > <tr> > > > > <td bgcolor="#CCCCCC"> <div align="right"><strong><font > > size="2" > > > > face="Arial, Helvetica, sans-serif">Phone: > > > > </font></strong></div></td> > > > > <td><div align="left"> > > > > <input name="txtPhone" type="text" id="txtPhone" size="14" > > > > maxlength="12"> > > > > </div></td> > > > > </tr> > > > > <tr> > > > > <td bgcolor="#CCCCCC"><div align="right"><strong><font > > size="2" > > > > face="Arial, Helvetica, > > sans-serif">UserName:</font></strong></div></td> > > > > <td><input name="txtUserName" type="text" id="txtUserName" > > > > size="27" maxlength="25"></td> > > > > </tr> > > > > <tr> > > > > <td bgcolor="#CCCCCC"> <div align="right"><strong><font > > size="2" > > > > face="Arial, Helvetica, sans-serif">eMail > > > > Address: </font></strong></div></td> > > > > <td><div align="left"> > > > > <input name="txtEmail" type="text" id="txtEmail" size="40" > > > > maxlength="38"> > > > > </div></td> > > > > </tr> > > > > </table> > > > > <br> > > > > <input name="Submit" type="submit" id="Submit" value="Submit"> > > > > <input name="Reset" type="reset" id="Reset" value="Reset"> > > > > <input type="hidden" name="MM_insert" value="frmReg"> > > > > </form> > > > > <p><br> > > > > </p> > > > > <p><strong><font size="3" face="Arial, Helvetica, > > > > sans-serif"></font></strong> > > > > </p> > > > > > > > > <?php > > > > mysql_free_result($rsID); > > > > ?> > > > > > > > > > > > > > > > > -- > > > > PHP Database Mailing List (http://www.php.net/) > > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > ------------------------------------------------------------------------ > > --- > > > Peter Beckman Systems Engineer, Fairfax Cable Access > > Corporation > > > beckman@purplecow.com > > http://www.purplecow.com/ > > > > > ------------------------------------------------------------------------ > > --- > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > ------------------------------------------------------------------------ --- > Peter Beckman Systems Engineer, Fairfax Cable Access Corporation > beckman@purplecow.com http://www.purplecow.com/ > ------------------------------------------------------------------------ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
