Resource id #4

[sip3]

Hi all,

i'm a new user of PHP,

at the moment, i have queries regarding the "Resource id #4"

everythings run perfectly but before the script showing the result,
it shows the "Resource id #4" in front of the result, and i don't have any clue what happend with it.

Could someone please help me with it.

thanks a lot,
regards,
adi

here is my code:

    <?php
      require_once('dbconnect.php');         
      $trackID = $_GET['TrackId'];      
      $trackName = mysql_query("SELECT TrackName FROM EHAC_track where TrackId='$trackID'");
      $meetingList = mysql_query("SELECT MeetingID, MeetingDate FROM EHAC_meeting WHERE TrackId='$trackID' ORDER BY MeetingDate");
    ?>
 
          <ul>
            <?php
              error_reporting(E_ALL);
              ini_set('display_errors', true);
              Echo $trackName;
              $count = 0;
              while ($row = mysql_fetch_array($meetingList)) {
                Echo "<li><a href=raceInformation.php?MeetingID=".$row['MeetingID']." class=\"item-link-1\">".$row['MeetingDate']."</a></li>";                         
                $count++;
              }
              if($count==0){
                Echo "<span class=\"header-2\">No date available on this track</span>";
              }
            ?>
          </ul>

[Markus]

<?php
require_once('dbconnect.php');
$trackID = $_GET['TrackId'];
$trackName = mysql_query("SELECT TrackName FROM EHAC_track where TrackId='$trackID'");
$meetingList = mysql_query("SELECT MeetingID, MeetingDate FROM EHAC_meeting WHERE TrackId='$trackID' ORDER BY MeetingDate");
 
//instead of stopping the parsing of php just echo-out the <ul>
echo "<ul>";
 
error_reporting(E_ALL);
ini_set('display_errors', true);
 
//this is the problem line
Echo $trackName;
$count = 0;
while ($row = mysql_fetch_array($meetingList)) {
Echo "<li><a href=raceInformation.php?MeetingID=".$row['MeetingID']." class=\"item-link-1\">".$row['MeetingDate']."</a></li>";
$count++;
}
if($count==0){
Echo "<span class=\"header-2\">No date available on this track</span>";
}
?>
 

Line 14 is the problem.
You need to use one of the provided mysql functions
i.e:

while($track = mysql_fetch_array($trackName)){
    echo $track;
}
 

Hope this helps :)

[sip3]

hi,

i have tried it, and you are correct that the problem is from line 14 but after i implement it, it shows "array" instead of "resource id#4".

i don't know why it shows array now.
i'm really sorry to ask a lot of question because i'm really new in here and this is my assignment for my uni.

thanks for the help.
regards,
adi

[Markus]

Sorry, i forgot a bit of it.

while($track = mysql_fetch_array($trackName)){
    echo $track;
}
 

needs to be

while($track = mysql_fetch_array($trackName)){
    echo $track[*table_row_name*];
}
 

*table_row_name* needs to be substituted with the appropriate row name.
:)

[sip3]

You are the star Markus :)

thank you very much for your help.

and i might need your help in the near future as i just started my assignment and i believe i will face a lot of trouble in this because i don't have IT background.

once again,

thank you.
regards,
adi

[Markus]

No problem at all :)

post back whenever you need some help

also, remember to use CODE tags when posting - it helps us work through your code.

-markus

[nsr7]

Hi Markus - Could u plz rectify my code as well??

<?php
 
if (isset($_POST['verifyotp'])) {
 
    // Authorisation details.
    $username = "[e-mail]";
    $hash = "01993a995a047af1dfe20536da550cf101e571c9f7ba4a05bd6638417d79455f";
 
    // Config variables. Consult http://api.textlocal.in/docs for more info.
    $test = "0";
    $numbers = $_POST['otpnumber'];
 
    // Data for text message. This is the text message data.
    $sender = "TXTLCL"; // This is who the message appears to be from.
    $numbers = $_POST['otpnumber']; // A single number or a comma-seperated list of numbers
    $otp = mt_rand(100000,999999);
    setcookie("otp", $otp);
    $message = "Dear Subscriber Your OTP is ".$otp;
    // 612 chars or less
    // A single number or a comma-seperated list of numbers
    $message = urlencode($message);
    $data = "username=".$username."&hash=".$hash."&message=".$message."&sender=".$sender."&numbers=".$numbers."&test=".$test;
    $ch = curl_init('http://api.textlocal.in/send/?');
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    $result = curl_exec($ch); // This is the result from the API
 
    curl_close($ch);
 
    if ($ch) {
        echo "CURL Error #: " .$ch;
    }
    else
    {
        $json = json_decode($result);
 
        if ($json->type == 'success') 
        {
            header('location: otpverified.php');
        }
        if ($json->type == 'error') 
        {
            echo 'Your OTP is not Verified "'.$json->message.'" ';
        }    
 
}
 
}
 
?>