can not access mySql result in php

Question

I have this mySQL query:

Select MIN(A.product_id  + 1)
From   Tabel A Left Join Tabel B
On A.product_id = B.product_id - 1
Where  B.product_id Is NULL

I run it on phpMyAdmin and this is the result:

phpMyAdmin screenshot

It returns the correct value (1803020005) but under the field 'MIN(a.product_id + 1)'.

How can I use it in php?

I use this but does not work:

$result = mysql_query ($select, $con);
$row = mysql_fetch_assoc($result);

this is the result of $result = mysql_query ($select, $con); :

Resource id #6

and this is the result of $row = mysql_fetch_assoc($result); :

Array

Why don't you print_r your $row and see what it contains (and post it)? Also, you should be using MySQLi or PDO, as php_mysql is deprecated. — Lusitanian
– Lusitanian, Commented Jun 29, 2012 at 16:51
@David this is the result of $result = mysql_query ($select, $con); : 'Resource id #6' and this is the result of $row = mysql_fetch_assoc($result); : 'Array' — biji buji
– biji buji, Commented Jun 29, 2012 at 17:30
@David : I think aliasing to 'min' is doing something strange. please help — biji buji
– biji buji, Commented Jun 29, 2012 at 18:32
Unfortunately, I really don't have much experience with the php_mysql extension anymore, as I haven't used it in something like six years. was that 'Array' your entire result of print_r? The MySQL extension is doing something wacky or your query is invalid. — Lusitanian
– Lusitanian, Commented Jun 29, 2012 at 18:34

Joe Majewski · Accepted Answer · 2012-06-29 16:51:44Z

2

You want to SELECT MIN(a.product_id +1) AS min and then get it under $row['min'];

answered Jun 29, 2012 at 16:51

Joe Majewski

1,6513 gold badges18 silver badges31 bronze badges

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

1 Comment

biji buji Over a year ago

it seems $row['min'] has nothing in it as echo does not show anything

Trey · Accepted Answer · 2012-06-29 16:51:28Z

1

Select MIN(A.product_id  + 1) AS product_id
From   Tabel A Left Join Tabel B
On A.product_id = B.product_id - 1
Where  B.product_id Is NULL

try telling it what you want the field to be returned as

answered Jun 29, 2012 at 16:51

Trey

5,5404 gold badges25 silver badges31 bronze badges

Comments

Justin · Accepted Answer · 2012-06-29 18:41:22Z

0

Your query is completely wrong....

On A.product_id = B.product_id -1 WHERE b.product_id IS NULL

Is telling MySQL that A.product_id must be the same as b.product_id subtracted by 1 as long as b.product_id is empty

Now, I think that you're looking for WHERE B.product_id IS NOT NULL and all your woes will be repaired.

Also, read up on mysqli and PDO as the mysql extensions (ie: mysql_query) are not maintained and contain a lot of security issues.. PDO takes some getting used to, mysqli you can switch to relatively easy without much hassle..

answered Jun 29, 2012 at 18:41

Justin

2,1614 gold badges24 silver badges41 bronze badges

1 Comment

biji buji Over a year ago

Thanks @justin but I am seeing true answer in phpmyadmin! please take a look at this

Collectives™ on Stack Overflow

can not access mySql result in php

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related