Jump to content

jawbreaker

New Members
  • Posts

    6
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

jawbreaker's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I am looking at a way to store a list of ids from a form. What I have is a form in php that lists a group of devices that I need store in a table in a mysql database. This form is dynamic in length. ---- Sample Form ---- Device #1 Device #2 - SELECTED Device #4 Device #5 - SELECTED Device #6 Device #7 - SELECTED Device #8 - SELECTED --------------------- So I want to take 2, 5, 7, 8 and store it into a database so I can recall it later and make a report on the items selected in the form. Would an array work in this situation? What type of solution would work for this?
  2. Lets say I have two tables NameID  Name ------------------- 1        Joe 2        Steve 3        Marty 4        Doug ------------------- ID  NameID  Last LogIn ------------------------- 1  1        2006-01-01 2  1        2006-01-02 3  2        2006-01-02 4  3        2006-01-03 5  4        2006-01-03 6  4        2006-01-04 7  1        2006-01-04 8  2        2006-01-04 ------------------------- I have joined the tables (on name ID) and now I want to add to the sql statement so that it lists each of the peoples last login and only the last login. I have tried to use GROUP BY but it only gives me the first login and not the last login. I need the output to look like the following Joe 2006-01-04 Steve 2006-01-04 Marty 2006-01-03 Doug 2006-01-04
  3. How would I use the mktime() function using two variables? $Date = 2006-01-01 $MonthsToAdd = 6
  4. I have a date stored in a MySQL table that I need to add a number of months to stored in another MySQL table. The date is stored in the date format in one of my tables: YYYY-MM-DD. How do I add the month to this date using PHP?
  5. Thank you for the help. Changing that option in the config. file worked.
  6. I have a problem with either the php code or the configuration of my server. I am trying to upload files to a mysql database and it works until I try and upload a file larger than 1MB. I tried to increase "max_allowed_packet" on my mysql server and that did not work. I still get the following error. Warning: fread(): supplied argument is not a valid stream resource in Again this only happens when I try and upload a file larger than 1MB.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.