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
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 runni
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: [EMA
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 t
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 Read
(re-ordered to bottom-posting, for clarity)
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Scott Bernard") wrote:
> 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
Hi!
You can order everything but you must be carefull in the database design.
Select "program" from "table" order by "time"
Where "time" is a DATE value in your database. In mysql you have a variety the
formats. For example,
DATETIME: -MM-DD hh:mm:ss
Maybe you need use a good book related
What you can do is create an html page blank, with meta-tags for the search
engines, but including the meta:
at the first line. This is going to redirect to the indicated php page.
I think its a solution, for the search enginges as for the users, because
the will not see anything.
Regards.
id
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 j
Thanks!
The other thing that I have been asked to design is an online tv guide for a
list of shows. Basically I want to be able to display a list of programmes
on the front page for the current date in time order. Can this be done in
the same way as alphabetical ordering?
I will also have a s
Hi!
I guess that you want the following:
Select "name" " from "Table" order by "name"
For the search box, you need build a form, send the search value to the script
(a PHP script for this list :-o) and the script must query in your database.
The script depends on the complexity in the search an
Thanks everyone for helping me with the resolution problems, its sorted now!
Q. How do I sort a list of names onto a page into a table in alphabetical
order?
I am doing a link database and require that I have a list of catagorie names
in alphabetical order with the links listed alphabetically
Somebody has installed the informix support to php with the apxs (APache
eXtenSion tool)??
-Mensaje original-
De: Mark Farver [mailto:[EMAIL PROTECTED]]
Enviado el: Viernes 9 de Febrero de 2001 11:53 AM
Para: Javier Morquecho Morquecho
CC: 'php-db list'
Asunto: RE: [PHP-DB] Linu
In the Python language, witht he appropriate module, one can construct a
string like:
"load data infile 'pwlist.txt' replace into table subscriber fields
terminated by '\t' optionally enclosed by '"' lines terminated by '\r\n' ",
pass it to the cursor.execute() function and it completes.
I've
On Tue, Feb 27, 2001 at 09:03:58PM +0100, Roel Mulder wrote:
> 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 t
> -Original Message-
> From: Darryl Friesen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 27, 2001 12:57 PM
> To: db
> Subject: Re: [PHP-DB] Resolution detect and redirect
>
>
> >>>Why not just create a table that will resize to any resolution?
> >>
> >> Because I am using differen
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 feeli
>>>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 i
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
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 r
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]> wrot
Hello Grant,
Well the thing with search engines is as AltaVista puts it very nicely:
Dynamic pages also block Web crawlers.
8>< 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 hal
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
>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?
__
> Perhaps I've misunderstood.
>
> I thought this IS a PHP list (see Rolf Hopkins below).
It's a PHP/Database list, not just PHP. POsts should have something to do
with BOTH.
> Secondly, this list is not only for MySQL questions and issues (see Cal
> Evans below). It is for all database questio
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. Em
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
ab
BDY.RTF
--
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]
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?
I'm assuming you're under Unix. Make sure you can use sqlplus as the
webserver user (nobody under most Linuxes). I had to add the Oracle_home
env variable to the system .profile script. Also try setting Oracle_home
inside the httpd.conf script (SetEnv?)
For windows users having the ORA-12154
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' "
-
I had a similar problem ( on 2000 ) until created a usr directory at the
root ( C: )and put the mibs directory in it from the php directory
- Original Message -
From: "Joe Brown" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 12:19 AM
Subject: Re: [PHP-DB] Fa
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 2
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 leas
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 databas
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 = my
36 matches
Mail list logo
