+ Reply to Thread
Results 1 to 2 of 2

Thread: array reset

  1. #1

    array reset

    I want to print a list from a mysql database, but the first list item isn't printing because mysql_fetch_array is called twice. I tried reset but it didn't work. What should I do? I have been working on this code for hours and i hope you guys can help me with this.

    here is the code :
    Code:
    $current_goam = mysql_real_escape_string($current_goam);
    $current_content = mysql_real_escape_string($current_content);
    
    $note_content = mysql_query("select * from notes where title='$current_content' and goam='$current_goam' and user_id='$user_id'");
    
    $note = mysql_fetch_array( $note_content );
    
    if($note['type'] == 'list')
    {
        $note_type='list';      
        reset($note);
    
        print "<table>";
        while($note_info = mysql_fetch_array( $note_content ))
        {
            print "<tr><td>";
               echo $note_info['body'];
                print "</td>";
    
                echo "<td><input type='checkbox' name='complete_goal' value='".$note_info['note_id']."'></input></td>";         
             print "</tr>";
        }
        print "</table>";
    }   
    else{
        echo $note['body'];
    }

  2. #2
    Junior Member
    Join Date
    Jan 2012
    Posts
    30
    try this piece of code instead of reset :
    Code:
    mysql_data_seek($note_content, 0);

+ Reply to Thread

Tags for this Thread

Bookmarks

Posting Permissions

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