MySQL Table Selecting

[Enverex]

Been trying for ages but cant get it to work. How do you select multiple tables in MySQL using PHP, my code is as follows -

if ($_REQUEST['letter'] == "all") {$Letter = '123, A, B, C, D, E, F, G, H, I, J, K, L, M, N, I, O, P, Q, R, S, T, U, V, W, X, Y, Z' ;}else{$Letter = $_REQUEST['letter'];};

if( !isset($_GET['k'])) {
$SQL="SELECT COUNT(*) AS Total FROM `$Letter`";
$SQL_Result=mysql_db_query($DB_Name, $SQL);
$SQL_Result_Array=mysql_fetch_array($SQL_Result) || die(mysql_error());
$Total=$SQL_Result_Array['Total'];
// Create a new SELECT Query with the ORDER BY clause and without the COUNT(*)
$SQL="SELECT * FROM `$Letter` ORDER BY Name";
}else{
$k = $_REQUEST['k'];
// Run The Query Without a Limit to get Total result
$SQL="SELECT COUNT(*) AS Total FROM `$Letter` WHERE Name LIKE $k";
$SQL_Result=mysql_db_query($DB_Name, $SQL);
$SQL_Result_Array=mysql_fetch_array($SQL_Result) || die(mysql_error());
$Total=$SQL_Result_Array['Total'];
// Create a new SELECT Query with the ORDER BY clause and without the COUNT(*)
$SQL="SELECT * FROM `$Letter` WHERE Name LIKE $k ORDER BY Name";
};

Its just the "{$Letter =" bit I need to find out, i.e. is there a "select all tables" command, or if not, how do I need to format the table syntax?

Cheers, off to bed now :o gnight,
NS

[Enverex]

Yeah, I nearly had to tear out my retinas after looking at it (thinks back to the "Amazing seizure robots" episode of the Simpsons).

lol,
NS

[danball1976]

Can just barely ready the green

[res00vaz]

easy click & hold cursor over text to select

[danball1976]

Originally posted by res00vaz
easy click & hold cursor over text to select

I knew that.

BTW, this forum needs smileys on the left of the post reply box dialoge

[Coaster]

its just as easy to put semi-colon right bracket, or :)

But thats me.

I'll add your suggestion, thanks Dan :)

[Enverex]

Um...... is there going to be an easy way of doing this as there are going to be 27 tables and 2000 records (6 fields each) per table...

NS

[Chilak]

I would assign 1 array with all the table names. And assign numbers to them. Then use a for statement to gather all the info.

[Enverex]

er..............

<------ MySQL n00b

NS

[Enverex]

Sorry, my eyes hurt and that Red On Blue is just going to make them explode....

NS

[Enverex]

uuuuuhhhhhhhh...........

I still cant figure this out, so i'll give you a bit more info, see if you can give me more of a push in the right direction.

The tables are: `123` and the Letters from A to Z, and the field it needs to be searching is called 'Name' which is all in the database named 'amigagames'.

Any ideas?
NS

[nekromancerus]

I didn't know shit about SQL and I had to learn the basics and I found these sites to be a great help. Now I know a tiny bit more than shit. ;)

http://sqlcourse.com
http://sqlcourse2.com