Re: PHP/MySql noob falls at first hurdle

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

 



On 12/9/05, Paul Jinks <paul@xxxxxxxxxxxxxxx> 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/

-- 
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