Howdy, Stranger!

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

Categories

Space in table(mysql) : echo value on screen

D MD M Member Posts: 1
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

  • SouldrinkerSouldrinker Member Posts: 143
    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

  • Chris BrownChris Brown USAMember Posts: 4,624 ✭✭

    _________ < http://forcoder.org /> free ebooks and video tutorials about / C, Swift, Visual Basic, C#, Go, Assembly, R, Delphi, Python, JavaScript, Visual Basic .NET, PL/SQL, MATLAB, C++, Scratch, Ruby, Perl, Objective-C, Java, PHP Scheme, Clojure, Apex, Scala, Julia, Logo, Fortran, Kotlin, Lisp, Alice, LabVIEW, Rust, Dart, VBScript, F#, FoxPro, Transact-SQL, Prolog, COBOL, ML, SAS, D, Bash, Crystal, Ada, ABAP, Erlang, Hack, Lua, Awk / ____

Sign In or Register to comment.