PHP - Adding Positive And Negative Numbers

Hi iam currently writing some code for my website and i have a number of records that i simply want to display in a table format, i have done this in a while loop and it works well, however i only want to display a maximum of 10 records per page as my div needs to be a fixed height and was wondering how i could include a next button that would act as like a page number. The thing is at any given point there could be from 1 record to display to 500, so i need a way of allowing the user to quickly navigate to the other records. How can i do this without using mulitple pages.

Hope this makes sense.

Heres my code

Code: [Select]
<?php echo"<table width='100%' border='1' align='center'><tr><th>Referal Name</th><th>Amount Received</tr>";
while ($row = mysql_fetch_array($sql_info))
{
extract($row);
echo "<tr><td align='center'>".$username."</td><td align='center'>".$cumulative_referral."</td></tr>";
}
echo "</table>";


?>
Thanks for your help

Hi all,

for some reason I cant see this blantantly obvious query.

I have 3 rows in my database, all with an id of 1, their is a column called price which contains three different float values, how the hell do I write a query in php for this?!
Code: [Select]
$q = mysql_query("SELECT price FROM mytable WHERE id=1")
????Thanks!

Say I do a query from a database that only asks for one field in return (which always has a number in it).  How do you write the PHP to take the first number returned and add it to the next number returned  (NOTE:  There may be more than two numbers returned, but for now, I'm always dealing with two)

For example, say I do a query that returns the number 27 first and then the number 10 second.  FYI, these numbers will be available in the variable $diff['result'].  So the code after the query would look something like this, but obviously i'm struggling with the part in comments...

Code: [Select]
if (!$numbers) {
die("Database query failed: " . mysql_error());
} else {
while ($diff = mysql_fetch_array($numbers)) {
//this would bring back 27 first, in the variable $diff['result'] and then on the 2nd loop through, it would bring back 10 in the $diff['result'] variable
                                                                //ultimately, i just want the difference between the numbers (which in the case would be 17).  It's just a simple addition, so Im obviously an idiot because I can't figure out the syntax for adding the first returned number to the next returned number:)



}

}

HI - I have tried COUNT and array_count _values but they don't do what I want.

I have an array of 'quantities' relating to orders.

I want to count how many key=>value pairs have a positive value that is to say Not 0 or null or "".

So for example array ( shoes=>5, coats=> 3, ties=>0)

The answer I seek in this case would be 2 as ties is zero.

I don't want to know what the aggregate of the values are or other such info.

I have tried looping through with a foreach loop testing for $value > 0  and I failed miserably

Any ideas ?

Many Thanks !

Hi,
I need to sort variables in groups of up to 15 and put it in an array. For example:
$exstract['center_tabOpBody_0'] =5
$exstract['center_tabOpBody_1'] =6
$exstract['center_tabOpBody_2'] =8
$exstract['center_tabOpBody_3'] =1


Should yield:
ARRAY(
          = center_tabOpBody_1,center_tabOpBody_2,center_tabOpBody_3 // <-----15 [1] = center_tabOpBody_0 //<----5
)

Is there some simple function do do the "efficiency" sort?

Thanks,
Vadim

Hi Guys   Bit stuck on a negative lookahead and not sure that what i want to achieve is possible.   Lets says I have a domain: www.mysite.com   I want to have a regex that will match www.mysite.com?q=123&g=34 but I don't want to match any file extensions like .php or .html   So the first part of matching the query string and the literal url is fairly straightforward (below) which matches any query string that may be applied

/^www.mysite.com[\/]?[\?\=\&a-z0-9]*$/

But then I want to use a negative lookahead to avoid matching a file extension, e.g.

/^www.mysite.com[\/]?[\?\=\&a-z0-9](?!php|html|htm)$/

But this doesn't work - presumably because the negative lookahead is following a character class.    So my questions:   can you use a negative lookahead in this way? If not, how can I achieve what I'm trying to?   Any help appreciated!    Drongo    

How do I reverse the logic of my Regex statement so it says, "If there is NOT a match..."
Code: [Select]
// (Replacement for non-supported Email-Filter.)
if (preg_match('#^[A-Z0-9_\+-]+(\.[A-Z0-9_\+-]+)*@[A-Z0-9-]+(\.[A-Z0-9-]+)*\.([A-Z]{2,7})$#i',
$trimmed['senderEmail'])){
// Valid Email.
// ???
}else{
// Invalid entry.
$errors['senderEmail'] = 'Please enter a valid E-mail address.';
}// End of VALIDATE ENTRY.

I want to do this so I don't have an empty THEN statement!


Debbie

I have a code to sum up a field called quantityHand in MySQL, in my example below, the value always return 40 as a positive number instead of 40.00-

0.00
0.00
40.00-

I have used intval() or floatval() function to convert the type of variable from string to int/float but still not working. Any help please?

Here is the code

Code: [Select]
$sql = mysql_query("SELECT DISTINCT itemNumber, itemDesc, quantityHand, SUM(quantityHand) AS quantityHand FROM inventory where itemNumber like '%$term%' GROUP BY `itemNumber` ORDER BY `itemNumber`");


while ($row = mysql_fetch_array($sql)){
  echo "<b>";
echo "</td><td style=\"text-align: center;\"><b>";
echo $row['itemNumber'];
echo "</td><td style=\"text-align: center;\"><b>";
echo $row['itemDesc'];
//echo "</td><td style=\"text-align: right;\">";
echo "</td><td style=\"text-align: center;\"><b>";
echo $row ['quantityHand'];
echo "</td></tr>";
    echo "</b>";

I'm curious, is there any reason to use
array_pop($value) at all when you can explode(' ', $value, -1)  ???

Besides being php version < version 5.1.0 compatible of course.

can you have something like..

echo $whatever;

this putput
1.2

can you split this number so the first integer will be in $val"(1)" or whatever and the second integer after the "." will be in $val2"(2)"

i have a price i want to add 10%-15% to the base price and that the result

will be rounded to 9 in the ones digit place.

for example

85 +15%=97.7
$result=99

117+15%=134.55
$result = 139

played with round() and ceil()

Hi i got an error. I cant get $new_score and $new_played variables.


$name = $_POST["name"];
$score = $_POST["score"];

$result = mysql_query("SELECT * FROM taure_lentele WHERE name='$name'");
$row = mysql_fetch_array($result);
if(mysql_num_rows(mysql_query("SELECT name FROM taure_lentele WHERE name='$name'") ) == 1 )
{
   $old_score = $row['score'];
   $score + $old_score = $new_score;

   $old_played = $row['played'];
 $new_played = $old_played++;

   mysql_query("DELETE FROM taure_lentele WHERE name='$name'");
   mysql_query("insert into `taure_lentele` set `name` = '$name', `score` = '$new_score',  `played` = '$new_played");
}

Hey I have a quick question.
I am trying to have a part of this PHP script compare two numbers.
There is a randomly generated two-digit number named $random and
There is another two digit number named $number.
I want to make it so the PHP checks to see if $number has any of the same charcters as $random.
I don't know how to do this though. I suspect that somehow both numbers need to be broken apart somehow.
Any advice would be appreciated.
Let me know if I should explain it more clearly
Thanks a ton!

Hello everyone, i am working on a page that displays news topic and would like to have the page numbers at the bottom of the page as links. You know the usual prev (link) then list couple of pages and then next (link).

prev - 1 2 3 4 5... next

below is the code i have to count my records on my db and display them. but the problem with this is that it displays all of them. page 1 through 50.

Code: [Select]
$query2 = "SELECT COUNT(title) FROM news";
$result2 = mysql_query($query2);
$row = mysql_fetch_row($result2);
$total_records=$row[0];
$total_pages = ceil($total_records / 5);


for ($i=1; $i<=$total_pages; $i++)
{
if ($i!=1 and $i !=10) { print "<a href='newsevents.php?page={$i}'> " .$i. " </a>"; }
if ($i==$total_pages)
{
print"<p><a href='newsevents.php?page={$i}'> Last Page </a>";
}
if ($i==1)
{
print "<p class='floatleft'><a href='newsevents.php?page={$i}'> First Page </a>";
}


}



Can someone help?

How I can format the number in a string to be displayed as four-digit. I mean transforming 1 to 0001; and 54 to 0054.