Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by NigeB
-
Omit data already entered
Oops, I had missed the ' ' from WHERE Dogs_BFA_No = $bfa1, works a treat now, thanks for the pointers. Cheers Nige B -
Omit data already entered
I get the idea, I endevoured to take it a step further by deleting all the records from the original table for each dogs_bfa_no added, but for some reason no records are deleted Have I missed something obvious? // Create a table with all relevent records for the year in question $query =... -
Omit data already entered
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... -
timestamp filter
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 -
Format font color as a reult of a date/time query
Ok, this is my train of thought 1. create a temporary table and populate with 3 records all with an AM (morning start time) 2. insert a field to be used with the formatting later 3. repeat 1. above for PM 4. insert a different formatting field for the field is blank 5. select the... -
Format font color as a reult of a date/time query
My query (listed above) brings back 3 records with numerous fields, one being a time, which is formatted into AM or PM depending on the timestamp value. What I would like to know is how do I create an output for each record depending on the value of the respective timestamp value, that I can... -
Format font color as a reult of a date/time query
I think you misundertand me, sorry, I can get the data out, and format the code - no problem, but can I specify the criteria based on a query result? The UNIX Timestamp does the formating into AM / PM but based on the result can I then ipose a criteria? Regards Nigel -
Format font color as a reult of a date/time query
Yes the question is how to format a field as a reult of that field, i.e. if it's AM (morning) i would like to format in one way and another way for PM. Is it possible with mysql? Regards NigeB -
Format font color as a reult of a date/time query
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... -
Titles and Lists
Thanks for the assitance, I managed with a little help from the php forum, the final code is - echo "<table width=600 border=0>\n"; $query1 = "SELECT DISTINCT country FROM teams_online order by country"; $res1 = mysql_query($query1); while ($c_row =... -
Headers and Lists
sleipnir214, thank you for the correction, it worked a treat. Regards Nige B -
Headers and Lists
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... -
Titles and Lists
rudy, thanks for the pointer, I had been using one query, but was getting lost trying to insert a country header in the middle of the loop, i.e. how to detect the country change, hence the two queries. What is your suggestion for inserting a header in this loop? As all that comes back is one... -
Titles and Lists
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... -
Parse Error
Try taking out a ; so .$_GET['id'];); looks like .$_GET['id']); HTH NigeB
