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!


Gert Vonck

<html> <head> <title> </title> </head> <body>

mysql_connect("localhost","root","") or
        die ("Could not connect to database");
mysql_select_db("oh") or
        die ("problems selecting database");




$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";




PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to