storing a variable and looping (1 reply)
- user warning: Table './programm_program/cache_content' is marked as crashed and should be repaired query: SELECT data, created, headers, expire FROM cache_content WHERE cid = 'content:10323:10323' in /home/programm/public_html/includes/database.mysql.inc on line 174.
- user warning: Table './programm_program/cache_content' is marked as crashed and should be repaired query: SELECT data, created, headers, expire FROM cache_content WHERE cid = 'content_type_info' in /home/programm/public_html/includes/database.mysql.inc on line 174.
- user warning: Table './programm_program/cache_content' is marked as crashed and should be repaired query: LOCK TABLES cache_content WRITE in /home/programm/public_html/includes/database.mysql.inc on line 174.
- user warning: Table './programm_program/cache_content' is marked as crashed and should be repaired query: UPDATE cache_content SET data = 'a:4:{s:11:\"field types\";a:3:{s:13:\"nodereference\";a:3:{s:5:\"label\";s:14:\"Node Reference\";s:6:\"module\";s:13:\"nodereference\";s:10:\"formatters\";a:4:{s:7:\"default\";a:3:{s:5:\"label\";s:12:\"Title (link)\";s:11:\"field types\";a:1:{i:0;s:13:\"nodereference\";}s:6:\"module\";s:13:\"nodereference\";}s:5:\"plain\";a:3:{s:5:\"label\";s:15:\"Title (no link)\";s:11:\"field types\";a:1:{i:0;s:13:\"nodereference\";}s:6:\"module\";s:13:\"nodereference\";}s:4:\"full\";a:3:{s:5:\"label\";s:9:\"Full node\";s:11:\"field types\";a:1:{i:0;s:13:\"nodereference\";}s:6:\"module\";s:13:\"nodereference\";}s:6:\"teaser\";a:3:{s:5:\"label\";s:6:\"Teaser\";s:11:\"field types\";a:1:{i:0;s:13:\"nodereference\";}s:6:\"module\";s:13:\"nodereference\";}}}s:5:\"image\";a:3:{s:5:\"label\";s:5:\"Image\";s:6:\"module\";s:10:\"imagefield\";s:10:\"formatters\";a:25:{s:21:\"100x100_thumb_default\";a:3:{s:5:\"label\";s:13:\"100x100_thumb\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:20:\"100x100_thumb_linked\";a:3:{s:5:\"label\";s:29:\"100x100_thumb as link to node\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:23:\"100x100_thumb_imagelink\";a:3:{s:5:\"label\";s:30:\"100x100_thumb as link to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:18:\"100x100_thumb_path\";a:3:{s:5:\"label\";s:32:\"path to 100x100_thumb derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:17:\"100x100_thumb_url\";a:3:{s:5:\"label\";s:31:\"url to 100x100_thumb derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:13:\"50x50_default\";a:3:{s:5:\"label\";s:5:\"50x50\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:12:\"50x50_linked\";a:3:{s:5:\"label\";s:21:\"50x50 as link to node\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:15:\"50x50_imagelink\";a:3:{s:5:\"label\";s:22:\"50x50 as link to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:10:\"50x50_path\";a:3:{s:5:\"label\";s:24:\"path to 50x50 derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:9:\"50x50_url\";a:3:{s:5:\"label\";s:23:\"url to 50x50 derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:17:\"MainImage_default\";a:3:{s:5:\"label\";s:9:\"MainImage\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:16:\"MainImage_linked\";a:3:{s:5:\"label\";s:25:\"MainImage as link to node\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:19:\"MainImage_imagelink\";a:3:{s:5:\"label\";s:26:\"MainImage as link to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:14:\"MainImage_path\";a:3:{s:5:\"label\";s:28:\"path to MainImage derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:13:\"MainImage_url\";a:3:{s:5:\"label\";s:27:\"url to MainImage derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:26:\"user_image_default_default\";a:3:{s:5:\"label\";s:18:\"user_image_default\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:25:\"user_image_default_linked\";a:3:{s:5:\"label\";s:34:\"user_image_default as link to node\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:28:\"user_image_default_imagelink\";a:3:{s:5:\"label\";s:35:\"user_image_default as link to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:23:\"user_image_default_path\";a:3:{s:5:\"label\";s:37:\"path to user_image_default derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:22:\"user_image_default_url\";a:3:{s:5:\"label\";s:36:\"url to user_image_default derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:7:\"default\";a:3:{s:5:\"label\";s:7:\"Default\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagefield\";}s:19:\"imagefield_nodelink\";a:3:{s:5:\"label\";s:12:\"link to node\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagefield\";}s:20:\"imagefield_imagelink\";a:3:{s:5:\"label\";s:13:\"link to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagefield\";}s:15:\"imagefield_path\";a:3:{s:5:\"label\";s:13:\"path to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagefield\";}s:14:\"imagefield_url\";a:3:{s:5:\"label\";s:12:\"url to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagefield\";}}}s:4:\"link\";a:3:{s:5:\"label\";s:4:\"Link\";s:6:\"module\";s:4:\"link\";s:10:\"formatters\";a:6:{s:7:\"default\";a:3:{s:5:\"label\";s:24:\"Title, as link (default)\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";}s:3:\"url\";a:3:{s:5:\"label\";s:12:\"URL, as link\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";}s:5:\"plain\";a:3:{s:5:\"label\";s:15:\"URL, plain text\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";}s:5:\"short\";a:3:{s:5:\"label\";s:32:\"Short, as link with title \"Link\"\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";}s:5:\"label\";a:3:{s:5:\"label\";s:34:\"Label, as link with label as title\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";}s:8:\"separate\";a:3:{s:5:\"label\";s:22:\"Separate title and URL\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";}}}}s:12:\"widget types\";a:4:{s:20:\"nodereference_select\";a:4:{s:5:\"label\";s:11:\"Select List\";s:11:\"field types\";a:1:{i:0;s:13:\"nodereference\";}s:6:\"module\";s:13:\"nodereference\";i:0;s:13:\"nodereference\";}s:26:\"nodereference_autocomplete\";a:4:{s:5:\"label\";s:23:\"Autocomplete Text Field\";s:11:\"field types\";a:1:{i:0;s:13:\"nodereference\";}s:6:\"module\";s:13:\"nodereference\";i:0;s:13:\"nodereference\";}s:5:\"image\";a:4:{s:5:\"label\";s:5:\"Image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagefield\";i:0;s:5:\"image\";}s:4:\"link\";a:4:{s:5:\"label\";s:29:\"Text Fields for Title and URL\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";i:0;s:4:\"link\";}}s:6:\"fields\";a:3:{s:10:\"field_link\";a:13:{s:10:\"field_name\";s:10:\"field_link\";s:4:\"type\";s:4:\"link\";s:8:\"required\";s:1:\"0\";s:8:\"multiple\";s:1:\"0\";s:10:\"db_storage\";s:1:\"1\";s:10:\"attributes\";a:3:{s:6:\"target\";s:6:\"_blank\";s:3:\"rel\";s:0:\"\";s:5:\"class\";s:0:\"\";}s:7:\"display\";a:1:{s:10:\"url_cutoff\";s:2:\"80\";}s:3:\"url\";s:8:\"optional\";s:5:\"title\";s:4:\"none\";s:11:\"title_value\";s:0:\"\";s:13:\"enable_tokens\";N;s:6:\"widget\";a:1:{s:5:\"label\";s:4:\"Link\";}s:9:\"type_name\";s:12:\"addreference\";}s:19:\"field_nodereference\";a:10:{s:10:\"field_name\";s:19:\"field_nodereference\";s:4:\"type\";s:13:\"nodereference\";s:8:\"required\";s:1:\"0\";s:8:\"multiple\";s:1:\"0\";s:10:\"db_storage\";s:1:\"1\";s:19:\"referenceable_types\";a:15:{s:4:\"list\";s:4:\"list\";s:4:\"page\";s:4:\"page\";s:5:\"drigg\";s:5:\"drigg\";s:12:\"addreference\";i:0;s:4:\"blog\";i:0;s:4:\"book\";i:0;s:7:\"comment\";i:0;s:11:\"drupal_site\";i:0;s:4:\"feed\";i:0;s:18:\"feedapi_aggregator\";i:0;s:5:\"forum\";i:0;s:5:\"image\";i:0;s:9:\"geshinode\";i:0;s:5:\"story\";i:0;s:6:\"janode\";i:0;}s:13:\"advanced_view\";s:2:\"--\";s:18:\"advanced_view_args\";s:0:\"\";s:6:\"widget\";a:1:{s:5:\"label\";s:13:\"NodeReference\";}s:9:\"type_name\";s:12:\"addreference\";}s:11:\"field_image\";a:9:{s:10:\"field_name\";s:11:\"field_image\";s:4:\"type\";s:5:\"image\";s:8:\"required\";s:1:\"0\";s:8:\"multiple\";s:1:\"0\";s:10:\"db_storage\";s:1:\"1\";s:13:\"default_image\";a:5:{s:8:\"filename\";s:15:\"field_image.jpg\";s:8:\"filepath\";s:47:\"files/imagefield_default_images/field_image.jpg\";s:8:\"filemime\";s:10:\"image/jpeg\";s:8:\"filesize\";s:5:\"27487\";s:6:\"source\";s:20:\"default_image_upload\";}s:17:\"use_default_image\";i:1;s:6:\"widget\";a:1:{s:5:\"label\";s:5:\"Image\";}s:9:\"type_name\";s:12:\"addreference\";}}s:13:\"content types\";a:12:{s:12:\"addreference\";a:16:{s:4:\"type\";s:12:\"addreference\";s:4:\"name\";s:13:\"Add Reference\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:0:\"\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:8:\"ShortTip\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:23:\"Code Snippet (optional)\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:0:\"\";s:7:\"url_str\";s:12:\"addreference\";s:6:\"fields\";a:3:{s:10:\"field_link\";a:14:{s:10:\"field_name\";s:10:\"field_link\";s:4:\"type\";s:4:\"link\";s:8:\"required\";s:1:\"0\";s:8:\"multiple\";s:1:\"0\";s:10:\"db_storage\";s:1:\"1\";s:10:\"attributes\";a:3:{s:6:\"target\";s:6:\"_blank\";s:3:\"rel\";s:0:\"\";s:5:\"class\";s:0:\"\";}s:7:\"display\";a:1:{s:10:\"url_cutoff\";s:2:\"80\";}s:3:\"url\";s:8:\"optional\";s:5:\"title\";s:4:\"none\";s:11:\"title_value\";s:0:\"\";s:13:\"enable_tokens\";N;s:6:\"widget\";a:6:{s:13:\"default_value\";a:1:{i:0;a:3:{s:3:\"url\";s:0:\"\";s:5:\"title\";s:0:\"\";s:10:\"attributes\";s:2:\"N;\";}}s:17:\"default_value_php\";s:0:\"\";s:4:\"type\";s:4:\"link\";s:6:\"weight\";s:1:\"0\";s:5:\"label\";s:4:\"Link\";s:11:\"description\";s:0:\"\";}s:9:\"type_name\";s:12:\"addreference\";s:16:\"display_settings\";a:3:{s:5:\"label\";a:1:{s:6:\"format\";s:6:\"inline\";}s:6:\"teaser\";a:1:{s:6:\"format\";s:7:\"default\";}s:4:\"full\";a:1:{s:6:\"format\";s:7:\"default\";}}}s:11:\"field_image\";a:10:{s:10:\"field_name\";s:11:\"field_image\";s:4:\"type\";s:5:\"image\";s:8:\"required\";s:1:\"0\";s:8:\"multiple\";s:1:\"0\";s:10:\"db_storage\";s:1:\"1\";s:13:\"default_image\";a:5:{s:8:\"filename\";s:15:\"field_image.jpg\";s:8:\"filepath\";s:47:\"files/imagefield_default_images/field_image.jpg\";s:8:\"filemime\";s:10:\"image/jpeg\";s:8:\"filesize\";s:5:\"27487\";s:6:\"source\";s:20:\"default_image_upload\";}s:17:\"use_default_image\";i:1;s:6:\"widget\";a:11:{s:14:\"max_resolution\";s:1:\"0\";s:12:\"max_filesize\";s:1:\"0\";s:17:\"max_number_images\";s:1:\"0\";s:10:\"image_path\";s:0:\"\";s:15:\"file_extensions\";s:16:\"jpg jpeg png gif\";s:10:\"custom_alt\";i:0;s:12:\"custom_title\";i:0;s:4:\"type\";s:5:\"image\";s:6:\"weight\";s:1:\"3\";s:5:\"label\";s:5:\"Image\";s:11:\"description\";s:0:\"\";}s:9:\"type_name\";s:12:\"addreference\";s:16:\"display_settings\";a:3:{s:5:\"label\";a:1:{s:6:\"format\";s:6:\"hidden\";}s:6:\"teaser\";a:1:{s:6:\"format\";s:13:\"50x50_default\";}s:4:\"full\";a:1:{s:6:\"format\";s:13:\"50x50_default\";}}}s:19:\"field_nodereference\";a:11:{s:10:\"field_name\";s:19:\"field_nodereference\";s:4:\"type\";s:13:\"nodereference\";s:8:\"required\";s:1:\"0\";s:8:\"multiple\";s:1:\"0\";s:10:\"db_storage\";s:1:\"1\";s:19:\"referenceable_types\";a:15:{s:4:\"list\";s:4:\"list\";s:4:\"page\";s:4:\"page\";s:5:\"drigg\";s:5:\"drigg\";s:12:\"addreference\";i:0;s:4:\"blog\";i:0;s:4:\"book\";i:0;s:7:\"comment\";i:0;s:11:\"drupal_site\";i:0;s:4:\"feed\";i:0;s:18:\"feedapi_aggregator\";i:0;s:5:\"forum\";i:0;s:5:\"image\";i:0;s:9:\"geshinode\";i:0;s:5:\"story\";i:0;s:6:\"janode\";i:0;}s:13:\"advanced_view\";s:2:\"--\";s:18:\"advanced_view_args\";s:0:\"\";s:6:\"widget\";a:6:{s:13:\"default_value\";a:1:{i:0;a:0:{}}s:17:\"default_value_php\";s:0:\"\";s:4:\"type\";s:26:\"nodereference_autocomplete\";s:6:\"weight\";s:1:\"5\";s:5:\"label\";s:13:\"NodeReference\";s:11:\"description\";s:0:\"\";}s:9:\"type_name\";s:12:\"addreference\";s:16:\"display_settings\";a:3:{s:5:\"label\";a:1:{s:6:\"format\";s:6:\"hidden\";}s:6:\"teaser\";a:1:{s:6:\"format\";s:6:\"hidden\";}s:4:\"full\";a:1:{s:6:\"format\";s:6:\"hidden\";}}}}}s:4:\"blog\";a:16:{s:4:\"type\";s:4:\"blog\";s:4:\"name\";s:10:\"Blog entry\";s:6:\"module\";s:4:\"blog\";s:11:\"description\";s:169:\"A blog is a regularly updated journal or diary made up of individual posts shown in reversed chronological order. Each member of the site may create and maintain a blog.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"0\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"1\";s:9:\"orig_type\";s:4:\"blog\";s:7:\"url_str\";s:4:\"blog\";s:6:\"fields\";a:0:{}}s:4:\"book\";a:16:{s:4:\"type\";s:4:\"book\";s:4:\"name\";s:9:\"Book page\";s:6:\"module\";s:4:\"book\";s:11:\"description\";s:386:\"A book is a collaborative writing effort: users can collaborate writing the pages of the book, positioning the pages in the right order, and reviewing or modifying pages previously written. So when you have some information to share or when you read a page of the book and you didn\'t like it, or if you think a certain page could have been written better, you can do something about it.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"0\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"1\";s:9:\"orig_type\";s:4:\"book\";s:7:\"url_str\";s:4:\"book\";s:6:\"fields\";a:0:{}}s:7:\"comment\";a:16:{s:4:\"type\";s:7:\"comment\";s:4:\"name\";s:7:\"Comment\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:46:\"A comment for use with the nodecomment module.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:7:\"Subject\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:0:\"\";s:7:\"url_str\";s:7:\"comment\";s:6:\"fields\";a:0:{}}s:5:\"drigg\";a:16:{s:4:\"type\";s:5:\"drigg\";s:4:\"name\";s:8:\"Question\";s:6:\"module\";s:5:\"drigg\";s:11:\"description\";s:15:\"Digg-style node\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:11:\"Description\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"0\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"1\";s:9:\"orig_type\";s:5:\"drigg\";s:7:\"url_str\";s:5:\"drigg\";s:6:\"fields\";a:0:{}}s:4:\"feed\";a:16:{s:4:\"type\";s:4:\"feed\";s:4:\"name\";s:4:\"Feed\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:49:\"Items from these feeds will be turned into nodes.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:4:\"feed\";s:7:\"url_str\";s:4:\"feed\";s:6:\"fields\";a:0:{}}s:18:\"feedapi_aggregator\";a:16:{s:4:\"type\";s:18:\"feedapi_aggregator\";s:4:\"name\";s:24:\"Feed (lightweight items)\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:90:\"Aggregates RSS or Atom feeds. Feed items will be turned into lightweight database entries.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"0\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:0:\"\";s:7:\"url_str\";s:18:\"feedapi-aggregator\";s:6:\"fields\";a:0:{}}s:9:\"geshinode\";a:16:{s:4:\"type\";s:9:\"geshinode\";s:4:\"name\";s:16:\"Source code node\";s:6:\"module\";s:9:\"geshinode\";s:11:\"description\";s:43:\"Source code with GeSHi syntax highlighting.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"0\";s:8:\"modified\";s:1:\"0\";s:6:\"locked\";s:1:\"1\";s:9:\"orig_type\";s:9:\"geshinode\";s:7:\"url_str\";s:9:\"geshinode\";s:6:\"fields\";a:0:{}}s:5:\"image\";a:16:{s:4:\"type\";s:5:\"image\";s:4:\"name\";s:5:\"Image\";s:6:\"module\";s:5:\"image\";s:11:\"description\";s:83:\"An image (with thumbnail). This is ideal for publishing photographs or screenshots.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"0\";s:8:\"modified\";s:1:\"0\";s:6:\"locked\";s:1:\"1\";s:9:\"orig_type\";s:5:\"image\";s:7:\"url_str\";s:5:\"image\";s:6:\"fields\";a:0:{}}s:4:\"list\";a:16:{s:4:\"type\";s:4:\"list\";s:4:\"name\";s:4:\"List\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:0:\"\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:11:\"Topic Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:28:\"(Optional) Topic Description\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:0:\"\";s:7:\"url_str\";s:4:\"list\";s:6:\"fields\";a:0:{}}s:4:\"page\";a:16:{s:4:\"type\";s:4:\"page\";s:4:\"name\";s:4:\"Page\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:83:\"If you want to add a static page, like a contact page or an about page, use a page.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:4:\"page\";s:7:\"url_str\";s:4:\"page\";s:6:\"fields\";a:0:{}}s:5:\"story\";a:16:{s:4:\"type\";s:5:\"story\";s:4:\"name\";s:5:\"Story\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:219:\"Stories are articles in their simplest form: they have a title, a teaser and a body, but can be extended by other modules. The teaser is part of the body too. Stories may be used as a personal blog or for news articles.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:5:\"story\";s:7:\"url_str\";s:5:\"story\";s:6:\"fields\";a:0:{}}}}', created = 1337882650, expire = 0, headers = '' WHERE cid = 'content_type_info' in /home/programm/public_html/includes/database.mysql.inc on line 174.
- user warning: Table './programm_program/cache_content' is marked as crashed and should be repaired query: LOCK TABLES cache_content WRITE in /home/programm/public_html/includes/database.mysql.inc on line 174.
- user warning: Table './programm_program/cache_content' is marked as crashed and should be repaired query: UPDATE cache_content SET data = 'a:0:{}', created = 1337882650, expire = 0, headers = '' WHERE cid = 'content:10323:10323' in /home/programm/public_html/includes/database.mysql.inc on line 174.
Submitted by programmer on Fri, 08/15/2008 - 19:10.
I am very much a newbie to mysql with php and I am having some difficulty figuring out how to do what I will describe below:
I am trying to do the following:
List the availability of a product in different states around the US by showing the state and then listing below it all the rows from the database that are in that state, then moving down to the next state and repeating the same procedure until everything has been exausted.
I can select a unique list of states by doing the following:
<?php
<br />
$result = mysql_query("SELECT DISTINCT clients.State FROM clients,stock WHERE clients.StoreNo=stock.StoreNo AND stock.ProductID=2 AND clients.Country <> 'CAN' ORDER BY State")
<br />
or die(mysql_error());
<br />
$row = mysql_fetch_array( $result );
<br />
// Print out the contents of each row into a table
<br />
echo "<a name='frubi_";
<br />
echo $row['State'];
<br />
echo "'>";
<br />
echo $row['State'];
<br />
echo "</a></td>";
<br />
?>This gives me the first state value of a row that has a Product ID of 2.
Then *somehow* I have to list all the cities below and move to the next.
Would this involve an "IF" statement? A "do while"?
Somehow I would have to store the value of the string variable and compare the rows in the database, and then I would have to discard that value and repeat it with the next.
Any help with this procedure would be GREATLY appreciated.