Jump to content

GoneNowBye

Members
 View Profile  See their activity

  • Posts

    119

  • Joined

  • Last visited

 Content Type 

Everything posted by GoneNowBye

  1. GoneNowBye
    instead of y-m-d or whatever use an integer colomn and put the time() value into the number of seconds since the unix epoch - the first second of 1970. then just "order by `last_post` desc"
  2. GoneNowBye
    http://alec-teal.com/ the site i want to add the little icon which apears as the icon for the tab - i think its called FavIcon or something? could i have a sample tag? name? link something like that. i know its not entirly php, well not even php at all. most relivant place to ask though thanks. Oh and please do click the link i'd like to see if you guys like/hate it. Thanks
  3. GoneNowBye
    you could also use a nested slelect select id,email,(select country from country where country.id = user_detail.id) as country from user_detail i find that easier
  4. GoneNowBye
    Oh comon please
  5. GoneNowBye

    Sorting

    GoneNowBye replied to Deivas's topic in MySQL Help

    the limit clause works as so Limit 5 is the same as Limit 0,5 which means limit to 5 rows after the zeroth row (start) limit 5,5 means limit 5 rows after the fith row (return 5 from the 5th, so page two) limit 1,100 return 100 rows after the first returned rows (see rows 2-102) (starting from row one) you want limit ((page_number-1)*number_per_page),number_per_page assuming your pages start at one that way the 1st page is limit of 0 to number per page. many people think its the row range returned, that 10, 100 returns 90 rows, from the tenth to the hundreth, but its not its 100 rows after teh tenth result. hope i helped
  6. GoneNowBye
    the first post example is what i'm looking for i'd like to know the number and types of queries people have done - idealy live
  7. GoneNowBye
    Please i really need this
  8. GoneNowBye
    echo('<a href="view_artist_details.php?id='.$row->id.'">'.$row->artist.'</a><br>'); your welcome
  9. GoneNowBye
    anything?
  10. GoneNowBye
    (sorry i didn't read the above) but here's what i'd do for the origonal post stuff_i_can_buy [id][name]....whatever stuff_styles [id][name][stuff_i_can_buy.id] and that could be Green assigned to item 2 and have stuff_sizes[id][stuff_i_can_buy.id] you could even put those into one table and have a colour colomn set to zero for sizes or whatever hope this helps
  11. GoneNowBye
    No thats not my question, i want to be able to track user's usage to mysql, like a webhost would, but i myself have my own server, any more thoughts?
  12. GoneNowBye
    please help
  13. GoneNowBye
    ADDITIONAL: no mysql version included because the suggestion may include that, (i'm happy to "downgrade" if need be) no other "READ BEFORE POST" statements apply
  14. GoneNowBye
    Just echo it, make sure you're storing them in a binary colomn - Blob, i'd also store a mime type: in php: " header('content-type: img/jpg'); echo($image_binary_data); " sorted
  15. GoneNowBye
    Heya guys, long post in a while, i'm alittle stuck, I need a version of SQL which logs to a table the count (or something) of users' usage for example: Name | sel | upd | ins | del -------------------------------------- person_a | 12 | 13 | 18 | 20 person_b | 15 | 22 | 10 | 50 they were just some numbers but HOPEFULLY it shows what i mean i have found ExtSQL but i'd really like something which is just double click, i'm a windows user btw, i understand google did something but that's *nix only. Please Help Thanks
  16. GoneNowBye
    <body onLoad="javascriptFunction(FUNCTION NAME);"> or <body onLoad="javascript:FUNCTIONNAME();">
  17. GoneNowBye
    thanks -.-
  18. GoneNowBye
    last thing before i call this solved, how do you make a javascript function execute on page load?
  19. GoneNowBye
    okay thats alll good how did geoforms do it is there any other way you can think of? at all (i do know what php does dont worrie - hence i dragged my loly question here)
  20. GoneNowBye

    Using &

    GoneNowBye replied to BahBah's topic in PHP Coding Help

    Thanks
  21. GoneNowBye
    how does that translate to named arrays?
  22. GoneNowBye
    you could not sort multiple data sets against each other anyway, not without grouping them and sorting the subgroups. unless they were exectly preportional x=ky for example, but then why would you want to sort both?
  23. GoneNowBye
    been there done that, but more advanced stuff, - reolution for example my old geoforms site did do it somehow by default, without javascript any ideas as to how
  24. GoneNowBye
    What does the foreach thing do? and how does it work? i've never quite got it and this seems a good thread to ask
  25. GoneNowBye
    IP adress Host Name User-Agent - Browser - Version - OS but what else? resolution? what else can you obtain about your visitors from / though php. I would like to find out visitors resolutions is this actually doable in php (lf not how would it be done) Havok
×
×
  • 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.