User Profile

Collapse

Profile Sidebar

Collapse
yeahuh
yeahuh
Last Activity: Dec 18 '06, 09:44 PM
Joined: Nov 17 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • yeahuh
    started a topic Looking for help with MySQL 4.0.24 LEFT JOIN
    in MySQL

    Looking for help with MySQL 4.0.24 LEFT JOIN

    Quick and dirty version.
    Godaddy server using MySQL 4.0.24

    I’m trying a left join to obtain id’s in table A(cars) that are NOT in car_id in table B(newspaper):

    *This is a cut down version to simplify testing. Full version is posted towards the end.

    Code:
    SELECT C.id
FROM cars C LEFT OUTER JOIN newspaper N USING (C.id=N.car_id)
WHERE N.car_id IS NOT NULL;
    I’m sure it’s...
    See more | Go to post
    • yeahuh
      replied to "connect failed"
      in PHP
      I'm new as well so belive me i feel your pain lol.

      php.net says "require_on ce() should be used in cases where the same file might be included and evaluated more than once during a particular execution of a script, and you want to be sure that it is included exactly once to avoid problems with function redefinitions, variable value reassignments, etc."

      I would asume it's not the root of your problem but as...
      See more | Go to post

        Leave a comment:

      • yeahuh
        replied to How to append data in LIST box
        in PHP
        I'm not sure the policy on links here but i have seen a decent example of doing just that using ajax at this site. http://www.dhtmlgoodies.com/scripts/...ed-select.html

        I used it my self to build a dynamic car make / model select.

        If linking is not allowed here and it gets removed just PM me and I'll send ya the info.
        See more | Go to post

          Leave a comment:

        • yeahuh
          replied to what is the different between get & post in PHP
          in PHP
          My understanding is that get sends the information via url
          I.E. "index.php?pg=3 &info=4631"

          And post sends the information via form. obtainable this way.
          [PHP]$first_name = $_POST['first_name'];[/PHP]

          Though I am still quite new to PHP so I could be way off....
          See more | Go to post

            Leave a comment:

          No activity results to display
          Show More
          Working...