So you just want to insert a bunch of words into the table if they aren't
there already? Why not make the column unique and just insert them. Ignore
the warnings about duplicates...
---John Holmes...
----- Original Message -----
From: "Zac Hillier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Analysis & Solutions"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 5:54 PM
Subject: Re: [PHP] row pointer
> John, Dan & All,
>
> Thanks for your response, perhaps if I tell you more of the story then
it'll
> make more sense. I'm afraid I seem to have an ability for asking cryptic
> questions.
>
> Below is the code I'm using, it is meant to check for a list of between 10
> and 50 words in a table then return the key of the words found, for the
> words not in the table they should be added to the table.
>
> It seems to work fine, but in a effort to make the code more efficient I
> realised that at present I'm walking through a lot of the recordset for
each
> keyword. But that the majority of the recordset would be in the same order
> as the keywords. So if I can add a little extra code that says if the next
> record in the recordset is not the word I'm trying to find then walk
through
> the recordset, if you reach the end then start at the beginning and go
> down-to the initial row. This should confirm that the word is not in the
> recordset and so needs to be added, but leave the recordset in the correct
> place to check the next word.
>
> However to do this I thought initialy I would need to identify the row the
> recordset was presently at. However now I understand I need to push the
> recordset into an array then use this array to loop through finding the
> key's and the words that need to be added. However saying it and coding it
> seem to be two completely different things, can anyone help me getting
> started? Hope this makes some sense? If you have any other comments on the
> code to improve it or good coding practice I would appreciate your
comments
> as I'm still new to this.
>
> Thanks
>
> Zac
>
> Code:
>
> #--create select statement for getting keywords from table
> $fndWrds = '';
> foreach($kywrd as $val) {
> $fndWrds .= "wrd = '$val' OR ";
> }
>
> #-- add test word to get a result regardless
> $fndWrds .= "wrd = 'test'";
>
> #-- get present keywords from db
> $dbKy = mysql_query("SELECT ky, wrd FROM ".$site_no."kywrdInd WHERE
> $fndWrds;");
>
> #--create kywrd index array for index to be used in update value list
> $indx = array();
>
> #--create update value lists to later add record into lookup table
> $vlst = '';
>
> foreach($kywrd as $key => $val) {
> $fnd = 0;
> While ($kyRw = mysql_fetch_array($dbKy)) {
> if($kyRw['wrd'] == $val) {
> $fnd = 1;
> $indx[$key] = $kyRw['ky'];
> break 1;
> }
> }
> #-- reset pointer of db array back to begining
> mysql_data_seek($dbKy, 0);
>
> #-- if not in db then add word to db then set index
> if($fnd == 0) {
> if(! mysql_query("INSERT INTO ".$site_no."kywrdInd (wrd) values
> ('".$val."');")) echo 'Word not added';
> $indx[$key] = mysql_insert_id();
> }
>
> #-- check to see that each word has an index value
> if($indx[$key]) {
> #--create value list for update into lookup table
> $vlst .= "($compID," . $indx[$key] . "," . $scr[$key] . "), ";
> } else {
> echo 'no index set for keyword, word = '.$val.' index = '.$key.'<br>';
> }
>
>
> ----- Original Message -----
> From: "John Holmes" <[EMAIL PROTECTED]>
> To: "'Zac Hillier'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, June 14, 2002 6:42 PM
> Subject: RE: [PHP] row pointer
>
>
> > Keep track of it yourself as you loop through the data. Maybe if you
> > explained what you need "overall" then we could suggest a method...
> >
> > ---John Holmes...
> >
> > > -----Original Message-----
> > > From: Zac Hillier [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, June 14, 2002 3:59 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: [PHP] row pointer
> > >
> > > Hi
> > >
> > > I'm looking for a php function that will return the position of the
> > > pointer
> > > in a mysql recordset.
> > >
> > > I found mysql_data_seek, but this appears to only move the pointer, I
> > need
> > > to get the equivalent row number for the pointer position before
> > moving
> > > it,
> > > then return to the same position.
> > >
> > > Can anyone help?
> > >
> > > Thanks
> > >
> > > Zac
> > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
