hi,
I am using the following code, but it is not populating my script. If you can help
I would be grateful.
I am using mysql as database.
$typedesc";
}
?>
thanks.
"John W. Holmes" <[EMAIL PROTECTED]> wrote:
From: "andy amol"
> I would like to know how to create and populate drop
J. Alejandro Ceballos Z. wrote:
[snip...]
But while trying to be called based on parameter, is not possible to
call them via:
$myerror = "ERROR1";
That would be $myerror= ERROR1;
echo "ERROR"._$myerror."";
... and that would be echo "".ERROR."._$myerror."";
It not works.
D
Add an AS to your statement
... ditoevents.eventdate,DATE_FORMAT(ditoevents.eventdate, '%a, %b %d
%Y') AS eventdateformatted, ditoevents.eventtime ...
then $row[eventdateformatted] should contain the date in the way you
want it.
-Mike
-Original Message-
From: Tyler Replogle [mailto
In PHP you could do something like:
$mydate = date("l, F jS, Y", strtotime($row["eventdate"]));
echo $mydate;
http://us4.php.net/manual/en/function.date.php gives a full listing of possible
formatting options.
--Nicole
---
Nicole Swan
Web Programming Specialist
Carroll C
I have declared some values as define statements, like:
define("_ERROR1","Error: Your value is wrong, please check params");
But while trying to be called based on parameter, is not possible to call
them via:
$myerror = "ERROR1";
echo "ERROR"._$myerror."";
It not works.
Any su
You could always make your own function. If you need help with that i would
be glad to help there too.
From: "Justin @ Dreaming in TO" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Displaying Date from Value in MySQL DB
Date: Tue, 20 Apr 2004 14:27:30 -0400
Hey All,
Looking to tr
All Macintosh users can't or is it just a type of one because that happened
to me before i change my sites to work with it. So if it is just one type of
Macintosh computer i might be able to help you.
From: matthew perry <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Macs and ses
I've been developing on a Mac for quite some time now without any
problems with sessions. I doubt it's something unique to the Mac. Are
trying to generate a pop-up window via Javascript for the login? Just
about all browsers that a Mac person would use have popup blocking
turned on.
If your we
From: "Justin @ Dreaming in TO" <[EMAIL PROTECTED]>
> SELECT ditoevents.eventstatus, ditoevents.eventdate,
> DATE_FORMAT(ditoevents.eventdate, '%a, %b %d %Y'), ditoevents.eventtime,
> ditoevents.eventlocation, ditoevents.topic, ditoevents.presenter
> FROM ditoevents
> WHERE ditoevents.eventstatus
Hey All,
Looking to try to figure at small problem.
This is the SQL query I am using to show the next event on a page:
SELECT ditoevents.eventstatus, ditoevents.eventdate,
DATE_FORMAT(ditoevents.eventdate, '%a, %b %d %Y'), ditoevents.eventtime,
ditoevents.eventlocation, ditoevents.topic, ditoe
Does anybody know of a good tutorial of using foreign keys in MySQL InnoDB
tables?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I think the problem isn't session data specifically. The log in fails
before the session begins.
Strangely this ONLY happens with macs. I have never had a problem with
PCs.
Maybe mac computers have a different default setting that could be
causing this problem?
Matt
--
PHP Database Mailing
Check if the session id is stored as a cookie and the mac users accepts cookies.
Otherwise try to send the session id by _GET
- Original Message -
From: matthew perry
To: [EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 8:31 PM
Subject: [PHP-DB] Macs and sessions
Macintosh us
Are you certain that, for those users experiencing problems, cookies are
enabled/accepted by their browsers?
Just a guess.
> -Original Message-
> From: matthew perry [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 20, 2004 1:32 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Macs and sess
Macintosh users can't log in on my web site.
I don't require anything unusual for log ins - simply a form with a user
id and password that queries a MySQL database.
The form is not encripted and I don't even use any security precautions
for the data transfer (users can't do much anyway).
After th
If it is a MySWL database, the following code works great
\n";
while ($view_list = mysql_fetch_array($result))
{
$view_code = $view_list[choice];
$view_desc = stripslashes($view_list[description]);
$viewing .= "$view_desc\n";
}
$viewing .= "";
?>
Of course you'll have to change it to fit yo
From: "andy amol" <[EMAIL PROTECTED]>
>I would like to know how to create and populate drop down boxes in php.
> I want the value to be populated from database.
> What I am try to do is to provide the forign key value as combo box
option, so that I do not have to check for referential integrit
At 10:53 4/20/2004, andy amol, wrote:
>hi,
>
>Also if you can help me with a date validation program I will be grateful.
You could use a Regular Expression:
http://tinyurl.com/yr6up
http://www.Google.com/search?q=regular+expressions+site%3Aphp.net
Start Here to Find It Fast! -> http://www.US-We
You mean html dropdown-s?
print '';
$r = mysql_query("SELECT id, field1, fieldn FROM table WHERE fieldn = 'sg'");
while($RESULT = mysql_fetch_array($)) {
print ''.$RESULT['fieldn']'.';
}
print '';
Validating: just check the $_POST['sg'] value, against is_numeric(), then you can do a SELEC
I use html forms with select field size 1 and the option values and/or
what is supposed to appear in the box. This you populate by your DB
query, maybe using an array and a loop (from 0 to ..).
Torsten
andy amol schrieb:
hi,
I would like to know how to create and populate drop down boxes in
hi,
I would like to know how to create and populate drop down boxes in php.
I want the value to be populated from database.
What I am try to do is to provide the forign key value as combo box option, so that I
do not have to check for referential integrity.
Also if you can help me with a date
hi,
I would like to know how to create and populate drop down boxes in php.
I want the value to be populated from database.
What I am try to do is to provide the forign key value as combo box option, so that I
do not have to check for referential integrity.
Thanks in advance.
Rene,
This is a clarification of what I think Ignatius was talking about.
I did like this on www.deep-purple.com/tourdates:
Your database structure must look something like this for it to work:
ID ITEMCATEGORY
1 1 1
2 2 1
3 3
Hi everyone,
I got working. Here is my configure that worked:
./configure' '--with-zlib-dir=/usr/local/' '--with-gd'
'--with-jpeg-dir=/sw' '--with-png-dir=/sw'
'--with-mysql=/usr/local/mysql' '--with-xml' '--with-pdflib-dir=/sw'
'--enable-ftp' '--enable-ldap' '--with-curl=/sw' '-enable-calendar
Hi Jason and list,
Yes your right about the two machines... I changed the libjpeg,
libpng, libtiff to this:
--with-jpeg-dir=/sw \
--with-png-dir=/sw/ \
--with-tiff-dir=/sw /
--with-gd \
I get this when I run the configure:
checking for GD support... yes
checking for the location of libjpeg... /
On Tue, 20 Apr 2004 10:10:46 +1000
Christopher Jones <[EMAIL PROTECTED]> wrote:
> To connect to Oracle in PHP 4, the old name OCILogon() can be used.
> Check PHPs oci8.c source code for all names and aliases.
No, there is no need to look into source code.
Just wait for some time, old functions wi
I hope the following will solve the purpose
mysql_query( "Drop Table 'Table name'");
regards,
Lalit Goyal
-Original Message-
From: Uzi Klein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 2:44 PM
To: 'charalambos nicolaou'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] How to Erase
Use only one query:
SELECT
category,
item,
...
ORDER BY category, item
Now fetch rows, and keep the latest categoryID in a flag variable:
- if fetched categoryID <> flag, close table, create a new table, add header
row
- otherwise add content row to the current table
- update flag with the latest
Hi,
I want to make the following page,
Category 1
Item 1 of category 1
Item 2 of category 1
Item 3 of category 1
Item 4 of category 1
Category 2
Item 1 of category 2
Item 2 of category 2
Item 3 of category 2
Category 3
Item 1 of category 3
Item 2 of category 3
Item 3 of category 3
Item 4 of c
Hi everyone,
I can not find in my manual a MySQL command which erase permanently a table
and it's content from a MySQL database.
- "DROM TABLE 'tbl_name';"
Thanks in advance
Charalambos
_
MSN 8 helps eliminate e-mail vi
On Tuesday 20 April 2004 09:31, Craig Hoffman wrote:
> Here is what I am running:
> ./configure --with-zlib-dir=/usr/local --with-libjpeg-dir=/sw
> --with-libpng-dir=/sw --with-libtiff-dir=/sw --with-gd
> --with-mysql=/usr/local/mysql --with-xml --with-freetype=/sw
> --with-pdflib=/sw --enable-ftp
31 matches
Mail list logo