Echo variable which has same name in php join

Question

I have a mysql join which is pulling from two tables name product & cart and they're both being pulled from a variable $row_checkout

If i have to echo a certain field, i can normally go $row_checkout['cartid'] and that works fine.

However, i have a coloumn in each table which is called the same 'Status'.

How do i echo from one of the tables? I thought something like $row_checkout['cart.status'] might work but it doesnt appear to?

My database code is as follows:

$colname_checkout = "-1";
if (isset($row_booking['sessionid'])) {
  $colname_checkout = (get_magic_quotes_gpc()) ? $row_booking['sessionid'] : addslashes($row_booking['sessionid']);
}
mysql_select_db($database_main, $main);
$query_checkout = sprintf("SELECT * FROM cart, productdatabase WHERE cart.productid = productdatabase.productid AND cart.status != 1 AND cart.status != 0 AND cart.sessionid = '%s' ORDER BY `name` ASC", $colname_checkout);
$checkout = mysql_query($query_checkout, $main) or die(mysql_error());
$row_checkout = mysql_fetch_assoc($checkout);
$totalRows_checkout = mysql_num_rows($checkout);

you could use alias for column names while fetching fields in your query — Sudhir Bastakoti
– Sudhir Bastakoti, Commented Jul 19, 2013 at 9:49
var_dump $row_checkout for the column names and stop using mysql use PDO or msqli instead — EvilEpidemic
– EvilEpidemic, Commented Jul 19, 2013 at 9:50

Nicole Stutz · Accepted Answer · 2013-07-19 10:10:30Z

2

You can use alias to change a tables field name, to a name that you want.

the cart.status filter, you could make simpler, simpler by asking > 1

SELECT c.status as car_status, pro.status as pro_status 
FROM cart as c, productdatabase as pro
WHERE c.productid = pro.productid AND c.status >1 AND c.sessionid = '%s' 
ORDER BY `name` ASC", $colname_checkout

Seeing what you get, it will display an associative array with all names and values, that you can use to address the data

while ($row_checkout = mysql_fetch_assoc($checkout)) {
    print_r($row_checkout);
}

or specific the fields:

while ($row_checkout = mysql_fetch_assoc($checkout)) {
    echo $row_checkout["car_status"];
    echo $row_checkout["pro_status"];
}

another comment, the mysql function is not recommended anymore. You could use MySQLi or PDO_MySQL. They are both object oriented and may need a little more time to learn.

edited Jul 19, 2013 at 10:10

answered Jul 19, 2013 at 9:51

Nicole Stutz

5164 silver badges15 bronze badges

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

4 Comments

user1491318 Over a year ago

Okay this makes sense but then how am i echoing the outputs? Sorry - still quite new to all this.

Nicole Stutz Over a year ago

well, you would have to iterate trough the output, i make an example above

user1491318 Over a year ago

Fantastic - this is making sense and is working for me. Final question though. I obviously have other fields in the table. Would i have to alias them all using SELECT c.status as car_status, c.name as car_name or is there a quicker way?

user1491318 Over a year ago

Never mind actually - worked it out. Just needed to add Select *, car... Thanks!

internals-in · Accepted Answer · 2013-07-19 10:21:04Z

0

Use alias.

Refernce : http://www.tutorialspoint.com/sql/sql-alias-syntax.htm

 $query_checkout = 
 sprintf("SELECT *,**cart.status AS cart_status, productdatabase.status as
 pdb_status** FROM  cart, productdatabase WHERE
 cart.productid = productdatabase.productid AND
 cart.status != 1 AND cart.status != 0 
 AND cart.sessionid = '%s' ORDER BY `name` ASC", $colname_checkout);

edited Jul 19, 2013 at 10:21

internals-in

5,0762 gold badges23 silver badges38 bronze badges

answered Jul 19, 2013 at 9:51

Ivanka Todorova

10.3k17 gold badges71 silver badges106 bronze badges

Collectives™ on Stack Overflow

Echo variable which has same name in php join

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related