www.webdeveloper.com

Search:

Type: Posts; User: beylah

Page 1 of 10 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    3
    Views
    182

    varchar - i know, i know - uggg but i cant do...

    varchar - i know, i know - uggg but i cant do anything about it now - this is how i received the work.
  2. Replies
    3
    Views
    182

    Time related query

    I have been assigned to an existing project where the time was put in as 12:15 pm, for example. I need to select all the times entered between 11:00 am and 3:00pm. I have created the following query...
  3. Replies
    2
    Views
    547

    It seems to work with other months but not...

    It seems to work with other months but not January. There are no entries from 01-07, but it should still give me the entries from 08-15 but it is showing nothing.
  4. Replies
    2
    Views
    547

    Query not working with BETWEEN

    I have a query to find records between specific dates but the database was not set up with a date entry but a using the following fields: month, day, year. So I have tried to select data using a...
  5. Replies
    2
    Views
    1,379

    ok i will check into this

    ok i will check into this
  6. Replies
    2
    Views
    1,379

    Scheduled Exports of Specific Data

    I get nightly dumps of my server data but someone has asked me if they can have nightly cvs exports of specific fields. I know how to make a download button that when clicked downloads specific data...
  7. Replies
    2
    Views
    1,607

    Sorting After the Query

    I have a database of catering orders. Some of the orders have refill times (1 & 2). I need to display a list of all order, including separate entries for those with refill times, in chronological...
  8. Replies
    10
    Views
    1,053

    thank you it makes sense what you are saying and...

    thank you it makes sense what you are saying and i did use an join and it worked. Could you tell me what is old code so i dont use it anymore?
  9. Replies
    10
    Views
    1,053

    Thank you deathshadow you pointed out my error -...

    Thank you deathshadow you pointed out my error - I was searching through the directory table first for those that are lawyers when i should have been searching after getting the content from the...
  10. Replies
    10
    Views
    1,053

    I am getting no output I have also tried the...

    I am getting no output

    I have also tried the WHERE lss1.lawyer = \"$profname\" and lss1.lawyer=lss2.lawyer - and get no output
  11. Replies
    10
    Views
    1,053

    [RESOLVED] Sorting by a calculated field

    I am trying to sort by a calculated field. I have 2 tables: lss1 and lss2. Each are the same. I am trying to get a sort order for their total number of hours.

    This is what I have but no total...
  12. Replies
    2
    Views
    538

    I have added this and it now works ...

    I have added this and it now works

    $name=utf8_decode($rows['name']);
  13. Replies
    2
    Views
    538

    [RESOLVED] Query with an accent

    I have a query to search for a name in a directory but there is an accent in the name and is not returning any results.


    $query = "SELECT * FROM directory WHERE name=\"$name\"";

    if I echo this...
  14. Replies
    8
    Views
    819

    I changed the WHERE to read AND id!='####' and...

    I changed the WHERE to read AND id!='####' and that worked, thanks
  15. Replies
    8
    Views
    819

    Many people fill in the records. The reason that...

    Many people fill in the records. The reason that there are 2 records (even though I suggested not) is that the person is in Toronto and Ottawa and together they represent Ontario. So when Ontario is...
  16. Replies
    8
    Views
    819

    100% agree with what you have posted. Firstly, I...

    100% agree with what you have posted. Firstly, I copied the name directly from the database. Secondly, The person spends time in 2 offices so needs different criteria for each office. I did not know...
  17. Replies
    8
    Views
    819

    the names are different though. One is 'Smith,...

    the names are different though. One is 'Smith, John' and the second is 'Smith, John (Toronto)' .

    I think the problem is that both entries has one of the criteria ie their title is 'Associate". So...
  18. Replies
    8
    Views
    819

    [RESOLVED] select criteria not working

    I am selecting data from a table and sorting it by school for 2 cities. One person is in the directory twice for both Toronto and Ottawa. But I dont want the person to show up twice. This is what I...
  19. Replies
    4
    Views
    646

    ok help on 2 parts how do you group by 2...

    ok help on 2 parts

    how do you group by 2 things I thought i could only group by one

    haw do you save the values
  20. Replies
    4
    Views
    646

    This is what I have gotten so far but it only...

    This is what I have gotten so far but it only shows one of the names of that are in conflict not both.



    <?php
    $sqla="SELECT DISTINCT(day) AS day, name AS name FROM forms_calendar WHERE...
  21. Replies
    4
    Views
    646

    Vacation Planner

    I have made a vacation planner to track employee vacations. But I want to add a feature to show conflicts. That is, only 1 person from each department can take vacation on a particular day. And I...
  22. Replies
    2
    Views
    474

    Fixed

    $cutoffdate = "$month/$day/$year";

    if(strtotime($cutoffdate) < strtotime('now')) {
  23. Replies
    2
    Views
    474

    [RESOLVED] Comparing Time

    I am trying to make a list that will only show events that have happened. The event is put in by month day and year. Here is my code:



    $todaysdate = strtotime('now');
    $sql = "SELECT * FROM...
  24. Replies
    5
    Views
    978

    Thank you, this makes sense too

    Thank you, this makes sense too
  25. Replies
    5
    Views
    978

    that work amazing - any chance you could explain...

    that work amazing - any chance you could explain it to me or direct me to where I could learn about this
Results 1 to 25 of 237
Page 1 of 10 1 2 3 4
HTML5 Development Center



Recent Articles