_spaz

Is is possible to auto increment an Alphanumeric number? example: AB001 AB002 ... ... BA001

How does one get the daily averages per month from a bunch of data with titles and Durations on different dates? Example: date Title Duration 2010-02-01 1 10 2010-02-03 2 16 2010-02-01 3 24 2010-03-02 4 10 2010-03-08 5 10 etc... I have this so far but its not calculating the daily average by Month properly Select Month(`date`) as Month, avg(`duration`) AS 'Daily Duration' from Table where `date` between '2009-01-01' and '2009-12-31' group by Month

Can someone please help me parse this XML structure with XMLReader? I'm having issues with the proper syntax i think? XML structure is: <Metadata> <App_Data App="MOD" Name="Title_Brief" Value="Test"/> <App_Data App="MOD" Name="Title" Value="Test12"/> <App_Data App="MOD" Name="Type" Value="title"/> </Metadata PHP code: reader = new XMLReader(); $reader->open($xmlfile); while ($reader->read()) { switch ($reader->nodeType) { case (XMLREADER::ELEMENT): if ($reader->Name == "Title") { $reader->read(); $Title = trim($reader->value); echo $Title; }

Hoping someone can help me with this issue I'm having, im trying to batch update records from a result set with pagination. The first page results (first 10 records) will update with the batch, but any other pages will not update.... the pagination coding is preventing the rest of the results to update when a date change is made. Here's the code im using: <div class="searchTitle">SCHEDULING</div> <div class="tabber" id="mytab1"> <div class="tabbertab"> <h2>RECORDS</h2><form name="namestoupdate" method="post" action="updateschedule.php"> <div class="searchTitle">RECORDS<input type='submit' class="submitButton" value='SUBMIT' src="images/submit.png" /></div> <table cellspacing="0" id="box-table-a"> <tr> <th>TITLE</th> <th>DATE</th> </tr> <?php $i = 0; while ($result_row = mysql_fetch_array($resultbypass)) { if($i< $startbypass || $i>=$stopbypass) { $i++; continue; } $i++ ; ?> <tr> <td><?php print "<input type='hidden' name='ID[$i]' value='{$result_row['ID']}' />" ?> <?php echo $result_row['Provider']; ?></td> <td><?php echo $result_row['Title']; ?></td> <td><?php print "<input type='text' size='8' name='Date[$i]' value='{$result_row['Date]}' maxlength='10' />"; ?></td> </tr> <?php } ?> </table> <?php echo getPaginationString($pagebypass,$totalitemsbypass,$itemsPerPage,1,$targetpage,$pagestringbypass); ?> </form> </div> Batch update script: (updateschedule.php) <?php session_start(); include("connect.php"); $size = count($_POST['ID']); $i = 0; while ($i <= $size) { $Date= $_POST['Date'][$i]; $id = $_POST['ID'][$i]; $query = "UPDATE Table SET Date= '$Date' WHERE ID = '$id' LIMIT 1"; mysql_query($query) or die ("Error in query: $query"); ++$i; } mysql_close(); ?>

Works Great.... Thanks for you're help!!

Great, is there a way to make it so that it displays it in Columns instead of rows? Weekno Movies FREE Regular 48 564 444 23423 49 50 51

This appears to give me a tally for all three combined, i require each 'type' to be seperate so there's a total for FREE, REGULAR, MOVIES in different columns. Sorry if I wasn't clear.....

Can someone help me with the syntax with the below mutiple where statement query? Can't seem to figure it out or if its even possible.... Any help would be great! Thanks! Calculate the movies Mins by week: SELECT week(Release) as week, sum(Mins where Service LIKE 'Movies') as Movies_total, sum(Mins where Service LIKE 'FREE') as FREE_total, sum(Mins where Service LIKE 'Regular') as REGULAR_total FROM Table where Release >= '2009-12-06' and Release <= '2009-12-29' group by week

