Jump to content

Maq

Administrators
  • Posts

    9,363
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by Maq

  1. Get your hands dirty by following tutorials. Posting and reading posts on the forums.
  2. I've always wondered what your username meant...
  3. "Status of my donations."
  4. No biggie, wasn't trying to be rude sorry if that's what you thought. Welcome to the boards! As far as JS, I assume you're referring the OOP and the similar class methods it provides. Which yes, you could say if you've used DOM in JS then it would be a fairly easy transition to PHP DOM.
  5. Yeah true, I think they averaged like 30 posts a day. Plus the forums were started in the late 90's. So 30 posts for 10 years would total over 100k.
  6. I've seen a couple sites where members have 100k+, the only one that comes to mind is the IGN board (forget the URL), it's some sort of gaming site. I recall multiple members having a massive amount of posts.
  7. You need SELECT, UPDATE etc... prior to the concat function.
  8. Maq

    SQL coding

    You're right, but I assumed he was talking about MS SQL. ???
  9. Can't you see she's already using DOM? And I don't know what you mean by similar to javascript...? What part are you having trouble with? Inserting into the database or grabbing the specific information? Try and get the appropriate information displaying first, you may have to read about xpath. I don't see where you even try to insert into the database, I know you know how to do it, I've helped you with MySQL questions before.
  10. Maq

    SQL coding

    http://swik.net/MySQL/MySQL+vs+MS+SQL+Server Tizag - MySQL+PHP - very basic
  11. If you're updating 1 record you don't need a loop. Id's are usually unique any way so there's no need for LIMIT 1. EDIT again: ^
  12. Read my edit about the or die statement. That will give you a descriptive error message if your query is failing.
  13. What makes you think there's an error? What happens, or doesn't happen? EDIT: A little debugging... You shouldn't use short hand php tags, use <?php. Change this line to: $result = mysql_query($sql) or die(mysql_error());
  14. I ran you code and it worked as I expected, this may be of interest:
  15. Variables won't interpolate in single quotes. You either have to break out of single quotes (like jonsjava did) or, use double quotes.
  16. Thx premiso @gemmerz, I had the quotes correct in my post, you don't have to break out of the string for variables to interpolate, with double quotes.
  17. Change this line to: $result = mysql_query ("SELECT title, subtitle, article FROM articles WHERE id = '$currentpage'");
  18. Looks like you should be using '$currentpage'.
  19. Well where does $id come from? Before your clause was "WHERE title = '$title'" now you're using id, which is it?
  20. On the next page just do check the same way you check $searchmodel with isset.
  21. Put this right after your opening php tag <?php ini_set ("display_errors", "1"); error_reporting(E_ALL);
  22. Like revraz already mentioned you need to change: $currentpage = $_GET('currentpage'); to: $currentpage = $_GET['currentpage'];
  23. Sure no problem. You should invoke mysql_real_escape_string() on variables that are used in queries to prevent SQL Injections. i.e.: $id = mysql_real_escape_string($_GET['id']); Please mark as [sOLVED] too.
  24. There are a lot of posts in the PHP section about this. It also depends if you need to post variables, login, etc... We need more information.
  25. Sure, just pass a variable in the URL with love for its value. Yeah, errors suck. Sorry for the lack of information, but you haven't given any yourself.
×
×
  • 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.