[Resolved] Help please: to functions on one page

[kat89]

i have to things "$orderby" and "$table" and i would like to have them both in my index.php
so they can be used on same page. is this possible though i have to "GET"?

maybe something like:

$query="SELECT * FROM '$table,$orderby' order by table";

echo "<!-- Begin table rows -->\n";
	$orderBy = "";
	if (!empty($_GET['sort'])) {
	  $orderBy	= "ORDER BY " .sqlite_escape_string($_GET['sort']);
	}

if (isset($_GET['tableName'])) {
				$table = sqlite_escape_string($_GET['tableName']);

			$query	= "SELECT * FROM $table,$orderBy ORDER BY title";
  $result	= sqlite_query($handle, $query) or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));


if (sqlite_num_rows($result) >0) {
	  $count	= 0;
	  $js			= "onClick=\"openRow(this);\"";
    while($row = sqlite_fetch_array($result)) {
      $class = "";
			if ($count % 2 == 0) {
				$class = "row index" .$count. " even";
			} else {
				$class = "row index" .$count. " odd";
			}
			echo "<tr id=\"$row[0]\" class=\"$class\" $js>\n";
			echo "\t<td class=\"first\">$count</td>\n";
			echo "\t<td>$row[1]</td>\n";
      echo "\t<td>$row[2]</td>\n";
      echo "\t<td>$row[3]</td>\n";
      echo "\t<td>$row[4]</td>\n";
      echo "\t<td>$row[5]</td>\n";
      echo "\t<td>$row[6]</td>\n";
      echo "\t<td class=\"last\">$row[7]</td>\n";
      echo "</tr>\n";
			$count++;
	  }
	}
	sqlite_close($handle);
	echo "<!-- End table rows -->\n";

[planetsim]

What functions? I dont see any. Please can you reword your original post it makes absolutely no sense and doesnt give any idea on what your wanting to do.

[kat89]

okay 🙂 my index.php is made so you can edit,add and delete in table "beer". i made a "$orderby" to sort the table.

now i made a selecttable.php which selects a table (i have 2 tables in one db)
.

both of them use this:
$query = "SELECT * FROM ... "

1. $query = "SELECT * FROM $orderBy";
   and
2. $query = "SELECT * FROM $table order by title";

what i would like to do is to merge these 2 into one select statement.

can i merge 2 GET into one $query?

[leatherback]

Hi,

-If there is a relationship between the two tables- you can.

You need to have:

In each table a colum which are linked. So the values of the ID colum of table1 should be related to a similar colum in the next table (You need to tell the database which records in each table are related to which other records in the second table).

Then you perform a join:

select * from $table left join $orderBy on $table.id = $orderBy.TableIdNr order by title

You have several optionf in a join (left, right, inner). Check out the manual and look for join syntax

J.

[kat89]

i think i found a way...