[Update help]

The tables are not actually called that. Sorry I did not make that easy for anyone did I!

 

The table is Called Uses! When I try to run the command on myphpadmin (v2.5.....) an erro is returned saying I have a syntax error in \'ORDER BY fileda DESC LIMIT 10\'

[Update help]

need a little guidance if anyone can help!

 

I want to update just a selection of rows based on some information given to the query.

 

My update statement reads as follows....

 

UPDATE table SET fieldx = fieldx+1 WHERE fieldx = \'$value\' ORDER BY fielda DESC LIMIT 4;

 

now this is done in a php script that generates $value from another query to the same table before this update query is attempted!

 

that query is as follows..

 

SELECT * FROM table WHERE filedy = \'$val\' ORDER BY fielda DESC;

 

and $val is user defined an not null!

 

I am using php 4.0 (on the server I use but I have no admin priviledges!)

 

is there something I\'m missing with the LIMIT statement?

[UPDATE Problem]

This may sound a lttle basic but I do like to assign variables to all my MySQL statements - if purely for error checking!

 

But the only thing I woulkd alter in the update query is to place each variable into single quotes \'$foo\'......

 

mysql_query (\"UPDATE taskoverview SET name = \'$d_name\', beschreibung = \'$d_beschreibung\', duedate = \'$d_duedate\', aufwand = \'$d_aufwand\' , status = \'$d_status\', verantwortlich = \'$d_verantwortlich\')\");

[LEFT JOIN Query help needed]

Thanks for the tips I will try it out and see what happens!

[LEFT JOIN Query help needed]

Hope soembody can help me!

 

I have two tables. One has the names of teams and a primary key identifying the team. The other table has list of fixtures using the team IDs and time stamps of the fixtures.

 

TableTeams

teamID TeamName

 

TableFixtures

fixID HomeTeamID awayTeamID timStam

 

I want a query that will list all the teamnames given in TeamName that DO NOT appear in the Fixtures table when timStam is between two specified values!

 

Please Help I have tried several times with the only succes not getting an error!