Hi,
I have created a database with following structure
CREATE TABLE member(
mem_id INT,
name TEXT,
age INT);
the first page is as follows :
!-- search1.html --
HTML
BODY
H1
How to delete all the data in database, without delete the table.
Looks like I can't delete all the data with single click in PHPmyAdmin mySQL
-naga
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List
How to delete all the data in database, without delete the table.
Looks like I can't delete all the data with single click in PHPmyAdmin mySQL
-naga
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP Database Mailing List
Hi,
I have created a database with following structure
CREATE TABLE member(
mem_id INT,
name TEXT,
age INT);
the first page is as follows :
!-- search1.html --
HTML
BODY
H1 This is
there is an excellent tutorial with a coded example of a shopping cart using
sessions.
http://www.phpbuilder.com/columns/evert2816.php3
only takes small mods to extend it so you can delete from cart as well.
Steve Brett
Internal Development
EMIS Ltd.
"Privileged and /or Confidential
I have read and have reccommended several times: "PHP Fast and Easy Web
Development" By Juli C Meloni.
ISBN: 0-7615-3055-X
Prima Tech publishing
#---#
"Believe nothing - consider everything"
Using PhpMyAdmin click the 'empty' hyperlink. This will empty all the
data from the table but not delete the table.
HTH :)
Russ
#---#
"Believe nothing - consider everything"
you can,
choose the database on the left hand side and you will se all of your tables
in that db on the right with the option to EMPTY
olinux
- Original Message -
From: "Naga Sean" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 02, 2001 12:25 AM
Subject: [PHP-DB] Delete all
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi php-db members,
I'm not sure if this is the right forum to say this or if this is more
of a PHP technical issue
I have found a strange problem with the MSSQL interface.
I have a small relational database and a PHP script which populates
and
Hi all... I'm having a little problem in converting a site to
spanish, due to - apparently - IE that doesn't like accented words.
I have a db-driven website, of a fairly classical type - texts and
image paths are stored in a DB, and pages are generated thru PHP.
I'm converting this site
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]
Hi there,
you can also do it this way using Javascript
script
if (navigator.appName == "Netscape") {
StyleSheet = "netstyle.css"
} else {
StyleSheet = "iestyle.css"
}
/script
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]
Hi People,
Below I have included some code that just doesn't seem to be functioning all
correctly. I have this running and it appears to stop the query/echo after
the first entry in the database. What is it that I am doing wrong here??
Regards,
Shannon
?
$roundnum = "";
$sql = "select * from
Hi People,
Below I have included some code that just doesn't seem to be functioning all
correctly. I have this running and it appears to stop the query/echo after
the first entry in the database. What is it that I am doing wrong here??
Regards,
Shannon
?
$roundnum = "";
$sql = "select * from
What is ...
1) The maximum number of tables in a database?
2) The maximum number of rows and
3) (most importantly) the maximum size of a MySQL MyISAM table ? (3.23.35)
1.
I can find no documentation on this; assuming its atleast 2 bytes; or 65536
tables; this value is if no real concern.
2.
-Original Message-
From: Martin Skjoldebrand [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 31, 2001 10:52 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] array_diff usage
I'm daft. I don't understand the PHP Manual.
I have two arrays:
Open[0] contains 1 2 3 4 5
Closed[0]
Hey guys, need somore help..
i need to pass a variable like $cr from view.php to comment.php..i thought
there used to be a variable called $php_self, but i just searched the
php.net site and nothin showed up...newaz any help is appreciated. thnx
--
Chris Hall
sytems administrator
funnelbox
form method="post" action="?php echo $PHP_SELF?"
I use this in forms to submit something to the same page and then do
something like if($submit){ do this }
Hope it helps
Lisa
-Original Message-
From: Chris Hall [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 9:13 AM
To:
session_register("cr");
and then read the manual page on starting sessions etc ...
Steve Brett
Internal Development
EMIS Ltd.
"Privileged and /or Confidential information may be contained in this
message. If you are not the original addressee indicated in this message (or
responsible for
Chris:
in view.php:
a href="anotherpage.php?cr=yes"Click here to see the value of cr/a
in anotherpage.php:
echo $cr; //outputs 'yes'
Or:
?php
form method=\"POST\" action=\"$PHP_SELF\"
input type="hidden" name="arse" value="big"
more form stuff etc etc yadda yadda yadda
/form
?
Hello,
I've been working on this script all day, but I'm getting the same failure
report each time:
Warning: Supplied argument is not a valid MySQL result resource in
c:\program files\apache group\apache\htdocs\motoerit\toon_alles.php on line
23
What could be wrong? This is the code I have:
I'm daft. I don't understand the PHP Manual.
I have two arrays:
Open[0] contains 1 2 3 4 5
Closed[0] contains 1 2
Now:
$test = array_diff($Open, $Closed);
Given the setup you've described, I think you might actually want
$test = array_diff($Open[0], $Closed[0]);
OK
Hi -
how are persistent connections closed once they're opened? is there a timeout or
something that deactivates them? i just want to make sure they're not hanging around
when they're not needed.
Nathaniel Dose
LeoMedia Berlin
-Original Message-
From: Martin [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 10:48 AM
To: Mark Roedel; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] array_diff usage
This, on the other hand, makes me suspect that the arrays themselves
don't actually contain what you
I want to extract a date from a datetime field in Microsoft SQL, via ODBC
('cause we support different databases, or so I'm told, and hey, what do I
know! gr!).
I want the format to be CCYYMMDD.
Is there a MS SQL function for this?
I've found DATEPART("",field), but I don't know
I'm trying compiling PHP4 with Solid once again (Dan Kalowsky advised me to repost
here) and yet again I've hit a totally brick wall.
1, I'm not sure what is needed in the Solid lib directory and where I can get the
files if they're not in the archive I've used to install Solid
2, Because
I want to display a user's full name and user id that would be from their
login action. (The login stuff is already set up.) How would I be able to
grab the user id from the login? Any ideas on where to look?
Thanks,
Liz
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
-Original Message-
From: Slider [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 9:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Please help me with this script...
Hello,
I've been working on this script all day, but I'm getting the
same failure
report each time:
how do i duplicate a table?
i tried
create table refer2 select * from refer;
create table refer2 as select * from refer;
they didn't work.
my mysql version is mysql 3.22.28,
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
And to go one step further with his question, I would like to know how to do
the following:
2 tables named table1 and table2
table1 contains 3 records, firstname, lastname, password.
table2 is the same except that it has one more field at the beginning and
that field is of type serial.
Now,
Well in linux I use the CLI interface from php to run all my queries. I
read somewhere that the native CLI interface was faster than using the ODBC
driver. I have the ODBC driver working properly, I just wanted to know if
it was possible to use CLI with PHP in windows (like on Linux).
I guess
hello everyone-
I'm running MySQL 3.23.27-beta with php 4.04pl1. What I am wondering is I
have an auto incrementing field and if I delete all the entries in the table
with this field the incrementing doesn't start over. For example, if I
insert 6 records for the first time into this table the
Hi--
I have a form that cannot have a specific field blank, so I would like to
add a message box saying "fill out the x field," is there a way to do this
WITHOUT having to refresh the page?
Julio Cuz, Jr.
Riverside Community College
[EMAIL PROTECTED]
--
PHP Database Mailing List
joseph,
This was a feature that was recently modified. Older versions of mySQL
support the
feature that you seem to want. 3.23.xx and above will support the feature
that you
have just described. If you want to roll your own out,
you could do something like...
mysql SELECT
Hello,
"Julio Cuz, Jr." wrote:
Hi--
I have a form that cannot have a specific field blank, so I would like to
add a message box saying "fill out the x field," is there a way to do this
WITHOUT having to refresh the page?
Maybe you would like to try this PHP form generation and
Ok, in your $sql var, put:
$sql = "SELECT * FROM table LIMIT 20";
Leave the other code intact. This fetches 20 rows from MySQL.
-- David Balatero
-Original Message-
From: Bob Stone [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 3:53 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Naga Sean) wrote:
How to delete all the data in database, without delete the table.
Do you want to delete every *table* in the *database*, or delete every
*row* in the *table*? Assuming the latter, "delete from database_name".
--
CC
--
PHP
Okay, Im having some problem using setcookie(). Basically, I have to form fields,
Username/Login. When the username and login are authenticated using mysql, it logs
into the secure area. I set the cookie so taht it takes the $username variable that
the user entered into the form and on the
Your might want to consider limiting the records selected. For example
"select emp_name from employees limit 0,20".
Alternatively consider using a a "for" statement.
- Brian Hardwick
Tangible Networks.
-Original Message-
From: Bob Stone [mailto:[EMAIL PROTECTED]]
Sent: Monday, April
Okay, don't ask me how, but for whatever reason, this "partially worked":
"./configure --with-openlink=/usr/local/openlink/odbcsdk --with-mysql=/usr/l
ocal --with-apache=../apache"
however, now I get a different error:
In file included from internal_functions.c:38:
Daevid,
You shouldn't need iodbc.h, just odbc.h - until I can compare what is each
SDK distribution, just create a symbolic link of iodbc.h pointing to odbc.h
udbcext.h is in our iODBC SDK - you should have that. Here is the linux
glibc2.1.1 version:
Is there a way, once updating a table to load another PHP? After, I have the
user click on the save button, the code calls a update routine. After the
UPDATE is done, I want the code to call another progam.
Thank you.
Jim
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
I've tried this with both PHP4.0.4 and PHP4.0.4pl1 as a module (it's for a
daily script eventually).
[root=pts/1]7:29pm@content:{/www/html/private/TattooShop}
./odbc-test2.phtml
#!/bin/php -q
Segmentation fault
the relevant part of phpinfo(); is below, so I'm assuming that I finally got
odbc
Julio,
It is much more efficient to do that type of validation client-side, using
Javascript. No
sense in making another round trip to the server if not necessary.
Here is a quicke example:
if (document.autoform.txtVehicleNumber.value == ""){
document.autoform.txtVehicleNumber.focus()
I am a little less biased ;-)
I think Manuel's Metabase is the bomb. Unfortunatly, so does Windows...
Metabase provides some truely wonderful features. On Windows, Metabase with
OCI8 my server keep performing illegeal instructions. I think this is a
lack of PHP's maturity on Win32, not
Daevid,
connection script snipped (looked fine)
$dsn="DSN=OpenLink"; // this is a valid DSN set up in the above odbc.ini
//$conn_id = odbc_connect("DSN=OpenLink;UID=daevid;PWD=secret","","");
?
--
[OpenLink]
Driver = /usr/local/openlink/lib/oplodbc.so.1
Maybe after the UPDATE statement, you could do:
?php
header("Location: /path/to/other/script.php");
?
...but I don't know, I don't use header() that much.
-- David Balatero
-Original Message-
From: Jim Ray [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 6:23 PM
To: [EMAIL
48 matches
Mail list logo