multiple queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am trying to pull data out of a mysql db, and am not sure how to begin to do this as a newbie...

what I have so far, which surprisingly does work:
----------------------------
<?

$db_name = "gwsched";

$table_name = "dates";

$connection = mysql_connect("xxxxx","xxxxxx","xxxxx") or die ("could not connect");

$db = @mysql_select_db($db_name, $connection) or die ("count not connect to data
base");


$sql = "SELECT * from dates where store=$store and date=$date";

$result = @mysql_query($sql,$connection) or die("could not execute");

while ($row = mysql_fetch_array($result)) {

$store = $row['store'];
$date = $row['date'];
$flash = $row['flash'];
}

---------------------

ultimately I would like to display data for 3 days on either side of this.

$minus3 - $minus2 - $minus1 - $date - $plus1 - $plus2 - $plus3

plus the data associated with the $minusX and $plusX days, but havent been able to find that anywhere.

$flash3 - $flash2 - $flash1 - $flash - $flashp1 - $flashp2 - $flashp3


I attempted to use pre and post increment/decrement, but I can not get it pull from the db, it does what it is suppose to do and decrement/increments $flash/$date.


I guess my question is, how do I get $minusX, etc. to reflect what is in my db.

thanks,
cameron

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux