anyone know how to put this in a while loop

[rickyj]

anyone got an idea how to complete the following while loop. I want to set a database column (LT_URL) to a sting ($ltURLarray),

but 1st i want to check if it already exist in the db, if it does exist, then I want to test the next sting exist in the db, if it doesnt set LT_URL to $ltURLarray on the i'th attempt.

 

$ltURLarray[0] = 'string0';
$ltURLarray[1] = 'string1'; //.......
$ltURLarray[100] = 'string100';

// some how put the follwing in a while loop while i<100:
i = 0;
URLdata = mysql_query("SELECT LT_URL FROM lt_Users WHERE LT_URL = '$ltURLarray[i]' LIMIT 1")or die(mysql_error()); 
if (!mysql_num_rows($URLdata)){
$ltURL =$ltURLa[0];
} 

[Yesideez]

<?php
  foreach ($ltURLarray as $ltURL) {
    $fetch=mysql_fetch_assoc(mysql_query("SELECT `LT_URL` FROM `lt_users` WHERE `LT_URL`='".$ltURL."'"));
    if (empty($fetch['LT_URL'])) {
      mysql_query("INSERT INTO `lt_users` (`LT_URL`) VALUES ('".$ltURL."')");
    }
  }
?>

 

Something like that I guess is what you're looking for.

[rickyj]

Thanks for the quick response

 

Will foreach not go through each one(regardles of result), I want to stop if the 1st is not found in the colum, or if not try second.... 

[Yesideez]

If one is found and you want to stop the foreach() loop then add this line as part of an else for the if() statement:

} else {
  break;
}

[rickyj]

dow! break... thats what i was looking for, just forgot, thanks

[rickyj]

I have something else that does the inserting, so the follwing code should work?

 

  foreach ($ltURLarray as $ltURL) {
    $fetch=mysql_fetch_assoc(mysql_query("SELECT `LT_URL` FROM `lt_users` WHERE `LT_URL`='".$ltURL."'"));
    if (empty($fetch['LT_URL'])) {
      break;
    }
  }

 

// so now $ltURL is set to  $ltURLarray (where ltURLarray is not found)

 

(sorry for me being a bit dumb and spelling it out in full), do you think this will work?

[rickyj]

the above didnt work, it just set it to the first one, regardles of it already being present in the database! but I used:

 

  foreach ($ltURLarray as $ltURL) {

    $fetch=(mysql_query("SELECT `LT_URL` FROM `lt_users` WHERE `LT_URL`='".$ltURL."'"));

    if (empty($fetch['LT_URL'])) {

      break;

    }

  }

 

why dont these posts merge