techker
-
Posts
812 -
Joined
-
Last visited
Everything posted by techker
-
did you see the link
-
hey guys im doing a car dealer site for my budy and im trying to figure out a page to show multible cars inventory page.. i got this going but it is now showing the second query right? <?php $QQQ = mysql_query("SELECT * FROM employees"); if (!$QQQ) die(mysql_error()); // Get the total number of rows $total_items = mysql_num_rows($QQQ); // Get the page limit & page $limit = $_GET['limit']; $page = $_GET['page']; // Do default setting if((!$limit) || (is_numeric($limit) == false) || ($limit < 1) || ($limit > 5)) { $limit = 2; //default } // Do default setting if((!$page) || (is_numeric($page) == false) || ($page < 0) || ($page > $total_items)) { $page = 1; //default } // Calculate the number to page to display $total_pages = ceil($total_items / $limit); $set_limit = $page * $limit - ($limit); $QQQ1 = mysql_query("SELECT * FROM employees LIMIT $set_limit, $limit "); if(!$QQQ1) die(mysql_error()); $err = mysql_num_rows($QQQ1); if($err == 0) die("No matches met your criteria."); // Let user decide how many result to show in each page // echo "Results per page: "; //echo "<a href='list_store.php?limit=2&page=1'>2</a> | //<a href='list_store.php?limit=5&page=1'>5</a> | //<a href='list_store.php?limit=10&page=1'>10</a>"; //Count Message $count = 1; //to loop the results into the table rows code goes here //while($FFF = mysql_fetch_assoc($QQQ1)) { ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <style type="text/css"> <!-- body { background-image: url(images/index_23.gif); } --> </style></head> <body> <table width="515" height="346" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="515" height="346" valign="top" background="images/admin_mid_m.jpg"><table width="506" height="140" border="1" align="center" cellpadding="0" cellspacing="0"> <tr><?php while ($info=mysql_fetch_array($QQQ1)) {?> <td width="209" height="105" rowspan="6"><div align="center"><?php echo '<img src="/ADMIN/pics/'. $info['thumb'] .'" border="0" alt="" /> <br />'; ?></div></td> </tr> <tr> <td colspan="2"><div align="center"><?php echo $info['name'] ?>-<?php echo $info['email'] ?></div></td> <td> </td> </tr> <tr> <td height="23" colspan="2"><strong>Numero de commande:<?php echo $info['numero'] ?></strong></td> <td width="87"> </td> </tr> <tr> <td height="60" colspan="2"><?php echo $info['description'] ?></td> <td> </td> </tr> <tr> <td height="29" colspan="2"><strong>Sold </strong>:<?php echo $info['sold'] ?></td> <td height="29"> </td> </tr> <?php } ?> </table> <p><table width="194" border="1" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td width="194"><div align="center"> <?php $prev_page = $page - 1; if($prev_page >= 1) { echo(" <a href=index_view.php?limit=$limit&page=$prev_page><b>Prev</b></a>"); } for($i = 1; $i <= $total_pages; $i++){ if($i == $page){ echo($i." "); }else{ echo("<a href=\"index_view.php?limit=$limit&page=$i\">$i</a> "); } } $next_page = $page + 1; if($next_page <= $total_pages) { echo("</b><a href=index_view.php?limit=$limit&page=$next_page><b>Next</b></a> "); } //dbDisconnect($conn2); ?></td> </tr> </table></p></td> </tr> </table> </body> </html> this is whats it showing. http://www.canada-auto.com/new/inv_inc.php
-
<? if (mysql_affected_rows == 0) { echo "Off"; } else { while($row = mysql_fetch_array($result9)) { echo $row['Totalhours'] ." H"; } } ?>
-
its the line that you made.
-
its giving me Parse error: syntax error, unexpected T_STRING in /home/techker/public_html/PUNCH/index2.php on line 70
-
nice thx!i have a hard time with the mixing of html and php..
-
when there is no row(no results,nothing in there)
-
ok small question for me to understand once and for all!lolsorry that querry is in the top of my page.now in my page were the echo is i put this <? while($row = mysql_fetch_array($result9)) {?> <? echo $row['Totalhours'] ." H"; ?> <? }?> now do i put that if there? <? while($row = mysql_fetch_array($result9)) {?> if (mysql_affected_rows == 0) { echo "Off"; } else { <? echo $row['Totalhours'] ." H"; ?> }
-
well ok.. my querry: $query9 = "SELECT COUNT(*) AS TotalCount, `to_t1` - `from_t1` + `to_t2` - `from_t2`+ `to_t3` - `from_t3`+ `to_t4` - `from_t4`+ `to_t5` - `from_t5`+`to_t6` - `from_t6`+ `to_t7` - `from_t7` AS TotalNumber, SUM( `to_t1` - `from_t1` + `to_t2` - `from_t2`+ `to_t3` - `from_t3`+ `to_t4` - `from_t4`+ `to_t5` - `from_t5`+`to_t6` - `from_t6`+ `to_t7` - `from_t7`) AS Totalhours FROM `week1`GROUP BY `from_t1` "; $result9 = mysql_query($query9) or die(mysql_error()); when when my db is empty it shows nothing.now i want it so when it is empty it shows off
-
hey guys i have a query that retreives hours from my database.now i want to put an if on the query that if empty returne off..
-
so if $color = ($Totalhours > 40) ? 'red' : 'blue'; echo 'Total hours: <font color="', $color, '">', $Totalhours, '</font>';
-
hey is there a way that if the total hours pass 40 it shows in red? i added up all the sums and it works a1! now in the query can i add something like an if Totalhours is over '40' show in red
-
that did it.did it ask for a group since we added to fileds in one? now i just need to add all the filds up.thx
-
that should be it but it gives me this? Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
-
see i want to calculat how many hours i have done in a day.and a week. they bust my balls over over time..lol i dont understand the sum part?
-
i tried this $query2 = "SELECT COUNT( `to_t1` )-( `from_t1`) AS Totalhours FROM `week1`; "; but it gives me -7h
-
hey guys so i got this going but there sum is wrong?? $query2 = "SELECT COUNT( `to_t1` )-( `from_t1`)AS TotalNumber, SUM( `to_t1` )-( `from_t1`) AS Totalhours FROM `week1`; "; $result2 = mysql_query($query2) or die(mysql_error()); while($row = mysql_fetch_array($result2)) { echo $row['Totalhours'] ." H"; } 21H to_t1 is 17:30 and from_t1 is 9:30 how does it get 21?i need 8h
-
problem.. every thing is working fine now..the only thing is that in my table time, i created field from_m1,from_m2..that represents from.. and 7 more to_m1,to_m2.. that represents the to in the days.. so i have this monday input filed(from_m1) to input filed(to_m1) now if i have more then one entry it screws up cause it show both. i need to assosiate monday to form_m1 and to_m1 and tuesday to form_m2 and to _m2...... i make one table week 1 and put the fields in that one. so the second time would go in week 2..... the only thing is for that to be associated ?(guess something like a drop down menu with week 1 week2 week 3 week 4 week 5..) the place that i would jam is how to determine if he selected week 1 to insert the data in that table..
-
so SELECT sum( `time` ) AS TotalNumber, SUM( `time` ) AS Totalhours FROM `fc`;
-
ya but what would be the php formula?cause lets say i make a database with monday input filed from to input field and it puts it in the database. to pull it out SELECT COUNT( `time` ) AS TotalNumber, SUM( `time` ) AS TotalPrice FROM `fc`;
-
well i was more thinking of input forms.from time to what time and lunch for every day.
-
hey guy im looking in to making a small web site that i can access from my blackberry to log my hours i do at work.. can somebody guide me in the write direction fro the calculations?
-
i think im getting there.i forgot to close my div tag
-
sorry the cell name i put this it works put the space between the pics is to mutch? div.thumb { float: vertical; width: 25%; border: thin silver solid; margin: 0.5em; padding: 0.5em; }
-
featured is the table name..
