Re: [PHP] PHP/MySql noob falls at first hurdle

2005-12-09 Thread John Nichel
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

Re: [PHP] PHP/MySql noob falls at first hurdle

2005-12-09 Thread Zareef Ahmed
Hi Paul, Why you are closing your connection before finishing your work on the database? Zareef Ahmed - Original Message - From: Paul Jinks [EMAIL PROTECTED] To: php-general@lists.php.net Sent: Friday, December 09, 2005 6:50 AM Subject: [PHP] PHP/MySql noob falls at first

RE: [PHP] PHP/MySql noob falls at first hurdle

2005-12-09 Thread Dan Parry
Hi [snip] ? while($ouput_row = mysql_fetch_array($result)) { ? [/snip] Try: while($ouput_row = mysql_fetch_array($result, MYSQL_ASSOC)) [snip] ?=$output_row[projTitle]?br / [/snip] You have missed the ; (semicolon) after [projTitle] also Dan -Original Message- From: Paul

Re: [PHP] PHP/MySql noob falls at first hurdle

2005-12-09 Thread Rory McKinley
Paul Jinks wrote: snip ? while($ouput_row = mysql_fetch_array($result)) { ? ?=$output_row[projTitle]?br / snip Paul - is this the actual code that you are using? - because you have a typo in your while statement - $ouput_row instead of $output_row - means that when you

Re: [PHP] PHP/MySql noob falls at first hurdle

2005-12-09 Thread Rory McKinley
Paul Jinks wrote: Rory McKinley wrote: Paul Jinks wrote: snip ? while($ouput_row = mysql_fetch_array($result)) { ? ?=$output_row[projTitle]?br / snip Paul - is this the actual code that you are using? - because you have a typo in your while statement - $ouput_row

Re: [PHP] PHP/MySql noob falls at first hurdle

2005-12-09 Thread Dan McCullough
I would hate to see a time clock that tabulated how many hours I wasted with typos and stupid things like that. On 12/9/05, Rory McKinley [EMAIL PROTECTED] wrote: Paul Jinks wrote: Rory McKinley wrote: Paul Jinks wrote: snip ? while($ouput_row =

RE: [PHP] PHP/MySql noob falls at first hurdle

2005-12-09 Thread Jim Moseby
For future reference, during testing, you can set your error reporting levels ( i think) in php.ini to output a notice regarding a variable that does not exist - would have helped you spot the error! I normally use the Zend debugger which does quite a good job of telling me that I am an