vb.org Archive - Adding a column in the database?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - Adding a column in the database? (https://vborg.vbsupport.ru/showthread.php?t=52749)

Koutaru

05-10-2003 01:58 AM

Adding a column in the database?

I want to add the #s in a column in the database

example:

rating
4
5
6

total: 15

what query will work for this?
Thanks!

Koutaru

05-10-2003 03:30 AM

Without that capability, my queries look totally out of hand

PHP Code:


		
			
$five = $DB_site->query_first("SELECT COUNT(*) AS rating FROM review WHERE title = \"$title\" AND rating=5");

$four = $DB_site->query_first("SELECT COUNT(*) AS rating FROM review WHERE title = \"$title\" AND rating=4");

$three = $DB_site->query_first("SELECT COUNT(*) AS rating FROM review WHERE title = \"$title\" AND rating=3");

$two = $DB_site->query_first("SELECT COUNT(*) AS rating FROM review WHERE title = \"$title\" AND rating=2");

$one = $DB_site->query_first("SELECT COUNT(*) AS rating FROM review WHERE title = \"$title\" AND rating=1");



$totalnumber = $five[rating]*5+$four[rating]*4+$three[rating]*3+$two[rating]*2+$one[rating]*1;

Koutaru

05-10-2003 03:47 AM

:) Problem solved (I searched all over google)
For future reference to anyone Oo; I'm such a noob

PHP Code:


		
			
$average = $DB_site->query_first("SELECT AVG(rating) AS rating FROM review WHERE title = \"$title\"");

All times are GMT. The time now is 07:03 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01041 seconds Memory Usage 1,718KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: