Web site builder - 548 CHAPTER 22 SQLITE This returns the
548 CHAPTER 22 SQLITE This returns the following (this shows only one of three possible outcomes): Randomly chosen employee of the month: Ray Fox (Employee ID: 3) One point of common confusion that arises in this example regards the starting index offset of result sets. The offset always begins with 0, not 1, which is why you need to subtract 1 from the total rows returned in this example. As a result, the randomly generated row offset integer must fall within a range of 0 and one less than the total number of returned rows. Learning More About Table Schemas There is one function available for learning more about an SQLite table schema. It s introduced in this section. sqlite_fetch_column_types() array sqlite_fetch_column_types (string table, resource dbh) The function sqlite_fetch_column_types() returns an array consisting of the column types located in the table identified by table. The returned array includes both the associative and numerical hash indices. The following example outputs an array of column types located in the employee table used earlier in this chapter:
Looking for affordable and reliable webhost to host and run your business application? Then look no more and go to servlet web hosting services.