Learn VBA & Macros in 1 Week!

PHP - Getting Primary Key From New Row

Full Excel VBA Course - Beginner to Expert

Getting Primary Key From New Row	View Content

If I am using this:

Code: [Select]
mysql_query("INSERT INTO M1QuizResults
(Email, Q1Choice, Q2Choice, Q3Choice, Score, Pass, Date_Taken, Time_Taken)
VALUES(' " . $_SESSION['Email'] . " ', '$QChoice_1', '$QChoice_2', '$QChoice_3', '$Score', '$Pass', CURDATE(), NOW())")

or die(mysql_error());

What would I use to find out what the row's "Id" is? "Id" is my primary key. I want to store this "Id" as a session variable. thanks!

Full Excel VBA Course - Beginner to Expert

Print Primary Key

Similar Tutorials

View Content

I am using function to insert into database. But the primary key is automatic and I used Quote

$_SESSION['Tes_ID'] = mysql_insert_id();

to retrieve this. But now that I use function method. I am not sure how to retrieve the primary key on to the next page.

Code: [Select]
$value = modulesql($postVar1, $postVar2, $SessionVar1, $SessionVar2);

$_SESSION['Tes_ID'] = mysql_insert_id();

echo $value, $_SESSION['Tes_ID'];

Code: [Select]
<?php
function modulesql($Tes_Name, $Tes_Description, $Use_ID, $Sub_ID){
$con = OpenConnection();

mysql_select_db("examination", $con);
$module = ("INSERT INTO test (`Tes_Name`, `Tes_Description`, `Use_ID`, `Sub_ID`)
VALUES ($Tes_Name, $Tes_Description, $Use_ID, $Sub_ID)")
or die('Cannot Execute:'. mysql_error());

CloseConnection($con);
return $module;
}
?>

Have I lost you with my question??

How To Retrieve A Primary Key

Similar Tutorials

View Content

I have a form that ask user to enter other details but the primary key as this is automated and when they click on Submit button it takes the user to different form. now on this form I would like to retreive the primary that has just been added to the table. How can I do this?

Primary Key Issue?

Similar Tutorials

View Content

I can't figure out where this is going wrong. But it obviously has to do with the primary key for the table. Here is the code:

//set led request
if ( isset ( $action ) && $action == 'submit_led_request' ) {

	$order_id = $_GET['order_id'];
	$products = explode(',', $_GET['product']);
	$qty = explode(',', $_GET['qty']);

	//make sure the same of number of records exist in each array
	if ( count ( $products ) == count ( $qty ) ) {
		
		$original_request_id = $pdo->query("SELECT MAX(id) FROM leds_requests LIMIT 1")->fetch(PDO::FETCH_NUM)[0] + 1;

		for ( $i = 0; $i <= count ( $products ) - 1; $i++ ) {

			$query = "INSERT INTO leds_requests (original_request_id, order_id, user_id, product_id, qty, status_id) VALUES (:original_id, :order_id, :user_id, :product_id, :qty, 0)";
			$statement = $pdo->prepare($query);
			$statement->execute([
				'original_id' => $original_request_id,
				'order_id' => $order_id,
				'user_id' => $_SESSION['user_id'],
				'product_id' => $products[$i],
				'qty' => $qty[$i],
			]);

		}

		//setup variables for system wide message function
		$send_to_users[] = ['user_id' => 54]; //r
		$send_to_users[] = ['user_id' => 49]; //b
		$send_to_users[] = ['user_id' => 55]; //g
		$send_to_users[] = ['user_id' => 1]; //j
		$message = 'An LED pull request has been made by: ' . get_user_full_name($_SESSION['user_id'], $pdo) . '. Please go to the LED Request Manager to review the request.';
		
		//send the messages
		$chat_message_id = send_system_message( $message, $send_to_users, $order_id, $pdo );

		//establish relationship for messages
		$pdo->query('
				INSERT INTO
					chat_message_rel_leds(
						chat_message_id,
						original_request_id
					) VALUES (
						'. $chat_message_id .',
						'. $original_request_id .'
					)
			');
		
	}
	else {
		exit();
	}

}

Here is a screenshot of the problem:

If you look at row 235 and 236, they have a value of 233 and 234 in the 'original_request_id' column. If you look below 235, the last key was 232 so that should have been correct (original_request_id should be the initial key assigned to the record from the table).

Is my method for determining what that key is going to be fault in some way? IE:

$original_request_id = $pdo->query("SELECT MAX(id) FROM leds_requests LIMIT 1")->fetch(PDO::FETCH_NUM)[0] + 1;

From what I understand, there isn't a way in PDO to get the current max primary key except after an insert function is performed. Is this correct and am I doing something wrong here?

How To Extract Current Primary Key

Similar Tutorials

View Content

Hi, I am trying to build a function that takes in the current primary key as a parameter. My question is how do I extract it/retrieve it and store it in a variable?

Any help is much appreciated!

Duplicate Entry '6' For Key 'primary'

Similar Tutorials

View Content

What exactly does the entry in the title mean? I cannot make sense out of it.

I would appreciate if somebody can shed some light in.

The error message occurs when I try to vote with the voting system I created.

Help:duplicate Entry '1' For Key 'primary'

Similar Tutorials

View Content

Please i ran into this problem help me : Code: [Select]
<p>Posted by <a href="">
<?php
if(isset($_GET['id']))
{
$tpid=$_GET['id'];
}
else
{
$tpid=$_POST['id'];
}
include"header.php";
$sql="SELECT*FROM topics WHERE topicsid='$tpid'";
$result=mysql_query($sql) or die(mysql_error());
while($row=mysql_fetch_array($result))
     {
                  echo"{$row['topics_by']}";

echo"</a></p>";

echo"<p>";
                  echo"{$row['topics_subject']}";

  echo" <p align='left'><img src='speakout_1.png'/>";
echo"{$row['topics_content']}";

echo"<p class='post-footer align-right'>

<a href='' class='comments'>";
session_start();
if(isset($_SESSION['views']))
$_SESSION['views']=$_SESSION['views']+1;
else
$_SESSION['views']=1;
echo"Comments:".$_SESSION['views'];
echo"</a>";
echo"<span class='date'>";

echo"{$row['topics_date']}";
}
?></span>
</p>

</div>

<h3>Comments:</h3>

<table>
<tr class="row-a">
<td class="first"></td>
<td><?php
                                 include"header.php";
                                  $sql="SELECT post_content,post_by FROM post WHERE topicsID='$tpid'";
                            $result=mysql_query($sql)or die(mysql_error());
                                while($row=mysql_fetch_array($result))
                             {

                               echo"<strong>{$row['post_by']}</strong>:  {$row['post_content']}"."</br>";
                             }
                                         ?></td>

</tr>
</table>
<?php
include"header.php";
if(isset($_POST['submit']))
{
$comment=mysql_real_escape_string(trim($_POST['comment']));
$name=mysql_real_escape_string(trim($_POST['name']));
$hidden=$_POST['id'];
if($comment!=='' && $name!=='')
{
$ins="INSERT INTO post(topicsID,post_content,post_by)VALUES('$hidden','$comment','$name')";
mysql_query($ins) or die(mysql_error());
}
else
{
echo"you cannot post an empty field";
}
}

?>
<h3>Post your comments here</h3>
<form action=''method='post'>
<textarea name="comment" id="content" style="width:400px;height:50px;background-color:#D0F18F;color:#000000;font:15px/20px cursive;scrollbar-base-color:#638E0D;"></textarea>
<br />
Name:<input type="text"name="name"/>
<input class="button" type="submit"name="submit"value="submit" />
<input type="hidden"name="id"value='<?php echo "$tpid"; ?>'/>
</p>
</form>

<br />

</div>

Getting Primary Key From Db2 Merge In Php Script

Similar Tutorials

View Content

I have a successful select query, where I'm looping and building a row for getting parameters which works correctly

while ($row = $orderDetailCheck->fetch(PDO::FETCH_ASSOC)) {

$params = [
":INVOICE_NUMBER" => $row["INVOICE_NUMBER"],
":CUSTNM" => $row["CUSTNM"],
":SELLINGN" => $row["SELLINGN"],
":GROUP" => $row["GROUP"],
":DTL12" => $row["DTL12"],
":DTL13" => $row["DTL13"],
":QUANTITY" => $row["QUANTITY"],
":COUNT_PLMN_1" => $row["COUNT_PLMN_1"],
":LAST_DATE" => $row["LAST_DATE"],
];

}

My issue now is that, for each row, I need to perform two merges because the data from that select is going to be split into two tables in db2. Some values are truly split between the tables but some values are shared between the two. I'm not sure the best way to perform these two merges because if the first one (products table) inserts, then it creates an ID that I need as a foreign key basically, to insert into the orders table. So on insert I need to grab that newly created ID and use it for ```product_id``` in the second merge. If the first merge performs the update when matched, then I need to grab the existing ID for that record so that I can update the proper record in the orders table.

My two merge statements:

/*products table*/
MERGE INTO products AS P
USING(VALUES(

:GROUP,
:DTL12,
:DTL13,
:CUSTNM,
:SELLINGN,
:COUNT_PLMN_1,
:LAST_DATE

)
)

AS S(GROUP,DTL12,DTL13,CUSTNM,SELLINGN,COUNT_PLMN_1,LAST_DATE)
ON s.GROUP = p.GROUP and s.DTL12 = p.DTL12 and s.DTL13 = p.DTL13 and s.CUSTNM = p.CUSTNM

WHEN MATCHED
THEN UPDATE SET LAST_DATE = s.LAST_DATE

WHEN NOT MATCHED
THEN INSERT VALUES (s.GROUP,s.DTL12,s.DTL13,s.CUSTNM,s.SELLINGN,s.COUNT_PLMN_1,s.LAST_DATE)

/*ORDERS Table*/
MERGE INTO ORDERS AS PO
USING(VALUES(

/*need foreign key, which is id from products table*/
:QUANTITY,
:LAST_DATE,
:INVOICE_NUMBER
))

AS S(PRODUCT_ID,quantity_ordered,LAST_DATE,invoice_number)
ON s.PRODUCT_ID = po.id

WHEN MATCHED
THEN UPDATE SET LAST_DATE = s.LAST_DATE, quantity_ordered = s.quantity_ordered, invoice_number = s.invoice_number

WHEN NOT MATCHED
THEN INSERT VALUES (s.PRODUCT_ID, s.quantity_ordered, s.LAST_DATE, s.invoice_number)

Examples:

If my ROW Returns

Then my insert into products would be

products

and my insert to orders:

ORDERS

PRODUCT_ID | QUANTITY_ORDERED | LAST_DATE | INVOICE
============================================================
1 13 '2018-12-14' 1122

But if my next record matched on my unique qualities with a new invoice, quantity and date

ROW Returns

Then I would update products like so:

products

and update orders like so:

ORDERS

PRODUCT_ID | QUANTITY_ORDERED | LAST_DATE | INVOICE
============================================================
1 4 '2018-12-18' 1133

I guess the main question is: How can I get the ID of a record from the products table (whether it's an existing match OR newly created in the merge) and once I get it, how can I use it for the 2nd merge?

Error: Duplicate Entry '' For Key 'primary'

Similar Tutorials

View Content

Hi there,

I am trying to add a bit of php to capture an email address and add it to mysql database. This part works fine but i get this message:

Error: Duplicate entry '' for key 'PRIMARY'

How do i get rid of this error?

Thanks!

<?php

session_start();
include('include/includes.php');
$cart = Cart::CreateInstance();

if(isset($_GET)){
   foreach($_GET as $k=>$v){
      $smarty->assign($k,$v);
      }
   }
if(isset($_GET['remove'])){
$cart->RemoveItems($_GET['remove'],1);
   }
if(isset($_GET['removeAll'])){
$cart->RemoveItems($_GET['removeAll'],$_GET['counts']);
   }

if(isset($_GET['emptyCart'])){
if($_GET['emptyCart']){
   $cart->EmptyCart();
   header("Location: cart.html");
   exit(0);
}}

if(isset($_GET['add'])){

   $itemId = $_GET['add'];
   $size = $_GET['size'];

   if (isset($_GET['qty'])) {
      $qty = $_GET['qty'];
   } else {
      $qty = 1;
   }

   $cart->addItems($itemId.'-'.$size, array($size,$itemId), $qty);
}
$cart = Cart::CreateInstance();
$cartBox = $cart->GetCart();
//print_r($cartBox);
$total = 0;
$subTotal = array();
$db = new DB();
$prods = $db->select("SELECT friendly,name,id FROM products");
$smarty->assign('prods',$prods);
if(is_array($cartBox)){
   foreach($cartBox as $key=>$item){
      $id = $cartBox[$key]['data']->_itemData[1];
      $products = $db->select("SELECT detail,image,friendly,name FROM products WHERE id='$id'");
      $detailjson = json_decode($products[0]['detail']);

      foreach($detailjson as $detail){
         list($k, $v) = split_by_colon($detail);
         if($k == $cartBox[$key]['data']->_itemData[0]){ $price = $v;}
      }
      $cartBox[$key]['data']->_itemData[3] = $products[0]['image'];
      $cartBox[$key]['data']->_itemData[6] = $products[0]['name'];
      $cartBox[$key]['data']->_itemData[2] = $products[0]['friendly'];
      $cartBox[$key]['data']->_itemData[5] = $price;
      $sub = (int)$item['count'] * $price;
      $cartBox[$key]['data']->_itemData[4] = $sub;
      $total += $sub;
   }
} else {
   $cartBox = array();
}

$count = $cart->GetItemsCount();

$shipping = (int)0;
if($total>0&&$total<5){ $shipping = 2.99;
}elseif($total>5&&$total<10){ $shipping = 3.99;
}elseif($total>10&&$total<15){ $shipping = 4.99;
}elseif($total>15&&$total<20){ $shipping = 5.99;
}elseif($total>20&&$total<30){ $shipping = 6.99;
}elseif($total>30&&$total<40){ $shipping = 7.99;
}elseif($total>40&&$total<50){ $shipping = 8.99;
}elseif($total>50&&$total<60){ $shipping = 9.99;
}elseif($total>60&&$total<70){ $shipping = 10.99;
}elseif($total>70&&$total<80){ $shipping = 11.99;
}elseif($total>80&&$total<90){ $shipping = 12.99;
}elseif($total>90&&$total<100){ $shipping = 15.99;
}elseif($total>100&&$total<110){ $shipping = 16.99;
}elseif($total>110&&$total<120){ $shipping = 17.99;
}elseif($total>120&&$total<130){ $shipping = 18.99;
}elseif($total>130&&$total<140){ $shipping = 19.99;
}elseif($total>140&&$total<150){ $shipping = 20.99;
}elseif($total>150&&$total<160){ $shipping = 21.99;
}elseif($total>160&&$total<170){ $shipping = 22.99;
}elseif($total>170&&$total<180){ $shipping = 23.99;
}elseif($total>180){ $shipping = 24.99;
}

/*
0 - 4.99 = 2.99
5 - 9.99 = 3.99
10 - 14.99 = 4.99
15 - 19.99 = 5.99
20 - 29.99 = 6.99
30 - 39.99 = 7.99
40 - 49.99 = 8.99
50 - 69.99 = 9.99
70 - 99.99 = 10.99
100+ = 12.99

*/

if(isset($_GET['eushipping'])||(isset($_POST['rec_country'])&&$_POST['rec_country']!='uk')){

if($_POST['rec_country']=='au' || $_GET['country']=='au'){
//Set shipping for Austria
$shipping = ceil($total/60.00)*30.00;
}elseif($_POST['rec_country']=='be' || $_GET['country']=='be'){
//Set shipping for Belgium
$shipping = ceil($total/60.00)*20.00;
}elseif($_POST['rec_country']=='bu' || $_GET['country']=='bu'){
//Set shipping for Bulgaria
$shipping = ceil($total/60.00)*50.00;
}elseif($_POST['rec_country']=='cy' || $_GET['country']=='cy'){
//Set shipping for Cyprus
$shipping = ceil($total/60.00)*108.00;
}elseif($_POST['rec_country']=='cz' || $_GET['country']=='cz'){
//Set shipping for Czech Republic
$shipping = ceil($total/60.00)*33.00;
}elseif($_POST['rec_country']=='de' || $_GET['country']=='de'){
//Set shipping for Denmark
$shipping = ceil($total/60.00)*30.00;
}elseif($_POST['rec_country']=='es' || $_GET['country']=='es'){
//Set shipping for Estonia
$shipping = ceil($total/60.00)*45.00;
}elseif($_POST['rec_country']=='fi' || $_GET['country']=='fi'){
//Set shipping for Finalnd
$shipping = ceil($total/60.00)*30.00;
}elseif($_POST['rec_country']=='fr' || $_GET['country']=='fr'){
//Set shipping for France
$shipping = ceil($total/60.00)*28.00;
}elseif($_POST['rec_country']=='ge' || $_GET['country']=='ge'){
//Set shipping for Germany
$shipping = ceil($total/60.00)*25.00;
}elseif($_POST['rec_country']=='gr' || $_GET['country']=='gr'){
//Set shipping for Greece
$shipping = ceil($total/60.00)*50.00;
}elseif($_POST['rec_country']=='hu' || $_GET['country']=='hu'){
//Set shipping for Hungary
$shipping = ceil($total/60.00)*25.00;
}elseif($_POST['rec_country']=='ir' || $_GET['country']=='ir'){
//Set shipping for Ireland
$shipping = ceil($total/60.00)*25.00;
}elseif($_POST['rec_country']=='it' || $_GET['country']=='it'){
//Set shipping for Italy
$shipping = ceil($total/60.00)*30.00;
}elseif($_POST['rec_country']=='la' || $_GET['country']=='la'){
//Set shipping for Latvia
$shipping = ceil($total/60.00)*42.00;
}elseif($_POST['rec_country']=='li' || $_GET['country']=='li'){
//Set shipping for Lithuania
$shipping = ceil($total/60.00)*35.00;
}elseif($_POST['rec_country']=='lu' || $_GET['country']=='lu'){
//Set shipping for Luxembourg
$shipping = ceil($total/60.00)*20.00;
}elseif($_POST['rec_country']=='ma' || $_GET['country']=='ma'){
//Set shipping for Malta
$shipping = ceil($total/60.00)*108.00;
}elseif($_POST['rec_country']=='ne' || $_GET['country']=='ne'){
//Set shipping for Netherlands
$shipping = ceil($total/60.00)*25.00;
}elseif($_POST['rec_country']=='no' || $_GET['country']=='no'){
//Set shipping for Norway
$shipping = ceil($total/60.00)*37.00;
}elseif($_POST['rec_country']=='pol' || $_GET['country']=='pol'){
//Set shipping for Poland
$shipping = ceil($total/60.00)*35.00;
}elseif($_POST['rec_country']=='por' || $_GET['country']=='por'){
//Set shipping for Portugal
$shipping = ceil($total/60.00)*30.00;
}elseif($_POST['rec_country']=='ro' || $_GET['country']=='ro'){
//Set shipping for Romania
$shipping = ceil($total/60.00)*48.00;
}elseif($_POST['rec_country']=='slv' || $_GET['country']=='slv'){
//Set shipping for Slovakia
$shipping = ceil($total/60.00)*32.00;
}elseif($_POST['rec_country']=='slk' || $_GET['country']=='slk'){
//Set shipping for Slovenia
$shipping = ceil($total/60.00)*29.00;
}elseif($_POST['rec_country']=='sp' || $_GET['country']=='sp'){
//Set shipping for Spain
$shipping = ceil($total/60.00)*36.00;
}elseif($_POST['rec_country']=='swe' || $_GET['country']=='swe'){
//Set shipping for Sweden
$shipping = ceil($total/60.00)*32.00;
}elseif($_POST['rec_country']=='swi' || $_GET['country']=='swi'){
//Set shipping for Switzerland
$shipping = ceil($total/60.00)*55.00;
}elseif($_POST['rec_country']=='ukh' || $_GET['country']=='ukh'){
//Set shipping for UK - Highlnads and Islands
$shipping = ceil($total/60.00)*18.00;
}elseif($_POST['rec_country']=='ukn' || $_GET['country']=='ukn'){
//Set shipping for UK - Northern Island
$shipping = ceil($total/60.00)*18.00;
}elseif($_POST['rec_country']=='jng' || $_GET['country']=='jng'){
//Set shipping for Jersey and Guernsey
$shipping = ceil($total/60.00)*34.00;
}
}



/*

*/
if(isset($_GET['count'])){
   echo (int)$count;
   exit;
   }

if(isset($_GET['order'])){
if($_GET['order']){

   }}

if(isset($_GET['ajax'])){
   $noAjax = $_GET['ajax'];
}else{
   $noAjax = false;
}

$smarty->assign('noAjax',$noAjax);

if(isset($_GET['t'])){
   $t=$_GET['t'].'.tpl';
} else {
   $t = 'cart.tpl';
}

if(isset($_POST['cmd'])) {
   $_SESSION['paypal'] = $_POST;
   //print_r($_POST);
   }
if(isset($_POST['rec_houseA1'])){

   $filename = time().'-'.rand(1,499);
   $paypal = $_SESSION['paypal'];
   unset($paypal['checkout_x']);
   unset($paypal['checkout_y']);

   $_SESSION['addresses'] = $_POST;


$File = 'sales/'.$filename.'.php';
$Handle = fopen($File, 'x');
fwrite($Handle,'<?
');
fwrite($Handle,'$cart = array(');

foreach($cartBox as $k=>$v){

      fwrite($Handle,'"'.$k.'"=>array(');
      foreach($v as $key=>$value){

            if(is_object($value)){
      fwrite($Handle,'"'.$key.'"=>(object)array(');

      foreach($value as $keys=>$values){
         if(is_array($values)){
            fwrite($Handle,'"'.$keys.'"=>array(');
            foreach($values as $keyd=>$valued){
               fwrite($Handle, '"'.$keyd.'"=>"'.$valued.'",');
               }
            fwrite($Handle,'""=>""),');

            }else{
            fwrite($Handle, '"'.$keys.'"=>"'.$values.'",');      }
         }   fwrite($Handle,'""=>""),');
      }else{fwrite($Handle, '"'.$key.'"=>"'.$value.'",');}
         }
      fwrite($Handle,'""=>""),');

   }
//$total += $_POST['shipping'];
fwrite($Handle,'"total"=>"'.$total.'");');
fwrite($Handle,'

');
fwrite($Handle,'$detail = array(');
foreach($_POST as $k=>$v){
   if(is_array($v)){
      fwrite($Handle,'array(');
      foreach($v as $key=>$value){

            if(is_array($value)){
      fwrite($Handle,'array(');
      foreach($value as $keys=>$values){
            fwrite($Handle, '"'.$keys.'"=>"'.$values.'",');
         }
      fwrite($Handle,')');
      }else{fwrite($Handle, '"'.$key.'"=>"'.$value.'",');}
         }
      fwrite($Handle,')');
      }else{
   fwrite($Handle, '"'.$k.'"=>"'.$v.'",');
   }
   }
fwrite($Handle,'""=>"");');
fwrite($Handle,'

');
fwrite($Handle,'$paypal = array(');
foreach($paypal as $k=>$v){
   if(is_array($v)){
      fwrite($Handle,'array(');
      foreach($v as $key=>$value){

            if(is_array($value)){
      fwrite($Handle,'array(');
      foreach($value as $keys=>$values){
            fwrite($Handle, '"'.$keys.'"=>"'.$values.'",');
         }
      fwrite($Handle,')');
      }else{fwrite($Handle, '"'.$key.'"=>"'.$value.'",');}
         }
      fwrite($Handle,')');
      }else{
   fwrite($Handle, '"'.$k.'"=>"'.$v.'",');
   }
   }
fwrite($Handle,'""=>"");');

fwrite($Handle,'

');

fwrite($Handle,'$shipping = "'.$shipping.'";
');
fwrite($Handle,'$subtotal = "'.$total.'";
');
$totals = $total+$shipping;
fwrite($Handle,'$totals = "'.$totals.'";');
   fclose($Handle);

   $smarty->assign('filename',$filename);
   $smarty->assign('shipping',$shipping);
   $smarty->assign('paypal',$paypal);
   //print_r($paypal);
   $smarty->display('paypal.tpl');
}else{
   $smarty->assign('total',$total+$shipping);
   $smarty->assign('itemsInBox',$count);
   $smarty->assign('cartBox',$cartBox);
   $smarty->assign('shipping',$shipping);
   $style = $db->select("SELECT * FROM styles WHERE `name`='default'");
   $smarty->assign('style',$style);
   $smarty->display($t);
}
?>
<?php
$con = mysql_connect("organicgrowshopcouk.fatcowmysql.com","worm","*******");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("ogs_mailinglist1", $con);

$sql="INSERT INTO mailinglist (email)
VALUES
('$_POST[rec_email]')";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}

mysql_close($con);
?>

Table Not Being Sorted By Primary Key By Default

Similar Tutorials

View Content

I have a table with two columns. The first is an id column, set to be my primary key, non null, unique, int, and auto increment. The second is a varchar(10) column. Very strangely, when I set the varchar(10) column to unique, and try to edit the table in workbench, the table is automatically ordered by my varchar column, and not my id (primary key column). If I mark the varchar(10) column as not unique, data is ordered by the primary key, as expected. What is going on here? I expected the primary key to be default ordering for the table. I hope to not use an ORDER BY clause.
Edited by E_Leeder, 29 November 2014 - 02:14 AM.

What Is The Primary Source Of "motion" Using Jquery Collapsible?

Similar Tutorials

View Content

I am looking to use this functionality : http://www.w3schools...mob_collapsible However using my own CSS style. I looked at the source code, unfortunately the code is just jammed together so it isn't immediately clear how it works, I thought too that I could find every semi-colon and do a line escape but I don't know / think that javascript / jquery follows the same end of line statement as php. I'm just looking to have a rectangle that when pushed, another rectangle of the same width but different color / font "extends" below this one, pushing the other elements below, away. If anyone would care to chime in I'd appreciate it, otherwise I'll scrutinize the javascript/jquery code, I haven't worked with either too much yet. Thanks
Edited by moose-en-a-gant, 17 January 2015 - 07:22 AM.