You are here: php mysql form variable works one time « PHP Programming Language « IT news, forums, messages
php mysql form variable works one time

Posted by baccaril on 11/22/06 14:28

Hello,

I have a form the post to a php script, the variable is passed to the
php script successfully. I then query MySQL and output 8 rows at a
time. So the problem I'm having is the first 8 rows are displayed on
the web page correctly, but now when I attempt to display rows 9-16
the variable that was posted from the form is now blank. How do I
ensure the variable does not disappear?

LouB.

=================================
Here are the three main part of my php script.


# post from form....
$sortby = $_REQUEST["sortby"];

$query = "select personal_identifier, first_name, last_name,
company_name, photo_path, custom_field_1 from $dbname order by $sortby
limit $offset, $rowsPerPage";

result = mysql_query ($query)
//or die ("Cannot execute query");
or die (mysql_error());

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация