Re: How can I capture just the first record in a found set and edit it?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> Op 8 jan. 2015, om 19:00 heeft DealTek <dealtek@xxxxxxxxx> het volgende geschreven:
> 
> semi newbie
> 
> Hi all,
> 
> 1 - I do a query for multi records - and sort a certain way
> 
> 2 - then I need to capture/edit just the first found record in the result (no user interaction)
> 
> 
> 
> Q: using php - How do I set a variable to the first first found record in the result and do more with this record?
> 
> 
> 
> --
> Thanks,
> Dave - DealTek
> dealtek@xxxxxxxxx
> [db-15]
> 

Just do a fetch once. See the php manual for the fetch syntax for your specific DBMS.

Manipulate the data, and do an update query. See the manual for your specific DBMS.

That is really all there is to it

Sincerely,

Jasper Kips


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux