Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    New to the CF scene
    Join Date
    Oct 2009
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How can we avoid repeating it.

    helo

    pleas help me.

    i have some question about this code.

    we have a program that it Make 4 Column and 10 row.(From the database as a random)

    Field id from table ads Including 1 to 99 (no repeat)

    but some of the data entered repeated.

    How can we avoid repeating it.

    For example,

    11-32-45-28
    56-12-11-99
    80-13-20-21
    ...

    Number 11 is repeated

    note:there isn't any repeated data in the Database( there is one id=11 in the Database)


    i will be glad if you answer to me.

    tanks.
    PHP Code:
    <?php
      
    include("config.php");

      
    mysql_connect($db_server$db_username$db_password);
      
    mysql_select_db($db_name);

      
    $query "SELECT COUNT(ID) FROM ads ";
      
    $result mysql_query($query);
      
    $row mysql_fetch_array($result);
      
    $adcnt $row[0];

      
    $query "SELECT * FROM ads ";
      
    $result mysql_query($query);
      
    $i 1;
      while ((
    $row mysql_fetch_array($result)))
        {
        
    $rows[$i] = $row;
        
    $i++;
        }

      
    $ids_arr     null;

        for (
    $i=1$i<=10$i++)
        {
        
    $ids      null;

        for (
    $j=1$j<=4$j++)
          {
          
    $cellno = ($i-1)*4+$j;

            
    srand((double)microtime()*1000000);
            
    $adno mt_rand(1, ($adcnt));
            
    $ids[$j]     = $rows[$adno]['ID'];
            }

          
    $ids_arr[$i]     = $ids;
        }
        print( 
    $ids_arr[1][1]);
        print(
    "-");
        print( 
    $ids_arr[1][2]);
        print(
    "-");
        print( 
    $ids_arr[1][3]);
        print(
    "-");
        print( 
    $ids_arr[1][4]);
        echo(
    "<br>");
        print( 
    $ids_arr[2][1]);
        print(
    "-");
        print( 
    $ids_arr[2][2]);
        print(
    "-");
        print( 
    $ids_arr[2][3]);
        print(
    "-");
        print( 
    $ids_arr[2][4]);
        echo(
    "<br>");
        print( 
    $ids_arr[3][1]);
        print(
    "-");
        print( 
    $ids_arr[3][2]);
        print(
    "-");
        print( 
    $ids_arr[3][3]);
        print(
    "-");
        print( 
    $ids_arr[3][4]);
        echo(
    "<br>");
        print( 
    $ids_arr[4][1]);
        print(
    "-");
        print( 
    $ids_arr[4][2]);
        print(
    "-");
        print( 
    $ids_arr[4][3]);
        print(
    "-");
        print( 
    $ids_arr[4][4]);
        echo(
    "<br>");
        print( 
    $ids_arr[5][1]);
        print(
    "-");
        print( 
    $ids_arr[5][2]);
        print(
    "-");
        print( 
    $ids_arr[5][3]);
        print(
    "-");
        print( 
    $ids_arr[5][4]);
        echo(
    "<br>");
        print( 
    $ids_arr[6][1]);
        print(
    "-");
        print( 
    $ids_arr[6][2]);
        print(
    "-");
        print( 
    $ids_arr[6][3]);
        print(
    "-");
        print( 
    $ids_arr[6][4]);


    ?>
    Last edited by sara01; 10-11-2009 at 09:43 AM.


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •