Jump to content

bwaxse

New Members
  • Posts

    9
  • Joined

  • Last visited

    Never

About bwaxse

  • Birthday 06/10/1986

Contact Methods

  • AIM
    BalmostMW
  • Website URL
    http://www.myCourseReview.com

Profile Information

  • Gender
    Male
  • Location
    Fort Worth Texas

bwaxse's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. haha its adrenaline - thats an amine group (NH)
  2. I've always wondered if there was an all around solution to this problem.  I can get them to line up in IE, but not Firefox, then with Firefox and not IE.  Is there a way to fix this or is this too complicated (meaning it's conditional) thanks, b
  3. Happy Thanksgiving everyone.  Here's my site:  [url=http://www.myCourseReview.com]http://www.myCourseReview.com[/url] I'd love to know what you all think. Thanks
  4. Hello all, I get "Invalid use of group function" with this query and don't know why. I'm trying to look through a database of entries to find the user with the most entries and get the name and the number.  Thanks! [code]$sql = "SELECT sUsername, COUNT(sUsername) FROM tbl_questions WHERE sSchoolID = ".$_SESSION['schoolid']." ORDER BY COUNT(*) DESC LIMIT 0,1";[/code]
  5. Hey all, I am trying to set up a section of my site that displays the latest updated posts.  Each post has a dtUpdated column in the database that gets a timestamp when changed.  When Im trying to look though the database, whats the best way to get the 5 most recent?  I think im supposed to ORDER by dtUpdated DESC, but was wondering what it would look like. I need PostID's from tbl_posts that have the most recent updates. Thanks for all your help!
  6. Thanks a bunch, I used: $sql = "SELECT * FROM tbl_classes WHERE sClassID = '".$_SESSION['CLASS1']."'||'".$_SESSION['CLASS2']."'||'".$_SESSION['CLASS3']."' ||'".$_SESSION['CLASS4']."'||'".$_SESSION['CLASS5']."'||'".$_SESSION['CLASS6']."'"; Is there a major difference or is one better than the other?
  7. Alright so im pretty new to php and sql - I know theres an easier way to do this: I have Class IDs set in the Users Table and I want to get the Class Names by referencing the Classes table. The if statements - If a user has a class entered in, look up that ID and set the $_SESSION[CLASS#] equal to that name. <?php                         if ($_SESSION['CLASS1'] != "0"){         $query2 = "SELECT sClassName FROM tbl_classes WHERE sClassID ='".$_SESSION['CLASS1']."'";         $result2 = mysql_query($query2) or die("Invalid query: " . mysql_error());         $row2 = mysql_fetch_assoc($result2);                 $_SESSION['CLASS1'] = $row2['sClassName'];}         if ($_SESSION['CLASS2'] != "0"){         $query3 = "SELECT sClassName FROM tbl_classes WHERE sClassID ='".$_SESSION['CLASS2']."'";         $result3 = mysql_query($query3) or die("Invalid query: " . mysql_error());         $row3 = mysql_fetch_assoc($result3);                 $_SESSION['CLASS2'] = $row3['sClassName'];} X4 More times ?>
×
×
  • 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.