www.webdeveloper.com

Search:

Type: Posts; User: Brooksie155

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    1,079

    As usual you pull your hair out, ask for help and...

    As usual you pull your hair out, ask for help and suddenly the answer pops out of knowhere:

    SELECT
    SUM(a.net) AS net,
    a.date
    FROM
    table_a a
    WHERE
    a.date = '2007-05-31'
    AND b.counter > 0
  2. Replies
    1
    Views
    1,079

    SUM(DISTINCT x) as y

    I'm trying to get a calculation from my sql, which requires joining two tables in order to check the criteria of the rows. The problem is that the second table contains multiple rows and the SUM...
  3. Replies
    1
    Views
    535

    you could create a many to many table.. ...

    you could create a many to many table..

    user_paintings
    user_id
    painting_id

    Then you simply SELECT painting_id FROM user_paintings WHERE user_id = '<USERS ID>'
  4. Replies
    2
    Views
    1,003

    When the swf is loaded I use loadAndSend() to...

    When the swf is loaded I use loadAndSend() to pass and XML string to a server script, the server script users this to gat the game data then returns the game data as XML.

    In IE this works fine,...
  5. Replies
    4
    Views
    678

    Not sure about SSI but with PHP you can do this...

    Not sure about SSI but with PHP you can do this easily. Create a file called navigation.html, then copy the code for this part of the site into it, then in it's place in you pages put the line:
    ...
  6. Replies
    2
    Views
    1,003

    Flash using XML in firefox?

    I am endeavouring to run a flash .swf which uses the xml.sendAndLoad() function. I have created the application and all works fine in Internet Explorer.

    However when I load it in Firefox, although...
  7. Replies
    6
    Views
    5,058

    Assuming you are trying to seperate the words so...

    Assuming you are trying to seperate the words so as to split "My search string" so the query will look for "My", "search" and "string" you could do the following:



    // Get array of key words...
  8. Replies
    8
    Views
    1,534

    try Freeola.com - Unlimited disk space / e-mail...

    try Freeola.com - Unlimited disk space / e-mail addresses. If you don't have a domian you can use one of theres (Free1000) domain names i.e.
    ukdots.com - so yours would be myname.ukdots.com.
    ...
  9. Replies
    1
    Views
    1,303

    You could set it by default: $main_page =...

    You could set it by default:
    $main_page = "wordpress";
    -Or-
    $_REQUEST['main_page'] = "wordpress"

    safest way would probably be to put this at the top of yout page:


    if...
  10. Thread: PHP tree

    by Brooksie155
    Replies
    3
    Views
    1,078

    I would probaly create a class object, and...

    I would probaly create a class object, and instantiate a new copy for each branch in the tree, then use a recursive function to link them together, storing the a unique branch value in each object,...
  11. Replies
    8
    Views
    1,263

    If you search for PHP MS WORD you may find some...

    If you search for PHP MS WORD you may find some sites offering a package for building word documents for you - I know there is one for Excel in the PEAR database,

    Otherwise you can produce PDF...
  12. I think you could send a packet of data 'message...

    I think you could send a packet of data 'message or whatever' by connecting to www.consultant.com by using fsockopen(), or fopen().

    Depending on what you are trying to achieve?
  13. if you split the date field for each quote into...

    if you split the date field for each quote into $day and $month, your if could be something like:


    if ($day = date("d") && $month = date("m") {
    ... Found a match for today ...
    } else {
    ......
  14. Replies
    1
    Views
    632

    Erm, your code looks a bit nasty - how about you...

    Erm, your code looks a bit nasty - how about you do this,


    $bgcolor = "white"; // Set bgcolor to white
    while(!$rs_employeeqa->EOF) {

    if (strcmp($bgcolor, "white") == 0) {
    ...
  15. Thread: php dates

    by Brooksie155
    Replies
    2
    Views
    777

    SELECT fields FROM table WHERE date >= [1st date]...

    SELECT fields FROM table WHERE date >= [1st date] AND date <= [2nd date];

    e.g. for all rows between 1st and 31st of January
    SELECT fieldsFROM table WHERE date >= 2006-01-01 AND date <=...
  16. Replies
    2
    Views
    827

    check you php.ini file is correctly configured...

    check you php.ini file is correctly configured for sending mail, I think I remember reading somewhere that if some lines have not been commented out windows gets a bit confused i.e.

    ; For Unix...
  17. Replies
    4
    Views
    2,187

    You could just use a large image. and on the list...

    You could just use a large image. and on the list page shrink it to fit:

    <img src="image.jpg" height="10" width="10">

    This will resize it explicitly to the stated sizes, to amintain aspect...
  18. Replies
    3
    Views
    764

    $space_position = strpos($dates," "); You...

    $space_position = strpos($dates," ");

    You should find that $space_position will contain the strings index value for the space.

    Therefore:


    $month = substr($dates,0,$space_position);
    $year...
  19. Well twist my nipple nuts and send me to alaska,...

    Well twist my nipple nuts and send me to alaska, the answer was simply a matter of removing the line:

    AND p.int_product_id = pci.int_product_id

    once I had added the JOIN, well hope my...
  20. As a quick addendum I just found this on Mysql...

    As a quick addendum I just found this on Mysql site in the Reference Manual:



    However it is still not returning records which are not in 'table2'?

    The Query as it stands:


    SELECT...
  21. Multiple table search - with incomplete data?

    I am endeavouring to search across multiple tables in order to compile a search result listing. However some of the table I want to include in the search don't always contain data for a given...
  22. Replies
    5
    Views
    1,945

    I don't really recognise that message, as long as...

    I don't really recognise that message, as long as the column 'title' exists in table 'meeting' you should be ok, even though based on the previous SQL statements, you are not referencing this field...
  23. Replies
    12
    Views
    1,495

    Assuming your selection boxes, and 'go' button...

    Assuming your selection boxes, and 'go' button are within a form, and the button is of type submit, e.g.

    <FORM action="your_php_file.php" method="POST">
    <select name="sel_region">
    <option...
  24. Replies
    4
    Views
    1,167

    Not sure if you've tested that but the servers I...

    Not sure if you've tested that but the servers I work with will detect all fields within the POSTed form as being set, even if they are blank. This may be browser dependant, but as you can't...
  25. Replies
    14
    Views
    1,642

    But you have to admint: ...

    But you have to admint:

    sx84r8772BGGM2sV8347a3267gfS4h5gy9Kj0H96923NUsGYrruSIY24kwQyinS5461Xh91s1b2U5e7GIX7l2U9CxKcIor5S46zk

    is going to be hard to guess, although probably just as easy to...
Results 1 to 25 of 50
Page 1 of 2 1 2
HTML5 Development Center



Recent Articles