I have:
Apache 2.0.59
MySQL 5.0.41
PHP 4.4.7 & 5.2.5

and this is my program:

<?php
session_start();
include("includes/functions_main.php");
include("Vars.php");
?>
<?php get_header(); ?>
<?php get_sidebar(); ?>
<?php
$page = '$_GET[page]';
$cxn = mysqli_connect($host, $user,$passwd, $database) or die
("Can't Connect.");
$sql = "SELECT * FROM page WHERE id=$page";
$result = mysqli_query($cxn, $sql);
$row = mysqli_fetch_assoc($result);
extract ($row);
?>
<div id="column_right">
<div class="content">
<h2><?php $title ?></h2>
<?php $content ?>
</div>
</div>
<?php get_footer();?>


But i get an error every time. I have read PHP and MySQL for Dummies to
get me started but none of the things in the book seem to work for me.
It is very frustrated. I dont know whether it just my lameass host
provider that hasn't set the mysql properly.

I would appreciate any help.

Thanks

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

You did everything perfectly in the email except for show what the
error message was.

i am assuming your issue is with the line

$page = '$_GET[page]';

that should just be

$page = $_GET['page'];

The way you are doing it (inside single quotes) does not evaluate the
array as a variable, rather PHP thinks the entire thing is just a
string.

when you you do the query

$sql = "SELECT * FROM page WHERE id=$page";

Your query is actually

"SELECT * FROM page WHERE id=$_GET[page]";

Now changing that one line may fix the issue at hand but I will also
suggest that you read articles, blog entries, etc about SQL Injection
and how to cleanse your data before throwing a user submitted value at
your database.

Thanks,
Joseph Crawford

On Sep 2, 2008, at 3:05 PM, Chris Hale wrote:

> I have:
> Apache 2.0.59
> MySQL 5.0.41
> PHP 4.4.7 & 5.2.5
>
> and this is my program:
>
> <?php
> session_start();
> include("includes/functions_main.php");
> include("Vars.php");
> ?> <?php get_header(); ?>
> <?php get_sidebar(); ?>
> <?php
> $page = '$_GET[page]';
> $cxn = mysqli_connect($host, $user,$passwd, $database) or die
> ("Can't Connect.");
> $sql = "SELECT * FROM page WHERE id=$page";
> $result = mysqli_query($cxn, $sql);
> $row = mysqli_fetch_assoc($result);
> extract ($row);
> ?>
> <div id="column_right">
> <div class="content">
> <h2><?php $title ?></h2>
> <?php $content ?>
> </div>
> </div>
> <?php get_footer();?>
>
>
> But i get an error every time. I have read PHP and MySQL for Dummies
> to get me started but none of the things in the book seem to work
> for me. It is very frustrated. I dont know whether it just my
> lameass host provider that hasn't set the mysql properly.
>
> I would appreciate any help.
>
> Thanks
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

In the HTML, you either need to use <?php echo $title; ?> or, if you
have short tags on, <?= $title ?>, not <?php $title ?>.

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



Chris Hale wrote:
> I have:
> Apache 2.0.59
> MySQL 5.0.41
> PHP 4.4.7 & 5.2.5
>
> and this is my program:
>
> <?php
> session_start();
> include("includes/functions_main.php");
> include("Vars.php");
> ?> <?php get_header(); ?>
> <?php get_sidebar(); ?>
> <?php
> $page = '$_GET[page]';
> $cxn = mysqli_connect($host, $user,$passwd, $database) or die
> ("Can't Connect.");
> $sql = "SELECT * FROM page WHERE id=$page";
> $result = mysqli_query($cxn, $sql);
> $row = mysqli_fetch_assoc($result);
> extract ($row);
> ?>
> <div id="column_right">
> <div class="content">
> <h2><?php $title ?></h2>
> <?php $content ?>
> </div>
> </div>
> <?php get_footer();?>
>
>
> But i get an error every time. I have read PHP and MySQL for Dummies
> to get me started but none of the things in the book seem to work for
> me. It is very frustrated. I dont know whether it just my lameass host
> provider that hasn't set the mysql properly.
>
> I would appreciate any help.
>
> Thanks
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php