i dont understand why this wont run

so many sites so little time

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 ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
}
{
if ($show = SELECT body from home;)

print "<h3>{$show}</h3>
<hr />\n";
}

mysql_close(); // Close the database connection.
?>

Nov 19 '06 #1

Subscribe Post Reply

2218

so many sites so little time

to see a test of this go to www.kirewire.com/ttp/index.php

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 ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
}
{
if ($show = SELECT body from home;)

print "<h3>{$show}</h3>
<hr />\n";
}

mysql_close(); // Close the database connection.
?>

Nov 19 '06 #2

Jerry Stuckle

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 ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
}
{
if ($show = SELECT body from home;)

print "<h3>{$show}</h3>
<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.
js*******@attglobal.net
==================

Nov 19 '06 #3

Jerry Stuckle

so many sites so little time wrote:

to see a test of this go to www.kirewire.com/ttp/index.php

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 ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
}
{
if ($show = SELECT body from home;)

print "<h3>{$show}</h3>
<hr />\n";
}

mysql_close(); // Close the database connection.
?>

Not Found
The requested URL /ttp/index.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.
Apache/1.3.37 Server at www.kirewire.com Port 80

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

Nov 19 '06 #4

so many sites so little time

woops sorry its /tpp why isnt it valid syntax :( pay so much for books
that lie ;_;
Jerry Stuckle wrote:

so many sites so little time wrote:
to see a test of this go to www.kirewire.com/ttp/index.php

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 ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
}
{
if ($show = SELECT body from home;)

print "<h3>{$show}</h3>
<hr />\n";
}

mysql_close(); // Close the database connection.
?>

Not Found
The requested URL /ttp/index.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.
Apache/1.3.37 Server at www.kirewire.com Port 80

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

Nov 19 '06 #5

so many sites so little time

im really stuck what would work in this case all im trying to do with
that $show is to query the data base to select from table home the info
in column body and print it to the screen
so many sites so little time wrote:

woops sorry its /tpp why isnt it valid syntax :( pay so much for books
that lie ;_;
Jerry Stuckle wrote:
so many sites so little time wrote:
to see a test of this go to www.kirewire.com/ttp/index.php
>
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 ('Could select the database because: ' . mysql_error() .
>>'');
>> }
>>
>>} else {
>> die ('Could not connect to MySQL because: ' . mysql_error() .
>>'');
>>}
>>{
>>if ($show = SELECT body from home;)
>>
>> print "<h3>{$show}</h3>
>> <hr />\n";
>> }
>>
>>mysql_close(); // Close the database connection.
>>?>
>
>
Not Found
The requested URL /ttp/index.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.
Apache/1.3.37 Server at www.kirewire.com Port 80

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

Nov 19 '06 #6

so many sites so little time

i tried to fix it getting
Parse error: syntax error, unexpected T_STRING in
/home/kirewire/public_html/pp2/index.php on line 222

for

....ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);

// Connect and select.
if ($dbc = mysql_connect ('localhost', 'kirewire', 'erikwire')) {

if (!mysql_select_db ('kirewire_tpp')) {
die ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
$query = SELECT body from home;

print "<h3>{$$query}</h3>
<hr />\n";
}

mysql_close(); // Close the database connection.
?>
so many sites so little time wrote:

im really stuck what would work in this case all im trying to do with
that $show is to query the data base to select from table home the info
in column body and print it to the screen
so many sites so little time wrote:
woops sorry its /tpp why isnt it valid syntax :( pay so much for books
that lie ;_;
Jerry Stuckle wrote:
so many sites so little time wrote:
to see a test of this go to www.kirewire.com/ttp/index.php

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 ('Could select the database because: ' . mysql_error() .
>'');
> }
>
>} else {
> die ('Could not connect to MySQL because: ' . mysql_error() .
>'');
>}
>{
>if ($show = SELECT body from home;)
>
> print "<h3>{$show}</h3>
> <hr />\n";
> }
>
>mysql_close(); // Close the database connection.
>?>

>
Not Found
The requested URL /ttp/index.php was not found on this server.
>
Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.
Apache/1.3.37 Server at www.kirewire.com Port 80
>
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Nov 19 '06 #7

so many sites so little time

alright so this is where im at, i did this and now it says it works but
jerry knows that i resolved my problem earlier with
www.kirewire.com/tpp2/update_site.php now i just fixed the problem with
kirewire.com/tpp2/index.php but nothing shows up on the index site but
i get no errors on the index site it looks like this

if ($dbc = mysql_connect ('localhost', 'kirewire', 'erikwire')) {

if (!mysql_select_db ('kirewire_tpp')) {
die ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');

}
$result = mysql_query ($query);

$query = 'SELECT * FROM home';

print "<h3>{$result}</h3>
<hr />\n";
mysql_close(); // Close the database connection.
?>

on the update site it looks like this:

// Define the query.
$query = "Update home Set body = '($_POST)'";

// Execute the query.
if (@mysql_query ($query)) {
print 'Your site has been updated!.';
} else {
print "Sorry by your site could not be updated because: " .
mysql_error() . ". The query was $query.";
}

mysql_close();

}

// Display the form.
?>

so many sites so little time wrote:

i tried to fix it getting
Parse error: syntax error, unexpected T_STRING in
/home/kirewire/public_html/pp2/index.php on line 222

for

...ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);

// Connect and select.
if ($dbc = mysql_connect ('localhost', 'kirewire', 'erikwire')) {

if (!mysql_select_db ('kirewire_tpp')) {
die ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
$query = SELECT body from home;

print "<h3>{$$query}</h3>
<hr />\n";
}

mysql_close(); // Close the database connection.
?>
so many sites so little time wrote:
im really stuck what would work in this case all im trying to do with
that $show is to query the data base to select from table home the info
in column body and print it to the screen
so many sites so little time wrote:
woops sorry its /tpp why isnt it valid syntax :( pay so much for books
that lie ;_;
Jerry Stuckle wrote:
so many sites so little time wrote:
to see a test of this go to www.kirewire.com/ttp/index.php
>
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 ('Could select the database because: ' . mysql_error() .
>>'');
>> }
>>
>>} else {
>> die ('Could not connect to MySQL because: ' . mysql_error() .
>>'');
>>}
>>{
>>if ($show = SELECT body from home;)
>>
>> print "<h3>{$show}</h3>
>> <hr />\n";
>> }
>>
>>mysql_close(); // Close the database connection.
>>?>
>
>

Not Found
The requested URL /ttp/index.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.
Apache/1.3.37 Server at www.kirewire.com Port 80

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

Nov 19 '06 #8

Tim Roberts

"so many sites so little time" <kk*****@gmail.comwrote:

>
the table is head the colunm is called body

<?php //show_site.php
// This script retrieves blog entries from the database.
...
// Connect and select.
if ($dbc = @mysql_connect ('localhost', 'username', 'password')) {

if (!@mysql_select_db ('username_tpp')) {
die ('Could select the database because: ' . mysql_error() .
'');
}
} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
}
{
if ($show = SELECT body from home;)

You didn't really expect that to work, did you?

$q = mysql_query("SELECT body FROM home;", $dbc);
while( $row = mysql_fetch_array($q) )
{
echo "<h3>$row</h3>\n";
}

>mysql_close(); // Close the database connection.
?>

By the way, you can't embed an <h3tag into a <ptag.
--
Tim Roberts, ti**@probo.com
Providenza & Boekelheide, Inc.

Nov 19 '06 #9

Jerry Stuckle

so many sites so little time wrote:

alright so this is where im at, i did this and now it says it works but
jerry knows that i resolved my problem earlier with
www.kirewire.com/tpp2/update_site.php now i just fixed the problem with
kirewire.com/tpp2/index.php but nothing shows up on the index site but
i get no errors on the index site it looks like this

if ($dbc = mysql_connect ('localhost', 'kirewire', 'erikwire')) {

if (!mysql_select_db ('kirewire_tpp')) {
die ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');

}
$result = mysql_query ($query);

$query = 'SELECT * FROM home';

print "<h3>{$result}</h3>
<hr />\n";
mysql_close(); // Close the database connection.
?>

on the update site it looks like this:

// Define the query.
$query = "Update home Set body = '($_POST)'";

// Execute the query.
if (@mysql_query ($query)) {
print 'Your site has been updated!.';
} else {
print "Sorry by your site could not be updated because: " .
mysql_error() . ". The query was $query.";
}

mysql_close();

}

// Display the form.
?>

so many sites so little time wrote:

>>i tried to fix it getting
Parse error: syntax error, unexpected T_STRING in
/home/kirewire/public_html/pp2/index.php on line 222

for

...ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);

// Connect and select.
if ($dbc = mysql_connect ('localhost', 'kirewire', 'erikwire')) {

if (!mysql_select_db ('kirewire_tpp')) {
die ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
$query = SELECT body from home;

print "<h3>{$$query}</h3>
<hr />\n";
}

mysql_close(); // Close the database connection.
?>
so many sites so little time wrote:

>>>im really stuck what would work in this case all im trying to do with
that $show is to query the data base to select from table home the info
in column body and print it to the screen
so many sites so little time wrote:

woops sorry its /tpp why isnt it valid syntax :( pay so much for books
that lie ;_;
Jerry Stuckle wrote:

>so many sites so little time wrote:
>
>>to see a test of this go to www.kirewire.com/ttp/index.php
>>
>>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 ('Could select the database because: ' . mysql_error() .
>>>'');
>>> }
>>>
>>>} else {
>>> die ('Could not connect to MySQL because: ' . mysql_error() .
>>>'');
>>>}
>>>{
>>>if ($show = SELECT body from home;)
>>>
>>> print "<h3>{$show}</h3>
>>> <hr />\n";
>>> }
>>>
>>>mysql_close(); // Close the database connection.
>>>?>
>>
>>
>Not Found
>The requested URL /ttp/index.php was not found on this server.
>
>Additionally, a 404 Not Found error was encountered while trying to use
>an ErrorDocument to handle the request.
>Apache/1.3.37 Server at www.kirewire.com Port 80
>
>--
>==================
>Remove the "x" from my email address
>Jerry Stuckle
>JDS Computer Training Corp.
>js*******@attglobal.net
>==================

Not Found
The requested URL /tpp2/index.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.
Apache/1.3.37 Server at www.kirewire.com Port 80

And you'll get more help when you learn to post properly.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Nov 19 '06 #10

so many sites so little time

gah sorry let me copy and paste it i didnt put it in the directory and
its such a stupid directory name that i keep forgetting exactly what it
is... http://kirewire.com/pp2/index.php
Jerry Stuckle wrote:

so many sites so little time wrote:
alright so this is where im at, i did this and now it says it works but
jerry knows that i resolved my problem earlier with
www.kirewire.com/tpp2/update_site.php now i just fixed the problem with
kirewire.com/tpp2/index.php but nothing shows up on the index site but
i get no errors on the index site it looks like this

if ($dbc = mysql_connect ('localhost', 'kirewire', 'erikwire')) {

if (!mysql_select_db ('kirewire_tpp')) {
die ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');

}
$result = mysql_query ($query);

$query = 'SELECT * FROM home';

print "<h3>{$result}</h3>
<hr />\n";
mysql_close(); // Close the database connection.
?>

on the update site it looks like this:

// Define the query.
$query = "Update home Set body = '($_POST)'";

// Execute the query.
if (@mysql_query ($query)) {
print 'Your site has been updated!.';
} else {
print "Sorry by your site could not be updated because: " .
mysql_error() . ". The query was $query.";
}

mysql_close();

}

// Display the form.
?>

so many sites so little time wrote:

>i tried to fix it getting
Parse error: syntax error, unexpected T_STRING in
/home/kirewire/public_html/pp2/index.php on line 222

for

...ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);

