problem with next an previus botton

i have these errors:
Warning: sprintf(): Too few arguments in /Applications/XAMPP/xamppfiles/htdocs/lijo/productos-detalles.php on line 45

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /Applications/XAMPP/xamppfiles/htdocs/lijo/productos-detalles.php on line 46

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /Applications/XAMPP/xamppfiles/htdocs/lijo/productos-detalles.php on line 47

Warning: sprintf(): Too few arguments in /Applications/XAMPP/xamppfiles/htdocs/lijo/productos-detalles.php on line 49

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /Applications/XAMPP/xamppfiles/htdocs/lijo/productos-detalles.php on line 50

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /Applications/XAMPP/xamppfiles/htdocs/lijo/productos-detalles.php on line 5

my code is:

mysql_select_db($database_hermanos, $hermanos);
$query_rsProductos = sprintf("SELECT * FROM productos WHERE prodID = %s", GetSQLValueString($colname_rsProductos, "int"));
$rsProductos = mysql_query($query_rsProductos, $hermanos) or die(mysql_error());
$row_rsProductos = mysql_fetch_assoc($rsProductos);
$totalRows_rsProductos = mysql_num_rows($rsProductos);


$rsNext = mysql_query(sprintf("SELECT * FROM productos WHERE prodID = %s AND prodID > %s ORDER BY prodID ASC LIMIT 0, 1", $_GET['prodID']));
$row_rsNext = mysql_fetch_assoc($rsNext);
$totalRows_rsNext = mysql_num_rows($rsNext);

$rsPrev = mysql_query(sprintf("SSELECT * FROM productos WHERE prodID = %s AND prodID < %s ORDER BY prodID DESC LIMIT 0, 1", $_GET['prodID']));
$row_rsPrev = mysql_fetch_assoc($rsPrev);
$totalRows_rsPrev = mysql_num_rows($rsPrev);

Please attach a copy of the page itself so I can see line numbers.

Originally Said By: Ray Borduin

  Please attach a copy of the page itself so I can see line numbers.  

http://www.pescadoshermanoslijo.com/productos-detalles.php?prodID=1

On line 45 you have %s two times in your select statement, but only pass one replacement value. Same thing on line 49.

45 should probably be:
$rsNext = mysql_query(sprintf("SELECT * FROM productos WHERE prodID = %s AND prodID > %s ORDER BY prodID ASC LIMIT 0, 1", GetSQLValueString($colname_rsProductos, "int"), GetSQLValueString($colname_rsProductos, "int")));

and 49:
$rsPrev = mysql_query(sprintf("SSELECT * FROM productos WHERE prodID = %s AND prodID < %s ORDER BY prodID DESC LIMIT 0, 1", GetSQLValueString($colname_rsProductos, "int"), GetSQLValueString($colname_rsProductos, "int")));

i have this error now:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\inetpub\vhosts\pescadoshermanoslijo.com\httpdocs\productos-detalles.php on line 49

appears below the menu:
http://pescadoshermanoslijo.com/productos-detalles.php?prodID=1

In lines 260 and 265, i have two buttons to go next product or previous product

Please attach a current version of the file so I can see it after the changes you made.

It looks like there is an extra S in the select statement for that second recordset that may be the problem:

$rsPrev = mysql_query(sprintf("SSELECT * FROM productos WHERE prodID = %s AND prodID < %s ORDER BY prodID DESC LIMIT 0, 1", GetSQLValueString($colname_rsProductos, "int"), GetSQLValueString($colname_rsProductos, "int")));

should be:
$rsPrev = mysql_query(sprintf("SELECT * FROM productos WHERE prodID = %s AND prodID < %s ORDER BY prodID DESC LIMIT 0, 1", GetSQLValueString($colname_rsProductos, "int"), GetSQLValueString($colname_rsProductos, "int")));

I remove the extra S, sorry for that....

i am trying to do, is when you select a product in the product page "http://pescadoshermanoslijo.com/productos.php", the user go to the details page of the product http://pescadoshermanoslijo.com/productos-detalles.php?prodID=1, in the lines 379 i have the buttons previous and next to go to another product page detail

line 379

<?php if ($totalRows_rsPrev): ?> <a class="nonblock nontext Button clearfix grpelem" id="buttonu1366" href="?prodID=<?php echo $row_rsPrev['prodID']; ?>"><!-- container box --><div class="clearfix grpelem" id="u1367-4"><!-- content --><p>ANTERIOR</p></div></a><?php endif; ?>

line 383
<?php if ($totalRows_rsNext): ?><a class="nonblock nontext Button clearfix grpelem" id="buttonu1347" href="?prodID=<?php echo $row_rsNext['prodID']; ?>"><!-- container box --><div class="clearfix grpelem" id="u1349-4"><!-- content --><p>SIGUIENTE</p></div></a><?php endif; ?>

What exactly is the problem you are experiencing now?

the next button and previous button doesnt work.

They have to go to the next o previous product, I have this code:

<?php if ($totalRows_rsPrev): ?> <a class="nonblock nontext Button clearfix grpelem" id="buttonu1366" href="?prodID=<?php echo $row_rsPrev['prodID']; ?>"><!-- container box --><div class="clearfix grpelem" id="u1367-4"><!-- content --><p>ANTERIOR</p></div></a><?php endif; ?>

<?php if ($totalRows_rsNext): ?><a class="nonblock nontext Button clearfix grpelem" id="buttonu1347" href="?prodID=<?php echo $row_rsNext['prodID']; ?>"><!-- container box --><div class="clearfix grpelem" id="u1349-4"><!-- content --><p>SIGUIENTE</p></div></a><?php endif; ?>

You probably have to put the page name in front of the ? in the href.