Php/mysql Error unable to jump

[Anon]

Im getting these errors:

Warning: Unable to jump to row 1 on MySQL result index 2 in /home/cust2/usr2253/cgi-bin/load.php3 on line 15

Warning: Unable to jump to row 1 on MySQL result index 3 in /home/cust2/usr2253/cgi-bin/load.php3 on line 20
&date=
Warning: Unable to jump to row 1 on MySQL result index 4 in /home/cust2/usr2253/cgi-bin/load.php3 on line 30
&No=
Warning: Unable to jump to row 1 on MySQL result index 5 in /home/cust2/usr2253/cgi-bin/load.php3 on line 40
&name=
Warning: Unable to jump to row 1 on MySQL result index 6 in /home/cust2/usr2253/cgi-bin/load.php3 on line 49
&email=
Warning: Unable to jump to row 1 on MySQL result index 7 in /home/cust2/usr2253/cgi-bin/load.php3 on line 58
&url=
Warning: Unable to jump to row 1 on MySQL result index 8 in /home/cust2/usr2253/cgi-bin/load.php3 on line 67
&details=
Warning: Unable to jump to row 1 on MySQL result index 9 in /home/cust2/usr2253/cgi-bin/load.php3 on line 76
&posx=
Warning: Unable to jump to row 1 on MySQL result index 10 in /home/cust2/usr2253/cgi-bin/load.php3 on line 85
&posy=
Warning: Unable to jump to row 1 on MySQL result index 11 in /home/cust2/usr2253/cgi-bin/load.php3 on line 94
&ipnr=
Warning: Unable to jump to row 1 on MySQL result index 12 in /home/cust2/usr2253/cgi-bin/load.php3 on line 103
&Nomax=

On this script

#!/usr/local/bin/php
<?php
$send_date = "&datenow=";
$send_date .= rawurlencode((date("d/m/Y (H:i)")));

    echo "$send_date";

$server = "unixsql3.interland.net";
    $user = "Mort";
    $password = "Candy";  
    $db = mysql_connect($server,$user,$password); mysql_select_db("IdiotBoxTV",$db);

    $get_count = "SELECT count(id) FROM guest";
    $count_result = mysql_query($get_count);
    $count = mysql_result($count_result, 1, "count(id)");


    $get_date = "SELECT datenow FROM guest WHERE id = '$count'";
    $date_result = mysql_query($get_date);
    $return= mysql_result($date_result, 1, "datenow");
    $send_date2 = "&date=";
    $send_date2 .= rawurlencode($return);


    echo "$send_date2";


    $get_id = "SELECT id FROM guest WHERE id = '$count'";
    $id_result = mysql_query($get_id);
    $return= mysql_result($id_result, 1, "id");
    $send_id = "&No=";
    $send_id .= rawurlencode($return);


    echo "$send_id";


    $get_name = "SELECT name FROM guest WHERE id = '$count'";
    $name_result = mysql_query($get_name);
    $return = mysql_result($name_result, 1, "name");
    $send_name = "&name=";
    $send_name .= rawurlencode($return);


    echo "$send_name";

    $get_quote = "SELECT email FROM guest WHERE id = '$count'";
    $quote_result = mysql_query($get_quote);
    $return = mysql_result($quote_result, 1, "email");
    $send_email = "&email=";
    $send_email .= rawurlencode($return);


    echo "$send_email";

    $get_url = "SELECT url FROM guest WHERE id = '$count'";
    $url_result = mysql_query($get_url);
    $return = mysql_result($url_result, 1, "url");
    $send_url = "&url=";
    $send_url .= rawurlencode($return);


    echo "$send_url";

    $get_details = "SELECT details FROM guest WHERE id = '$count'";
    $details_result = mysql_query($get_details);
    $return = mysql_result($details_result, 1, "details");
    $send_details = "&details=";
    $send_details .= rawurlencode($return);


    echo "$send_details";

    $get_posx = "SELECT posx FROM guest WHERE id = '$count'";
    $posx_result = mysql_query($get_posx);
    $return = mysql_result($posx_result, 1, "posx");
    $send_posx = "&posx=";
    $send_posx .= rawurlencode($return);


    echo "$send_posx";

    $get_posy = "SELECT posy FROM guest WHERE id = '$count'";
    $posy_result = mysql_query($get_posy);
    $return = mysql_result($posy_result, 1, "posy");
    $send_posy = "&posy=";
    $send_posy .= rawurlencode($return);


    echo "$send_posy";

    $get_ipnr = "SELECT ipnr FROM guest WHERE id = '$count'";
    $ipnr_result = mysql_query($get_ipnr);
    $return = mysql_result($ipnr_result, 1, "ipnr");
    $send_ipnr = "&ipnr=";
    $send_ipnr .= rawurlencode($return);


    echo "$send_ipnr";

    $get_No_max = "SELECT id FROM guest WHERE id = '$count'";
    $No_max_result = mysql_query($get_No_max);
    $return = mysql_result($No_max_result, 1, "id");
    $send_No_max = "&Nomax=";
    $send_No_max  .= rawurlencode($return);


    echo "$send_No_max";

?>

Thanks

[Anon]

You have 11 queries where you only need one, but that's not what's causing your error. It looks like each query is only returning one row, the index of which is zero, not 1.

Look into how to use SELECT statements, I don't think you get the idea of what they are.

Did you know you can do this?

$result = mysql_query("SELECT COUNT(id) as count,datenow,name,email,url,details,posx,posy,ipnr FROM guest WHERE id='$count'")

You don't need to ever use "select id from guest where id='$count'" and you do it twice. If you already know $count, then you know what $id is..just do $id=$count if you really want to.

Read some of the tutorials on here and on Devshed.com, I think they'll help you.

---John Holmes...

[Anon]

Warning: Unable to jump to row 1 on MySQL result index 2 in overzicht.php on line 36

Warning: Unable to jump to row 1 on MySQL result index 2 in overzicht.php on line 37

Warning: Unable to jump to row 1 on MySQL result index 2 in overzicht.php on line 38

Warning: Unable to jump to row 1 on MySQL result index 2 in overzicht.php on line 39

Warning: Unable to jump to row 1 on MySQL result index 2 in overzicht.php on line 40

Warning: Unable to jump to row 1 on MySQL result index 2 in overzicht.php on line 41

Warning: Unable to jump to row 1 on MySQL result index 2 in overzicht.php on line 42

Warning: Unable to jump to row 1 on MySQL result index 2 in overzicht.php on line 43

Warning: Unable to jump to row 1 on MySQL result index 2 in overzicht.php on line 44

Warning: Unable to jump to row 1 on MySQL result index 2 in overzicht.php on line 45

Warning: Unable to jump to row 1 on MySQL result index 2 in overzicht.php on line 46

Warning: Unable to jump to row 1 on MySQL result index 2 in overzicht.php on line 47

Warning: Unable to jump to row 1 on MySQL result index 2 in overzicht.php on line 48

=========================================
source

include('database.php');

// Als zowel toestel als provider zijn gekozen

if ($toestel && $provider)
{
// Opmaak van een pagina voor het specifiek gekozen toestel
// Tevens zullen eventuele accesoires worden vermeld

// Hieronder worden de overige typenummers gegenereerd, aan de hand van de database.
// Eerst wordt een query gedaan met wat beperkingen
// Zo worden alle unieke Types ingeladen van het gekozen merk

$QUERY = mysql_query
("
SELECT *
FROM toestellen
WHERE toestel = '$toestel'
AND provider = '$provider'
");

$NUMROWS = mysql_num_rows($QUERY);

// Hieronder wordt het aantal entries ingelezen die voldeden aan bovenstaande query.
// Dit aantal is nodig voor het genereren van de knoppenbalk

$i = 0;

$Id = mysql_result($QUERY,$i,"Id");
$toestel = mysql_result($QUERY,$i,"toestel");
$fabrikant = mysql_result($QUERY,$i,"fabrikant");
$provider = mysql_result($QUERY,$i,"provider");
$standby = mysql_result($QUERY,$i,"standby");
$gewicht = mysql_result($QUERY,$i,"gewicht");
$spreektijd = mysql_result($QUERY,$i,"spreektijd");
$extra = mysql_result($QUERY,$i,"extra");
$beltegoed = mysql_result($QUERY,$i,"beltegoed");
$top = mysql_result($QUERY,$i,"top");
$omschrijving = mysql_result($QUERY,$i,"omschrijving");
$voorraad = mysql_result($QUERY,$i,"voorraad");
$prijs = mysql_result($QUERY,$i,"prijs");
$levertijd = mysql_result($QUERY,$i,"levertijd");

does anybody know what goes wrong here?

[Anon]

Try "0" instead of '1'

$count = mysql_result($count_result, 0, "count(id)");

0 returns the first record; 1 the second.

if there is no record returned, the warning message would come back again.

Good luck.

[Anon]

Try "0" instead of '1'

$count = mysql_result($count_result, 0, "count(id)");

0 returns the first record; 1 the second.

if there is no record returned, the warning message would come back again.

Good luck.