// Connect and select.
if ($dbc = mysql_connect ('localhost', 'kirewire', 'erikwire')) {

if (!mysql_select_db ('kirewire_tpp')) {
die ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
$query = SELECT body from home;

print "<h3>{$$query}</h3>
<hr />\n";
}

mysql_close(); // Close the database connection.
?>
so many sites so little time wrote:

im really stuck what would work in this case all im trying to do with
that $show is to query the data base to select from table home the info
in column body and print it to the screen
so many sites so little time wrote:

woops sorry its /tpp why isnt it valid syntax :( pay so much for books
that lie ;_;
Jerry Stuckle wrote:

so many sites so little time wrote:

>to see a test of this go to www.kirewire.com/ttp/index.php
>
>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 ('Could select the database because: ' . mysql_error() .
>>'');
>> }
>>
>>} else {
>> die ('Could not connect to MySQL because: ' . mysql_error() .
>>'');
>>}
>>{
>>if ($show = SELECT body from home;)
>>
>> print "<h3>{$show}</h3>
>> <hr />\n";
>> }
>>
>>mysql_close(); // Close the database connection.
>>?>
>
>
Not Found
The requested URL /ttp/index.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.
Apache/1.3.37 Server at www.kirewire.com Port 80

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

Not Found
The requested URL /tpp2/index.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.
Apache/1.3.37 Server at www.kirewire.com Port 80

And you'll get more help when you learn to post properly.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Nov 19 '06 #11

so many sites so little time

and the other one is http://kirewire.com/pp2/update_site.php
i just dont understand why that doesnt work i cant find anything that
would suggest that that shouldnt work.
so many sites so little time wrote:

gah sorry let me copy and paste it i didnt put it in the directory and
its such a stupid directory name that i keep forgetting exactly what it
is... http://kirewire.com/pp2/index.php
Jerry Stuckle wrote:
so many sites so little time wrote:
alright so this is where im at, i did this and now it says it works but
jerry knows that i resolved my problem earlier with
www.kirewire.com/tpp2/update_site.php now i just fixed the problem with
kirewire.com/tpp2/index.php but nothing shows up on the index site but
i get no errors on the index site it looks like this
>
if ($dbc = mysql_connect ('localhost', 'kirewire', 'erikwire')) {
>
if (!mysql_select_db ('kirewire_tpp')) {
die ('Could select the database because: ' . mysql_error() .
'');
}
>
} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
>
}
$result = mysql_query ($query);
>
$query = 'SELECT * FROM home';
>
print "<h3>{$result}</h3>
<hr />\n";
>
>
mysql_close(); // Close the database connection.
?>
>
on the update site it looks like this:
>
// Define the query.
$query = "Update home Set body = '($_POST)'";
>
// Execute the query.
if (@mysql_query ($query)) {
print 'Your site has been updated!.';
} else {
print "Sorry by your site could not be updated because: " .
mysql_error() . ". The query was $query.";
}
>
mysql_close();
>
}
>
// Display the form.
?>
>
so many sites so little time wrote:
>
>>i tried to fix it getting
>>Parse error: syntax error, unexpected T_STRING in
>>/home/kirewire/public_html/pp2/index.php on line 222
>>
>>for
>>
>>...ini_set ('display_errors', 1);
>>error_reporting (E_ALL & ~E_NOTICE);
>>
>>// Connect and select.
>>if ($dbc = mysql_connect ('localhost', 'kirewire', 'erikwire')) {
>>
>> if (!mysql_select_db ('kirewire_tpp')) {
>> die ('Could select the database because: ' . mysql_error() .
>>'');
>> }
>>
>>} else {
>> die ('Could not connect to MySQL because: ' . mysql_error() .
>>'');
>>
>>
>>$query = SELECT body from home;
>>
>> print "<h3>{$$query}</h3>
>> <hr />\n";
>> }
>>
>>mysql_close(); // Close the database connection.
>>?>
>>so many sites so little time wrote:
>>
>>>im really stuck what would work in this case all im trying to do with
>>>that $show is to query the data base to select from table home the info
>>>in column body and print it to the screen
>>>so many sites so little time wrote:
>>>
>>>>woops sorry its /tpp why isnt it valid syntax :( pay so much for books
>>>>that lie ;_;
>>>>Jerry Stuckle wrote:
>>>>
>>>>>so many sites so little time wrote:
>>>>>
>>>>>>to see a test of this go to www.kirewire.com/ttp/index.php
>>>>>>
>>>>>>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 ('Could select the database because: ' . mysql_error() .
>>>>>>>'');
>>>>>>> }
>>>>>>>
>>>>>>>} else {
>>>>>>> die ('Could not connect to MySQL because: ' . mysql_error() .
>>>>>>>'');
>>>>>>>}
>>>>>>>{
>>>>>>>if ($show = SELECT body from home;)
>>>>>>>
>>>>>>> print "<h3>{$show}</h3>
>>>>>>> <hr />\n";
>>>>>>> }
>>>>>>>
>>>>>>>mysql_close(); // Close the database connection.
>>>>>>>?>
>>>>>>
>>>>>>
>>>>>Not Found
>>>>>The requested URL /ttp/index.php was not found on this server.
>>>>>
>>>>>Additionally, a 404 Not Found error was encountered while trying to use
>>>>>an ErrorDocument to handle the request.
>>>>>Apache/1.3.37 Server at www.kirewire.com Port 80
>>>>>
>>>>>--
>>>>>==================
>>>>>Remove the "x" from my email address
>>>>>Jerry Stuckle
>>>>>JDS Computer Training Corp.
>>>>>js*******@attglobal.net
>>>>>==================
>
>
Not Found
The requested URL /tpp2/index.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.
Apache/1.3.37 Server at www.kirewire.com Port 80

