|
|
Posted by Jerry Stuckle on 11/17/06 14:11
casper christensen wrote:
> Well
>
> Using the insert tag, it returns the value"0", any idea why. Obviously
> it doesnt get the last inserted id (tried Last_insert_id.. too)
>
> casper
>
> Jerry Stuckle skrev:
>
>>casper christensen wrote:
>>
>>>I'm not asking you or anyone to go throught the entire code to find a
>>>bug. There is no bug!
>>>I need to know how to fetch the created Id. The must be some "standard"
>>>code to get "load" values from the database.
>>>
>>>casper
>>>
>>
>>I'm not sure what you mean by fetch the "created id". Are you talking
>>about after your user adds a new row to the table? If that's the case,
>>see http://www.php.net/manual/en/function.mysql-insert-id.php.
>>
>>But you're also not using "standard" MySQL functions. MySQLQuery is not
>>a PHP function. The one defined in PHP is mysql_query. I have no idea
>>what your function is doing.
>>
>>--
>>==================
>>Remove the "x" from my email address
>>Jerry Stuckle
>>JDS Computer Training Corp.
>>jstucklex@attglobal.net
>>==================
>
>
First of all, does the table have an autonumber column? Since you were
looking for an ID, I suspected it did, but my assumption may be wrong.
Also, did you call it after making the insert, using the same connection
as the INSERT (and without closing the connection)?
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|