Jump to content

NovaHaCker

Members
  • Posts

    15
  • Joined

  • Last visited

    Never

About NovaHaCker

  • Birthday 10/26/1985

Contact Methods

  • MSN
    novastorm02@hotmail.com

Profile Information

  • Gender
    Male
  • Location
    Adelaide, Australia

NovaHaCker's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I believe you can just set the destination folder as read/write with no execute permissions at all. Might need someone else to clear that one, but i think its right.
  2. what exactly do you mean by changing it? Photoshop would be the easiest option or you could use GD
  3. Also it is a very good habbit to get into at an early stage to write proper SQL Queries, do not use SELECT * where ever you can, include specific column names in your queries. eg SELECT column1, colum2, column3 FROM table It reduces the load on the database and it also protects your scripts from failing if the database is updated in a manner that affects your code.
  4. [code] $result=mysql_query("SELECT UNIX_TIMESTAMP(datetime) As timestamp, datetime FROM Topics WHERE Parent=0 ORDER BY timestamp", $forumdb); [/code]
  5. GD, but i would presume that it would be harder to code initially then to simply use something like paint or photoshop, unless you intend for it to be an active tree that is going to be used and updated enough to warrent such coding time. On the other hand though, there might already be open source software around the place that does it already, take a look.
  6. [quote author=mlin link=topic=119009.msg486802#msg486802 date=1166388321] select * from table_name where column like 'a%' [/quote] I agree, best to solve as many data issues at the sql script instead of sorting this out in PHP, so the above SQL query would be correct.
  7. I had a problem along this line a week or so back. I had to pipe data out from a ssh command into 5 different boxes, and quite understandably I didn't want this command to be run everytime the user hit the page. So I took the results and inserted them into what id call a cache table in the database with a timestamp, and when the user hits the page it checks the timestamps of any data, if any and if it is within the expiry time then simply use the data from there, otherwise flush the old stuff out, if any and again generate the data from the other servers. Not sure if i explained it very well, but using this method has put one of our longest loading pages on par with the rest of them, and the best thing is that it doesnt require a cron script, as it only gathers data on demand and the cache table is self maintaining.
  8. You have to select the data from the database in unix timestamp format then order it [code] SELECT UNIX_TIMESTAMP(datetime) As timestamp,           datetime FROM table ORDER BY timestamp [/code]
  9. also i might add that str_replace is not the function that you will be using for something like this, more like preg_match from memory. Sorry I don't do a terrible amount of work in this area to be of more use.
  10. It is possible, You will need to get involved with regular expressions to accomplish this. A simple google search will yield lots of results. Hope this helps.
  11. When you use header, you must ensure that nothing has been written to the document at all, otherwise the header command will return that error. Hope this helps.
  12. I am just using plain old php and sql, Plus i have never had to download anything other than the executables before anyways?? But ill try it anyways Thanks, Brenton
  13. im not sure if this would help but i was just looking in the WinMySQL Admin thingy and on the opening page with the ODBC This is what is displayed in the box below it Not Found Driver 3.51 not found I am so puzzeled Ive never had this much trouble b4
  14. This is an error being reported from one of my scripts Warning: your browser was not able to connect to the database-server. Please try to reload the page by clicking on reload. If this problem is still there, contact the administrator:
  15. I lost windows XP over the long weekend so i reinstalled her Now I redownloaded and reinstalled IIS 5.1 PHP 4.2.3 mySQL 4.0 I can access my .php pages through the browser but cannot connect to the database at all!!! The username and password have been set properly. I can\'t think of anything else that could be wrong :\'( Please help Thanks BRenton
×
×
  • 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.