Search results for query: *

I have created a query, which populates a table, but I would like to omit any records that are already in the table. For example dogs_bfa_no = 1234 is already in the table to be populated and therefore I would like to populate with the next one in line Any ideas / pointers appreciated code...

Is there a way to filter a timestamp? Specifically I would like to filter all rows with a timestamp that relate to a time before 12 noon, the date is irrelevent in this particular query. TIA NigeB

Is it possible to apply formating font code as a result of a date time? What I am trying to do is present a list of courses (the result of a query) and Would like to colour all the "am" times Blue and "pm" times Red. I am just after a few pointers in the right direction. A snippet of the...

I am trying to create a page that queries a table containing team names and country to return a list thus Belgium Smiths Team Jones Team Rogers Team Holland Sithy's Team Peters Team etc etc, I have written a query, but unfortunatly it only returns the first country and teams from that...

I am trying to create a page that queries a table containing team names and country to return a list thus Belgium Smiths Team Jones Team Rogers Team Holland Sithy's Team Peters Team etc etc, I have written a query, but unfortunatly it only returns the first country and teams from that...

I generate a table of information from a MySQL query and then I would like to select a field in a row of data, by clicking onit, it posts that hyperlink to a new page as post data, is this possible if so how? TIA NigeB

I have written the query below to insert data into a table. The query runs, I get no errors but no data is inserted. Any suggestions as to my error(s) greatly appreciated TIA Nigel. ****************************************************** $result = mysql_query("SELECT DISTINCT...

I am trying to create a query which will return the most recent 5 entries for each Team The table is team, reg_no, amount, date The data is entered in all sorts of dates, so one team may have their most recent 5 entries spanning 2 years, whilst another may have the most recent 5 entries...

I am using a php / mysql combination to display a list of teams from around the globe. I can sort into country order no problem and county / state, but what I would like to do is display a group of all the teams in the same state together and put the teams in alphabetical order like thus...

I am using a php / mysql combination to display a list of teams from around the globe. I can sort into country order no problem and county / state, but what I would like to do is display a group of all the teams in the same state together and put the teams in alphabetical order like thus...

Is there a Sytax I can use in the <Form Method=Post Action=formname1.php> so I can post the results of an input form to multiple files. Basically I want to send the results to a data processor form which will add the information to a MySQL database (I have this part of the form working) and...

I am looking to make a graphical bar that reports on bookings for a specific class / course It would start at 10% full and slowly increase over a month until it is 90% full. The clculation, I assume would be based on Course_Start_Date - Date() = $var1 Beyond that I do not really have an...

I have the following code to populate a drop down box and some javascript to perform the jump, both seem to work fine, except I get a server error saying I do not have permissions to emter the directory (permissions are set to 777). *********************************************************...

The code as it appears on the web page is listed below, it is not complete as I am having problems towards the end, basically I create a Temp table place corresponding records from two existing tables into it (seedtmp1) I then create a second temporary table and filter the first one so that all...

The code as it appears on the web page is listed below, it is not complete as I am having problems towards the end, basically I create a Temp table place corresponding records from two existing tables into it (seedtmp1) I then create a second temporary table and filter the first one so that all...

I am having problems with the code listed below, I keep having a parse error reported on the line pertaining to DROP TABLE. Am I missing something fundamental or is it a bigger problem? Any help is appreciated. Nigel ___________________________________________________ <? $db =...

I have a database consisting of teams who compete irregularly, what I wish to do is query a table to return the most recent 5 results for each team, I can not use a date value (to select the records) as in the last month some teams may have competed 12 times while others only 5 times or less. I...

I am trying to query a table with the fields - TRN, Date, Fastest_Time and Tournament_ID What I wish to do is query the table and give an index number for each team (TRN) in order of the last time each competed (Date). All the teams do not compete at all the tournaments. The sort of info I...

Is there a way to perform a query and generate a table then perform a query on that table to give another? This is probobly easy, but I require this to be done each time the first query is run to bring back data to a web page (PHP) Many thanks in advance Nigel.

I currently have a website in which I wish to create a form to allow users to upload files, mainly PDF. Unfortunatly the server is does not allow annoymous posts, the page will ulitmatly be protected by a passowrd entry (already done), but I need to know how to have the user name and password to...