Professional Web Applications Themes

resetting mysql_fetch_array() - PHP Development

Is there a way to reset the pointer when iterating through records using mysql_fetch_array()? <?php connect .... $result = mysql_query("SELECT idno FROM mydata"); // i need the value from the 1st record here if ($row = mysql_fetch_array($result,MYSQL_NUM) { $somevar = $row[0]; } /// more code while ($i<10) { // i need it again here if ($row = mysql_fetch_array($result,MYSQL_NUM)) { //blah blah TIA, jrg...

  1. #1

    Default resetting mysql_fetch_array()

    Is there a way to reset the pointer when iterating through records using
    mysql_fetch_array()?

    <?php
    connect ....

    $result = mysql_query("SELECT idno FROM mydata");

    // i need the value from the 1st record here
    if ($row = mysql_fetch_array($result,MYSQL_NUM)
    {
    $somevar = $row[0];
    }

    /// more code

    while ($i<10)
    {
    // i need it again here
    if ($row = mysql_fetch_array($result,MYSQL_NUM))
    {
    //blah blah

    TIA,
    jrg


    jg Guest

  2. #2

    Default Re: resetting mysql_fetch_array()

    On Mon, 05 Apr 2004 19:17:47 GMT, "jg" <jrgnospam-weirdcat.com> wrote:
    >Is there a way to reset the pointer when iterating through records using
    >mysql_fetch_array()?
    Go to [url]www.php.net[/url]. Put in the "Search" box at the top:

    reset pointer mysql

    --
    Andy Hassall <andyandyh.co.uk> / Space: disk usage ysis tool
    [url]http://www.andyh.co.uk[/url] / [url]http://www.andyhsoftware.co.uk/space[/url]
    Andy Hassall Guest

Similar Threads

  1. script blocks on $news=mysql_fetch_array($result);
    By Georges.Kuntz in forum PHP Development
    Replies: 2
    Last Post: October 9th, 09:23 AM
  2. problems with mysql_fetch_array in 2D array
    By Kevin Torr in forum PHP Development
    Replies: 6
    Last Post: February 13th, 10:27 PM
  3. mysql_fetch_array
    By Robert in forum PHP Development
    Replies: 8
    Last Post: January 7th, 08:09 AM
  4. Replies: 0
    Last Post: October 27th, 11:36 AM
  5. #25998 [NEW]: mysql_fetch_array display nothing over 530 records
    By hsutanto78 at hotmail dot com in forum PHP Development
    Replies: 0
    Last Post: October 27th, 09:17 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139