Returning a sql variable to PHP

Question

I have the following query:

    SET @q = 12;  
    UPDATE `table` 
    SET qty = CONCAT(GREATEST(qty - @q, 0), LEFT(@q := @q - LEAST(qty, @q), 0)) 
    ORDER BY id;

(Go vote eggyal up for the great query here: Removing a quantity from multiple rows in a database )

I am running the query (without preparing in this case) through OOP PDO / MySQL.

I want to pass the value of the @q back to PHP or any flag really if @q did not get to 0. I'm not sure how to accomplish this. If anyone is able to point me in the right direction, I'd appreciate it.

Thanks

Marc B · Accepted Answer · 2012-06-19 16:10:30Z

1

Just select it, as you would anything else:

$res = mysql_query("SELECT @q AS q") or die(mysql_error());
$row = mysql_fetch_assoc($res);
echo $row['q'];

answered Jun 19, 2012 at 16:10

Marc B

362k44 gold badges433 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hjpotter92 · Accepted Answer · 2012-06-19 16:09:56Z

1

Doesn't this work:

$res = mysql_fetch_array( mysql_query( "SELECT @q" ) );
print_r( $res );

answered Jun 19, 2012 at 16:09

hjpotter92

81.1k36 gold badges148 silver badges188 bronze badges

Collectives™ on Stack Overflow

Returning a sql variable to PHP

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related