Check your query variable $sql or $query
Eric On 3/26/07, Pete <[EMAIL PROTECTED]> wrote: > > This is probably dumb - but I keep getting the message > > PHP Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL > result resource in c:\Inetpub\wwwroot\personalphp\resultsbyname.php on line > 20 > > I have attached both programs to this email. > > Regards > > Pete > > I'm guessing it must either be the $record or the $result. > > I changed the $name back to $record. > > > > -----Original Message----- > From: Eric Haskins [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 27 March 2007 6:05 AM > To: CF-Talk > Subject: Re: OT - PHP Question > > Yeah I know I only use it for specific things such as an action or mode > which I reserve for my apps > > I use $_GET or $_POST for most. > > Eric > > > On 3/26/07, Kevin Aebig <[EMAIL PROTECTED]> wrote: > > > > I'd personally suggest staying away from the $_Request global. It can > make > > it difficult to pick up where the variables are actually coming from as > it > > checks the URL, Sessions and the POST variables for that particular > > variable. > > > > !k > > > > -----Original Message----- > > From: Eric Haskins [mailto:[EMAIL PROTECTED] > > Sent: Sunday, March 25, 2007 9:41 PM > > To: CF-Talk > > Subject: Re: OT - PHP Question > > > > Use > > > > $_REQUEST['rec_ID'] or $_GET['rec_ID'] / $_POST['rec_ID'] > > > > Like so > > > > $sql="SELECT * FROM personal WHERE ID = '" . $_REQUEST['rec_ID'] . "' "; > > > > Most servers or hosts like me turn of Register Globals. DOnt forget to > > use > > strip_tags() or other form of input sanitation > > > > Eric > > > > > > On 3/25/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > > > > > Pete wrote: > > > > Hi All just wondering if anyone knows of a similar PHP message > board. > > > > > > http://nl2.php.net/support.php > > > > > > > > > > And the second one (which should display the result however I keep > > > getting > > > > an error message when I have $rec_ID below. It says : > > > > > > > > Sorry there is no information > > > > Back PHP Notice: Undefined variable: rec_ID in > > > > c:\Inetpub\wwwroot\personalphp\see_rec.php on line 8 > > > > > > > > > http://nl2.php.net/manual/en/reserved.variables.php#reserved.variables.get > > > > > > Jochem > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
