Re: [PHP-DB] Error? new set of eyes...

2002-05-28 Thread Ed Gorski
Why don't you try this instead: while(list($id, $2d, $3d, $web, $prog, $tut, $proj)=mysql_fetch_array($portfolio)) { do whatever.. } the list construct only works with numerical arrays and it might not like the $section array (doesn't it get stored as number indicies AND column names?

Re: [PHP-DB] creating errors

2002-05-28 Thread Ed Gorski
try just: $sql = "INSERT INTO $table_name (f_name,l_name,email_addy,un,pw) VALUES ('$f_name','$l_name','$email_addy','$un', 'PASSWORD('$pw')'"; ed At 09:55 AM 5/28/2002 -0600, Jas wrote: >I am trying to add an insert into a table and set one of the fields to a >password hash, however I am recie

Re: [PHP-DB] variables gone?

2002-05-29 Thread Ed Gorski
In php.ini you need to turn register_globals on..you also might want to start using the $_GET, $_POST, $_SESSION global arrays ed At 02:49 PM 5/29/2002 +0100, Rob Fraser wrote: >Dear All, >I am probably doing something silly but I don't know what (story of my >life). I have just upgraded to

Re: [PHP-DB] dropping one word from column entries

2002-05-29 Thread Ed Gorski
use: $name="Mouse Housing Products"; $name=str_replace("Products","",$name); also the RTFM() function works too ed At 11:06 AM 5/29/2002 -0500, Jen Swofford wrote: >I'm having a problem with this and suppose I'm looking for a handout. :| > >I am displaying names of product categories. The na

RE: [PHP-DB] dropping one word from column entries

2002-05-30 Thread Ed Gorski
there are a number of >substring-style things available, string position etc. > >HTH > >Beau > >// -Original Message- >// From: Ed Gorski [mailto:[EMAIL PROTECTED]] >// Sent: Thursday, 30 May 2002 12:09 AM >// To: Jen Swofford; php-db@lists. php. net >// Subjec

Re: [PHP-DB] mysql exclusion in php

2002-05-30 Thread Ed Gorski
You need to parse the string and PHP and generate the appropriate query based on that parsing... ed At 09:22 PM 5/29/2002 -0700, Chris Payne wrote: >Hi there everyone, > >How can I do a search which excludes certain words if they put a - in the >search string? I can do a search easily, but if

Re[2]: [PHP-DB] how to pull array out?

2002-05-30 Thread Ed Gorski
Well put Julie ed At 10:39 AM 5/30/2002 -0700, Julie Meloni wrote: >Jas (and anyone else) - > >With all due respect, you're acting like a troll. Posting a question, >getting MANY correct answers, then reposting the question and bitching >about not understanding the answers, well, that's tro

RE: Re[2]: [PHP-DB] how to pull array out?

2002-05-30 Thread Ed Gorski
People use to suppress errors / warning messagesI know I use it a lot with obdc and SQL SERVER procedures... ed At 02:32 PM 5/30/2002 -0400, Leotta, Natalie (NCI/IMS) wrote: > From what I've seen on the PHP.net site, it doesn't look like people use the >@ in @mysql_query, and I know that I