PHP - Moved: How To Select Row With Highest Auto Increment Value?

Hi,

I have coded a lot in the past but only now getting into PHP and web coding in general, when I use a while loop in most other languages I need to increment some form of counter to move to the next item e.g.
Code: [Select]
while (count < 10)
{
Do something;
count + 1;
}
I am going through a set of tutorials that have just enlightened me to the following code when looking up a MYsql d'base:
Code: [Select]
$reults = "SELECT * FROM table";
while ($row = mysql_fetch_assoc($results)){
extract($row);
echo $tblcol1;
echo "  - ";
echo $tblcol2;
echo "<br>";
}
Now in fairness I have no real problem with this, if thats how you extract your results from a query then fine but I feel I am missing something and have not been able to nail it on the head.  Am I to assume that $row in the loop returns the first row from the query results, moves through the actions of the loop, returns then automatically points to the next row of the array?

Does that mean while($row){} where $row is a 3x3 array(for example) it would loop through this 3 times assigning the next row until the end?

Is there a better way to explain this?

ok, how do I add an auto incremented value to another table at the same time the value is created. 
so I will do a query to insert into db, and it creates auto incremented value of 1, then I need this value to also be put into another table just as text.  how do I go about doing this?  I need this all in one query.

is there a way to save a field in a session or variable while its being inserted into the data base?
with out having to select it using another query

$mail2 = "INSERT INTO pm SET pm_id = '', (turn pm_id into a $variable or session) WHERE blah blah blah

the problem im having is Im creating two rows right after each other where each row is in differant tables and I need them to match ids and I have nothing to compare it to.

only option i can think of is making a fast toggle switch or telling my select to grab in order which would work.

Is there a way to copy an auto-increment value (`id`) into another field in the same table (`org_id`)?

So, when someone creates a new organization, it will copy the new auto-increment value into the org_id field. Is this possible?

Thanks!

hey guys i have this invoice im working on but my clients  want's the invoice id start at a specific  number?   do it put that number in phpmyadmin direct on the line null?or can i do it another way?

Hi everyone,   I have an application that makes use of a transaction, inserting and updating values in different tables. One of the first tables it inserts into has an auto increment ID field. This ID values is used / updated in some other tables. Everything works fine. If however the transaction fails then the auto_increment values are upset - meaning that the sequence is jumped.   For ex. if I had auto_increment values from 1 to 6 in this table and then the insert query fails for an auto_increment value of ID=7, then this value of ID = 7 is lost because the next time the query is run the auto_increment ID value will be equal to 8 and accordingly updated in the tables. ID value = 7 is lost. Is there any way to prevent this ? Please know that this is a multi - user application.   Thanks.          

I've been trying to grab the unique auto incrementing table id and put into a session variable.


$name_id = mysql_insert_id();

$query = sprintf("INSERT INTO profile (
 name_id, bio, ex)
VALUES (LAST_INSERT_ID(),'%s','%s')",
mysql_real_escape_string($_SESSION['pro']['bio']),
mysql_real_escape_string($_SESSION['pro']['ex']));

$result = mysql_query($query, $db) or die(mysql_error($db));
$name_id = mysql_insert_id();

$_SESSION['name_id'] = $name_id; //this is the key line
                $_SESSION['logged'] = 1;
header('Refresh: 5; URL=main.php');


I've echoed out the result of $_SESSION['name_id'] and it says '0'.

I've tried changing the key line to

$_SESSION['name_id'] = LAST_INSERT_ID();


but I get this error message: Fatal error: Call to undefined function LAST_INSERT_ID() in C:\x\xa

Is my goal acheivavle or should I just set up a select query after the insert query and extract the id key?

Hello,

I need to set a CSS class for the highest number in a MySQL column, and the second highest. So for instance I have a column named scores. I would want the <td> with highest scores to be <td.Winner> and the second highest to be <td. RunnerUp>. I know how to set the css part up, so just need help with creating a function. I did something similar to set the background of table cells based on the text data and that looked like this.

function cssfromdate($date) {
 $class = array('December_January' => 'January', 'March_April' => 'March');
 return $class[$date];
}

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


  echo "<tr>";

  echo "<td>" . $row['last_name'] . "</td>\n";
  echo "<td>" . ucwords($row['first_name']) . "</td>\n";
 
    echo "<td class=\"".cssfromdate($row['Class_Date'])."\">".$row['Class_Date']."</td>\n";
  
  echo "</tr>";
 


  }



I am hoping I can accomplish what I need to doing something similar.

Hi, I have come up with the following code, I need it to get the details of several scattered products and echo the results, the trick is I don't want it to echo the results one after the other... I want to have the products scattered between unique text on the page but don't want to run the query several times for performance reasons.

E.g.- PAGE to look like this:

$Product_1

unique text/images

$Product_2
$Product_3

unique text/images

$Product_4


Current Code:

Code: [Select]
<?
$result = mysql_query("SELECT * FROM products where Product_ID IN (475, 465, 234, 567, 845)");
while($row = mysql_fetch_array($result))
  {
    $x = "1";
      while ($x<=3)
{
          echo $x;
          $Product = "Product_";
          $Product = $Product.$x;
          echo $Product;
          $Product = $row['Product_ID'];
          echo $Product;
          $x++;
          echo $x;
        }
  }

At the moment it returns the following results:

Quote

1
Product_1
465
2

2
Product_2
465
3

3
Product_3
465
4

1
Product_1
475
2

2
Product_2
475
3

3
Product_3
475
4


A few problems...

In Blue... it duplicates for product 465
In Red... It repeats again for 475
Also.... it starts with 465, but I want it to go in order as how it appears - $result = mysql_query("SELECT * FROM products where Product_ID IN (475, 465, 234, 567, 845)");  so should start with 475


I want to get the following result:

Quote

1
Product_1
475
2

2
Product_2
465
3

3
Product_3
234
4

4
Product_4
567
4

(and so on.....)



If anyone could provide me assistance with my troubled 'while loop' statement that would be much appreciated! 

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=331209.0

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=343888.0

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=352528.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=310894.0

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=320341.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=309828.0