And you'll get more help when you learn to post properly.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Nov 19 '06 #12

so many sites so little time

ok here is the code i am working off of and they embed the h3 tag i
dont think larry ulman would lie to me :(

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html;
charset=iso-8859-1" />
<title>View My Blog</title>
</head>
<body>
<?php // Script 12.6 - view_blog.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 ('myblog')) {
die ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
}

// Define the query.
$query = 'SELECT * FROM blog_entries ORDER BY date_entered DESC';

if ($r = mysql_query ($query)) { // Run the query.

// Retrieve and print every record.
while ($row = mysql_fetch_array ($r)) {
print "<h3>{$row['title']}</h3>
{$row['entry']} 
<a href=\"edit_entry.php?id={$row['blog_id']}\">Edit</a>
<a href=\"delete_entry.php?id={$row['blog_id']}\">Delete</a>
<hr />\n";
}

} else { // Query didn't run.
die ('Could create the table because: ' . mysql_error() . ".
The query was $query.");
} // End of query IF.

mysql_close(); // Close the database connection.

?>
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html;
charset=iso-8859-1" />
<title>View My Blog</title>
</head>
<body>
<?php // Script 12.6 - view_blog.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 ('myblog')) {
die ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
}

// Define the query.
$query = 'SELECT * FROM blog_entries ORDER BY date_entered DESC';

