I can't connect to the mysql for some reason.

jazzdrive

here is my code:

<?php
//connect to the mysql database
$db = mysql_connect("localhost","username","password");

    mysql_select_db("webdb", $db);

    $sql = "SELECT MainPage.Comic
            FROM MainPage
            WHERE MainPage.Date=" . $comicDate;

    $q = mysql_query($sql);

    $result = mysql_fetch_array($q);

    $currentComic = $result["Comic"];


    ?>

Of course, where username and password are, the real values are inserted.

It's frustrating, and any help would be appreciated.

Thanks,

Matt.

LordShryku

Debug

$db  = mysql_connect("localhost","username","password") OR die(mysql_error());
       mysql_select_db("webdb", $db);

$sql = "SELECT Comic
        FROM   MainPage
        WHERE  Date='".$comicDate."'";

$q   = mysql_query($sql) OR die("Query Error: ".mysql_error());

jazzdrive

But I can't find what it is. That's what I have been looking for.

Query Error: You have an error in your SQL syntax near '' at line 3

LordShryku

It doesn't know what $comicDate is. Where's the variable defined? It wasn't defined in your previous code. Echo the sql to the screen to see what it's doing

jazzdrive

<?php $comicDate = "20031103" ?>

<?php include 'TopPage.html'; ?>

<?php include 'ComicArea.php'; ?>

<?php include 'NewsArea.php'; ?>

<?php include 'BottomPage.html'; ?>

And the code in my previous post is in ComicArea.php. Does the variable initialization not carry through?

Sorry, I'm still a little new at this.

Thanks for your help.

LordShryku

It should carry. Like I said, echo the sql to the screen to make sure it looks right. From your previous post, I take it that you are connecting, it's just having trouble running the SQL.

jazzdrive

sweet I got it working. Sorry for the bother of a newbie, but I really appreciate it.

Thanks.

LordShryku

No prob bob 🙂