php parse error

Question

hi guys,

this was working for me for the last couple of days until this morning when I must have changed something by accident. I thought I changed back everything but it's still not working.

This is the error I'm getting

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in C:\wamp\www\xxxxx\reg.php on line 169

Here is the snippet of code where the problem supposedly is:

$time = "SELECT date FROM orderdetails WHERE compName = '$companyName'";

$sql5 = mysql_query($time);

if (!mysql_query($time, $conn))
{
    die('Error: ' . mysql_error());
}

while($row = mysql_fetch_array($sql5, MYSQL_ASSOC))
{
    **$time_record = $row['date'];**
}   

$orderno = "SELECT orderNo FROM orderdetails WHERE compName = '$companyName'";

$sql4 = mysql_query($orderno);

if (!mysql_query($orderno, $conn))
{
    die('Error: ' . mysql_error());
}

while($row = mysql_fetch_array($sql4, MYSQL_ASSOC))
{
    $orderno_record = $row['orderNo'];
}

The starred line is 169 but I can't see any issues with it at all. Nor can I see any issues around it.

Can a fresh pair of eyes help? Please :)

Answer 1

$orderno = "SELECT `orderNo` FROM `orderdetails` WHERE `compName` = '".$companyName."'";

Answer 2

replace

**$time_record = $row['date'];**

with 

$time_record = $row['date'];

Answer 3

First check whether the variable $companyName is initialized with a value or not. If it's initialized, then there is no problem with the query & you need not change it, otherwise please check the query.

Now you should also try the following statement change, because I haven't seen this type of any PHP statement in my life:-

$time_record = $row['date'];

instead of

**$time_record = $row['date'];**

Hope it helps.

Answer 4

I can tell you that there is nothing wrong with that particular snippet of code. However, that's not to say it isn't something somewhere else in the file. Perhaps you could post some more of your code if possible?

Answer 5

There's nothing wrong in the code posted.

Double check that the Parse error refers to the file you are checking, this happens a lot of times to me.

Answer 6

$discountCostCustomer = $discountCost / 100;`

remove the back tick at the end of the line

Answer 7

Try this - i think your original code was over complicating matters. Untested mind.

it won't solve your error but will make your code clearer.

$sql = mysql_query("SELECT `date`, `orderNo` FROM `orderdetails` WHERE `compName` = '$companyName'") 
 or die('Query failed: ' . mysql_error());

/* If just one row is returned, 
 * you don't need to do while
 * try this:
 */

$row = mysql_fetch_array($sql) or die('Can\'t retrieve records: ' . mysql_error());

$time_record = $row['date'];
$orderno_record = $row['orderNo'];