Re: PHP/MySql noob falls at first hurdle

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Paul Jinks wrote:
Hi all

I've been asked to put simple database interactivity on an academic site. They want users to enter a few details of their projects so other researchers can search and compare funding etc. How difficult can that be, I thought....

I've built the database in MySQL and entered some dummy data, and I'm now trying in the first place to get the data to display with a simple select query to display the variable "projTitle" from the table "project" thus:

<head>
    <snip>
    <?
$SQLquery = "SELECT projTitle FROM project";
    $result = mysql_query($SQLquery)
    or die ("couldn't execute query");
    mysql_close($connect)
?>

<body>
<p>Result of <b><?=$SQLquery ?></b></p>

<p>
    <?
        while($ouput_row = mysql_fetch_array($result)) {
    ?>
    <?=$output_row["projTitle"]?><br />
<?
    }
?> </p>
</body>

When I view the page I get this:

<p>Result of <b>SELECT projTitle FROM project</b></p>

<p>
    <br />
    <br />
    <br />
    <br />
</p>

There are indeed 4 entries in the database, but I can't figure out why it's not displaying the data. It worked fine on my "PHP/Mysql-in-a-box" course. No, we didn't study the syntax :(

Any help gratefully received.

Are short tags disabled?  Change this line...

<?=$output_row["projTitle"]?><br />

To...

<?php echo ( $output_row["projTitle"] ) ?><br />

--
By-Tor.com
...it's all about the Rush
http://www.by-tor.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux