Re: PHP/MySql noob falls at first hurdle
| From: | Brice | Date: | Fri, 09 Dec 2005 14:23:57 +0000 |
| Subject: | Re: PHP/MySql noob falls at first hurdle | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-227194@lists.php.net to get a copy of this message | ||
On 12/9/05, Paul Jinks <paul@pauljinks.co.uk> 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>
Try to check the key of your result row with a print_r or a var_dump command.
Brice Favre
http://pelmel.org/