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: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] 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
> [EMAIL PROTECTED]
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

Reply via email to