User Profile

Collapse

Profile Sidebar

Collapse
thepresidentis
thepresidentis
Last Activity: May 20 '07, 07:12 PM
Joined: Feb 11 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • thepresidentis
    replied to Evaluating variables in a string
    in PHP
    Like This?
    Code:
    echo "[<a href=\"$SAVE"\>Save This Event</a>]";
    See more | Go to post

      Leave a comment:

    • thepresidentis
      started a topic Evaluating variables in a string
      in PHP

      Evaluating variables in a string

      does anyone know how to create a link in php to evoke the actions of a variable?
      here is what i have so far and it is not working.
      [CODE=php]
      echo "[<a href=\"$SAVE">S ave This Event</a>]";
      [/CODE]
      See more | Go to post
      Last edited by pbmods; May 20 '07, 06:47 PM. Reason: Changed code language. Thanks for using CODE tags!
      • thepresidentis
        replied to saving data to another database
        in MySQL
        would it be possible to create a clickable link to envoke a variable called
        Code:
        $SAVE = mysql_connect("host","username","password");
mysql_select_db("userdb");
$query2="insert into map_userconcert (userid,concertid) values ('".$userid."','".$concertid."')";
mysql_query($query2);
        See more | Go to post

          Leave a comment:

        • thepresidentis
          replied to saving data to another database
          in MySQL
          p.s the users db is a seperate database than the concerts database

          here is my structure

          Database: EVENT DATA
          Table:Events
          then there is a seperate fields for State, city, metro area, etc...

          Database: UserDB
          Table: Active_guests
          Table:Active_Us ers
          Table:Banned_us ers
          Table:Map_userc oncerts
          Table:Users
          See more | Go to post

            Leave a comment:

          • thepresidentis
            replied to saving data to another database
            in MySQL
            Thanks for all the info, it is really helping...
            I am still a little confused(sorry)
            on map_concerts does there need to be an index?
            I have 2 fields
            userid and concert id.
            See more | Go to post

              Leave a comment:

            • thepresidentis
              replied to saving data to another database
              in MySQL
              also could I just register the primary Key as a variable and just save the Primary Key in the saved events column in the USER REG DB?
              I am Hoping this will save disk space rather than saving all of the show information again.
              See more | Go to post

                Leave a comment:

              • thepresidentis
                replied to saving data to another database
                in MySQL
                okay. Thanks
                one more question though,
                how would I send the data from the concert listing to the database?
                i was thinking that i could create the save this show link and then if they were to press it then it would call a function?
                that would use insert into.
                but my problem is that i am still new to coding with php, and I am not sure how to pass the data stored in the variables to a function that will use insert into....
                See more | Go to post
                Last edited by pbmods; May 17 '07, 10:29 PM. Reason: Changed code language. Thanks for using CODE tags!

                  Leave a comment:

                • thepresidentis
                  replied to href to link file
                  in PHP
                  Have you tried registering the primary key as a variable and linking to a query for the primary key which will return only one result?
                  then format the result you do not need to link externally this can all be done in the same script.
                  See more | Go to post

                    Leave a comment:

                  • thepresidentis
                    started a topic saving data to another database
                    in MySQL

                    saving data to another database

                    I have a database that users can search for concert listings.
                    I also have a user registration database where users can log on.
                    I want to be able to have a link in the search results for the concert listings to save the show information to their profile.
                    I have thought long and hard about this but I am still green on PHP
                    I thought i could create a link next to the each concert listing (SAVE THIS EVENT) and then send the...
                    See more | Go to post
                    Last edited by thepresidentis; May 16 '07, 11:06 PM. Reason: forgot a word
                    • thepresidentis
                      started a topic problem with returning all search results MYSQL PHP
                      in MySQL

                      problem with returning all search results MYSQL PHP

                      here is my problem,
                      i have a website that compiles concert listings for users to search for shows in their local area, i ran into a problem with returning search results due to an improper format of my query, So i formatted the query properly Thanks to steve Klein :) , and all worked fine because there was only 1 show in my data base,
                      I tryed to search for the show and it returned properly, and then i searched for the show with a...
                      See more | Go to post
                      • thepresidentis
                        started a topic problem with returning all results from search query MYSQL & PHP
                        in PHP

                        problem with returning all results from search query MYSQL & PHP

                        here is my problem,
                        i have a website that compiles concert listings for users to search for shows in their local area, i ran into a problem with returning search results due to an improper format of my query, So i formatted the query properly Thanks to steve Klein :) , and all worked fine because there was only 1 show in my data base,
                        I tryed to search for the show and it returned properly, and then i searched for the show with a...
                        See more | Go to post
                        • thepresidentis
                          started a topic PhP and Flash
                          in Flash

                          PhP and Flash

                          i want to make a site with flash that users can fill out a form and store it in a mysql database, and users can also search the data base with a form. then return results inside the flash movie.

                          does anyone know how to do this or know of a tutorial?
                          See more | Go to post
                          No activity results to display
                          Show More
                          Working...