RE: [PHP-DB] when click on button, how renew info on page?
| From: | Blain | Date: | Mon, 24 Mar 2003 05:13:45 +0000 |
| Subject: | RE: [PHP-DB] when click on button, how renew info on page? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26584@lists.php.net to get a copy of this message | ||
Yeah..
U Just a need a normal Button, target to the same site with id+1
-----Ursprüngliche Nachricht-----
Von: gert vonck [mailto:gert_vonck@hotmail.com]
Gesendet: Montag, 24. März 2003 00:28
An: php-db@lists.php.net
Betreff: [PHP-DB] when click on button, how renew info on page?
hello everyone,
with this code, a table is loaded with info from the mysql db with id = '1'.
but now i want to make a button, and when it is clicked, he has to renew the
table with the info from the db with id ='2'
does anyone know has this should be done?
thanks in advance!
Greetings,
Gert Vonck
<html>
<head> <title> </title> </head>
<body>
<?php
mysql_connect("localhost","root","") or
die ("Could not connect to database");
mysql_select_db("oh") or
die ("problems selecting database");
?>
<h2>Info_DJ</h2>
<?php
$result0 = mysql_query("SELECT
naam,leeftijd,muziekgenre,favoriet_liedje,motto,picture_right FROM info_dj
WHERE id='1'") or die (mysql_error());
print"<table border=1>\n";
$field_count = mysql_num_fields($result0);
while ($get_info0 = mysql_fetch_row($result0))
{
print "<tr><td><table>";
for($i = 0; $i < $field_count - 1 ; $i++){
$value = $get_info0[$i];
$column = mysql_field_name($result0,$i);
print
"\t<tr><td>$column</td><td>$value</td></tr>\n";
}
$last = $field_count - 1;
print "</table></td><td><img
src='$get_info0[$last]'></td></tr>\n";
}
print "</table>\n";
mysql_close();
?>
</body>
</html>
_________________________________________________________________
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php