unexpected T_STRING in this short Query

[Modernvox]

Can't fix it?

 

<?php
include('connect.php');
mysql_query("SELECT itemQty SUM(itemQty) FROM transactions Where itemDescription= 'raffle'") or die mysql_error());
$row = mysql_fetch_array( $result );

echo $row['sum(itemQty)'];
?>

[fortnox007]

would this help you?

<?php
include('connect.php');
$result = mysql_query("SELECT itemQty SUM(itemQty) FROM transactions Where itemDescription= 'raffle'") or die mysql_error());
$row = mysql_fetch_array( $result );

echo $row['sum(itemQty)'];
?>

 

: ) i added $result = before you mysql_query();

[Modernvox]

would this help you?

<?php
include('connect.php');
$result = mysql_query("SELECT itemQty SUM(itemQty) FROM transactions Where itemDescription= 'raffle'") or die mysql_error());
$row = mysql_fetch_array( $result );

echo $row['sum(itemQty)'];
?>

 

: ) i added $result = before you mysql_query();

 

Nope. Thanks for trying though:-)

[fortnox007]

Hmm I have closed my sql to test it, but arent you missing a loop at the bottom to run through the array of results?

 

does maybe this work for you?

 

<?php
include('connect.php');
$result = mysql_query("SELECT itemQty SUM(itemQty) FROM transactions Where itemDescription= 'raffle'") or die mysql_error());

while ($row = mysql_fetch_array( $result )){
echo $row['sum(itemQty)'];
}
?>

 

if this doesnt work It might be the ['sum(itemQty)'] that is weird. But i hope this works

[Modernvox]

Hmm I have closed my sql to test it, but arent you missing a loop at the bottom to run through the array of results?

 

does maybe this work for you?

 

<?php
include('connect.php');
$result = mysql_query("SELECT itemQty SUM(itemQty) FROM transactions Where itemDescription= 'raffle'") or die mysql_error());

while ($row = mysql_fetch_array( $result )){
echo $row['sum(itemQty)'];
}
?>

 

if this doesnt work It might be the ['sum(itemQty)'] that is weird. But i hope this works

 

Nope. Still nothing. I have tried $row['itemQty']; 

[fortnox007]

This could be nothing but i just googled for http://www.parse-error-unexpected-t-string.com/ and if i look at your code Maybe a ( is missing right after the or die clause

 or die mysql_error());

instead of

 or die (mysql_error());

 

So maybe this is correct now:

<?php
include('connect.php');
$result = mysql_query("SELECT itemQty SUM(itemQty) FROM transactions Where itemDescription= 'raffle'") or die (mysql_error());

while ($row = mysql_fetch_array( $result )){
echo $row['sum(itemQty)'];
}
?>

[Modernvox]

This could be nothing but i just googled for http://www.parse-error-unexpected-t-string.com/ and if i look at your code Maybe a ( is missing right after the or die clause

 or die mysql_error());

instead of

 or die (mysql_error());

 

So maybe this is correct now:

<?php
include('connect.php');
$result = mysql_query("SELECT itemQty SUM(itemQty) FROM transactions Where itemDescription= 'raffle'") or die (mysql_error());

while ($row = mysql_fetch_array( $result )){
echo $row['sum(itemQty)'];
}
?>

 

Yep. That eliminated the error. Thank you. Although it still returns 0 results i at least know what u pointed out:-)

[fortnox007]

Cool : )

 

Btw i found a nice script for all your error stuff handling while reading some more:

http://php.net/manual/en/function.mysql-error.php

 

IN the comments are a few good ones

[mikosiko]

Can't fix it?

 

<?php
include('connect.php');
mysql_query("SELECT itemQty SUM(itemQty) FROM transactions Where itemDescription= 'raffle'") or die mysql_error());
$row = mysql_fetch_array( $result );

echo $row['sum(itemQty)'];
?>

 

you are missing a , after itemQty... your select should read

mysql_query("SELECT itemQty, SUM(itemQty) AS TitemQty FROM transactions Where itemDescription= 'raffle'") or die (mysql_error());

notice that I also added an alias for the aggregate function... it will allow you to change this line

echo $row['sum(itemQty)'];

for the more simple

echo $row['TitemQty'];

[Modernvox]

Can't fix it?

 

<?php
include('connect.php');
mysql_query("SELECT itemQty SUM(itemQty) FROM transactions Where itemDescription= 'raffle'") or die mysql_error());
$row = mysql_fetch_array( $result );

echo $row['sum(itemQty)'];
?>

 

you are missing a , after itemQty... your select should read

mysql_query("SELECT itemQty, SUM(itemQty) AS TitemQty FROM transactions Where itemDescription= 'raffle'") or die (mysql_error());

notice that I also added an alias for the aggregate function... it will allow you to change this line

echo $row['sum(itemQty)'];

for the more simple

echo $row['TitemQty'];

 

Ahhhh.. Absolutely. That works.. Thanks Guys for the tutorial!

[fortnox007]

notice that I also added an alias for the aggregate function... it will allow you to change this line

very smart : )

 

@vox, : ) always happy to help