Hi Shimul,
Thanks for your reply.. please send me the full code... so that it will be
useful for me with explaination.
On 10/28/05, Shimul <[EMAIL PROTECTED]> wrote:
>
> as u dont have pk or unique key so there must some composite key by which
> u can detect them as duplicate key. right? if u can detect them as duplicate
> now u can delete them . there are lots of way to do this. i'm giving u a
> very simple solution. first find that occurance like this query
> first select all from that table like : SELECT * FROM table;
> loop start with mysql_fetch_array()
> {
> SELECT count(*) as cnt FROM table WHERE field='$rsField[field_name]'
> now after running this query check if its 0 or gather then 0
> if(countVariable > 1)
> {
> DELETE FROM table where field='$rsField[field_name]' LIMIT 1
> }
> }loop end
> -------------------------------------
> hope this will help u. i did this process with my own class and methods
> thats why i'm telling u just procvess not full code. ok? if u still have any
> question pls let me know
> shimul
>
> *kumar Devan <[EMAIL PROTECTED]>* wrote:
>
> Hi all,
> I am having one table in that there is no unique,primary key ...
> In that table there are dublicates entries of the rows, i need to delete
> the duplicate rows in that table and row will contain unique entries only..
> please let me know the solution to delete the dublicate rows.
> Thanks & Regards,
> Devan.
>
> ------------------------------
> Yahoo! FareChase - Search multiple travel sites in one
> click.<http://us.lrd.yahoo.com/_ylc=X3oDMTFqODRtdXQ4BF9TAzMyOTc1MDIEX3MDOTY2ODgxNjkEcG9zAzEEc2VjA21haWwtZm9vdGVyBHNsawNmYw--/SIG=110oav78o/**http%3a//farechase.yahoo.com/>
> ------------------------------
> YAHOO! GROUPS LINKS
>
>
> - Visit your group "php_king<http://groups.yahoo.com/group/php_king>"
> on the web.
> - To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]<[EMAIL PROTECTED]>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------
>
>
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/HKFolB/TM
--------------------------------------------------------------------~->
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
