| MySql C API Example - Called from PHP Script |  |
| Intro | PHP Script | Text Produced | HTML Produced | XML Produced | Run Text | Run HTML | Run XML | q.sql | mysql_c_api.c | db_mysql.h | Download |
| MySql C API Example - Called from PHP Script | |
| Intro | PHP Script | Text Produced | HTML Produced | XML Produced | Run Text | Run HTML | Run XML | q.sql | mysql_c_api.c | db_mysql.h | Download |
Author: Mike Massingill - MikeM@OuSob.Com
Query in q.sql
select *
from ref_zip_codes where state_code='TX' and city_name='Pasadena'
Row(s): 8
Date: 2010-09-09
Time: 13:38:52
0 zip_code_id = 64621
1 zip_code = 77501
2 zip_type = P
3 city_name = Pasadena
4 city_type = D
5 state_name = Texas
6 state_code = TX
7 area_code = 713
8 latitude = 29.684464
9 longitude = -95.169800
0 zip_code_id = 64622
1 zip_code = 77502
2 zip_type = S
3 city_name = Pasadena
4 city_type = D
5 state_name = Texas
6 state_code = TX
7 area_code = 713
8 latitude = 29.679942
9 longitude = -95.198440
0 zip_code_id = 64624
1 zip_code = 77503
2 zip_type = S
3 city_name = Pasadena
4 city_type = D
5 state_name = Texas
6 state_code = TX
7 area_code = 713
8 latitude = 29.691128
9 longitude = -95.162613
0 zip_code_id = 64625
1 zip_code = 77504
2 zip_type = S
3 city_name = Pasadena
4 city_type = D
5 state_name = Texas
6 state_code = TX
7 area_code = 713
8 latitude = 29.649003
9 longitude = -95.182296
0 zip_code_id = 64626
1 zip_code = 77505
2 zip_type = S
3 city_name = Pasadena
4 city_type = D
5 state_name = Texas
6 state_code = TX
7 area_code = 713
8 latitude = 29.654184
9 longitude = -95.149733
0 zip_code_id = 64627
1 zip_code = 77506
2 zip_type = S
3 city_name = Pasadena
4 city_type = D
5 state_name = Texas
6 state_code = TX
7 area_code = 713
8 latitude = 29.705414
9 longitude = -95.201839
0 zip_code_id = 64628
1 zip_code = 77507
2 zip_type = S
3 city_name = Pasadena
4 city_type = D
5 state_name = Texas
6 state_code = TX
7 area_code = 713
8 latitude = 29.625223
9 longitude = -95.057353
0 zip_code_id = 64629
1 zip_code = 77508
2 zip_type = P
3 city_name = Pasadena
4 city_type = D
5 state_name = Texas
6 state_code = TX
7 area_code = 713
8 latitude = 29.663810
9 longitude = -95.148185
Processing Time 1.000000 second(s)