RE: [PHP-DB] query question

See http://www.php.net/manual/en/ref.array.php You will need a multi-dimensional array if your resultset has more than one field Regards Jon -- Jon Farmer Õ¿Õ¬ Systems Programmer, Entanet www.enta.net Tel +44 (0)1952 428969 Mob +44 (0)7968 524175 PGP Key available, send blank email to pgpkey@bctech.co.uk -----Original Message----- From: L Melville [mailto:lee.melville@lineone.net] Sent: 28 August 2001 14:54 To: php-db@lists.php.net Subject: Re: [PHP-DB] query question yeh this would work, how can I assign the rows to a new array? Is each row accessed as an element? "Jon Farmer" <jonfarmer@enta.net> wrote in message news:OOEBLEHOEDLBKALJPPJCAEOACAAA.jonfarmer@enta.net... > The only way i could think of doing this is to loop through $result and > assign the rows you want to keep to a new array. > > > > -- > Jon Farmer Õ¿Õ¬ > Systems Programmer, Entanet www.enta.net > Tel +44 (0)1952 428969 Mob +44 (0)7968 524175 > PGP Key available, send blank email to pgpkey@bctech.co.uk > > -----Original Message----- > From: L Melville [mailto:lee.melville@lineone.net] > Sent: 28 August 2001 14:41 > To: php-db@lists.php.net > Subject: Re: [PHP-DB] query question > > > I want to loop round $result fetching rows and if the current row is not > needed then removing it from $result, $result will then get used again but > with the said rows removed. I am trying to do this to avoid some major code > changes with what I am working with. > > > "Rick Emery" <remery@excel.com> wrote in message > > news:EAA093B474ABD311A71E00508B5FE08305C2C83A@adntex03.us.excel.com... > > What exactly are you trying to do? Do you want to delete certain rows > from > > $result? Or delete ALL rows, in which you'd use: > > mysql_return_result($result); > > > > If you want to delete certain rows, you can't. You just have to make your > > selection criteria more precise. Then, fetch row by row to weed out those > > rows you do not want. > > > > rick > > -----Original Message----- > > From: L Melville [mailto:lee.melville@lineone.net] > > Sent: Tuesday, August 28, 2001 8:21 AM > > To: php-db@lists.php.net > > Subject: [PHP-DB] query question > > > > > > Hi, > > > > If I run a query;- > > > > $result = mysql_query($query); > > > > is there a way of deleting rows from $result after this runs. Or does > > anyone have any idea of how $result is generally structured when > > mysql_query($query) is run. > > > > thanks > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net