Just starting out help....

designer2004 · 08-07-2004, 03:48 PM

Hello I am just starting out trying to learn PHP without taking scripts and modifying them to my likeing so now I just read tuts and books and code snippets. Now here is my code then is my problem.

My Connections page thats a bit modifyed so i can post it here.

PHP Code:

  <?php

     // Connection parameters

 
     define ('DB_USER', '*****');

     define ('DB_PASSWORD', '*****');

     define ('DB_HOST', 'localhost');

     define ('DB_NAME', '*******');

 
     $connect = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) or die (mysql_error());

????: NamePros.com http://www.namepros.com/code/42376-just-starting-out-help.html
 
     mysql_select_db (DB_NAME);

?>

Now my index page.
????: NamePros.com http://www.namepros.com/showthread.php?t=42376

PHP Code:

  <?php

   include ('./includes/header.inc');

   include ('./includes/connections.php');

 
 
 
   $query = "Select * FROM  home_news";

   $result = mysql_query($query);

?>

Now i am sure im missing something or doing something wrong cuz on my page nothing comes up except for my header that includes just a navbar and a banner. Any help..? Thanks

deadserious · 08-10-2004, 05:15 PM

You still need to echo the result.

You can try adding something like this at the bottom of your script.

Code:

while ($row = mysql_fetch_array($result)) { 
    echo $row['YourSelectedFieldName']; 
}

08-07-2004, 03:48 PM	THREAD STARTER #1 (permalink)
designer2004 New Member Join Date: Aug 2004 Location: Pittsburgh Posts: 3	Just starting out help.... Hello I am just starting out trying to learn PHP without taking scripts and modifying them to my likeing so now I just read tuts and books and code snippets. Now here is my code then is my problem. My Connections page thats a bit modifyed so i can post it here. PHP Code: `<?php // Connection parameters define ('DB_USER', '***'); define ('DB_PASSWORD', '*'); define ('DB_HOST', 'localhost'); define ('DB_NAME', '****'); $connect = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) or die (mysql_error()); ????: NamePros.com http://www.namepros.com/code/42376-just-starting-out-help.html mysql_select_db (DB_NAME); ?>` Now my index page. ????: NamePros.com http://www.namepros.com/showthread.php?t=42376 PHP Code: `<?php include ('./includes/header.inc'); include ('./includes/connections.php'); $query = "Select FROM home_news"; $result = mysql_query($query); ?>` Now i am sure im missing something or doing something wrong cuz on my page nothing comes up except for my header that includes just a navbar and a banner. Any help..? Thanks

08-10-2004, 05:15 PM	#2 (permalink)
deadserious Senior Member Join Date: Aug 2002 Posts: 1,255	You still need to echo the result. You can try adding something like this at the bottom of your script. Code: while ($row = mysql_fetch_array($result)) { echo $row['YourSelectedFieldName']; }

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)