Database connection breaking my page.

partypete

Hello,

I'm trying to make a page with a recordset in dreamweaver MX, and it appears to work while in dreamweaver. But when I upload the page to my webserver it breaks. This is code from a test page I made. Can you see what might be causing it to break??

Thanks, Peter
Code::::::

<?php require_once('Connections/connWebsiteAuction.php'); ?>
<?php
mysql_select_db($database_connWebsiteAuction, $connWebsiteAuction);
$query_rsAuctions = "SELECT item_id, item_title, item_description,
item_ends, item_view, item_photo_thumb, item_photo_big FROM auction_items
WHERE item_ends >= now() AND item_view ="S" ORDER BY item_ends ASC";
$rsAuctions = mysql_query($query_rsAuctions, $connWebsiteAuction) or
die(mysql_error());
$row_rsAuctions = mysql_fetch_assoc($rsAuctions);
$totalRows_rsAuctions = mysql_num_rows($rsAuctions);
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>

partypete

What the heck? It's just the WHERE clause that's causing the problem. If I delete the WHERE clause the page appears.

WHERE item_ends >= now() AND item_view ="S"

Is this WHERE clause messed up? It works when Testing it while creating the recordset, so why won't it work on the web????

Peter

Sxooter

Next time, use the PHP tags and you'll see the error:

$query = "select * from test where S="W" order by idfield";
print $query;

See how the " symbol is ending your string early? PHP thinks that W is the next command it's being tossed to parse, not the data. To make a " show up as data, use a \ in front of it.

$query = "select * from table where S=\"W\"";
print $query;

BUT!!! that's not all. You shouldn't use " to quote data in a SQL query, only identifiers (although MySQL for some reason chooses to not support this, but that's a side point / mini rant.) so, you need this:

$query = "select * from table where S='W'";
print $query;

partypete

THANK YOU THANK YOU THANK YOU A THOUSAND TIMES!!!!!!! Wrong damn quotes, how simple, I'm an ass.

I was mainly confused because in dreamweaver when I tested that query it returned the records I wanted and didn't report any errors in my SQL so I thought there was no problem with it.

Thank you again for taking the time!

Peter

partypete

Oops one more thing, what do you mean by use the PHP tags and you'll see the error?

Thanks!

Sxooter

When you bring up the editor on this site, there's a button up there that says php. If you click it, you get tags that look like this: [ php ] but without the spaces I added (so you could see it.)

They cause your code to be color coded, which helps you find these things.

Also, if you're running apache, you can turn on the phps handler function with the line:

AddType application/x-httpd-php-source .phps

in httpd.conf

then, you can do:

ln -s sourcefile.php sourcefile.phps

and when you view the phps file in your web browser (served through apache) it will be nicely color coded as well.

Oh yeah, and you're welcome... Welcome to the board.