[Resolved] Parse error

Raul_VP

Hi,

I have this code:

if (tep_session_is_registered('customer_id')){
$downloads_query_raw1 = "SELECT DATE_FORMAT(date_purchased, '%Y-%m-%d') as date_purchased_day, o.orders_id, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays
FROM " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd
WHERE customers_id = '" . $customer_id . "'
AND o.orders_id = op.orders_id
AND o.orders_status >= '2'
AND o.orders_status != 99999
AND opd.archived != 'yes'
AND opd.orders_products_id=op.orders_products_id
AND opd.orders_products_filename<>''
ORDER BY opd.orders_products_download_id DESC LIMIT 999";
$download1 = tep_db_query($downloads_query_raw1);
$download = tep_db_fetch_array($download1);
if ($download > 0) {
include(DIR_WS_BOXES . 'download_files.php');
}
}

And I receive this message:

Parse error: parse error on line 20

Line 20 is this:

WHERE customers_id = '" . $customer_id . "'

What is wrong?
😕

Pig

Couple things, you seem to be stepping of the text to use a var, but you don't. For instance: TABLE_ORDERS_PRODUCTS is that supposed to be a var? There is no $.

2nd, echo out your query strings before you run the query to see what they are being parsed as.

eg: echo $downloads_query_raw1;

3rd, put the php brackets ( [ php ]text here[ /php ] -- but without the spaces) around your text if you are going to paste it in here. It makes it a lot easier to read.

ZeroG

Hi im really new to php i just installed it and now i am reading a book to learn how it is working and here i am with my first problem that i dont understand since im new to that and that the code im usiong is coming out of the book.

i get this error trying to load my page :
Parse error: parse error, unexpected '/' in c:\program files\easyphp\www\membres\membre.php on line 18

This is the page itself

include "commun/connextion.inc.php";

<?
$sql="select * from pays";
$resultat=@mysql_db_query($dbname,$sql,$id_link);
echo '<select name="pays">';
echo '<option value="" selected></option>';

while ($rang=mysql_fetch_array($resultat)){

$code=$rang['code'];
$nom=$rang['nom'];
echo '<option value=\"$code\">$nom</option>";
}
echo '</select>'; <-------- this is where i get the error

<html>
<head>
<title>inscription</title>
</head>
<body>
Pour vous inscrire vous devez nous founir les information suivantes.
<form action="inscription_p2" method="post" name="page_1">
<input type="text" name="nom">
<input type="text" name="nick">
<input type="text" name="email">
<input type="text" name="motpasse">
<input type="text" name="ville">
<input type="text" name="codepostal">
<input type="text" name="pays">
<input type="submit" name="je m'inscrit">

</form>
</body>
</html>

so can any one help me out on this so i can keep going with leraning!

Pig

Dude, don't hijack someones' thread. Start a new one, and take to heart what I said about using the [ php ] tags.

n00854180t

LOL.

Raul_VP

Thanks Pig but I don't have idea about this. It is a code that I'm supossed to paste in a php file (there is not not indication about the place to paste it)

I has tried your suggestion 1 & 2 and I get the same message, for the 3 I don't have idea of this.

When I pasted this code the first time, there was another message about an unknown column, I noticed that in:

TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd

there was not " at the end, I put it and now I have the actual message.

Thahnks and sorry for my english

Raul

Pig

Well, TABLE_ORDERS_PRODUCTS_DOWNLOAD doesn't make any sense. when you exit out of a string, it is usually to call an array, variable or a function. This is none of those. I don't know where you are getting the code, but it seems to be fundamentally flawed, or perhaps was not reproduced correctly.

#2 is only to give you an idea of the error. It allows you to see exactly what you are trying to feed to the database. eg: if you are using a variable that is not defined, you could spot that in the string that you echo.

#3 above the box where you type your message, there are a bunch of buttons:

[url]http://[/url]
@
IMG
#
PHP
List
Quote

Use the php button to put brackets around your code when you paste.

Raul_VP

if (tep_session_is_registered('customer_id')){

    $downloads_query_raw1 = "SELECT DATE_FORMAT(date_purchased, '%Y-%m-%d') as date_purchased_day, o.orders_id, opd.download_maxdays, op.products_name, opd.orders_products_download_id, opd.orders_products_filename, opd.download_count, opd.download_maxdays

                          FROM " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " opd

                          WHERE customers_id = '" . $customer_id . "'

                          AND o.orders_id = op.orders_id

                          AND o.orders_status >= '2'

                          AND o.orders_status != 99999

						  AND opd.archived != 'yes'

                          AND opd.orders_products_id=op.orders_products_id

                          AND opd.orders_products_filename<>''

						  ORDER BY opd.orders_products_download_id DESC LIMIT 999";

   $download1 = tep_db_query($downloads_query_raw1);

  $download = tep_db_fetch_array($download1);

 if ($download > 0) {

     include(DIR_WS_BOXES . 'download_files.php');

Is this OK?

Pig

only one set of brackets around the whole thing, not each line. Also, did you create this code, or get it from somewhere else?

Raul_VP

Well, when I push the PHP buttom there is a window that allow me to put only one line, I don't know how to done with this.

The code came from an add-on of oscommerce. It is supossed to allow visitors to download free files directly from the web page.

Raul_VP

I has found, thanks

Raul