Data in textfield

[Neliz]

Hi, iam very new here an to php so don't blame me if this is a reeaaallly easy (or very stupid) question for some of you...

i can show some data from a table on the screen, that's not so difficult. But now i want to show the data in a few textfields and by pressing a 'next' button, jump to the next record. and previous ofcourse...

think i've got to use VALUE = something, but i don't know how.

is there someone who could help me or do you need more information?

thanx

[Pig]

To make it more concise, just make your value equal the row output.

eg: value=\"$row[id]\"

Don't forget the quotes! If your content has space in it, everything after it will be lost if do not have the quotes in place.

[Neliz]

thanks for your reply, but i still don't get it......

for example:

i've got 2 fields, called: Id and Name.
now i just want to make 2 textfields where i can see just 1 record at a time, and 2 links, 'next' and 'previous' to go te the next or the previous record.

i don't know what i've gotta do with VALUE=\"$row[0]\"

<?php
# ...
# ...
# ...
$result = mysql_exec($db, $query);
$row = mysql_fetch_row($result);

echo "<INPUT TYPE=TEXT NAME='Id' VALUE=\"$row[0]\"><br>";
echo "<INPUT TYPE=TEXT NAME='Name' VALUE=\"$row[1]\">";

// next and previous links
$next = '<a href="' . $PHP_SELF . '?page=' . ($page+1) . '">Next</a>';

if ($page > 1)
$prev = '<a href="' . $PHP_SELF . '?page=' . ($page-1) . '">Previous</a>';

print $prev . ' | ' . $next;
?>

someone?

thanx

[Pig]

Well, I think the problem is with how you are handling the array. row[0] refers to the first row, and row[1] refers to the 2nd row, NOT the 2nd part of row[0].

You can call the componets of the row by number or name.

ie: if you want to access the id and name for the first row, you would

echo("
<INPUT TYPE=TEXT NAME='Id' VALUE=\"$row[0][id]\"><br>
<INPUT TYPE=TEXT NAME='Name' VALUE=\"$row[0][name]\">
");

And accessing the second row would be the same, only it would be row[1] instead of row[0].

I hope that makes sense. There are lots of ways you can increment through your list as well.

[nnichols]

Have a play with this -

<?
// $page being the variable used to track which records to display
if ($_GET['page'])
	$page = $_GET['page'];
else
	$page = 1;

$max_per_page = 1;
$start = ($page-1)*$max_per_page;

$db = mysql_connect('localhost','user','pass')
	or die('Error: '.mysql_error());
mysql_select_db('db_name')
	or die('Error: '.mysql_error());

// get total number of records to be returned by query
$sql = "SELECT COUNT(*) FROM tbl_name";
$result = mysql_query($sql, $db)
	 or die('Error: '.mysql_error().'<br>Query: '.$sql);
$row = mysql_fetch_row($result);
$tot_pages = ceil($row[0]/$max_per_page);

$sql = "SELECT * FROM tbl_name LIMIT $start, $max_per_page";
// run your query and display result
$result = mysql_query($sql, $db)
	 or die('Error: '.mysql_error().'<br>Query: '.$sql);

while ($row = mysql_fetch_row($result)) {
echo '<INPUT TYPE=TEXT NAME="Id" VALUE="' . $row['Id'] . '"><br>';
echo '<INPUT TYPE=TEXT NAME="Name" VALUE="' . $row['Name'] . '">';
}

// build your next and previous links
if ($tot_pages > $page) {
	$next = '<a href="' . $PHP_SELF . '?page=' . ($page+1) . '">Next</a>';
	}
else {
	$next = "<font color=\"#C0C0C0\">Next<font>";
	}

if ($page > 1) {
	$prev = '<a href="' . $PHP_SELF . '?page=' . ($page-1) . '">Previous</a>';
	}
else {
	$prev = "<font color=\"#C0C0C0\">Previous<font>";
	}

print $prev . ' | ' . $next;
?>

The only things you should need to change to get this to work are - connection details, db_name and tbl_name.

This example is slightly more than you need but it gives a simple insight into a pagination method.

Hope this helps 😉