What's wrong here?

2001-06-14 Thread Vladimir Kravtsov
?php require('common.php'); function DisplayPoll() { connectdb(); mysql_select_db(pollbooth); $sql = select choice from choices; $query = mysql_query($sql); $num_of_voting_choices = mysql_num_rows($query); $sql = select choice from votes; $query = mysql_query($sql);

Table won't update

2001-06-11 Thread Vladimir Kravtsov
The table sitesats won't update and shows no errors! (even though there are two instances of echo(mysql_error())) html body ?php require('../common.php'); if (!isset($areview)) { echo(You must review the site); } else { if (!isset($apositive)) { echo(You must review the site); } else { if

PHP + MySQL question

2001-06-10 Thread Vladimir Kravtsov
Here is my db hierarchy: Database: xtopsites Table: Categories idName 1Name1 2Name2 3Name3 4Name4 5Name5 6Name6 I would like the user to get to a sign up form and have all the names of the categories displayed.is this possible to do using fetch_array? If it

PHP Prob contd.

2001-06-10 Thread Vladimir Kravtsov
Well I fixed that part so now the file looks like this: html head body ?php require('../common.php'); connectdb(); mysql_select_db(xtopsites); $validated=1; $sql = select id, siteurl, sitename, from sitesats where validated = '$validated'; $r = mysql_query($sql); $numrows = mysql_num_rows($r);

MySQL Problem -- Please help

2001-06-09 Thread Vladimir Kravtsov
I'm using MySQL with PHP (just learned MySQL so bear with me). Here's a two part program: Test.php: html body ?php require(common.php); CalculateScore(1); ? /body /html Common.php: ?php //Global variables $Sitename=Toplist; $Siteurl=; $Links_per_page=50; $Base_site_url=localhost; //MySQL