Posted by Jerry Stuckle on 11/19/06 03:08

so many sites so little time wrote:
> the table is head the colunm is called body
>
> <?php //show_site.php
> // This script retrieves blog entries from the database.
>
> // Address error handing.
> ini_set ('display_errors', 1);
> error_reporting (E_ALL & ~E_NOTICE);
>
> // Connect and select.
> if ($dbc = @mysql_connect ('localhost', 'username', 'password')) {
>
> if (!@mysql_select_db ('username_tpp')) {
> die ('<p>Could select the database because: <b>' . mysql_error() .
> '</b></p>');
> }
>
> } else {
> die ('<p>Could not connect to MySQL because: <b>' . mysql_error() .
> '</b></p>');
> }
> {
> if ($show = SELECT body from home;)
>
> print "<p><h3>{$show}</h3>
> </p><hr />\n";
> }
>
> mysql_close(); // Close the database connection.
> ?>
>

Possibly because you never queried the database?

Also, the line:

if ($show = SELECT body from home;)

is not valid syntax.

And if you want to see the error messages, you need to also remove the
'@' from the mysql calls.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Re: i dont understand why this wont run
• Prev in forum: Re: i dont understand why this wont run
• Thread view: Re: i dont understand why this wont run

[Reply to this message]