Posts by Mr. Majestic

21) Message boards : Number crunching : MYSQL frustrations (Message 854909)
Posted 18 Jan 2009 by Profile Mr. Majestic
Post:
I'm not trying to do a sales pitch or anything, but if you are trying to do PHP and MySQL, I found a very good book that will teach you both, and gives you examples both in the book and online.

Apress - Beginning PHP and MySQL 5: From Novice to Professional, Second Edition

I was completely self-taught for HTML, and wanted to learn how to make my own PHP-BB forum. I haven't gotten around to it yet, but this book is awesome.

You actually don't need to know any PHP or MYSQL at all to set up phpbb3. all you need is a server with php and mysql, and Database and your set.


As long as you know how to upload files to a server and change some permissions you should be more or less set.
22) Message boards : Number crunching : MYSQL frustrations (Message 854908)
Posted 18 Jan 2009 by Profile Mr. Majestic
Post:
could 'key' be a reserved variable in sql ? try other one ..

That's it!!!!! Thank you so very much! ;)


Hi

Glad you solved your problem. I thought I would share mine. My very first ever PHP page and MYSQL project failed because of something called "Magic Quotes". I think it took me two weeks of asking on microsoft.public before someone told me that if I pass a string in quotes to a sql command from a web page that quotes are removed. Anyway, I did manage to get it to work but I think the person who invented the "PHP magic quotes" should have been strangled as a small child. That is just my personal opinion and not worth 2c.

Anyway, the page is at http://swri.info/cpustats check it out. If you get yours working, share it.


Mine already works...... The UFO Files

I am programming an admin panel so I can add and edit the articles more easily though. I am basically making my own CMS. I wasn't satisfied with Joomla or any of those, so i decided to just make my own ;)
23) Message boards : Cafe SETI : The Last Person To Post Wins #78 - Magenta Wins! (Message 854826)
Posted 17 Jan 2009 by Profile Mr. Majestic
Post:
1344
24) Message boards : Number crunching : MYSQL frustrations (Message 854817)
Posted 17 Jan 2009 by Profile Mr. Majestic
Post:
could 'key' be a reserved variable in sql ? try other one ..

That's it!!!!! Thank you so very much! ;)
25) Message boards : Number crunching : MYSQL frustrations (Message 854815)
Posted 17 Jan 2009 by Profile Mr. Majestic
Post:
yes, just double checked
26) Message boards : Number crunching : MYSQL frustrations (Message 854807)
Posted 17 Jan 2009 by Profile Mr. Majestic
Post:
the code now looks like this:

<?php
$title = $_POST['title'];
$text = $_POST['title'];
$des = $_POST['des'];
$key = $_POST['key'];
$src = $_POST['src'];
mysql_connect ("localhost", "USER", "PASS") or die (mysql_error());
mysql_select_db ("DB");
$sql="INSERT INTO articles (id, title, des, key, text, src) VALUES ('NULL','".$title."','".$des."','".$key."','".$text."','".$src."')";
mysql_query($sql) or die (mysql_error());
echo "Db update done!";
?>


but it returns this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key, text, src) VALUES ('NULL','test','test','test','test','test')' at line 1
27) Message boards : Number crunching : MYSQL frustrations (Message 854650)
Posted 17 Jan 2009 by Profile Mr. Majestic
Post:
that didn't fix it
28) Message boards : Number crunching : MYSQL frustrations (Message 854644)
Posted 17 Jan 2009 by Profile Mr. Majestic
Post:
mysql_query("INSERT INTO articles (title,des,key,text,src) VALUES('$title','$des','$key','$text','$src')")or die(mysql_error());

probably something really obvious that I'm missing, but what's wrong with this syntax?
29) Message boards : Cafe SETI : The Last Person To Post Wins #78 - Magenta Wins! (Message 854309)
Posted 16 Jan 2009 by Profile Mr. Majestic
Post:
Winning after finally getting my opp app set up on my quadie ;)
30) Message boards : Cafe SETI : What Is Your Weather Like? (Message 854034)
Posted 16 Jan 2009 by Profile Mr. Majestic
Post:
-4F with wind chill

Tomorrow:
-25 with wind chill :(
31) Message boards : Cafe SETI : Back with the project ;) (Message 851772)
Posted 10 Jan 2009 by Profile Mr. Majestic
Post:
LOL

Meow.......we always come back, don't we?

I couldn't bear being away from the kitties any longer anyway
32) Message boards : Number crunching : Network question. (Message 851766)
Posted 10 Jan 2009 by Profile Mr. Majestic
Post:
Thank you! Works like a charm now ;)
33) Message boards : Cafe SETI : Back with the project ;) (Message 851764)
Posted 10 Jan 2009 by Profile Mr. Majestic
Post:
LOL
34) Message boards : Number crunching : Network question. (Message 851760)
Posted 10 Jan 2009 by Profile Mr. Majestic
Post:
I don't know how to set this option on vista. I know that in XP you just go to the folder options menu in explorer, but that isn't there in Vista. Anyone know how to do this?
35) Message boards : Cafe SETI : The Last Person To Post Wins #78 - Magenta Wins! (Message 851750)
Posted 10 Jan 2009 by Profile Mr. Majestic
Post:
In for the win.
36) Message boards : Cafe SETI : Back with the project ;) (Message 851748)
Posted 10 Jan 2009 by Profile Mr. Majestic
Post:
Not as much fun I must say...... Rosetta didn't want to agree well with some stuff, so I gave up on that....
37) Message boards : Cafe SETI : Back with the project ;) (Message 851741)
Posted 10 Jan 2009 by Profile Mr. Majestic
Post:
Wow! That was fast :)
38) Message boards : Number crunching : Network question. (Message 851738)
Posted 10 Jan 2009 by Profile Mr. Majestic
Post:
Ok, I currently have my Windows vista networked to an ubuntu server. I am using samba to achieve this.... The only problem I have is that on the windows comp you can't see the hidden (.) files.... Is there any way to achieve this?
39) Message boards : Cafe SETI : Back with the project ;) (Message 851736)
Posted 10 Jan 2009 by Profile Mr. Majestic
Post:
I'm back ;)
40) Message boards : Cafe SETI : Back with the project ;) (Message 847119)
Posted 31 Dec 2008 by Profile Mr. Majestic
Post:
Well, I'm leaving this project for awhile. This is only going to be a temporary thing.... a few months most likely. I just feel that my CPU time could be used for more useful research. I am all for finding ET.... it would be one of the greatest discoveries in man's history, but it won't help with today's real at home problems. I am switching all my comps over to Rosetta@home for awhile. SETI@Home is the biggest BOINC project at the moment and has more than enough help for the moment. Rosetta@Home is doing research that could potentially save lives and is in FAR MORE need of help than this project. I hope that you all understand my decision...... I do plan to return to this project after awhile though as I still DO FEEL IT IS IMPORTANT.

- Mr. Majestic (John)


Previous 20 · Next 20


 
©2024 University of California
 
SETI@home and Astropulse are funded by grants from the National Science Foundation, NASA, and donations from SETI@home volunteers. AstroPulse is funded in part by the NSF through grant AST-0307956.