MYSQL Query in a loop

Question

I am trying to write a query but it gives me same value for entire loop. I must get a different value for $ckxf[usercookie] everytime, what am i doing wrong.

$queryxyzzy12=("SELECT * FROM visitorcookiesbrowsing ORDER by id ASC");
    $resultxyzzy23=mysql_query($queryxyzzy12) or die(mysql_error());

    //var_dump($ckxf);
    while($ckxf = mysql_fetch_assoc($resultxyzzy23)){
    $querycrtx=("SELECT * FROM cart WHERE userkey='$ckxf[usercookie]' ORDER by datebegan  DESC");
    $resultcrtx=mysql_query($querycrtx) or die(mysql_error());
    $numcrtx=mysql_numrows($resultcrtx);
    $ixxy=0;

Samson · Accepted Answer · 2012-07-15 10:31:31Z

2

You know that you can do this in only one query :

SELECT * FROM visitorcookiebrowsing v 
LEFT JOIN cart c on c.userkey=v.usercookie 
ORDER by v.id ASC, c.datebegan  DESC

Learn the power of SQL:)

answered Jul 15, 2012 at 10:31

Samson

2,8317 gold badges40 silver badges55 bronze badges

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

1 Comment

TerryE Over a year ago

It will also execute a lot faster ;-?

Collectives™ on Stack Overflow

MYSQL Query in a loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related