PHP/MySql noob falls at first hurdle

From: Date: Fri, 09 Dec 2005 11:50:54 +0000
Subject: PHP/MySql noob falls at first hurdle
Groups: php.general 
Request: Send a blank email to php-general+get-227184@lists.php.net to get a copy of this message
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. Thanks Paul

« previous php.general (#227184) next »