[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[no subject]
Chris Fowler wrote:
>
> This might be the best way but how do I do this? "select serial_no from
> table_533 where ....."
>
I'm not personally sure in Perl, but in PHP, you can do the following:
$result = mysql_query("INSERT INTO xxxyyy (id, hihi) VALUES ('', 'hihi')");
$rowId = mysql_insert_id($result);
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - <a rel="nofollow" href="http://enigmail.mozdev.org">http://enigmail.mozdev.org</a>
iD8DBQFCqEjHPXInbkqM7nwRAz0nAKCUpRRfjSFE8N5iMqYOKQLkPSCpHwCdEZkt
KXxQX0ukUg034Bn1OaPWEss=
=0mKm
-----END PGP SIGNATURE-----
</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00401" href="msg00401.html">[ale] Getting the next index of a table in mysql</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Chris Fowler)</li></ul></li>
<li><strong><a name="00402" href="msg00402.html">[ale] Getting the next index of a table in mysql</a></strong>
<ul><li><em>From:</em> james.sumners at gmail.com (James Sumners)</li></ul></li>
<li><strong><a name="00403" href="msg00403.html">[ale] Getting the next index of a table in mysql</a></strong>
<ul><li><em>From:</em> fd0man at gmail.com (Michael B. Trausch)</li></ul></li>
<li><strong><a name="00405" href="msg00405.html">[ale] Getting the next index of a table in mysql</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Chris Fowler)</li></ul></li>
<li><strong><a name="00406" href="msg00406.html">[ale] Getting the next index of a table in mysql</a></strong>
<ul><li><em>From:</em> fd0man at gmail.com (Michael B. Trausch)</li></ul></li>
<li><strong><a name="00407" href="msg00407.html">[ale] Getting the next index of a table in mysql</a></strong>
<ul><li><em>From:</em> cfowler at outpostsentinel.com (Chris Fowler)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00409.html">[ale] Getting the next index of a table in mysql</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00411.html">[ale] Drive recovery</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00409.html">[ale] Getting the next index of a table in mysql</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00412.html">[ale] suse 9.2 yast2 - printer media source setting</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00410"><strong>Date</strong></a></li>
<li><a href="threads.html#00410"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>
<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>