if ($r = mysql_query ($query)) { // Run the query.

// Retrieve and print every record.
while ($row = mysql_fetch_array ($r)) {
print "<h3>{$row['title']}</h3>
{$row['entry']} 
<a href=\"edit_entry.php?id={$row['blog_id']}\">Edit</a>
<a href=\"delete_entry.php?id={$row['blog_id']}\">Delete</a>
<hr />\n";
}

} else { // Query didn't run.
die ('Could create the table because: ' . mysql_error() . ".
The query was $query.");
} // End of query IF.

mysql_close(); // Close the database connection.

?>
</body>
</html>
so many sites so little time wrote:

gah sorry let me copy and paste it i didnt put it in the directory and
its such a stupid directory name that i keep forgetting exactly what it
is... http://kirewire.com/pp2/index.php
Jerry Stuckle wrote:
so many sites so little time wrote:
alright so this is where im at, i did this and now it says it works but
jerry knows that i resolved my problem earlier with
www.kirewire.com/tpp2/update_site.php now i just fixed the problem with
kirewire.com/tpp2/index.php but nothing shows up on the index site but
i get no errors on the index site it looks like this
>
if ($dbc = mysql_connect ('localhost', 'kirewire', 'erikwire')) {
>
if (!mysql_select_db ('kirewire_tpp')) {
die ('Could select the database because: ' . mysql_error() .
'');
}
>
} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');
>
}
$result = mysql_query ($query);
>
$query = 'SELECT * FROM home';
>
print "<h3>{$result}</h3>
<hr />\n";
>
>
mysql_close(); // Close the database connection.
?>
>
on the update site it looks like this:
>
// Define the query.
$query = "Update home Set body = '($_POST)'";
>
// Execute the query.
if (@mysql_query ($query)) {
print 'Your site has been updated!.';
} else {
print "Sorry by your site could not be updated because: " .
mysql_error() . ". The query was $query.";
}
>
mysql_close();
>
}
>
// Display the form.
?>
>
so many sites so little time wrote:
>
>>i tried to fix it getting
>>Parse error: syntax error, unexpected T_STRING in
>>/home/kirewire/public_html/pp2/index.php on line 222
>>
>>for
>>
>>...ini_set ('display_errors', 1);
>>error_reporting (E_ALL & ~E_NOTICE);
>>
>>// Connect and select.
>>if ($dbc = mysql_connect ('localhost', 'kirewire', 'erikwire')) {
>>
>> if (!mysql_select_db ('kirewire_tpp')) {
>> die ('Could select the database because: ' . mysql_error() .
>>'');
>> }
>>
>>} else {
>> die ('Could not connect to MySQL because: ' . mysql_error() .
>>'');
>>
>>
>>$query = SELECT body from home;
>>
>> print "<h3>{$$query}</h3>
>> <hr />\n";
>> }
>>
>>mysql_close(); // Close the database connection.
>>?>
>>so many sites so little time wrote:
>>
>>>im really stuck what would work in this case all im trying to do with
>>>that $show is to query the data base to select from table home the info
>>>in column body and print it to the screen
>>>so many sites so little time wrote:
>>>
>>>>woops sorry its /tpp why isnt it valid syntax :( pay so much for books
>>>>that lie ;_;
>>>>Jerry Stuckle wrote:
>>>>
>>>>>so many sites so little time wrote:
>>>>>
>>>>>>to see a test of this go to www.kirewire.com/ttp/index.php
>>>>>>
>>>>>>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 ('Could select the database because: ' . mysql_error() .
>>>>>>>'');
>>>>>>> }
>>>>>>>
>>>>>>>} else {
>>>>>>> die ('Could not connect to MySQL because: ' . mysql_error() .
>>>>>>>'');
>>>>>>>}
>>>>>>>{
>>>>>>>if ($show = SELECT body from home;)
>>>>>>>
>>>>>>> print "<h3>{$show}</h3>
>>>>>>> <hr />\n";
>>>>>>> }
>>>>>>>
>>>>>>>mysql_close(); // Close the database connection.
>>>>>>>?>
>>>>>>
>>>>>>
>>>>>Not Found
>>>>>The requested URL /ttp/index.php was not found on this server.
>>>>>
>>>>>Additionally, a 404 Not Found error was encountered while trying to use
>>>>>an ErrorDocument to handle the request.
>>>>>Apache/1.3.37 Server at www.kirewire.com Port 80
>>>>>
>>>>>--
>>>>>==================
>>>>>Remove the "x" from my email address
>>>>>Jerry Stuckle
>>>>>JDS Computer Training Corp.
>>>>>js*******@attglobal.net
>>>>>==================
>
>
Not Found
The requested URL /tpp2/index.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.
Apache/1.3.37 Server at www.kirewire.com Port 80

And you'll get more help when you learn to post properly.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Nov 19 '06 #13

so many sites so little time

this is the statement im using now and it looks clean to me but doenst
work and doesnt give me an error

$query = 'SELECT * FROM home';

if ($result = mysql_query ($query))

print "<h3>{$result}</h3>
<hr />\n";
}

so im guessing that ($result doesnt = mysql_query (query))
but why what am i doing wrong?
so many sites so little time wrote:

