[SOLVED] Radio button array

[Thomisback]

Hello,

 

I was just wondering, is it possible to retrieve e.g. database names/tables/columns from MySQL and retrieve them as radio buttons (an array) for my administration panel & edit them?

 

Thanks a lot!

[schme16]

I don't see why not.

 

I'm not sure of the specific code for the job, but it'd be a mysql_query("") with a while and a mysql_fetch_array.

 

something like this:

 

$read_tables = mysql_query(" sql query goes here (cheack the MySQL Manual for this)");

//this will read each table and output its values to a variable called table
while($table = mysql_fetch_array($read_tables))
{

print'
<label>
$table['name'] 
<input type="radio" id="'.$table['name'].'" name"'.$table['name'].'"  />
</label>
<br />';

}

 

 

[Thomisback]

Thanks! Unfortunately I can't find the code to retrieve database & table names, I did find the code to retrieve column names.

[zenag]

$con=mysql_connect("localhost","username","password");

mysql_connect_db("databasename,$con);

$read_tables = mysql_query(" select fieldname from tablename");

 

[schme16]

http://au2.php.net/manual/en/function.mysql-tablename.php

 

This will allow you to dynamically list all tables in a database.

[Thomisback]

Thanks all, I also found how to retrieve the database names:

http://au2.php.net/manual/en/function.mysql-db-name.php

[Thomisback]

I successfully did it but I now have too many tables (lol) so I changed my mind to a combo box but I can't figure out how to do it.

 

For my radio input I now have:

echo "<label>";
print "$row[0]\n";
echo "<input type=radio id=";
print "$row[0]\n";
echo "name=";
print "$row[0]\n";
echo "/>
</label>
<br>";

 

So how would I configure a combo box like this to do the same?

<input type="select" name="OS">
  <option value="Win95">Windows 95/98</option>
  <option value="WinNT">Windows NT/2000</option>
  <option value="OSX">Macintosh OS X</option>
  <option value="OS9">Macintosh OS 9</option>
  <option value="Linux">Linux</option>
  <option value="Solaris">Solaris</option>
  <option value="BSD">FreeBSD</option>
</input>

[zenag]

<select name="">
<option value="">value</option>
</select>

[Thomisback]

Thanks but now I get a different combo box for each table :/

[zenag]

<?php

mysql_connect("localhost", "root", "");

$result = mysql_list_tables("test");

$num_rows = mysql_num_rows($result);

 

echo "<select name=''>";

for ($i = 0; $i < $num_rows; $i++) {

echo "<option value=''>".mysql_tablename($result, $i)."</option>";

}

echo "</select>";

   

 

 

mysql_free_result($result);

?>

 

[Thomisback]

!wow thanks a lot, that seriously helped