Jump to content
xisto Community

nightfox1405241487

Members
 View Profile  See their activity

  • Content Count

    666

  • Joined

  • Last visited

Everything posted by nightfox1405241487

  1. nightfox1405241487
    ok,ok... I took an example from my other php book and now, I replaced $row = mysql_fetch_array(mysql_query($sql)); to $result = mysql_query($sql) or die(mysql_error()); and now, I got a different error message: Column 'id' in where clause is ambiguous At least it is better than working with Microsoft errors which tell you nothing... I can partly understand what that means... Edit: Ok, I re-did the code and it's now this: $sql = "SELECT * " . "FROM users u " . "JOIN content c " . "WHERE u.access_name='$active_user' AND u.id = 'c.cid'";$row = mysql_fetch_array(mysql_query($sql));not producing any errors, but now I see my "Invalid ID or General Error" message even when I try to execute the script with a VALID access name (test.php?id=access_name) [N]F
  2. nightfox1405241487
    Didn't work.... I don't even know how it works... I'm going off the pointless examples that don't make any sense... I've been googling & looking through my PHP & MySQL books... so based on these confusing examples, I revised my code to this: $sql = "SELECT * " . "FROM users u " . "JOIN content c " . "WHERE access_name='$active_user' AND id = 'id'";$row = mysql_fetch_array(mysql_query($sql));and for some reason, it's complaining about this line:$row = mysql_fetch_array(mysql_query($sql)); It's always that line whenever I work with MySQL... that's why I hate working with it so much... [N]F
  3. nightfox1405241487
    OK... I'm stuck and getting frustrated... I have two tables: -users -content The users table contains the following: -id -user -pass -access_name The content table contains the following: -id -content Here's my test file code: <?php$username = "root";$password = "";$hostname = "localhost"; $database = "join-test";$dbh = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");mysql_select_db($database) or die("Unable to connect to database. Check connection settings.");// #############################################$active_user = $_GET['id'];// #############################################$sql = "SELECT * FROM `users, content` WHERE `access_name`='".$active_user."' AND `users.id`=`content.id`";$row = mysql_fetch_array(mysql_query($sql));if($row['id']!="") {?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://forums.xisto.com/no_longer_exists/ http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><title>Untitled Document</title></head><body><?phpecho("User's profile:<br>".$row["content"]."");?></body></html><?php}else{die("<h1>Invalid ID or General Error</h1>");}?><?phpmysql_close($dbh);?>which gives me the following error whenever I try to access it even WITH a VALID access name: I think I joined the tables wrong with: $sql = "SELECT * FROM `users, content` WHERE `access_name`='".$active_user."' AND `users.id`=`content.id`"; but I'm not sure how it should be. I've been googling for about an hour and I'm really confused on how this should be! [N]F
  4. nightfox1405241487
    Hey,hope to see you around sometime![N]F
  5. nightfox1405241487
    Me too! Though I hate it when people call me the "computer nerd"... sometimes (depends on who it is though) I'll usually correct them with "computer geek" [N]F
  6. nightfox1405241487
    haha! same! it was 1 year for me in April. I still remember my first site before I went away for a while... it was dumb anyways and I wanted to start again. And now I have! You're lucky your a mod here. I'd LOVE to mod at Xisto! In my old days, I was a mod on a smaller forum but active none the less. The forum admin and I have been friends since and he said I could probably have my old position back when his new forum picks up. gotta love it! Well, I think I've gone off topic enough Anywho, yeah, Xisto... it's great. The community is so addicting now that sometimes I forget about my credits and I'll be like, "oh shoot! I need to post!" But then you get wrapped up in the wonderful community! Normally, I'm not a fan of "post to host" sites, but Asta is different... way different! [N]F
  7. nightfox1405241487
    Doesn't explain WHY it happens in Diet Coke and not in Regular Coke. I'm not a pop expert, but what is the difference between regular and diet?? That difference could be the reason why it erupts! Also, who on earth thought of putting MENTOS in DIET COKE?? I never would think of something as crazy as that... [N]F
  8. nightfox1405241487
    Yeah.. it's XP with 10 gigs of graphics. All the "new" features in Vista have already been done in Linux and MS could just save some time and money by just putting all these "security things" in XP Service Pack 3... [N]F
  9. nightfox1405241487
    hehe.. you don't seriously think the drinks alone cost $5000, main course $20,000 and dessert $10,000, do you? [N]F
  10. nightfox1405241487
    Anyways, back on topic of MySQL connections...That message is just a sort of "protection" for MySQL. if it allowed many connections, the MySQL server could crash due to a high amount of connections. It is sorta the server's "safety backup" kicking in. I guess a lot of people are using MySQL then.This should be nothing to worry about.[N]F
  11. nightfox1405241487
    If I remember correctly, you don't lose all your credits... assuming OpaQue coded it, he was nice enough and leaves you 5 credits (correct me if I'm wrong) to get started with because the system would suspend you at 0 credits and you'd need 4 to get unsuspended. So it's easier to just leave you with 5 or whatever the number is. [N]F
  12. nightfox1405241487
    @lonebyrd: you can check server services & load in Cpanel. Login, under General Server Information in the left column, at the bottom above the language selection box, click on Server Status. Xisto's basic server status can be found here: http://forums.xisto.com/no_longer_exists/ @vujsa: I did it again and yet again I got a corrupt tar file! Also, it's 11:33 PM EST (GMT -5) and the server load is 0.40 and my line is perfectly fine. How is it timing out?? Also, this is a FRESH installation of Windows too since I nuked my hard drive accidentally due to a Linux/Windows partitioning problem. [N]F
  13. nightfox1405241487
    Yeah, I'm a little "mixed" on this too. On one hand, it seems good. On the other hand, it's like "OMG! We made a mistake!". I'm not sure how to see the acquisition. From a business stand point, it's like "They just want the money" but from the end user stand point, it's like "wow... what's going on here?!"[N]F
  14. nightfox1405241487
    Wow, that's a lot! I'll have to find some time to read it all and absorb it! lol [N]F
  15. nightfox1405241487
    ok, I'll have to take a look at this later when I have time! [N]F
  16. nightfox1405241487
    Personally, I only use MySpace to keep in touch with friends & friends who no longer live near me. otherwise, I do hate myspace and here's why!1) The coding SUCKS... whoever did it (*cough* tom *cough*) did a terrible job.2) ADS ADS ADS ADS ADS... it's owned by a MULTI-BILLION DOLLAR company... WHY SO MANY ADS?!?!3) Terrible network... even Yahoo and google are faster & they carry more users! Plus, I'll get routed to a down server because of a faulty load balancing system & the damn load balancing system won't put me on a server that is UP or I'll get a bunch of "Server Busy" messages.4) Windows servers... need I say more??5) Data center doesn't TEST backup generators!! Thank goodness MySpace is NOT a hosting company anymore (I believe before tom got his hand on the domain, it was a hosting company)That's just a basic rundown...[N]F
  17. nightfox1405241487
    Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always learned ONE table... put EVERYTHING in one database table.I'm making a profile system so there needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two together? I could probably figure this out faster if someone explained and posted sample SQL code that shows how the two are linked together.Thanks!![N]F
  18. nightfox1405241487
    Ok, that is just wrong. Agreed with the whole "Hitler Nazi" thing... comparable to it, very much so. Actually, the boy scouts aren't that bad... fun camp outs, merit badges, but I think the "Piracy Badge" justs pushes it a little too far. I know piracy is bad and wrong, but come on! Would you turn someone in just for downloading ONE MP3?? I think all of us have downloaded at least ONE MP3 illegally. I find it is a great way to try new artists. That's how I got hooked on AFI & I want to buy their latest CD. "Borrowing" also helps because I don't really get any "good" radio stations in my room.. the signal is all static or junk. Or, my favorite radio station (which I can't get in my room, go figure) posts song titles online of what they've played so I'll go and look up a song and see if I like it or not.If there are any boy scouts here who want their "Piracy badge", I'll let you gladly turn me in.[N]F
  19. nightfox1405241487
    It gives me a 14 megabyte corrupt tar file. I don't think it is working. I clicked on "Download Today's Back-Up" and it was nothing. Empty 14 meg corrupt tar file... OpaQue will probably need to take care of this. It normally works perfectly. [N]F
  20. nightfox1405241487
    So? Look at the bright side, you won't have signals colliding and causing interference with each other. It's better to have cables AND be able to use your stuff, then eliminate cables and not. You have your options, I'd suggest the first one. If you don't like cables, deal with it. I do. [N]F
  21. nightfox1405241487
    Ok, I ran into some problems with my install of Kubuntu. Windows was screwed anyways & needed to be removed . OK, anyways, I have USB ports on my laptop but Kubuntu isn't detecting them and I MUST have USB ports for my flash drive and external hard drive.I'm going to do a nice long search to see if I can find anyone else with the same problem. Other than that, it works fine.[N]F
  22. nightfox1405241487
    Yeah, sounds to me that you have WAY too much wireless stuff in your room. Seriously, WAY to much. If the wireless phone is a 2.4 GHz & so is your router, there's one problem solved. But if the router is in your room, just get a 15 foot ethernet cable and run it to your computer. Seriously. My router is 55 (or so) feet away from my room and I just got fed up with large print jobs getting sucked into black holes and stuff, that I got my dad to run about 70-80 feet of ethernet to my room where my network switches hook up to the network drop. It really sounds to me that you have TOO MUCH wireless dude... way too much. Convert most of that stuff to wires & things will get better. Trust me.[N]F
  23. nightfox1405241487
    lol, I know. I love SuSE as well. Except Kubuntu is the ONLY Linux distro that will actually WORK on my laptop (USB ports currently aren't working in the Live CD version... worked on my mom's comp though, but the graphics card wasn't detected properly and was at a very low res) and I think the USB problem might be a little isolated problem. Once I get my partition resized and Kubuntu installed, I'll have to see if they work. [N]F
  24. nightfox1405241487
    lol, ok. I'll give it a try. And I plan on backing up everything. I don't even trust Windows. It can't even keep my laptop battery charged when it's even plugged into the wall so why should I trust it with my data? I'll just go and use my other laptop to download and burn it for later because I'm still having too much fun! Without running windows, the performance of my laptop has GREATLY improved. [N]F
  25. nightfox1405241487
    Yeah, it's NTFS. Except I can't resize a partition that still has files at the end of it, can I?[N]F
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | 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.

  I accept