Re: [PHP-DB] Select where

On Wed, 21 Mar 2001, boclair wrote: This is simple but I cannot see where I am going wrong I have a table members with one of the fields status, varchar(10) The values may be active or retired or deceased or null If I run the select SELECT * FROM members WHERE status = 'deceased';

Re: [PHP-DB] Select where

- Original Message - From: boclair [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 12:02 AM Subject: [PHP-DB] Select where This is simple but I cannot see where I am going wrong I have a table members with one of the fields status, varchar(10) The values

Re: [PHP-DB] Select where

Thanks, I only gave the mySQL but the php scripting is $deceased = mysql_query(SELECT * FROM members where status=\'deceased\'"); and later while ($myrow = mysql_fetch_row($deceased)) MySQL now says in relation to the *while* line Warning: Supplied argument is not a

[PHP-DB] SELECT * vs. SELECT field, field, field

A quick question, which executes faster ? Suppose i have a table with 6 fields and I need to use all of the info in the table, SELECT * FROM $table_name WHERE id = \"$id\" or SELECT field1, field2, field3, field4, field5, field6 FROM $table_name WHERE id = \"$id\" I understand that they do

[PHP-DB] SELECT problem

Hi-- What's wrong with this line of code? echo("SELECT onChange=\"window.location=\"$PHP_SELF?campus+=\"this.value\"\"\" NAME='campus'"); Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED]

[PHP-DB] SELECT problem (2)

Hi-- Sorry, I forgot to finish the previous e-mail: What's wrong with this line? echo("SELECT onChange=\"window.location=\"$PHP_SELF?campus+=\"this.value\"\"\" NAME='campus'"); I'm trying to RELOAD the current page with the new value of "$campus" after the user selects a campus from a

RE: [PHP-DB] SELECT problem (2)

You probably want this.options[this.selectedIndex].value -Original Message- From: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 2:36 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] SELECT problem (2) Hi-- Sorry, I forgot to finish the previous e

Re: [PHP-DB] select with parentID field into multidimensional array?

:49:13 +1100 (EST) From: Stephen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] select with parentID field into multidimensional array? Hi I have a table which is set out like this ID name parentID I "select * from table" into $result. I then wish to wa

Re: [PHP-DB] select with parentID field into multidimensional array?

page. If I work it out Ill be sure to post it :) On Sun, 21 Jan 2001 [EMAIL PROTECTED] wrote: Date: Sun, 21 Jan 2001 15:50:16 -0500 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] select with parentID field into multidimensional array? Hi, Maybe it would be better

Re: [PHP-DB] select with parentID field into multidimensional array?

PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] select with parentID field into multidimensional array? Hi, Maybe it would be better not to use a multidimentionnal array in a db. You should create to additionnal columns that stores the ParentID of the row. It's

<    1   2   3   4