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 -

[PHP]if ($_REQUEST == "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;};

if( !isset($_GET)) {
$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;
// Create a new SELECT Query with the ORDER BY clause and without the COUNT(*)
$SQL="SELECT * FROM `$Letter` ORDER BY Name";
}else{
$k = $_REQUEST;
// 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;
// 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";
};[/PHP]

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