Page 1 of 1

Query Question

Posted: Thu Feb 19, 2004 10:08 am
by John Cartwright

Code: Select all

<?php
$result = @mysql_query("SELECT * FROM records_total ORDER BY `date` DESC");
?>
How would I only display the ones with the variable $league==cal in each row...


So it would look like

Variable 1----Variable 2------League
blah----------blah-------------cal

Posted: Thu Feb 19, 2004 10:16 am
by markl999
$result = mysql_query("SELECT * FROM records_total WHERE league='$league' ORDER BY date DESC") oe die(mysql_error());

Posted: Thu Feb 19, 2004 10:17 am
by John Cartwright
ty