MySQL Table Selecting

EnverexEnverex Worcester, UK Icrontian
edited June 2003 in Science & Tech
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

Comments

  • EnverexEnverex Worcester, UK Icrontian
    edited June 2003
    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
  • danball1976danball1976 Wichita Falls, TX
    edited June 2003
    Can just barely ready the green
  • edited June 2003
    easy click & hold cursor over text to select
  • danball1976danball1976 Wichita Falls, TX
    edited June 2003
    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
  • edited June 2003
    its just as easy to put semi-colon right bracket, or :)

    But thats me.

    I'll add your suggestion, thanks Dan :)
  • EnverexEnverex Worcester, UK Icrontian
    edited June 2003
    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
  • ChilakChilak Over there ->
    edited June 2003
    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.
  • EnverexEnverex Worcester, UK Icrontian
    edited June 2003
    er..............

    <
    MySQL n00b

    NS
  • EnverexEnverex Worcester, UK Icrontian
    edited June 2003
    Sorry, my eyes hurt and that Red On Blue is just going to make them explode....

    NS
  • EnverexEnverex Worcester, UK Icrontian
    edited June 2003
    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
  • edited June 2003
    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
Sign In or Register to comment.