MySQL Problem -- Please help

I'm using MySQL with PHP (just learned MySQL so bear with me). Here's a two part program: Test.php: Common.php: 3000) { $hits = 3000; } $score = (($arate * 5) + ($urate * 2) + ($inhits / 100)); echo($score); //$sql = "update sitestats set score=$score where id = $id"; //mysql_query($s

PHP + MySQL question

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 i

Another PHP/MySQL question

When I run this I get: Parse error: parse error in c:\inetpub\wwwroot/php/X-TopSites/admin/admin.php on line 8 I want it to select the id, siteurl, sitename (in a table called sitesats) of any site which is not validated (I made it so validated=1 and not validated=2) What's wrong here? T

PHP Prob contd.

Well I fixed that part so now the file looks like this: Now, when I run it I get this error: Warning: Supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot/php/X-TopSites/admin/admin.php on line 11 You have an error in your SQL syntax near 'from sitesats where valid

Once again, this doesn't do anything.

The following code doesn't insert and update info in the db for some reason: It gives me the success message but the db remains untouched. What have I done this time? :) Thanks in advance.

Table won't update

The table sitesats won't update and shows no errors! (even though there are two instances of echo(mysql_error())) Any ideas?

What's wrong here?

"); echo(" "."$choice_percentage"."\%"); } } } ?> Please help :)

RE: What's wrong here?

Sorry. It doesn't do anything. Oh and btw, I made it so it DOES call on the function. It would help if we knew what the error or problem was? - Original Message - From: "Vladimir Kravtsov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday,