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

Reply to this topic