Re: Im new to this but...

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