User Profile

Collapse

Profile Sidebar

Collapse
FallingReign
FallingReign
Last Activity: Apr 18 '07, 12:27 AM
Joined: Mar 7 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • FallingReign
    replied to Recordset inside a function
    in PHP
    Yeah i meant recordset when i said DB, anyway the connection was lost somewhere and i couldnt find where so i ended up just creating a new connection inside the function. that works fine.

    thanks for your help

    Justin
    See more | Go to post

      Leave a comment:

    • FallingReign
      replied to Recordset inside a function
      in PHP
      which is unusual.
      The DB isn't empty and I can echo the data from the DB just outside of the function brackets.

      is there any way around the error?
      See more | Go to post

        Leave a comment:

      • FallingReign
        started a topic Recordset inside a function
        in PHP

        Recordset inside a function

        Hi I have a function that is called when a user submits the signup form.
        Its supposed to check with the users in the DB whether the user name exists and then return true or false...

        i keep getting this error...
        Warning: mysql_num_rows( ): supplied argument is not a valid MySQL result resource in /home/www/domainname/signup.php on line 22

        $rsUsers is the record set
        $sValue is the username im comparing...
        See more | Go to post
        • FallingReign
          replied to Export Table to .csv (tab delimited)
          in PHP
          Im using Dreamweaver MX 2004 so im not sure what version of PHP that is but that function isn't supported......
          See more | Go to post

            Leave a comment:

          • FallingReign
            replied to Export Table to .csv (tab delimited)
            in PHP
            Also here is how my tables look in the SQL DB

            Database

            -Affiliates (table)
            --refid
            --email
            --name
            --surename
            --etc..

            -Sales (table)
            --refid
            --payment
            --type
            --etc...
            See more | Go to post

              Leave a comment:

            • FallingReign
              started a topic Export Table to .csv (tab delimited)
              in PHP

              Export Table to .csv (tab delimited)

              Hi, i was wondering if anyone could help me export a table that i have created to a tab delimited csv file...

              Code example of my Query and print:
              [PHP]mysql_connect($ server, $db_user, $db_pass)
              or die ("Database CONNECT Error");

              $result = mysql_db_query( $database, "SELECT sum(payment) as payments, email, sales.refid FROM sales,affiliate s WHERE sales.refid=aff iliates.refid group...
              See more | Go to post
              • FallingReign
                replied to PHP MySQL Query
                in PHP
                There is alot more information than just those values and it would require me to rewrite alot of the website to have the email field in the Sales table.

                I was just hopeing that there was some code that i could use instead to retrieve them both....
                See more | Go to post

                  Leave a comment:

                • FallingReign
                  started a topic PHP MySQL Query
                  in PHP

                  PHP MySQL Query

                  Hi i was wondering if anyone could help me to get information from 2 different tables in my database...

                  Associates (table)
                  -ID
                  -email

                  Sales (table)
                  -ID
                  -payment

                  What I need to do is have the above information displayed in a table like the one below. both ID's in the tables sales and associates are identical.

                  Code:
                  [B][U]Email               |  Payments  |  ID  |[/U][/B]
                  ...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...