mtoynbee

try this instead: while ($amulet_piece = mysql_fetch_assoc($amuletQuery)) { } This will make $amulet_piece an array like $amulet_piece['id'] etc..

Yes

$amuletQuery = mysql_query("SELECT * FROM amulet WHERE user_name = $username"); // slight edit added while ($amulet_piece = mysql_fetch_array($amuletQuery, MYSQL_ASSOC)) { // Your code here }

Also I've just noticed you need to use a double equals on your if statement otherwise you are assigning that value not validating it. This would also return as true. $amulet_piece = mysql_query("SELECT * FROM amulet WHERE user_name = $username"); if ($amulet_piece[amulet_id] == 1) { $amulet1 = "<img src=$base_url/images/real image here.gif>"; } else { $amulet1 = "<a href=amulet.pro.php?amulet=1><img src=$base_url/faded image here.gif></a>"; }

You'll need to use "mysql_fetch_array" or "mysql_fetch_assoc" to assign a variable to the result set.

This URL explains the installation process: http://uk.php.net/manual/en/mbstring.installation.php

What happens when you use $_SERVER['PHP_SELF'] instead?

Ah, let me save you some time here as this is a trap that most early database adopters get into. Your method of storing selections should instead utilise a "linkage table". This is a table normally with 2 columns which links one piece of data to another. Therefore the best route is to create a table called: user_selection user_id selection_id 1 2 1 5 1 6 2 1 2 3 2 5 That way you can then do a JOIN such as SELECT a.*,c.* FROM user AS a INNER JOIN user_selection AS b ON a.user_id = b.user_id INNER JOIN selections AS c ON b.selection_id = c.id and use INSERT INTO user_selection (user_id,selection_id) VALUES (1,2) when you are adding selections. This is not designed to complete your script for you but if you use this method you'll save a lot of time on a lot of projects in the future. Good luck

Perhaps can you post the whole script in relevant sections and the line number the error occurs? That would help to determine the issue.

I am trying to start learning PHP COM and have the following script: <?php error_reporting(E_ALL); try { $filename = "brief_synopsis.doc"; $word = new COM("word.application") or die("Unable to instantiate Word"); $word->Documents->Open($filename); $new_filename = substr($filename,0,-4) . ".txt"; $word->Documents[1]->SaveAs($new_filename,2); $word->Documents[1]->Close(false); $word->Quit(); $word->Release(); $word = NULL; unset($word); $fh = fopen($new_filename, 'r'); $contents = fread($fh, filesize($new_filename)); fclose($fh); unlink($new_filename); } catch (com_exception $e) { $err = array('errorCode' => $e->getCode(), 'errorMessage' => $e->getMessage(), 'errorFile' => $e->getFile(), 'errorLine' => $e->getLine()); var_dump($err); } ?> I get the exception error dump as: array(4) { ["errorCode"]=> int(-2147221020) ["errorMessage"]=> string(64) "Failed to create COM object `word.application': Invalid syntax " ["errorFile"]=> string(46) "E:\Inetpub\wwwroot\Intranet\phpcom.php" ["errorLine"]=> int(6) } I am using Windows Server 2003. IIS, PHP 5 Any ideas what is causing the error? Or if anyone has a working script for opening and view an MS Word file let me know. Thanks.

Try this instead: $input = "INSERT INTO category([name], [by]) VALUES('$category','$_SESSION[user]')"; $write = mysql_query($input,$db->link) or die(mysql_error() . " Query was: $input"); "BY" is a reserved word therefore is needs square brackets for MySQL to treat it as a column name.

I believe you would need to use PHP COM. #Instantiate the Word component. $word = new COM("word.application") or die("Unable to instantiate Word"); $word->Visible = 1; $word->Documents->Open("c:/anydocument.doc"); $temp = $word->Dialogs->Item(228); $temp->Execute(); $numwords = $temp->Words(); echo $numwords; $word->Quit(); Note that this is the only way to get the word count accurately: $word->ActiveDocument->Words->Count; Will see all carriage returns and punctuation as words so is wildy innaccurate. http://php.chinaunix.net/manual/zh/ref.com.php

Indeed, that was my thought as an enhancement to the 5 minute timeout idea.

Maybe you should explain further what you are trying to do.

Why not use AJAX to run a simple background refresh to see if the user's browser is still open - therefore is still "online"?

I think it is because you have specied $row as 0 and then use it as an array. Put $row = array(); before you use it as an array. That should fix it.

A few options: Hide the link by forcing a download dialog using PHP headers. http://uk.php.net/header Store the file as a BLOB (MySQL) in the database and output via headers http://dev.mysql.com/doc/refman/5.0/en/blob.html setup a .htaccess file (for Apache server) on that specific file so that the user cannot access it directly withouth being prompted for a password. http://httpd.apache.org/docs/1.3/howto/htaccess.html

If you learn MySQL you will still need PHP to interface with it on the web. http://uk2.php.net/mysql

Should these be the other way round? chmod($req_dir, 0755); $dir=mkdir($req_dir); Should be $dir=mkdir($req_dir); chmod($req_dir, 0755); You can't chmod a directory that doesn't exist yet.

As I said - this is the sort of error when you freestyle If you change: $sat[$week]++; to $sat[$week][]=1; $nonSat[$week]++; to $nonSat[$week][]=1; Not my best code I admit but hopefully will work. I'll leave it to you to polish.

Wild stab in the dark: <?php include "include/db_connect.inc.php"; $nonSat = array(); $sat = array(); $week = "28"; $query = "SELECT [week],[satindex] FROM vocdata WHERE Vocid='4820' GROUP BY week"; $result = mysql_query($query); $total = mysql_num_rows($result); while ($row = mysql_fetch_assoc($result)) // mysql_fetch_array? { $week=$row['week']; $wks[]=$week; echo $row['Satindex'] . "<br/>"; $index = $row['Satindex']; if ($index > 6) { $sat[$week]++; } else { $nonSat[$week]++; } } foreach ($wks AS $wk) { $satpercent = array_sum($sat[$wk]) / (count($sat[$wk])+count($nonSat[$wk])) * 100; $satpercent = (int)$satpercent; echo "Displaying fiscal week $wk"; echo "<br/>"; echo "Total: ".(array_sum($sat[$wk])+array_sum($nonSat[$wk]))." hits whereof ".count($sat[$wk])." where satisfied and ".count($nonSat[$wk]))." where non-satisfied"; echo "<br/>"; echo "This leaves us with a sat percentage of: $satpercent%"; ?>

Hi, Not sure why you would want to use the id as a GET variable. Why not use the UserId to look up the selections from the list within the script. GET vars should only be used when the user wants to communicate in a simple way with the webpage. If I have misunderstood the problem I apologise.

You can just use number_format http://uk.php.net/number_format

I think str_replace might be slightly quicker. ereg_replace is quicker than eregi as it's case insensitive. The difference is minimal though. If you are using str_replace already does that not strip the comma?

$foo = "1,516"; $foo = eregi_replace(",","",$foo);