onedumbcoder

dont worry about it Makeshift67, we all start out look dumb TO PEOPLE WHO HAVE BEEN DOING IT FOR YEARS. so don't take offense. here is what you need, not a book: http://www.tizag.com/mysqlTutorial/

unless the database is backed up on a hourly, daily, weekly or monthly bases, no. A database unlike your pc, is constantly reading, writing, and deleting on it's hard drives, so even a data recovery software would not be of any use to you.

WARNING I JUST GOT A VIRUS ALERT DOWNLOADING THAT!!!! MODS DELETE THAT FILE ASAP!!!!! Edit (Daniel0): Removed annoying formatting.

np, gl.

I am working on a game from my younger 9 yr old brother and I had to come up with some sort of equation like that and it turned out is was really easy, here is what I used: SELECT (number_of_jews_killed + number_of_arabirans_killed) AS level_of_greatness FROM hitler_kills WHERE date_stamp < DATE_ADD(NOW(), INTERVAL -1 DAY);

i left join table2 and i want a value returned from that to be used in the where condition. so both table1 and table2 have a field called sheep. I want to query to execute only if what is returned by the left join is equal to the value stored in table1 (table1.sheep = table2.sheep) or is nothing is return by the left join of table2 I have this and it is not working UPDATE table1 LEFT JOIN table2 ON (table2.type = 3) SET table1.type=3 WHERE table1.sheep = table2.sheep OR table2.sheep = ''

No idea what is wrong with it, but I am trying to get the top scores for "SELECT number_of_kills FROM kill WHERE type == 'jews' OR type ='arabirans' AND method='chamber' ORDER BY number_of_kills LIMIT 10 it is not returning the correct data, what it is suppose to do is return the top players for the chamber kills, and instead is returning scores that make no sense.

never mind it does not work and i can not delete this question.

is there anything wrong with doing it this way: $result = mysql_query($query) or die(mysql_error()); echo count($result); if all you care about is that the query returns at lest 1 row.

off topic, but corbin are you by any chance racist? I got that eerie feeling reading your post.

You are both wrong. You can use a WHERE in a insert statement, but not with the syntax typed above. INSERT INTO tableA(id,name) SELECT id, name FROM tableB WHERE age > 33

Thanks so much, that did it.

try this $result = mysql_query("select id AS total from user WHERE age > 33"); echo mysql_num_rows($result);

never mind, it is not possible to do what I want with mysql.

select count(id) from user WHERE age > 33 now when i execute that query how to i echo that value? $result = mysql_query('select count(id) from user WHERE age > 33'); $count = mysq_fetch_array($result); echo $count[???];