Space in table(mysql) : echo value on screen

I have the following problem.
I Use tables in Mysql and i use the same tables with ODBC in MS ACCESS.
The Tables were first created in MS ACCESS by someone else.
He used " " in the table names.
How do I print the tables information with echo or something else.

example: echo $row->telefone 2;
this doesn't work.

Comments

  • Hehe, " " in Tablenames, very funny - however, microsoft users (access) do not know much about conventions.

    Do those tables work in MySQL? I don't think so... but if they do (never tested it) here a suggestion on a solution for your problem:

    As I see you do your value-select with some object-function php provides to you. Just try the function "mysql_fetch_row", with that function you generate some array (you know: ...[0], ...[1], ...[2]) and so you have to select the values you like to use.

    If you have for example the following table:

    [code]
    Table: table_test
    Fields: id ( primary key, tinyint )
    name ( tinytext )
    [/code]

    Now you select id and name from this table and bind your result with mysql_fetch_row. After that you can resolve your table with some code like this (Name of variable the mysql_fetch_row information is stored in is $row) :

    [code]
    echo "ID: $row[0]
    ";
    echo "NAME: $row[1]
    ";
    [/code]

    hope this helps!

    best regards,

    sebastian mohrenstecher
    executive secretary
    net::allies

    www.net-allies.de
    info@net-allies.de

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion