setting default table

[Anon]

I have a php script that allows me to edit records in a form. However, I have had issues with setting a default table. How it works is there is a dropdown that lists the different tables that are available, but when the page first loads it does not have a value for $dbtable (you need to select a table and press submit for listing table records) so I get the "Warning: Supplied argument..." message until a table is selected.

How can I load a default table? Like tableA when the page first loads.

Any help would be great.

Regards,
Will

[techek]

Why not check if $dbtable is set to something valid / allowable and act on it? Like this :

<?php

if (!$dbtable || !in_array($dbtable, 'table_a', 'table_b', 'goes_on')) {
$dbtable = 'default_table';
}

$sql = "select * from $dbtable";

?>

That way you'll both be able to control which table the script may access AND control which table is the default table to be used ...

[Anon]

I tried it but the dropdown will not select the table now. It "displays" that it changed the table but the data that is entered is placed into the default_table and not the selected table...

[rulian]

It could be simple coding placement:
in case your asking for $dbtable to be executed when it's only defined in a code your including after. For example in my website I have a place where I have to echo the news and it's header, but both are defined in the same file news.php.
so I had to set up functions for them in order to display them where I want on my webpage:
include ('shared/news.php');
<table....
echo $news;
.../table>

<table...
showheader();
/>.....

[techek]

I'm quite sure Rulian is on the right track concerning placement of code. Since I don't have any code to look at, I suggest you read through your code and figure out how it SHOULD work. Something like this :

<?php

if(dbtable is invalid or not set) {
set dbtable to my defaulttable
}

show a dropdown with allowed tables + the defaulttable and highlight the selected

if (action == query) {
make some sql-query using the dbtable
show result
} else {
show some help about how to use the script
}

?>

Does it make any sense? Atleast it would be one way that I would make the script work (if I've understood your wishes correctly? s)