Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

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?

$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'];
}
share|improve this question

2 Answers

up vote 6 down vote accepted

try this instead of reset

mysql_data_seek($note_content, 0);

reset works for arrays

share|improve this answer
up vote 1 down vote

Try to load data in array and then use it as you whant

$records = array();
while($r = mysql_fetch_array($note_content)) {
    $records[] = $r;
}
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.