# Problems making queries to mysql via php

**URL:** <https://forum.kirupa.com/t/problems-making-queries-to-mysql-via-php/256852>\
**Category:** programming\
**Created:** [April 8, 2008, 2:21am UTC](https://forum.kirupa.com/t/problems-making-queries-to-mysql-via-php/256852 "2008-04-08T02:21:30Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mr\_Chulito](https://avatars.discourse-cdn.com/v4/letter/m/aca169/32.png) [@Mr\_Chulito](https://forum.kirupa.com/u/Mr_Chulito)\
**Post date:** [April 8, 2008, 2:21am UTC](https://forum.kirupa.com/t/problems-making-queries-to-mysql-via-php/256852/1 "2008-04-08T02:21:30Z")

</div>

Hello All,  
here is a code that is not working for me, it’s giving me intermittent results, I’ve trying adding quotations to the query but still getting random results here is the one that the below code would putout “ **Parse error** : syntax error, unexpected T\_VARIABLE in **C:\wamp\www\updateoutage.php** on line \*\*31”

this one is another output that it would give me in other times I run the query  
\*\*“Connected successfully outage ID: 1  
Query failed:  
Unknown column ‘$OLD\_OUTAGE\_ID’ in ‘where clause’”

\*\*  
can some one please help me with this issue, thank you very much for your time.  
\*\*

```php
<?php
$open_main_connection= mysql_connect('localhost', ' *******', '****')or die('<div>Could not connect: </div>' . mysql_error());
echo 'Connected successfully';
mysql_select_db('outages') or die('<div>Could not select database</div>');

$OLD_OUTAGE_ID= $_GET['OUTAGE_ID'];
$OLD_TICKET_NUMBER= $_GET['TICKET_NUMBER'];
$OLD_AFECTED_SERVICES= $_GET['AFECTED_SERVICES'];
$OLD_CMTS= $_GET['CMTS'];
$OLD_CARD_NUMBER= $_GET['CARD_NUMBER'];
$OLD_NODE_NUMBER= $_GET['NODE_NUMBER'];
$OLD_SYMPTOMS= $_GET['SYMPTOMS'];
$OLD_START_DATE= $_GET['START_DATE'];
$OLD_END_DATE= $_GET['END_DATE'];
$OLD_STATUS= $_GET['STATUS'];
$OLD_SUBMMITTER= $_GET['SUBMMITTER'];
$OLD_LAST_UPDATED= $_GET['LAST_UPDATED'];
echo '<div>outage ID: '.$OLD_OUTAGE_ID.'</div>';
$query = 'UPDATE outages SET 
                            TICKET_NUMBER = $OLD_TICKET_NUMBER,
                            CMTS = $OLD_CMTS,
                            CARD_NUMBER = $OLD_CARD_NUMBER,
                            NODE_NUMBER = $OLD_NODE_NUMBER,
                            SYMPTOMS = $OLD_SYMPTOMS,
                            START_DATE = $OLD_START_DATE,
                            END_DATE = $OLD_END_DATE,
                            STATUS = $OLD_STATUS,
                            SUBMMITTER = $OLD_SUBMMITTER,
                            LAST_UPDATED = $OLD_LAST_UPDATED
                        WHERE 
                            OUTAGE_ID = $OLD_OUTAGE_ID';
$result = mysql_query($query) or die('<div>Query failed: </div>' . mysql_error());
mysql_free_result($result);
mysql_close($open_main_connection);
//echo "<div>Update Complete</div>";

?>

```