MYSQL INSERT ID NOT WORKING

Posted on 16th Feb 2014 07:03 pm by admin

Code: $id = mysql_insert_id();
header("Location: ./?view=$id");
Why $id pulling blank nothing?


Code: mysql_query("INSERT INTO `prays` (`title`,`prayer`,`time`,`level`,`nameid`,`name`) VALUES (
'". mysql_real_escape_string($_POST['title']) ."',
'". mysql_real_escape_string($text) ."',
'". mysql_real_escape_string($time) ."',
'". mysql_real_escape_string($_POST['level']) ."',
'". mysql_real_escape_string($e) ."',
'". mysql_real_escape_string($name) ."');") or die(mysql_error()) ;
mysql_close();
$id = mysql_insert_id();
header("Location: ./?view=$id");

Your Answer:

Login to answer

Other forums

temporary objects
Until now i thought every temporary object in C++ is created as constant. I'm wondering why my compi

Timer control causing error
I recently decided to add a timer control to an existing page that uses AJAX on my site. As soon as

how to make database item unique
Hey guys,

is it possible to do this:

I have the database item $title being pulled for

use an array from 1 class in a second class
I have a class that adds data to an array

Then I have a second class and I need to check if t

SAP Treasury - Commodities
We are running SAP ECC 6.0 with Treasury Activated.
EA-FIN is also activated (SFW5).

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

Saving PHP output as a file
I wondered if anyone knows how to save the rendered output of a PHP script as a file?

I have

losing variables between php brackets
Hi

have got this code:
Code: $id=mysql_result($result,0,"itemid");
$title=mys

quick question about System Change Number(SCN) in FlashBack Query topic
i know tht we can get the SCN of the database using flashback concept as follows

SQL>

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi