Forums
This topic is locked
MySQL help needed
Posted 15 Jan 2003 15:21:39
1
has voted
15 Jan 2003 15:21:39 Kristian Waagsboe posted:
okay, I'm quite new to MySQL, this program PremiumSoft MySQL Studio helps me a lot. I need help with 2 issues:1:
I'm having problems making queries which calculates different values. I have a poll on my site, and in MS Access it was simple as nothing.
Example, the new field in the query, Prosent1's value is calculated to:
[vote1]/([vote1]+[vote2]+[vote3]+[vote4])
How can I make a similar effect using MySQL?
2:
My connection in Dreamweaver is properly set up, and I get no errors in normal pages. But I cant make recordsets which collects data from queries, only tables. Is this so? Can't we collect data from queries? I could collect from queries when I used MS Access...
DWMX - ASP VB - MySQL - MS IIS - PHP 4.3.0
.:. DWMX .:. MS IIS 5.1 .:. WinXP .:. MS Acsess XP