Azu

I don't understand then.. how do I store a bunch of On/Off values?

well thankfully it's a MyIsam table not InnoDB! Please tell me how do I recover my data from it? I'll be very very happy ^^ And I was doing a lot of work on my database, I had to delete some stuff, and I meant to replace the delete with a select but I left it by mistake

Hey I'm sorry but this is kind of urgent.. please can somebody help soon?

Does this still apply if I use divs but set them in CSS to act like tables? Or is that just as bad?

I don't get it. If you replaced all of those DIV with TABLE UL with TR and LI with TD How would it make the syntax incorrect and stuff? I'm confused..

A hear a lot of bad things about the accessibility and spiderability of tables. Can somebody please explain to me why? I like tables because they can line things up nice and neatly ^^

File download sites are more about speed and usefulness instead of bloat and shininess like most sites are. As long as it's fast and doesn't slow down under load and it works right, it's good. ^^

x_x I accidently put in "delete from table" instead of "select * from table" =/ Is there any way that I can recover my data from it? I don't have any backups of this table.. Edit: I think I found a log file "ib_logfile0" can I use this to recover?

http://www.google.com/search?hl=en&q=http+headers&btnG=Search

It's not really possible to accurately gage this since things like parked domains will skew any test that is done.

If it didn't list any headers then that's probably your problem right there. Browsers require headers from the server.

There's also an extension that lets you have multiple homepages so they all open up when you start Firefox. (I forget what it's called sorry)

Thanks that will work ^^ I don't understand why I can't index it though.. I want it to be fast.. Would it be faster just to make add like 40 tinyint(1) rows?

Thanks but I don't understand. If I can't index it how do I prevent it from being slow? And what is the command I need to use for the select?

Well then make a PHP application that displays a webpage correctly. Good luck because microsoft has failed in their attempts to even make a BROWSER that does this correctly.

Then post the python here so one of us can help you translate it.

Symbol (name) Value Symbol Value Symbol (name) Value kB (kilobyte) 1000^1 = 10^3 KB 1024^1 = 2^10 KiB (kibibyte) 2^10 MB (megabyte) 1000^2 = 10^6 MB 1024^2 = 2^20 MiB (mebibyte) 2^20 GB (gigabyte) 1000^3 = 10^9 GB 1024^3 = 2^30 GiB (gibibyte) 2^30 TB (terabyte) 1000^4 = 10^12 TB 1024^4 = 2^40 TiB (tebibyte) 2^40 PB (petabyte) 1000^5 = 10^15 PB 1024^5 = 2^50 PiB (pebibyte) 2^50 EB (exabyte) 1000^6 = 10^18 EB 1024^6 = 2^60 EiB (exbibyte) 2^60 So basically a gigabyte to the power of 4

64bit MySQL should be able to overcome the 4GB limit easily, no? I'm pretty sure 64bit can handle up to 16 exabytes, which there is NO WAY IN HELL you are going to use up all of.

Thanks guys! And it's not a problem if more then 1 mysql query is required, as long as there isn't a limit on recursion. I still don't understand how I need to use joins to do this though.. if it would be against forum policy for you to post the whole query for me.. maybe I could buy it? What would it cost? *doesn't have much*

Mm to many validation errors. Even though you have it set to transitional which is very lax and ignores most errors, there are STILL tons showing up!

Oh okay thanks ^^ I was putting it in the wrong place. It stopped giving an error now. But it seems to only return the post count 1 level deep.. I could have done that with just a simple select id,(select count(*) from posts where question_id=topics.id) from topics It needs to recurse as deep as it goes. That's what I don't know how to do in MySQL..

It doesn't change the error at all.

Thanks but that wasn't it. And I'm not even sure what I'm supposed to do with this query even if I do get it to run :s

You could try looking at what the python code sends and have your PHP code send that?

Hmm not sure about those but I think PHP has a built in error checker/bugger it gives me fairly good reports if there is something wrong with my regex.