Re: [PHP-DB] Sending multiple items via a single form field
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hayri wrote: > can somebody tell me what the hell does mysql_fetch_assoc do ??? > > thx It fetches a row of a result as an associative array (hash), the same as mysql_fetch_array($retval,MYSQL_ASSOC). -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFD3jQXj60GAoLuoDkRApiYAJ9hX2U/hMQWHSZ8EXK06ish5ok+EQCfVJNL UY4uxvuPcxF5AaZjDIGUYOg= =9tyr -END PGP SIGNATURE- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Sending multiple items via a single form field
RTFM www.php.net/mysql-fetch-assoc bastien From: Hayri <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: Re: [PHP-DB] Sending multiple items via a single form field Date: Mon, 30 Jan 2006 12:07:32 +0100 can somebody tell me what the hell does mysql_fetch_assoc do ??? thx Micah Stevens schrieb: You could just seperate the data in the field's value with a delimeter like | or something you wouldn't see in the data, then explode() based on that? What kind of field are you using? Your explanation is very vague. On Monday 14 November 2005 12:40 pm, Chris Payne wrote: Hi there everyon, I have a set of form fields dynamically generated but each item must contain 2 pieces of data - the input from the field AND the id that the input represents from the DB. I had this info a while back but had a major HD crash and lost the info I had, how can I do this easily in PHP? Hopefully an easier to understand scenario: I have a form with - example - 5 items listed, each item from the DB and you select ONE item only out of the list, when you submit the form it sends the input from the field you select BUT I also need it to send an addition bit of info in the form of $id so that on the processing page, I can extract both the ID and the data entered from a single field. Obviously I can't use a hidden field for this so the data has to be tacked-on to the input field somehow? Any help would save my life :-) Chris -- 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
Re: [PHP-DB] Sending multiple items via a single form field
can somebody tell me what the hell does mysql_fetch_assoc do ??? thx Micah Stevens schrieb: You could just seperate the data in the field's value with a delimeter like | or something you wouldn't see in the data, then explode() based on that? What kind of field are you using? Your explanation is very vague. On Monday 14 November 2005 12:40 pm, Chris Payne wrote: Hi there everyon, I have a set of form fields dynamically generated but each item must contain 2 pieces of data - the input from the field AND the id that the input represents from the DB. I had this info a while back but had a major HD crash and lost the info I had, how can I do this easily in PHP? Hopefully an easier to understand scenario: I have a form with - example - 5 items listed, each item from the DB and you select ONE item only out of the list, when you submit the form it sends the input from the field you select BUT I also need it to send an addition bit of info in the form of $id so that on the processing page, I can extract both the ID and the data entered from a single field. Obviously I can't use a hidden field for this so the data has to be tacked-on to the input field somehow? Any help would save my life :-) Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Sending multiple items via a single form field
At 04:40 PM 11/14/2005, Chris Payne wrote:
Hi there everyon,
I have a set of form fields dynamically generated but each item must contain
2 pieces of data - the input from the field AND the id that the input
represents from the DB. I had this info a while back but had a major HD
crash and lost the info I had, how can I do this easily in PHP?
Hopefully an easier to understand scenario:
I have a form with - example - 5 items listed, each item from the DB and you
select ONE item only out of the list, when you submit the form it sends the
input from the field you select BUT I also need it to send an addition bit
of info in the form of $id so that on the processing page, I can extract
both the ID and the data entered from a single field. Obviously I can't use
a hidden field for this so the data has to be tacked-on to the input field
somehow?
Any help would save my life :-)
Chris
You mean like this:
In the display area of the script, using the ubiquitous while $myrow =
mysql_fetch_array($result), sub_key being the SUBscriber_KEY :
print( '');
// rest of record - name, etc., then repeat
and as I was using this for a bulk delete, up top in the processing section:
//
// Bulk Delete
//
if ($chkdelete && $bulkdelete){
foreach ($chkdelete as $value){
$sql = "delete from subscriber where sub_key = '$value'";
$result = mysql_query($sql);
}
echo "Selected Records deleted!";
}
HTH -Miles Thompson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Sending multiple items via a single form field
You could just seperate the data in the field's value with a delimeter like | or something you wouldn't see in the data, then explode() based on that? What kind of field are you using? Your explanation is very vague. On Monday 14 November 2005 12:40 pm, Chris Payne wrote: > Hi there everyon, > > > > I have a set of form fields dynamically generated but each item must > contain 2 pieces of data - the input from the field AND the id that the > input represents from the DB. I had this info a while back but had a major > HD crash and lost the info I had, how can I do this easily in PHP? > > > > Hopefully an easier to understand scenario: > > > > I have a form with - example - 5 items listed, each item from the DB and > you select ONE item only out of the list, when you submit the form it sends > the input from the field you select BUT I also need it to send an addition > bit of info in the form of $id so that on the processing page, I can > extract both the ID and the data entered from a single field. Obviously I > can't use a hidden field for this so the data has to be tacked-on to the > input field somehow? > > > > Any help would save my life :-) > > > > Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
