Thanks for your interest in helping me.
Ok I know nothing about writing php but I cant see having a web-site without it.
It is a reality script that I use for something other.
It comes with its own standard templates that works great.
But I would love to incorporate this into my main site.
Iv started using style sheets instead of tables.
This is where the trouble is. It's a three-column layout
and the right column is fixed.
Now when the center column text content extends to far to the right it screws up my layout.
I have tried but I can't get the layout to work.
Now back to the code.
If I could use a hard return and not have the script go so far to the right
Everything would work fine.
So this is where my question comes in.
The line I stated in the first post is the one line. It goes way to the right.
I need to do a return (enter key) and keep it more to the left
in my editor. But when I do and upload it to the web I just get
an "contact the system admin" PAGE.
I then receive a SQL error message in my email.
I know when I to a return on the code in the first post that it is wrong because it goes from light gray text to
dark bold black text. (Don't laugh im new) lol
I have looked at tons of codes to see if I can get an idea and
I find nothing also I try and search but what do I search for?
$sql = "drop table IF EXISTS temp";
$recordSet = $conn->Execute($sql);
if ($recordSet === false) log_error($sql);
$sql = "CREATE TEMPORARY TABLE temp SELECT listingsDB.ID, listingsDB.Title, listingsDBElements.field_name, listingsDBElements.field_value FROM listingsDB, listingsDBElements WHERE (listingsDBElements.listing_id = listingsDB.ID) AND ";
if ($config[use_expiration] == "yes")
{
$sql .= "(listingsDB.expiration > ".$conn->DBDate(time()).") AND ";
}
$sql .= "(listingsDB.active = 'yes')";
$recordSet = $conn->Execute($sql);
if ($recordSet === false) log_error($sql);
reset ($HTTP_GET_VARS);
while (list($ElementIndexValue, $ElementContents) = each($HTTP_GET_VARS))
{
if ($ElementIndexValue == "sortby")
{
$guidestring_with_sort = "$ElementIndexValue=$ElementContents";
}
elseif ($ElementIndexValue == "cur_page")
{
// do nothing
}
elseif ($ElementIndexValue == "PHPSESSID")
{
// do nothing
}
elseif ($ElementIndexValue == "imagesOnly")
{
$guidestring .= "$ElementIndexValue=$ElementContents&";
if ($ElementContents == "yes")
{
$whilecount = 0;
$delete_string = "DELETE FROM temp WHERE ('blah' = 'blah')";
The code in red would be NORMALY BE IN ONE LINE. It doesn't look that way in this post.
Now lets say I wanted to start a new line after " listingsDB.Title," and then after " listingsDBElements"
How would I make this work .
The way it looks in this post would work fine but it wont work that way.
If I put an " in front of the next line it gos gray and looks like it would work but it don't.
e-mail message
December 21, 2003, 7:52:34 am -- CREATE TEMPORARY TABLE temp SELECT listingsDB.ID, listingsDB.Title,
,listingsDBElements.field_name, listingsDBElements.field_value FROM listingsDB, listingsDBElements WHERE (listingsDBElements.listing_id = listingsDB.ID) AND (listingsDB.active = 'yes')
