Desperate help Initializing Resource id!

[aibrahim]

How do I initialize a resource id in the mysql_result function. The problem is once the counter reaches 5 it will not reset the index to 0 even though I pass it in as 0 in
$result = mysql_query("SELECT * FROM music where ID='0'",$dbs);
$img = mysql_result($result,0,"image");

This is th.php3

$hour = 12;  //add 3 for eastern time (12 hour format)
$minutes = 28;
$second = 0;
$start_time = mktime((($hour+3)%12), $minutes, $second, $month, $day,$year); //3rd november 2001
//$start_time = mktime(1, 13, 0,1 ,25, 2004); //2nd november 2001
//every minute
$time_interval=5; 

This is the main php script:

 include("th.php");
    $databasehosts = "localhost"; // host with mySQL on it
    $databasename = "mugran"; // mySQL database name
    $tablename = "music"; // mySQL table name
    $dbusers = "mugransql";
    $dbpasss = "mughmv4";
    $dbs = mysql_connect($databasehosts,$dbusers,$dbpasss)
        or die("Unable to connect to mySQL server - please check configuration");
     mysql_select_db($databasename,$dbs);
    $now = date("j-m-y"); 
    $nw = date("g:i:s");

function str(&$i, &$index) {
       if (!($i))
    {
    $index=0;
    $new = mysql_query("SELECT * FROM music ,$dbs);
    trigger_error('Query error ' . mysql_error() . ' SQL: ' . $new); 
    echo "if I=0 i = $i before access resulting IMAGE RESULT passing 0 index=$index !!!!!\n";
    cho "newresult = $new\n";
    $img = mysql_result($new,0,"image");
} 
   
else 
{
  echo "ELSE i > 0i = $i before access resulting IMAGE\n";
 $img = mysql_result($result,$i,"image");
}
    echo " For $i $img  \n";
    $imageln = "http://www.mugran.com/training/img/$img"; 
 //printf("<img src=\"$imageln\"><br>\n ");
} 


$index = floor((time() - $start_time) / $time_interval);
$query = "SELECT * FROM $tablename ORDER BY id DESC LIMIT 1";
$res = mysql_query ($query)  or die ("Query failed");



while ( $row = mysql_fetch_object($res) )
{
    echo "The id is: ".$row->id."<br>\n";
    $last = "$row->id";
}



if (!($index < 0 ))

{
    if (($index > $last))    {
    echo "ENDED FOR ROW = $last resetting at to id = 0\n";
    $a=0;
    str($a, $index);
    }
    else { str($index); }
}     


else {
    echo " BEFORE TIME SCRIPT START INITIALIZE IMAGES + LINKS\n";
    $b=0;
    str($b);
} 

Can you please help?

I get the following error message:

before access resulting IMAGE RESULT passing 0 result = Resource id #6
Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 6 in /home/sites/site23/web/training/time/t1.php on line 37

[merk]

Im still having trouble understanding exactly what the function does.

How many rows are returned?

[aibrahim]

This script when given a start time vale based on the mktime function should increment the index value of the database every 5 seconds. It computes the index by the following formula:

(starttime - time()) / increment value.

so that every 5 seconds it would increment the index value by 1 to tthe next image in the database.

This works until it actually reaches the last element $last. For some reason I cannot initialize the query back to point to index/row 0 in the database.

I hope that explains it, can you help me??

[merk]

Im still totally confused.

I take it you're using this query to go through each of the returned records until it gets to the last one and it starts again?

You should check the given index number against the queries returned rows (there is a function that returns how many rows the query selected).

I hope that helps.

[aibrahim]

'

You should check the given index number against the queries returned rows (there is a function that returns how many rows the query selected).

I have done that already in my code. $last stores the last element/index number in the table

while ( $row = mysql_fetch_object($res) )
{
    echo "The id is: ".$row->id."<br>\n";
    $last = "$row->id";
} 

I then call for the function:

 
if (($index > $last))    {
    echo "ENDED FOR ROW = $last resetting at to id = 0\n";
    $a=0; //trying to pass an value of zero to the function
    str($a, $index);
    } 

I take it you're using this query to go through each of the returned records until it gets to the last one and it starts again?

This is exactly what I want.


I will make my question simple:

How do I pass zero to the id or resource link_identifier

mysql_query ( string query [, resource link_identifier] )

i.e. how do I modify the code below to initialize the resource id back to zero

$new = mysql_query("SELECT * FROM music ,$dbs); 

[merk]

I think you're misunderstanding what that does.

You use that optional parameter to specify which database connection to use.

[aibrahim]

Your right so how do I modify the code above to start parsing for informatio at the beginning of the database i.e. point back to row zero. I'm sure this is simple how do I do this??

[merk]

Well, I can only help you with the theory of it.

First, youll need to do a query. Get those results through a while loop. Then do whatever you're trying to do on the array, instead of the MYSQL result.

mysql_query("SELECT something FROM table"); # note no WHERE clause
 
while ($row = mysql_fetch_assoc($result))
{
  $tabledata[] = $row;
}
 
# Now, you have all the table data in an array where you can do a foreach() through it, or manipulate it however you want to.