Re: [PHP-DB] Help Needed with malfunctioning query

2006-02-25 Thread Murray @ PlanetThoughtful
On 26/02/2006 3:03 PM, Chris Payne wrote: Hi there everyone, This line of code USED TO WORK but now it gives me a Coudln't Execute Query error: $query2 = SELECT word,def,photo MATCH(word,def) AGAINST ('$txtsearchword' IN BOOLEAN MODE) AS m FROM dictionary WHERE MATCH(word,def) AGAINST

RE: [PHP-DB] HTML Tables in PHP...

2005-09-25 Thread Murray @ PlanetThoughtful
How can I give a table /table with all of it's parameters in PHP in each of the cells there is a variable that gives me the data back but I can't get the table to show as it always gives me either this error Parse error: parse error, unexpected T_LNUMBER, expecting ',' or ';' in

RE: [PHP-DB] Highlighting data selected from one table that appear in another

2005-09-01 Thread Murray @ PlanetThoughtful
mysql 4.0.25 php 4.3.1 I seem to be unable to solve this problem without some help. A webpage is to list all the clients in a mysql Client table. Each client has an an allocated clid. Those clients who are listed, identified by their allocated clid, in a Transactions are to be

RE: [PHP-DB] Need help with a tricky query

2005-05-20 Thread Murray @ PlanetThoughtful
I'm trying to write a query that pulls details on a game record, as well as the officials assigned to the game (up to 4 officials may be assigned to each game, but that's not always the case). Game details are in the games table, and assignments are in the games_referees table (which I

RE: [PHP-DB] Need help with a tricky query

2005-05-20 Thread Murray @ PlanetThoughtful
SELECT g. * , concat( ref.fname, ' ', ref.lname ) AS ref, concat( ar1.fname, ' ', ar1.lname ) AS ar1, concat( ar2.fname, ' ', ar2.lname ) AS ar2, concat( fourth.fname, ' ', fourth.lname ) AS fourth FROM ( ( ( ( ( ( ( ( games g RIGHT OUTER JOIN games_referees ref_ass ON ( g.id =

RE: [PHP-DB] database synchronization

2005-05-12 Thread Murray @ PlanetThoughtful
quote   I have web based application running on php and mysql and installed on multiple sites. The data on those sites need to be synchronized (to have same data on every site after insert/update/delete action in each site). Currently im using an ftp server to handle synchronization, im using

RE: [PHP-DB] Institute

2004-11-09 Thread Murray @ PlanetThoughtful
May you pls. suggest me a good institute for learning PHP AND MYSQL in and around Delhi or Noida (INDIA). preferably Noida. I don't know what the availability of training is like in your area, but if you find training difficult to find, there are several good textbooks that take you from

RE: [PHP-DB] mysql_query

2004-10-12 Thread Murray @ PlanetThoughtful
Hi, Unless you have 'register globals' on, are you retrieving the value of the variables passed by your form from the $_GET or $_POST super variables (whichever is appropriate)? In other words, at the top of the page that is performing your insert query, do you have lines such as: $ime =

[PHP-DB] RE: [PHP] Lost in query... Trying to get output from query....

2004-10-11 Thread Murray @ PlanetThoughtful
Hi, You need to loop through the returned recordset and use the returned result(s). Instead of: $admin_get_options_result = mysql_fetch_assoc($admin_get_options_results_reference); Try: While ($admin_get_options_result = mysql_fetch_assoc($admin_get_options_results_reference)){ echo

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Murray @ PlanetThoughtful
Hi Stuart, session_start() has to be the first actual codeline in your page. So: ? session_start() /* rest of code */ ? html Etc... On the page you're receiving the error on, move session_start() to the first line executed in the script. Much warmth, Murray

[PHP-DB] Recursively determine parent records?

2004-10-05 Thread Murray @ PlanetThoughtful
Hi All, I have recordset that contains a hierarchical representation of records where a record's [parentid] field contains the recid of the record 'above' the current record. A representation might look like this: Recid, parentid, title 1, 0, Top level record 2, 0, Another top