Consolidating a script?

Discussion in 'PHP' started by mokimofiki, Aug 18, 2008.

  1. #1
    I am just wondering if anyone knows of a way to consolidate the code below I am relativly new at php and need the advice :)

    $result = mysql_query("SELECT energy FROM playerstats WHERE name = 'Moki'");
    $row = mysql_fetch_array($result);
    
    if ($row['energy'] < 2)
    {
    include("jobnotenoughenergy.php");
    }
    else
    {
    Code (markup):
    Thank you in advance,
    Brandon A.K.A Moki Mofiki
     
    mokimofiki, Aug 18, 2008 IP
  2. jack_ss

    jack_ss Guest

    Messages:
    94
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I don't know what you need to "consolidate", try this?
    $r = mysql_query("SELECT energy FROM playerstats WHERE name = 'Moki'");
    if (mysql_result($r, 0); < 2) include("jobnotenoughenergy.php");
    else {
       ...
    }
    PHP:
     
    jack_ss, Aug 18, 2008 IP