Displaying a MySQL Query result usin PHP

Discussion in 'Software' started by iamien, Jun 24, 2003.

  1. iamien

    iamien Cptn "Eh!"

    Ok i'm trying to make a small test script that will query my database and display the result.

    <html>
    <body>
    <?php
    $db = mysql_connect("localhost", "****", "");
    mysql_select_db("emp",$db);
    $test = mysql_query("SELECT name FROM employees WHERE punch = 34");
    printf("Name is %s, $test);
    ?>
    </body>
    </html>

    now when i try to run this, i get
    Parse error: parse error, unexpected $ in /home/fritzsof/public_html/php/recall.php on line 11
    only line 11 is at the end of my script and there is nothing there
    no if i ocmment out the printf statemtn this goes away so i know my erro is there
    What am i doing worng and/or how can i display databse query results?
     
    iamien, Jun 24, 2003
    #1
  2. Vlad902

    Vlad902 Guest

    you forgot a "

    and PHP si not C, it's not:
    printf("Name is %s, $test);

    it's
    echo "Name is $test";
     
    Vlad902, Jun 25, 2003
    #2
  3. iamien

    iamien Cptn "Eh!"

    actual printf works ifne and i got it + tons mroe wokring hehe
    thanks
    i dont know echo alwasy giving me eror verso printf working fine any rreaosn to use echo over pritnf
     
    iamien, Jun 25, 2003
    #3
  4. Vlad902

    Vlad902 Guest

    Are you using ' or " or <<<, if you keep switching between ' and " you're gonna get errors, I can't find a link but somewhere in the PHP manual in the first 100 pages it talks about this...
     
    Vlad902, Jun 25, 2003
    #4
  5. iamien

    iamien Cptn "Eh!"

    whep i'll play with echo. it working so far and my sites getting going have cookies set up and that doing more html work then anything atm
     
    Last edited: Jun 25, 2003
    iamien, Jun 25, 2003
    #5
  6. da chicken

    da chicken MajorGeek

    Maybe you misspelt something? :D ;)
     
    da chicken, Jun 26, 2003
    #6
  7. iamien

    iamien Cptn "Eh!"

    quiet you :D
     
    iamien, Jun 26, 2003
    #7

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds