Re: [PHP-DB] array awry
In article 061201c0a063$08eab5a0$[EMAIL PROTECTED],
[EMAIL PROTECTED] ("Keith Spiller") wrote:
This associative array embedded within a function and declared as a global at
the start of the function, is meant to be a multidimensional array, but with
every loop of the while ($myrow = mysql fetch row($result)) statement, it's
previous values are replaced by the new ones. Any ideas on how I can fix
this?
If ($Selection == "3")
{
$tabledata[catid]= $myrow[0];
$tabledata[category] = "$myrow[1]";
$tabledata[under]= $myrow[2];
$tabledata[corder] = $myrow[3];
$tabledata[active] = $myrow[4];
}
So what you're saying is that want indexes 'catid', 'category', etc. to
have a distinct value for each row pulled from the database? Then you need
to add another dimension to that array.
--
CC
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Search engines database driven sites
Greetings I'm not sure my question fits into the remit of this list - so apologies in advance if it's off track... Please point me in a more suitable direction is necessary! I recently converted my sites from hardwired HTML to a PHP/MySQL combination - with dynamic 'newsy' info held in a database, tailored for each visitor. Unfortunately the 'hit rate' from search engines has gone virtually to zero as Altavista, Hotbot etc. removed me from their indexes - they don't index .php files as far as I can see, and also don't follow links on php pages (I imagine it's the same for ASP, ColdFusion etc.). In contrast Google and All The Web have no problems with the .php extension (and even index my .pdf files!). I would be grateful for any wisdom on how best to deal with this. I could of course make an HTML intro page, but that would be a pity since I'd hardly be able to an intro page that conveys all the necessary info to bring the right visitors. Any advice on how to do this well? I could alternatively change the setting of the PHP parser to parse all .html as if it's php. Unfortunately I'm sharing a server right now and my ISP is unlikely to accept this because of the reduction in performance (I may be prepared to move to a dedicated server if necessary though). Lastly I thought of writing a PHP routine that, run once a day, will make a few HTML 'mirror' pages based on the content of the database to capture the search engine visitors. I could do that, but it seems to defeat the purpose of the dynamic pages somewhat... pity. Any other ideas? How do others deal with this issue? Regards Grant --- Grant Ballard-Tremeer, HEDON Household Energy Network http://www.ecoharmony.net/hedon/ eco Ltd. http://ecoharmony.com --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Search engines database driven sites
Here is an article by Tim Perdue. Every time I lookup php stuff in google, phpbuilder shows up so he must be doing something right. http://www.phpbuilder.com/columns/tim2526.php3 Leon -Original Message- From: Grant Ballard-Tremeer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 7:25 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Search engines database driven sites Greetings I'm not sure my question fits into the remit of this list - so apologies in advance if it's off track... Please point me in a more suitable direction is necessary! I recently converted my sites from hardwired HTML to a PHP/MySQL combination - with dynamic 'newsy' info held in a database, tailored for each visitor. Unfortunately the 'hit rate' from search engines has gone virtually to zero as Altavista, Hotbot etc. removed me from their indexes - they don't index .php files as far as I can see, and also don't follow links on php pages (I imagine it's the same for ASP, ColdFusion etc.). In contrast Google and All The Web have no problems with the .php extension (and even index my .pdf files!). I would be grateful for any wisdom on how best to deal with this. I could of course make an HTML intro page, but that would be a pity since I'd hardly be able to an intro page that conveys all the necessary info to bring the right visitors. Any advice on how to do this well? I could alternatively change the setting of the PHP parser to parse all .html as if it's php. Unfortunately I'm sharing a server right now and my ISP is unlikely to accept this because of the reduction in performance (I may be prepared to move to a dedicated server if necessary though). Lastly I thought of writing a PHP routine that, run once a day, will make a few HTML 'mirror' pages based on the content of the database to capture the search engine visitors. I could do that, but it seems to defeat the purpose of the dynamic pages somewhat... pity. Any other ideas? How do others deal with this issue? Regards Grant --- Grant Ballard-Tremeer, HEDON Household Energy Network http://www.ecoharmony.net/hedon/ eco Ltd. http://ecoharmony.com --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Resolution detect and redirect
I am lookign for a piece of code that will detect the resolution of the user and return a page dependant on that i.e - The table will be adjusted to suit that. Is there a script where I can detect what the resolution is, and also redirect to a page depending on what resolution they are using? Thanks in advance for any help! _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] unixODBC and Sybase ASE 11.9.2 on a linux box
Hi, we are trying the above combination, but we do not find any hints how (which?) we configure an ODBC - Driver for Sybase in an odbc.ini file... if anyone has experience with this combination we would be very glad if you could post a small overview or a source, where we can find informations about this combination... thx Stefan Siefert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] array awry
All,
Perhaps I've misunderstood.
I thought this IS a PHP list (see Rolf Hopkins below).
Secondly, this list is not only for MySQL questions and issues (see Cal
Evans below). It is for all database questions, as we've seen from uestins
concerning other databases.
Am I incorrect?
Richard L. Emery
IT Sr. Project Manager
"There is no 'trying'...
There is only 'Do' or 'Not Do' "
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 6:50 AM
To: Keith Spiller
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] array awry
Hi Keith,
1: Don't cross-post. It's rude. Especially since this has nothing to do with
MySQL.
2: You are not building a multi-dimensional array. The code below won't even
build a single dimensional array because you didn't put your keys in quotes
so it's probably blowing chunks. At the very least, if you had put quotes
around your key names, it would have overwritten the data each loop.
Try something like this:
If ($Selection == "3")
{
$lcvA++;
$tabledata[$lcvA] = Array();
$tabledata[$lcvA]['catid']= $myrow[0];
$tabledata[$lcvA]['category'] = "$myrow[1]";
$tabledata[$lcvA]['under']= $myrow[2];
$tabledata[$lcvA]['corder'] = $myrow[3];
$tabledata[$lcvA]['active'] = $myrow[4];
}
This is a multidimensional array. The first dimension is a counter, $lcvA.
Make sure you init it at the top of your function. Now, each time you add a
row to the array, it' in a new row IN the array.
To access the data you use:
$myCOrder = $tabledata[$rowToAccess]['corder']
HTH,
Cal
http://www.calevans.com
-Original Message-
From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 9:10 PM
To: Keith Spiller; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: array awry
This is a PHP question and should really be asked on the PHP list.
But a suggestion. Tried using field names instead of number? ie.
$myrow["catid"];
I'd have to read up the PHP manual to find out for sure but I'm sure you can
do that just as well as I can.
-Original Message-
From: Keith Spiller [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 8:15 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [PHP-DB] array awry
This associative array embedded within a function and declared as a global
at the start of the function, is meant to be a multidimensional array, but
with every loop of the while ($myrow = mysql_fetch_row($result)) statement,
it's previous values are replaced by the new ones. Any ideas on how I can
fix this?
If ($Selection == "3")
{
$tabledata[catid]= $myrow[0];
$tabledata[category] = "$myrow[1]";
$tabledata[under]= $myrow[2];
$tabledata[corder] = $myrow[3];
$tabledata[active] = $myrow[4];
}
Keith
aka Larentium
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Resolution detect and redirect
Why not just create a table that will resize to any resolution? Because I am using different sized images for the different resolutions as well as other page thingys. And I need the script for other things too. So can anyone help? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Search engines database driven sites
Hello Grant,
Well the thing with search engines is as AltaVista puts it very nicely:
quote
Dynamic pages also block Web crawlers.
8 8cut 8 8
Typically such pages have a question mark (?) in the URL. When a search
engine crawler arrives at such a page, it captures the content but halts
immediately, and will not follow the links, because it sees ahead of it an
infinite number of pages -- a black hole that would bring it to a crash.
/quote
This came from http://doc.altavista.com/adv_search/ast_haw_wellindexed.html
where you can find more useful tips.
So if you are passing variables in any way like
http://www.site.com/dir/article.php?id=25 than these pages will simply not
be indexed...
One way to deal with this is the following:
Build the link above like this: http://www.site.com/dir/25.html this
document doesn't exist.
In that directory you refer the 404's to article.php where you call
getenv("REQUEST_URI") and look, it says 25.html which you can then use to
query the database and show that article :)
Roel
At 12:24 27-02-2001 +, you wrote:
Greetings
I'm not sure my question fits into the remit of this list - so apologies in
advance if it's off track... Please point me in a more suitable direction is
necessary!
I recently converted my sites from hardwired HTML to a PHP/MySQL
combination - with dynamic 'newsy' info held in a database, tailored for
each visitor. Unfortunately the 'hit rate' from search engines has gone
virtually to zero as Altavista, Hotbot etc. removed me from their indexes -
they don't index .php files as far as I can see, and also don't follow links
on php pages (I imagine it's the same for ASP, ColdFusion etc.). In contrast
Google and All The Web have no problems with the .php extension (and even
index my .pdf files!).
I would be grateful for any wisdom on how best to deal with this. I could of
course make an HTML intro page, but that would be a pity since I'd hardly be
able to an intro page that conveys all the necessary info to bring the right
visitors. Any advice on how to do this well? I could alternatively change
the setting of the PHP parser to parse all .html as if it's php.
Unfortunately I'm sharing a server right now and my ISP is unlikely to
accept this because of the reduction in performance (I may be prepared to
move to a dedicated server if necessary though). Lastly I thought of writing
a PHP routine that, run once a day, will make a few HTML 'mirror' pages
based on the content of the database to capture the search engine visitors.
I could do that, but it seems to defeat the purpose of the dynamic pages
somewhat... pity.
Any other ideas? How do others deal with this issue?
Regards
Grant
---
Grant Ballard-Tremeer,
HEDON Household Energy Network http://www.ecoharmony.net/hedon/
eco Ltd. http://ecoharmony.com
---
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Mulder Technisch Advies
Postbus 69
NL-2740 AB WADDINXVEEN
tel. 0182-640184 fax. 0182-640185
http://www.mta.nl
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] md5
You are aware that md5() generates a 32 byte character string?
Working on the 10 digit password request, have you alotted enough space in
your database columns to cater to a 32 byte string (64 for multibyte)?
BTW: md5 has eaten everything I've thrown at it ;-)
""bryan"" [EMAIL PROTECTED] wrote in message
005801c0a0f1$c5c3cd40$272478cc@bryan">news:005801c0a0f1$c5c3cd40$272478cc@bryan...
I need some advice on this
I am creating a random password through a function.
This creates a random password and updates it in the database.
The sql query works if I make it :
$sql = "UPDATE members SET password='$password', verify='$verify' WHERE
username='$username' ";
but if I make the code (as below) with the md5, it does not.
I must be doing something wrong, or it does not like to md5 random things
or something. Any Advice?
for ( $a=0; $a1; $a++) {
$password = newpwd( 10 );
$verify = $password;
$dbcnx = mysql_connect('localhost', 'bryan', 'fitch');
mysql_select_db( "playtime" );
$sql = "UPDATE members SET password=' ".md5($password)." ', verify='
".md5($verify)" ' WHERE username='$username' ";
Thanks
bryan
Bryan Fitch
Programmer
Concept Factory
[EMAIL PROTECTED]
http://www.concept-factory.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Resolution detect and redirect
This feat will require a java script (not appropriate for php/db). I saw something on a javascript site, perhaps www.webreference.com gl ""Matthew Cothier"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Why not just create a table that will resize to any resolution? Because I am using different sized images for the different resolutions as well as other page thingys. And I need the script for other things too. So can anyone help? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] md5
Yeah, i am aware of the 32 byte character string. As a matter of fact, I
md5 the password on initial
sign-up. Then just compare it to the regular password. As for this case, I
am trying to
update the password that is already md5 'd in the database. The problem is,
I am creating a
random string (with letters and numbers) and making it 10 characters long.
I think md5
has a problem with this, for some reason
Probably just me though. Thanks for the advice.
bryan
- Original Message -
From: "Joe Brown" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 27, 2001 12:40 PM
Subject: Re: [PHP-DB] md5
You are aware that md5() generates a 32 byte character string?
Working on the 10 digit password request, have you alotted enough space in
your database columns to cater to a 32 byte string (64 for multibyte)?
BTW: md5 has eaten everything I've thrown at it ;-)
""bryan"" [EMAIL PROTECTED] wrote in message
005801c0a0f1$c5c3cd40$272478cc@bryan">news:005801c0a0f1$c5c3cd40$272478cc@bryan...
I need some advice on this
I am creating a random password through a function.
This creates a random password and updates it in the database.
The sql query works if I make it :
$sql = "UPDATE members SET password='$password', verify='$verify' WHERE
username='$username' ";
but if I make the code (as below) with the md5, it does not.
I must be doing something wrong, or it does not like to md5 random things
or something. Any Advice?
for ( $a=0; $a1; $a++) {
$password = newpwd( 10 );
$verify = $password;
$dbcnx = mysql_connect('localhost', 'bryan', 'fitch');
mysql_select_db( "playtime" );
$sql = "UPDATE members SET password=' ".md5($password)." ', verify='
".md5($verify)" ' WHERE username='$username' ";
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Resolution detect and redirect
Why not just create a table that will resize to any resolution? Because I am using different sized images for the different resolutions as well as other page thingys. And I need the script for other things too. So can anyone help? Is there anyway to convince you this is a very very bad idea? Leave the choice up to the user. Why? Sure, my screen resolution is 1024x768, but I never run the browser full screen (I'd bet 99% of people don't), so forcing me to view a page that only looks good at 1024x768 when my window size is closer to 800x600 just annoys me (I've seen a few sites like that; left immediatly even though they were good sites). If I have the choice, I'll pick the one I think is closest to my current window size. I've seen several sites that do this. Much better. Another reason not to do this is all the extra work in maintaining all the different versions of pages/images etc. Better to spend the time writing PHP code. :) - Darryl -- Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED] Education Research Technology Services, http://gollum.usask.ca/ Department of Computing Services, University of Saskatchewan -- "Go not to the Elves for counsel, for they will say both no and yes" -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Resolution detect and redirect
Would be a feat indeed if you could get PHP to do this! It does need Javascript to do (although having returned the result, you could then carry this forward by setting a variable server side (in php!) that identified the user and continued to display appropriate page versions). If you were feeling really clever, you could even go the whole hog and store these as variables using the session functions of PHP4 (would then mean that the variable as well as any others you choose to set for the user don't have to be laboriously carried over each time). Just a thought. Seriously though, definitely worth trying http://www.irt.org I would be very supprised if there wasn't an FAQ specifically about this (its actually very easy to do in Javascript). Have fun, Ben Stoneham Technical Director - FCP Internet LTD ___ FCP Internet LTD - 'Making the Web Work for You' 70 Smithbrook Kilns, Cranleigh, Surrey, GU6 8JJ, UK. Tel. 01483 272 303 Fax. 01483 272 303 mail: [EMAIL PROTECTED] http://www.fcpl.com ___ -Original Message- From: Joe Brown [mailto:[EMAIL PROTECTED]] Sent: 27 February 2001 20:46 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Resolution detect and redirect This feat will require a java script (not appropriate for php/db). I saw something on a javascript site, perhaps www.webreference.com gl ""Matthew Cothier"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Why not just create a table that will resize to any resolution? Because I am using different sized images for the different resolutions as well as other page thingys. And I need the script for other things too. So can anyone help? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] MySQL join problem
I doubt that a few thousand records would be more than mysql is capable of handeling. However my ignorance of Mysql is abundant. Does it use the /tmp directory and is your /tmp or root partition small? (guessing linux here). Does mysql use the /tmp directory for temporary tables? (Answer in ReadMe(s) probably)... ""Elliott Lee"" [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Hi all, This may not necessarily be a PHP problem, but I was initially trying to do this in PHP. I was trying to do a join of two tables and I get a response from MySQL saying that some SQL temp file was out of space. One of my tables has a few thousand items in it and my other table that I'm joining with is pretty small, maybe 15 items. Is there a limitation to the size of the query that I can do? I'm not out of disk space either. Elliott -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Can't connect to local MySQL server error
Heh, hate this gotcha... The file permissions are good... ok, now check each directory up to mysql.loc /var /var/lib /var/lib/mysql Does the world have read and execute perms on all of the above (hehe made a funny)? Without read and execute perms on the parent directories, the world cannot see the file to have read write and execute to the socket file. gl "Rick Emery" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... MySQL is running; I can execute MySQL as ROOT. The /var/lib/mysql/mysql.sock file exists with read/write/execute permissions to user/group/world. Any other ideas are appreciated. Thanks rick Richard L. Emery IT Sr. Project Manager "There is no 'trying'... There is only 'Do' or 'Not Do' " -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 4:46 PM To: Rick Emery; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Can't connect to local MySQL server error Addressed to: Rick Emery [EMAIL PROTECTED] '[EMAIL PROTECTED]' ** Reply to note from Rick Emery [EMAIL PROTECTED] Mon, 26 Feb 2001 14:33:32 -0600 I tried: Grant ALL ON *.* to user@localhost IDENIFIED BY "password"; so as to provide access to all tables. I should have stated that the error I got was that I could not connect to the /var/lib/mysql/mysql.sock socket. Make sure that MySQL is running, that the mysql.sock file exitst, in the specified location, and that the permsiions on that file, and every directory above it allow the user the web server runs as has read and execute rights. Note that execute for directories means that you can cd to it, and has nothing about running programs from within it. If the file is missing, try to find it (locate) and look in php.ini for a setting to specify the correct location for your system. Rick Widmer Internet Marketing Specialists http://www.developersdesk.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Primary Key Value
mysql_insert_id() i *think* also pg_lastiod() or something similar... At 08:57 PM 2/27/01 -0800, Richard S. Crawford wrote: Suppose I put data into a table using an Insert query, and that the table generates a primary key for the data. Is there a way to get at that primary key without running a separate select query against the table? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Beau Lebens - Web Master Insurance My Way, Your Friendly Online Broker (08) 9226 5888 http://www.insurancemyway.com.au/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Primary Key Value
Perfect! Thanks. At 01:05 PM 2/28/01 +0800, Beau Lebens wrote: mysql_insert_id() i *think* also pg_lastiod() or something similar... At 08:57 PM 2/27/01 -0800, Richard S. Crawford wrote: Suppose I put data into a table using an Insert query, and that the table generates a primary key for the data. Is there a way to get at that primary key without running a separate select query against the table? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Beau Lebens - Web Master Insurance My Way, Your Friendly Online Broker (08) 9226 5888 http://www.insurancemyway.com.au/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
