MySQL & PHP problem

[rileypool]

Hey guys, I'm still fairly new to php/MySQL, but I'm learning. I'm trying to return two variables from the same database record. This is currently the code I'm using and I know its wrong because the query selects the event only. How can I also return the date it happened from that same record?

    <?php    
    $query = 'SELECT tih_event FROM todayinhistory WHERE right(tih_date,5) = "' . $currDay . '"';
    $result = mysql_query($query) or die(mysql_error());
    
    while($row = mysql_fetch_array($result)){
        echo 'Year: ' . $row['tih_date'] . ' - ' . $row['tih_event'] . '<br />';
        }
    ?>

 

[rileypool]

Okay, I think I found the answer. I think I do a SELECT * FROM query. I'm testing it now.

 

[rileypool]

Got it...

 

[emp]

You can also get more than one value with a Select Statement.

example:

$query = 'SELECT tih_event, tih_date FROM todayinhistory WHERE right(tih_date,5) = "' . $currDay . '"';

SELECT * can and will kill your performance, as you are getting every value in the table, not just the ones you need.

::emp::

 

[rileypool]

Thanks emp, that's quality material right there.

 

[d03boy]

emp has it correct. Don't ever use * unless for testing. Oddly enough, p202 uses it all over the place.

 

[kblessinggr]

emp has it correct. Don't ever use * unless for testing. Oddly enough, p202 uses it all over the place.

hehe. yep, selective queries work best overall.