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

Multiple websites question.
Hi, does php have any functionality that enables a programmer to extract information from a website

Problem with PHP code- simple contact form
Hi Folks,
I'm relativily new to PHP; I know HTML and CSS stuff but I have a problem- I have a co

Simple Question
I know this is a simple question, that if I knew what it was technically called i could probably loo

mysql select query problem
how can i select multiple fields from multiple table in one query like

i have table name t1 a

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to

BB_Code error
I'm having a problem with a custom built function and keep getting this error:


Warning: M

php/xmlrpc class issue
I am working on xml-rpc in php to start with.

I have a class that only has variables defined

Filling gaps in dates
So i'm doing a query for sales data and my return array looks like this

('date' => '20

How to separate records and ORDER BY
Let say i have 100 records and displayed in one page, then i want to get the records from 50-100 and

Problem with array max size.
Hi to everyone,
I've got a homework about filling a bidimensional array un spiral shape, I alre