techker

ya i reversed the calculation.thx for the help!

ok so i did it like this one $percentage = round(($students_detention_num / $total_students) * 100); but the number gives me this? Percentage 400% 270 total detentions 1080 total students 400 2701080

i get a Call to undefined function returnPercent() in /home/ecole514/public_html/V2/Main/Pourcentage.php on line 31 $x = 'SELECT COUNT(*) FROM Etudiant '; $result = mysql_query($x) or die(mysql_error()); $total_rows = mysql_fetch_row($result); $students_detention_num= $total_rows[0]; $x8 = 'SELECT COUNT(*) FROM Formulaire_S'; $result8 = mysql_query($x8) or die(mysql_error()); $total_rows8 = mysql_fetch_row($result8); $total_students= $total_rows8[0]; $percentage = returnPercent($students_detention_num,$total_students)

ok thats not a problem. so returnPercent will automaticly calculate the %. thats cool..thx

so i have a table with a number of students.(names-profileid...) and i have a detention table(name-date-time..) so i want to do a stats page that will calculate the percentage between the number of students and the detentions.. example 20% of the students go to detention.. then i can use it for months -weeks -per teacher....

So the $num1 = the first filed in table? $num = field 2

hey guys is it possible to have an output that will echo a percentage between 2 tables? like students vs detentions would give like 45%..

|| is not like and, example, in your case if you had: <? echo ($info['Status'] == 'Sold' && $info['Status'] == 'on hold') ? "<span class='echo'>".$info['Status']."</span>" :"For sale"; ?> Using the && and operator, this would mean that Both conditions would have to be met in order for you to receive the TRUEnternary response. However in your case, since you are using the || or operator, only one of the conditions needs to be met in order for the TRUE ternary response to output. this is the one i need.since they want in red on hold or if the car is sold.but i understand the && and toke note of it.thx for the help guys!

so basicly || is like an AND. thx for the help!

Hey guys i have <? echo $info['Status'] == 'Sold' ? "<span class='echo'>".$info['Status']."</span>" :"For sale"; ?> i need to add a second value to the == =='sold' or 'On hold' how can i do this?

ya that did it..thx for the help!!

wel its because the script is in a full page ..there is links and all on that page.. so the hole page does not show.. i would like it to show nothing..but the rest of the page needs to stay..

od it still gives me a white page when there is no data

Ah!nice.i had a feeling debug had something to do with it but wasn't shure.thx for the help!

class PS_Pagination { var $php_self; var $rows_per_page = 10; //Number of records to display per page var $total_rows = 0; //Total number of rows returned by the query var $links_per_page = 5; //Number of links to display per page var $append = ""; //Paremeters to append to pagination links var $sql = ""; var $debug = false; var $conn = false; var $page = 1; var $max_pages = 0; var $offset = 0; /** * Constructor * * @param resource $connection Mysql connection link * @param string $sql SQL query to paginate. Example : SELECT * FROM users * @param integer $rows_per_page Number of records to display per page. Defaults to 10 * @param integer $links_per_page Number of links to display per page. Defaults to 5 * @param string $append Parameters to be appended to pagination links */ function PS_Pagination($connection, $sql, $rows_per_page = 10, $links_per_page = 5, $append = "") { $this->conn = $connection; $this->sql = $sql; $this->rows_per_page = (int)$rows_per_page; if (intval($links_per_page ) > 0) { $this->links_per_page = (int)$links_per_page; } else { $this->links_per_page = 5; } $this->append = $append; $this->php_self = htmlspecialchars($_SERVER['PHP_SELF'] ); if (isset($_GET['page'] )) { $this->page = intval($_GET['page'] ); } } /** * Executes the SQL query and initializes internal variables * * @access public * @return resource */ function paginate() { //Check for valid mysql connection if (! $this->conn || ! is_resource($this->conn )) { if ($this->debug) echo "MySQL connection missing<br />"; return false; } //Find total number of rows $all_rs = @mysql_query($this->sql ); if (! $all_rs) { if ($this->debug) echo "SQL query failed. Check your query.<br /><br />Error Returned: " . mysql_error(); return false; } $this->total_rows = mysql_num_rows($all_rs ); @mysql_close($all_rs ); //Return FALSE if no rows found if ($this->total_rows == 0) { if ($this->debug) echo "Query returned zero rows."; return FALSE; } //Max number of pages $this->max_pages = ceil($this->total_rows / $this->rows_per_page ); if ($this->links_per_page > $this->max_pages) { $this->links_per_page = $this->max_pages; } //Check the page value just in case someone is trying to input an aribitrary value if ($this->page > $this->max_pages || $this->page <= 0) { $this->page = 1; } //Calculate Offset $this->offset = $this->rows_per_page * ($this->page - 1); //Fetch the required result set $rs = @mysql_query($this->sql . " LIMIT {$this->offset}, {$this->rows_per_page}" ); if (! $rs) { if ($this->debug) echo "Pagination query failed. Check your query.<br /><br />Error Returned: " . mysql_error(); return false; } return $rs; } /** * Display the link to the first page * * @access public * @param string $tag Text string to be displayed as the link. Defaults to 'First' * @return string */ function renderFirst($tag = 'Premier') { if ($this->total_rows == 0) return FALSE; if ($this->page == 1) { return "$tag "; } else { return '<a href="' . $this->php_self . '?page=1&' . $this->append . '">' . $tag . '</a> '; } } /** * Display the link to the last page * * @access public * @param string $tag Text string to be displayed as the link. Defaults to 'Last' * @return string */ function renderLast($tag = 'Dernier') { if ($this->total_rows == 0) return FALSE; if ($this->page == $this->max_pages) { return $tag; } else { return ' <a href="' . $this->php_self . '?page=' . $this->max_pages . '&' . $this->append . '">' . $tag . '</a>'; } } /** * Display the next link * * @access public * @param string $tag Text string to be displayed as the link. Defaults to '>>' * @return string */ function renderNext($tag = '>>') { if ($this->total_rows == 0) return FALSE; if ($this->page < $this->max_pages) { return '<a href="' . $this->php_self . '?page=' . ($this->page + 1) . '&' . $this->append . '">' . $tag . '</a>'; } else { return $tag; } } /** * Display the previous link * * @access public * @param string $tag Text string to be displayed as the link. Defaults to '<<' * @return string */ function renderPrev($tag = '<<') { if ($this->total_rows == 0) return FALSE; if ($this->page > 1) { return ' <a href="' . $this->php_self . '?page=' . ($this->page - 1) . '&' . $this->append . '">' . $tag . '</a>'; } else { return " $tag"; } } /** * Display the page links * * @access public * @return string */ function renderNav($prefix = '<span class="page_link">', $suffix = '</span>') { if ($this->total_rows == 0) return FALSE; $batch = ceil($this->page / $this->links_per_page ); $end = $batch * $this->links_per_page; if ($end == $this->page) { //$end = $end + $this->links_per_page - 1; //$end = $end + ceil($this->links_per_page/2); } if ($end > $this->max_pages) { $end = $this->max_pages; } $start = $end - $this->links_per_page + 1; $links = ''; for($i = $start; $i <= $end; $i ++) { if ($i == $this->page) { $links .= $prefix . " $i " . $suffix; } else { $links .= ' ' . $prefix . '<a href="' . $this->php_self . '?page=' . $i . '&' . $this->append . '">' . $i . '</a>' . $suffix . ' '; } } return $links; } /** * Display full pagination navigation * * @access public * @return string */ function renderFullNav() { return $this->renderFirst() . ' ' . $this->renderPrev() . ' ' . $this->renderNav() . ' ' . $this->renderNext() . ' ' . $this->renderLast(); } /** * Set debug mode * * @access public * @param bool $debug Set to TRUE to enable debug messages * @return void */ function setDebug($debug) { $this->debug = $debug; } }

hey guys i have a pagination script that works great but when there is nothing in the table it returns an error saying querry empty.. can i mod it to say nothing.. if(!$conn) die("Failed to connect to database!"); $status = mysql_select_db($db, $conn); if(!$status) die("Failed to select database!"); $sql = 'SELECT * FROM Formulaire_S'; /* * 10 = Number of rows per page * 5 = Number of links * "param1=valu1&param2=value2" = You can append your own parameters to paginations links */ $pager = new PS_Pagination($conn, $sql, 4, 5, "param1=valu1&param2=value2"); $pager->setDebug(true); $rs = $pager->paginate(); if(!$rs) die(mysql_error());

seems to work faster.i will see if it causes a problem thx for the help

true but if the name there lokking for is at the end of the list?

but could it be that the distinct is faster?

cool it looks good but the page freezes up when i start to type..like if it was searching..the database has over 1000 entries..

in need the Nom and Prenom first and last name. i go this but it echos onlythe Nom(first name) and searches only half of the database SELECT distinct Nom,Prenom as suggest FROM Etudiant WHERE Nom like('" .$search . "%') And Prenom like('" .$search . "%') ORDER BY Nom

hey guys i have this auto complete but it only selects one table..i need it to select 2? SELECT distinct Nom as suggest FROM Etudiant WHERE Nom like('" .$search . "%') ORDER BY Nom i need Nom and Prenom i tryed Nom,prenom but did not work..

ok i think i got it. SELECT `Foyer` , COUNT( `Foyer` ) FROM Formulaire_S GROUP BY `Foyer` LIMIT 0 , 30

hey guys in a DB i have multiple fields 1 F_ID 2 Nom 3 Foyer 4 Matiere 5 Prof 6 Motif 7 Notes_Sortie 8 Travail 9 Code_P 10 Date_Rempli 11 Surveillant 12 Comportement 13 C_Notes 14 Status 15 Status_Date 16 Bilan 17 Latreve_status 18 Heure_S 19 User_ID 20 Periode Now i wan't to query Foyer so it shows all the Foyer.and show at the same time how many students are in this Foyer.. so my query to show all the Foyer is to add Group By Foyer.but how can i add how many students? goup By Foyer and count(Nom) cause a student is associated to a foyer.(foyer is a type of division)

Hey guys i have a script that i made with multiple permissions.. i need to add in the pages restitutions for diffrent levels.. so i got the level $query = "SELECT * FROM users WHERE `username`='$username_from_cookie'"; $numresults=mysql_query($query); $numrows=mysql_num_rows($numresults); // get results $result = mysql_query($query) or die("Couldn't execute query"); // now you can display the results returned while ($row10= mysql_fetch_array($result)) { $permissions= $row10["permissions"]; echo '$permissions'; } Now to restick im ok with like to but more then that i get confused.. this shows navigation on levels of permissions.. if ($row10['permissions'] == 2) { print "<a href=\"U.php\"><img src=\"./Icons/Users.png\" title=\"Prof\" /></a>"; } else { print "<img src=\"./Icons/Users_o.png\"/>"; } 2 levels if ($row10['permissions'] == 5) { print "<a href=\"Prof_1.php\"><img src=\"./Icons/sec.png\" title=\"Enseignant(e)\"/></a>"; } elseif ($row10['permissions'] == 2) { print "<a href=\"Prof_1.php\"><img src=\"./Icons/sec.png\" title=\"Enseignant(e)\"/></a>"; } else { print "<img src=\"./Icons/sec_o.png\" title=\"Enseignant(e)\"/>"; } ok so instead of have 10 lines of codes can i $row10['permissions'] == 5&2&3 ??? and can i do if not permissions ==5 redirect to loggin.. thx