and the other one is http://kirewire.com/pp2/update_site.php
i just dont understand why that doesnt work i cant find anything that
would suggest that that shouldnt work.
so many sites so little time wrote:
gah sorry let me copy and paste it i didnt put it in the directory and
its such a stupid directory name that i keep forgetting exactly what it
is... http://kirewire.com/pp2/index.php
Jerry Stuckle wrote:
so many sites so little time wrote:
alright so this is where im at, i did this and now it says it works but
jerry knows that i resolved my problem earlier with
www.kirewire.com/tpp2/update_site.php now i just fixed the problem with
kirewire.com/tpp2/index.php but nothing shows up on the index site but
i get no errors on the index site it looks like this

if ($dbc = mysql_connect ('localhost', 'kirewire', 'erikwire')) {

if (!mysql_select_db ('kirewire_tpp')) {
die ('Could select the database because: ' . mysql_error() .
'');
}

} else {
die ('Could not connect to MySQL because: ' . mysql_error() .
'');

}
$result = mysql_query ($query);

$query = 'SELECT * FROM home';

print "<h3>{$result}</h3>
<hr />\n";

mysql_close(); // Close the database connection.
?>

on the update site it looks like this:

// Define the query.
$query = "Update home Set body = '($_POST)'";

// Execute the query.
if (@mysql_query ($query)) {
print 'Your site has been updated!.';
} else {
print "Sorry by your site could not be updated because: " .
mysql_error() . ". The query was $query.";
}

mysql_close();

}

// Display the form.
?>

so many sites so little time wrote:

>i tried to fix it getting
>Parse error: syntax error, unexpected T_STRING in
>/home/kirewire/public_html/pp2/index.php on line 222
>
>for
>
>...ini_set ('display_errors', 1);
>error_reporting (E_ALL & ~E_NOTICE);
>
>// Connect and select.
>if ($dbc = mysql_connect ('localhost', 'kirewire', 'erikwire')) {
>
> if (!mysql_select_db ('kirewire_tpp')) {
> die ('Could select the database because: ' . mysql_error() .
>'');
> }
>
>} else {
> die ('Could not connect to MySQL because: ' . mysql_error() .
>'');
>
>
>$query = SELECT body from home;
>
> print "<h3>{$$query}</h3>
> <hr />\n";
> }
>
>mysql_close(); // Close the database connection.
>?>
>so many sites so little time wrote:
>
>>im really stuck what would work in this case all im trying to do with
>>that $show is to query the data base to select from table home the info
>>in column body and print it to the screen
>>so many sites so little time wrote:
>>
>>>woops sorry its /tpp why isnt it valid syntax :( pay so much for books
>>>that lie ;_;
>>>Jerry Stuckle wrote:
>>>
>>>>so many sites so little time wrote:
>>>>
>>>>>to see a test of this go to www.kirewire.com/ttp/index.php
>>>>>
>>>>>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 ('Could select the database because: ' . mysql_error() .
>>>>>>'');
>>>>>> }
>>>>>>
>>>>>>} else {
>>>>>> die ('Could not connect to MySQL because: ' . mysql_error() .
>>>>>>'');
>>>>>>}
>>>>>>{
>>>>>>if ($show = SELECT body from home;)
>>>>>>
>>>>>> print "<h3>{$show}</h3>
>>>>>> <hr />\n";
>>>>>> }
>>>>>>
>>>>>>mysql_close(); // Close the database connection.
>>>>>>?>
>>>>>
>>>>>
>>>>Not Found
>>>>The requested URL /ttp/index.php was not found on this server.
>>>>
>>>>Additionally, a 404 Not Found error was encountered while trying to use
>>>>an ErrorDocument to handle the request.
>>>>Apache/1.3.37 Server at www.kirewire.com Port 80
>>>>
>>>>--
>>>>==================
>>>>Remove the "x" from my email address
>>>>Jerry Stuckle
>>>>JDS Computer Training Corp.
>>>>js*******@attglobal.net
>>>>==================

>
Not Found
The requested URL /tpp2/index.php was not found on this server.
>
Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.
Apache/1.3.37 Server at www.kirewire.com Port 80
>
And you'll get more help when you learn to post properly.
>
>
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Nov 19 '06 #14

Erwin Moller

Hi,

[Start Just a friendly word of advise.]
You might get luckier if you follow Jerry's advise and post properly.
This thread you created is a mess, and I gave up at trying to follow your
line of thought/problem somewhere at the end.

Please make sure you understand WHAT you are doing, then make a posting that
clearly describes your problem.
I don't think many in here will read through your whole thread with code,
corrections on the code, new code, top-postings, questions, wrong url, new
code, etc.
It is just too messy. (No offense intended)
[End Just a friendly word of advise.]

Now please restate your problem in a clear way in a fresh thread.
Regards,
Erwin Moller

Nov 19 '06 #15

Pedro Graca

Please do not top-post.
Please trim unnecessary lines from the quoted articles.
Please read http://www.greenend.org.uk/rjk/2000/06/14/quoting.html
Thank you.

so many sites so little time wrote:
<snip>

$result = mysql_query ($query);

$query = 'SELECT * FROM home';

print "<h3>{$result}</h3>
<hr />\n";

Wrong order of statements.

*First* you set up variables,
*then* you call mysql_query(),
*then* you call mysql_fetch_*(),
and *last*, in a loop, you print the data.

--
I (almost) never check the dodgeit address.
If you *really* need to mail me, use the address in the Reply-To
header with a message in *plain* *text* *without* *attachments*.

Nov 19 '06 #16

Pedro Graca

so many sites so little time wrote:

ok here is the code i am working off of and they embed the h3 tag i
dont think larry ulman would lie to me :(

Try the World Wide Web Consortium (W3C) Validator
http://validator.w3.org/

--
I (almost) never check the dodgeit address.
If you *really* need to mail me, use the address in the Reply-To
header with a message in *plain* *text* *without* *attachments*.

Nov 19 '06 #17

so many sites so little time

i followed erwin mollers advice and started a new thread i dont want it
to be a fetch array i dont want it to loop i only want 1 row of data
which is why i just used SELECT
Pedro Graca wrote:

so many sites so little time wrote:
ok here is the code i am working off of and they embed the h3 tag i
dont think larry ulman would lie to me :(

Try the World Wide Web Consortium (W3C) Validator
http://validator.w3.org/

--
I (almost) never check the dodgeit address.
If you *really* need to mail me, use the address in the Reply-To
header with a message in *plain* *text* *without* *attachments*.

Nov 19 '06 #18

so many sites so little time

plus that validator just shows errors in the html markup apparently
cause im not getting any php errors and the errors it is showing me
dont matter cause the site still works and those markups its showing me
were generated with dreamweaver 8

so many sites so little time wrote:

i followed erwin mollers advice and started a new thread i dont want it
to be a fetch array i dont want it to loop i only want 1 row of data
which is why i just used SELECT
Pedro Graca wrote:
so many sites so little time wrote:
ok here is the code i am working off of and they embed the h3 tag i
dont think larry ulman would lie to me :(
Try the World Wide Web Consortium (W3C) Validator
http://validator.w3.org/

--
I (almost) never check the dodgeit address.
If you *really* need to mail me, use the address in the Reply-To
header with a message in *plain* *text* *without* *attachments*.

Nov 19 '06 #19

Jerry Stuckle

so many sites so little time wrote:

i followed erwin mollers advice and started a new thread i dont want it
to be a fetch array i dont want it to loop i only want 1 row of data
which is why i just used SELECT
Pedro Graca wrote:

>>so many sites so little time wrote:

>>>ok here is the code i am working off of and they embed the h3 tag i
dont think larry ulman would lie to me :(

Try the World Wide Web Consortium (W3C) Validator
http://validator.w3.org/

--
I (almost) never check the dodgeit address.
If you *really* need to mail me, use the address in the Reply-To
header with a message in *plain* *text* *without* *attachments*.

And you're not going to get any answers on that thread either until you
learn how to post properly.

You need to follow ALL of Erwin's advice. It's good.

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

Nov 19 '06 #20

i dont understand why this wont run

Similar topics