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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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 -
file upload and adding name to dbase
deecee, below is a script I use for doing just that, a simple html form posts the data to this form that does the work. Note $page and $fext are my variables. The line - substr("$newfile", 38); strips the /home/extrabucc/public_html/schedules/ so that just the filename is... -
Can you post from a hyperlink?
Many thanks, yes I had a complete blank, the whole thing works well using the GET method. Regards NigeB -
Can you post from a hyperlink?
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 -
Data not Inserted?
The final code (below) worked just fine. Thanks for all the tips and instructions, sometimes at 3am you just miss the most obvious.... Thanks again guys. Regards Nigel. ******************************************** $query = "SELECT DISTINCT Team FROM Teams"; $result =... -
Data not Inserted?
I have cleaned up the code some, but I am still having problems with the line - WHERE Team = ".$myrow["Team"]." I am getting syntax error code for this line onwards "Query1 failed : You have an error in your SQL syntax near 'Stars ORDER BY Ttimes.Fastest_Time DESC...
