Woodie

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\'

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?

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\')\");

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

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!