Hey guys, how do I use JPGRAPH's to graph the below array results? (Weeks on the X axis and sum results in different colored bars / week for the y-axis. I have no idea how to do this, any help would be appreciated!! $queryatl="SELECT WEEK(Arrival) as Week, SUM(DATEDIFF(Release,Arrival) < 0) as Lessthan0, SUM(DATEDIFF(Release,Arrival) =0) as 0day, SUM(DATEDIFF(Release,Arrival) BETWEEN 1 and 5) as 1to5, SUM(DATEDIFF(Release,Arrival) BETWEEN 6 and 10) as 6to10, SUM(DATEDIFF(Release,Arrival) BETWEEN 11 and 15) as 11to15 FROM TableWHERE Arrival>= '2009-11-01' and Arrival <= '2009-11-30' GROUP BY WEEK(Arrival,0)"; $resultatl = mysql_query($queryatl) or die (mysql_error()); //$data2y=mysql_fetch_assoc($resultatl); while ($row = mysql_fetch_assoc($resultatl)) { print_r ($row); } .................. Results: Array ( [Week] => 44 [Lessthan0] => 0 [0day] => 0 [1to5] => 0 [6to10] => 2 [11to15] => 5 ) Array ( [Week] => 45 [Lessthan0] => 0 [0day] => 0 [1to5] => 10 [6to10] => 11 [11to15] => 8 ) Array ( [Week] => 46 [Lessthan0] => 0 [0day] => 0 [1to5] => 1 [6to10] => 19 [11to15] => 5 ) Array ( [Week] => 47 [Lessthan0] => 2 [0day] => 0 [1to5] => 1 [6to10] => 2 [11to15] => 0 ) Array ( [Week] => 48 [Lessthan0] => 1 [0day] => 0 [1to5] => 1 [6to10] => 0 [11to15] => 0 )

Thanks a bunch guys, ill try that out... I'm new to PHP which is why my code looks ugly:)

Not sure if I'm in the right area, but does someone now how I would multi bar graph the below SQL query using Jpgraph's? There's 6 buckets of cycle times grouped by weeks between a certain date period. I would like each bucket to be represented by a different colored bar, like 0-day bar would be green, and the 16-20 bar would be red.....and so on. Please point me in the right direction....thanks in advance. SELECT SUM(DATEDIFF(Release,Arrival) < 0) as Lessthan0, SUM(DATEDIFF(Release,Arrival) =0) as 0day, SUM(DATEDIFF(Release,Arrival) BETWEEN 1 and 5) as 1to5, SUM(DATEDIFF(Release,Arrival) BETWEEN 6 and 10) as 6to10, SUM(DATEDIFF(Release,Arrival) BETWEEN 11 and 15) as 11to15, SUM(DATEDIFF(Release,Arrival) BETWEEN 16 and 20) as 16to20 FROM table WHERE Arrival>= '2009-11-01' and Arrival<= '2009-11-30' GROUP BY WEEK(Arrival,0)

Can someone please help me with the below code, I'm trying to do a batch update on listed results where the column "priority" can either be 10 or 15, Im not sure if the syntax is correct, the result ID's do pass correctly but the "Priority Values" do not pass to my update.php script, i have a feeling that my syntax is wrong somewhere. Thanks in advance... <td> <?php print "<input type='hidden' name='ID[$i]' value='{$result_row['ID']}' />";?> <?php print "<select name='Priority[$i]' >"; ?> <?php print "<option value=''($result_row[Priority] == Null?' selected='selected'':null)></option>"; ?> <?php print "<option value='10'($result_row[Priority] == '10'?' selected='selected'':null)>10</option>";?> <?php print "<option value='15'($result_row[Priority] == '15'?' selected='selected'':null)>15</option>";?> <?php print "</select>" ?> </td>

You rock:) Works perfectly!! Thanks again.

Thanks for the explanation.... Is there a way to add a statement into the query to say if date="" then default to NULL?

Is it possible to keep a date field in a mysql NULL rather then it updating it to 0000-00-00 when i update other fields? When I do a record update for other fields it takes the null values in the date fields and changes it to 0000-00-00 everytime. How do I prevent that from changing and leaving it as NULL? UPDATE table SET Service='$Service',Provider='$provider',Date='$date' WHERE id = '$id';