Jump to content

Maq

Administrators
  • Posts

    9,363
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by Maq

  1. EDIT: Try removing the single quotes around NOW(). You should also back up your table by dumping it.
  2. Remove this semi-colon: elseif (($_POST['userMail'] == true) && ($_POST['subjectField'] == true));
  3. Can you post the entire error?
  4. I like to use the INSERT syntax: REPLACE INTO online_list (id, date) VALUES ({$_SESSION[id']}, 'NOW()') Please refer to the manual for more information - REPLACE.
  5. I would suggest you read and learn Database Normalization. You must utilize primary and foreign keys to link these tables. It's all covered in DB normalization.
  6. You could do it your way which would be slower, but you most likely won't notice a difference. With REPLACE you only need 1 query. You're choice.
  7. It is bad practice to use SELECT * unless you need all of the fields. Using * instead of listing just the required columns is not only inefficient, it also impacts the reliability and maintainability of your code. Just list the columns you want, it's not difficult.
  8. This isn't a trick. Check out REPLACE. It works similarly to insert except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted.
  9. I thought you wanted a watch dog...? If you want it to attack then get a pit bull, juice it up, mix gun powder in its food, and beat the shit out of him once in a while, that should do the trick.
  10. Maq

    TV suggestions

    I've never been disappointed by samsung tv's but I am pretty disappointed with my samsung cell phone right now. I've only heard positive feedback from people with Samsung TVs. Not sure I could say that same with the cellphones. Has anyone ever gamed on different types of TVs? For example if you played Call of Duty on an LCD 60Hz vs 120Hz or LCD vs Plasma. I hope the 60Hz won't lag or ghost that much.
  11. You're going to have to use cURL to obtain the contents if any fields are required to be filled in. If it's valid XHTML you can use simplexml otherwise you're going to have to use something like preg_match or preg_match_all with regex to scrape the information.
  12. Maq

    TV suggestions

    Thanks for the help guys. I finally went to the Best Buy in Delaware (tax free) and bought this for $1099.99. Samsung - 46" Class / 1080p / 60Hz / LCD HDTV Model: LN46B530 I know I could have saved money buying online but I didn't want the hassle of delivery damage and also the 3 year warranty with Best Buy was around $170 for 3 years.
  13. Or you could have changed $i=0 to $i=1.
  14. Yeah thats what I'm talking about. I tried that and it works but the number starts at 0 for some reason. Do you know how to make it start at 1? Put $i=1 before the loop. If you post the relevant code it will be easier to help.
  15. What?
  16. What do you mean dynamically? You should already have some sort of id or auto-increment values when inserting in the database.
  17. Maq

    Memberlist

    You need to create a select statement from the table(s) that your member information is on and iterate through the results. Google, "mysql php select".
  18. Maq

    Memberlist

    You should already be storing users in a table. Don't include it in your query. You just have to query the tables and fields that you want to display in the memberlist feature.
  19. Something like this: $time = strtotime('+ 1 week', $time); $date = date('m.d.y', $time);
  20. What are you using?
  21. No need for all those double quotes, then you have to escape them. Just use a double quote for the entire string, so your variable will interpolate, single quotes for attributes, and curly brackets around your associative array to escape it: echo "[{$gng['tag']}]";
  22. It's a simple href, you really need to learn how to do things on your own, or at least try. I see you ask questions here on a daily basis when you haven't even made an attempt yourself... Try:
  23. I can see when you assign date to the post values you have it in MM-DD-YYYY: $date = ("$my_t[month] $my_t[mday], $my_t[year]"); You can probably rearrange the format like so: $date = ("$my_t[year]-$my_t[month]-$my_t[mday]");
  24. Well what's your error? Also, post your current query. If you delete the WHERE you have to change the first AND to a WHERE.
  25. Yes it does. Echo $date and make sure it's in "YYYY-MM-DD" format.
×
×
  • 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.