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
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
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
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
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
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 will
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...
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'
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,
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.
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
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
You mean select/select html dropdown-s?
print 'select name=sg';
$r = mysql_query(SELECT id, field1, fieldn FROM table WHERE fieldn = 'sg');
while($RESULT = mysql_fetch_array($)) {
print 'option value='.$RESULT['id'].''.$RESULT['fieldn']'./option';
}
print '/select';
Validating: just check
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 integrity.
If it is a MySWL database, the following code works great
?
$sql = select choice, description from views;
$result = mysql_query($sql) or die(mysql_error());
$viewing = ;
$viewing .= select name=\view_code\\n;
while ($view_list = mysql_fetch_array($result))
{
$view_code = $view_list[choice];
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
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 sessions
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,
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 = 'next'
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
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
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 try
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 strongERROR._$myerror./strong;
It not works.
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
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
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 strongERROR._$myerror./strong;
... and that would be echo strong.ERROR.._$myerror./strong;
It
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.
?
$sql = SELECT course_id FROM course;
$sql_result = mysql_query($sql)
or die(Couldn't execute query.);
while ($row = mysql_fetch_array($sql_result))
27 matches
Mail list logo