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 ('$t

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

2005-09-25 Thread Murray @ PlanetThoughtful
> How can I give a 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 > C:\FoxServ\www\

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" a

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 O

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

RE: [PHP-DB] database synchronization

2005-05-12 Thread Murray @ PlanetThoughtful
  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 batch scri

RE: [PHP-DB] Need some help

2005-05-11 Thread Murray @ PlanetThoughtful
> Sorry but this isn't working. The variable $ttl_price is a calculation in > my first script. It stores the value of $Total_Price for all items. I am > trying to pass that to a new page. It isn't a form that I'm working with, > do I need to make it a form? I would greatly appreciate any help

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 begin

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 = $_GET['

[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: Etc... On the page you're receiving the error on, move "session_start()" to the first line executed in the script. Much warmth, Murray http://www.planetthoughtful.org Building a thoughtful planet, One quirky

[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 l