Professional Web Applications Themes

Resultset field object-type - PHP Development

while ($row = mysql_fetch_row($qid)) { for ($i = 0; $i < mysql_num_fields($qid); $i++) { if (mysql_field_name($qid, $i)) { $row[$i]; // HOW DO I KNOW WHAT KIND OF OBJECT $row[$i] IS HERE ???? } } }...

  1. #1

    Default Resultset field object-type

    while ($row = mysql_fetch_row($qid)) {
    for ($i = 0; $i < mysql_num_fields($qid); $i++) {
    if (mysql_field_name($qid, $i)) {
    $row[$i];

    // HOW DO I KNOW WHAT KIND OF OBJECT $row[$i] IS HERE ????

    }
    }
    }


    Ike Guest

  2. #2

    Default Re: Resultset field object-type

    Ike wrote: 

    Surely as designer of the table, you know what's in each column?

    Even so, you can use the following MySQL query to obtain info. about each column:

    DESCRIBE table

    See http://dev.mysql.com/doc/mysql/en/DESCRIBE.html for details.


    Hope this helps,
    Oli
    Oli Guest

  3. #3

    Default Re: Resultset field object-type

    Oli Filth wrote: [/ref]

    Actually, I don't think the array that mysql_fetch_row() returns can ever
    contain a PHP object (i.e. class), it will always contain an integer, float, or
    string. Which it is should be apparent from the MySQL type for the column in
    question.

    Oli
    Oli Guest

  4. #4

    Default Re: Resultset field object-type

    mysql_fetch_row() returns an array. mysql_fetch_object() returns the
    object...

    You can then use the get_class() function to give you the name of the
    object's class.

    "Oli Filth" <hotmail.com> wrote in message
    news:pKbrd.5$ntli.net... [/ref]
    >
    > Actually, I don't think the array that mysql_fetch_row() returns can ever
    > contain a PHP object (i.e. class), it will always contain an integer,
    > float, or string. Which it is should be apparent from the MySQL type for
    > the column in question.
    >
    > Oli[/ref]


    d Guest

Similar Threads

  1. Object of type 'System.String' cannot be converted to type 'System
    By Robert in forum ASP.NET Building Controls
    Replies: 8
    Last Post: May 17th, 08:45 AM
  2. alter field type
    By capik79 in forum Coldfusion Database Access
    Replies: 2
    Last Post: March 27th, 02:15 AM
  3. Replies: 3
    Last Post: September 29th, 03:25 AM
  4. Problem with character palette and Tracking field: can't type zero after type is modified
    By Tim_Murray@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 0
    Last Post: May 11th, 04:21 PM
  5. Cast from type 'Field' to type 'String'
    By in forum ASP Database
    Replies: 2
    Last Post: November 11th, 03:18 PM

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