• Member Avatar for mpc123
    mpc123

    Replied To a Post in sql update query based on pre-dates

    first time ever I haven't had a reply, anybody?
  • Member Avatar for mpc123
    mpc123

    Began Watching sql update query based on pre-dates

    I have a table of names that have done something on a certain date, now this could be over and over again yet of course on different dates but never …
  • Member Avatar for mpc123
    mpc123

    Replied To a Post in sql update query based on pre-dates

    Sorry the bottom part should read For example I would need to update last_time on id 1 with id 4 score / holes, then id4 would be need last_time updating …
  • Member Avatar for mpc123
    mpc123

    Created sql update query based on pre-dates

    I have a table of names that have done something on a certain date, now this could be over and over again yet of course on different dates but never …
  • Member Avatar for mpc123
    mpc123

    Marked Solved Status for passing variable for filters

    Hi I have a varible that is set at as a different value for each page this is called $mode. Currently I have succesfully set up a drop down menu …
  • Member Avatar for mpc123
    mpc123

    Replied To a Post in passing variable for filters

    BTW that works great thank you very much !!
  • Member Avatar for mpc123
    mpc123

    Replied To a Post in passing variable for filters

    WOW thanks for the advice, I will change i and also try what you have sent me, thanks again
  • Member Avatar for mpc123
    mpc123

    Replied To a Post in passing variable for filters

    Anybody give me any idea at least? I have tried in xmlhttp.open setting &$mode= but I can't get it to work
  • Member Avatar for mpc123
    mpc123

    Replied To a Post in passing variable for filters

    Can anybody tell me how to define $mode please?
  • Member Avatar for mpc123
    mpc123

    Marked Solved Status for query to find field text in another field

    Hi I need to look in a field to find the text same as another field I have this at the moment but it does not work, hoep you can …
  • Member Avatar for mpc123
    mpc123

    Replied To a Post in query to find field text in another field

    Great thanks that worked perfect. Thanks Again
  • Member Avatar for mpc123
    mpc123

    Created query to find field text in another field

    Hi I need to look in a field to find the text same as another field I have this at the moment but it does not work, hoep you can …
  • Member Avatar for mpc123
    mpc123

    Replied To a Post in passing variable for filters

    thanks for your replies, how would I define $mode also please?
  • Member Avatar for mpc123
    mpc123

    Created passing variable for filters

    Hi I have a varible that is set at as a different value for each page this is called $mode. Currently I have succesfully set up a drop down menu …
  • Member Avatar for mpc123
    mpc123

    Marked Solved Status for query delete words before a set of words in a field

    Hi I need to delete words before a set of words in a field. eg delete the words before the word price in that field. I already have a query …
  • Member Avatar for mpc123
    mpc123

    Created query delete words before a set of words in a field

    Hi I need to delete words before a set of words in a field. eg delete the words before the word price in that field. I already have a query …
  • Member Avatar for mpc123
    mpc123

    Replied To a Post in php single to combo box

    anything else somebody can offer please?
  • Member Avatar for mpc123
    mpc123

    Replied To a Post in php single to combo box

    Hi that looks great but the info in the database does change alot
  • Member Avatar for mpc123
    mpc123

    Created php single to combo box

    So I have a single drop down menu populated from data base, now i want to get a bit snazzy and select from the first and from the selected then …
  • Member Avatar for mpc123
    mpc123

    Marked Solved Status for wont echo field

    I have this to make a file ... but the file created is only ever .php, it is like it is not echoing the field name. $newfile ="" . str_replace(' …
  • Member Avatar for mpc123
    mpc123

    Replied To a Post in wont echo field

    Hi thanks for your help i had set my result as $row instead of $file therefore there was no result
  • Member Avatar for mpc123
    mpc123

    Created wont echo field

    I have this to make a file ... but the file created is only ever .php, it is like it is not echoing the field name. $newfile ="" . str_replace(' …
  • Member Avatar for mpc123
    mpc123

    Created 301 Redirect in Htaccess containing parts

    Hi I have changed some urls and know how to do a normal redirect but do not know where to start to be abale to redirect if part of the …
  • Member Avatar for mpc123
    mpc123

    Replied To a Post in update colomn sum of other colomns

    sorry i have now managed to make it work by just taking out the word SUM
  • Member Avatar for mpc123
    mpc123

    Marked Solved Status for update colomn sum of other colomns

    Hi I need to update a colomn with the result of colomn 1 divided colomn2 I have tried update TABLE set colomn =SUM(colomn1 / colomn2) but get [Err] 1111 - …
  • Member Avatar for mpc123
    mpc123

    Created update colomn sum of other colomns

    Hi I need to update a colomn with the result of colomn 1 divided colomn2 I have tried update TABLE set colomn =SUM(colomn1 / colomn2) but get [Err] 1111 - …
  • Member Avatar for mpc123
    mpc123

    Marked Solved Status for Update query takes ages

    HI Hope somebody can help. My query updates a colomn in tab1 from a row in tab2 but only if a colomn in tab1 is equal to that of a …
  • Member Avatar for mpc123
    mpc123

    Replied To a Post in Update query takes ages

    Great thanks for the quick reply, stange i already use indexes on those tables but looking at the indexes set they do not include those 2 colomns I am working …
  • Member Avatar for mpc123
    mpc123

    Created Update query takes ages

    HI Hope somebody can help. My query updates a colomn in tab1 from a row in tab2 but only if a colomn in tab1 is equal to that of a …

The End.