On Saturday 17 February 2001 10:20, Jeff Oien wrote:
>So if I want to delete
>a record by title, I'll end up deleting all songs with
>that title.
just for the discussion, you can use a delete query like
"delete from song_list where song_title='title' and song_book='book'"
to delete only one re
On Sat, 17 Feb 2001 04:27, Jeff Oien wrote:
> Yes! That was it. Thank you very much.
> Jeff Oien
>
> > Are you using 3.23.33? If so try removing the space between the
> > COUNT and the open paren. It looks like there may be a bug in the
> > latest release (seeing this problem on the mysql list f
You could try something like this:
SELECT year, count(studentID) FROM students GROUP BY year
...where studentID is the primary key column/field in your students table.
Josh Hoover
KnowledgeStorm, Inc.
Searching for a new IT solution for your company? Need to improve your
product marketing?
Vi
select count(*), year from students group by year;
on 3/1/01 12:07 PM, Kath at [EMAIL PROTECTED] wrote:
> I have a user database where a year has to be put in.
>
> Now, I want to compile a list of each different year and how many users are in
> that year.
>
> Is there a way to do this beyond
Shouldn't the primary key spec come at the end of the
table create command, not in the middle ex...
CREATE TABLE president (
last_name varchar(15) NOT NULL,
first_name varchar(15) NOT NULL,
suffix varchar(5) NOT NULL,
city varchar(20) NOT NULL,
state varchar(2) NOT NULL,
birth date NULL,
death da
),
KEY idxgroups (username, usergroupid)
);
-Original Message-
From: Jeff Oien [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 2:09 PM
To: PHP
Subject: [PHP] MySQL Create Table Problem
This is driving me nuts. I really tried to figure it out
myself. I have a form for creating a
t(10) unsigned DEFAULT '0' NOT NULL,
>lastpost int(10) unsigned DEFAULT '0' NOT NULL,
>posts smallint(5) unsigned DEFAULT '0' NOT NULL,
>timezoneoffset smallint(6) DEFAULT '0' NOT NULL,
>emailnotification smallint(6) DEFAULT '0&#x
cluded
everything below (including table schemata), to enable reproduction. It
seems like a bug to me - the question is, is the bug in PHP, MySQL, or my
brain?
This is driving me CRAZY
- Chris
mysql_connect("localhost", "myusername", "mypassword");
my
You can use KEY() which will add extra keys to the table.
--Joe
On Wed, Jan 10, 2001 at 12:58:37PM -0700, [EMAIL PROTECTED] wrote:
> Could someone suggest some options here for performance improvement?
>
> I have a table with about 300,000 entries/records by 7 columns/fields. All of
> the inf
You don't need to select all the data to get the number of rows. Try
this:
select count(*) as total from products where $product_query;
Then use total instead of num_rows.
Be sure the elements in your where clause are properly indexed.
[EMAIL PROTECTED] wrote:
>
> Could someone suggest some op
On Wednesday 10 January 2001 20:58, [EMAIL PROTECTED] wrote:
> I have PHP perform SELECT queries on the table, and I need to display
> the results in a format of: "viewing $top to ($top+$depth) of $numrows
> found"
>
> I haven't found a way to determine $numrows without performing a second
> SELE
Larry Hotchkiss wrote:
>
> I am developing a site with php, apache and mysql. The database will have
> likely 250k to 500k records at most, but the data will be changing often.
> New records will be constantly added and old ones removed. I am pretty new
> to DB's and was wondering what is
Hey Ray,
I would suggest looking for books on SQL. I have one (and want
more!), it is called "the practical sql handbook" and it's nice.
Seems every PHP book deals with MySQL directly too.
Anyway, my thought on the matter is go generic, go SQL.
Philip
On Thu, 11 Jan 2001, Ray Iftikhar wrote
On Thu, 11 Jan 2001, Ray Iftikhar wrote:
> I was looking for a good book that teaches you how to use PHP (mainly 3)
> with MySql. I went to Amazon.com and found "MySql" by Paul Dubois, which was
> supposed to be THE book for mySql programming. However, after reading some
> of the customer review
create a dir called tmp in de dir where de script runs chmod 777 that dir
and the run the script again ..
--
If it can be dreamt, it can be build
"andreas (@work)" <[EMAIL PROTECTED]> wrote in message
003501c07ce5$41a15120$fe78a8c0@devel01">news:003501c07ce5$41a15120$fe78a8c0@devel01...
hi list,
Here's what you wrote, 01-01-11:
> I was looking for a good book that teaches you how to use PHP (mainly 3)
>with MySql. I went to Amazon.com and found "MySql" by Paul Dubois, which was
>supposed to be THE book for mySql programming. However, after reading some
>of the customer reviews, it
, January 17, 2001 10:43 AM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL and Array Problem
I'm trying to store an array into a MySQL
table, what datatype should the column be, Varchar?
second this is the code I use to store it.
mysql_connect("$DBHost","$DBUser","$DBPass
:
http://www.mysql.com/doc/D/i/Disk_issues.html
Have fun,
Rom
- Original Message -
From: [ rswfire ] <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 2:09 PM
Subject: [PHP] MySQL Disk Space Usage
Is it possible to find out how much disk space
!!!
- Original Message -
From: Romulo Roberto Pereira <[EMAIL PROTECTED]>
To: [ rswfire ] <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 2:29 PM
Subject: Re: [PHP] MySQL Disk Space Usage
> I think that these are your answer:
>
y not. Thanks again..
- Original Message -
From: Larry Hotchkiss <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 2:42 PM
Subject: RE: [PHP] MySQL Disk Space Usage
> I believe you are going to need to take a look at the mysql manual a bit
> clos
..
What do you think?
Rom
- Original Message -
From: [ rswfire ] <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 2:42 PM
Subject: Re: [PHP] MySQL Disk Space Usage
Thank you for the reply, however, I do not believe this will solve my
problem. So p
On Sat, Jan 20, 2001 at 05:57:25PM -0800, PHP List wrote :
> dump a table to a file on my server:
> $sql = "SELECT * INTO OUTFILE '/tmp/test.txt' FIELDS TERMINATED BY '\t'
> LINES TERMINATED BY '\n' FROM table_name";
>
> Problem is that once I have created the dump file, it will not allow me to
Timo Mika Gläßer wrote:
> we're basically developing for DB2 or Oracle and don't usually need
> MySQl-Support with PHP. So in order to make the httpd binary a little
> smaller is it possible to compile PHP4 without any MySQL-Support added?
Configure & compile PHP with the --without-mysql fla
David Banning wrote:
>
> I am working with php-mysql
> and am inserting into mysql using a NULL value,
> which allows mysql to auto-insert (increment)
> a number - how could I find out what the value was
> mysql inserted, say on the next line of code after the insert?
http://
Are you adding slashes beforehand (or running magic quotes) ? Also I always do
a stripslashes() on the text fields I print out.
--Joe
On Sat, Jan 27, 2001 at 11:06:03PM -0500, [EMAIL PROTECTED] wrote:
> if you goto
> http://downloads.moddingcentral.com/add.php
> you will see a simple form
>
> t
izaerd.com
=
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, January 27, 2001 9:06 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] strange PHP/MySQL problem
>
>
> if you goto
> http://downloads.moddingcentral.com
Well, you're going to have to come up with a datamodel for storing the
parsed data. You can parse RDF files with the XML extension, see the docs
at http://www.zend.com/manual/ref.xml.php
There are some classes on phpclasses.upperdesign.com which will handle RSS
files - you can probably look at t
Hi Guys,
I have a question; if i lock a mysql table, will a PHP script wait untill
there is no lock anymore and then execute the script?
Thanks,
Jeroen
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTE
Hi,
is there any comapany (like freeservers.com and geocities.com)give a
free web space and supporting PHP/MySQL.
Thanks
--
Best Regards
Alaiddin Tayeh;
Webmaster
Palestinian Internet Services
WWW.P-I-S.COM
Tel: +97272843197
Fax: +97272843377
--
PHP General Mailing List (http://www.php.net
Need to see your code for inserting data.
But I think first, you should be naming your fields with empty[]s
Ie.
Etc
That way, php will build an array out of the variables, and it will ONLY
contain values, if values were submitted..
Then you build your insert query by looping through the array
Sent: Thursday, May 10, 2001 9:41 PM
Subject: [PHP] Mysql sequence help (OOT)
Hello,
Sorry for a litle bit out of topic.
But can anyone tell me how to create sequence in mysql?
For example, if I have table with column ID, NAME. I want ID to be
incremented by one (say starting from 100) everyt
\/_/ /_/ /_/\_\/_/_/_//_/_/_/
=
Telephone : (03) 9329 1455 Facsimile : (03) 9329 6755
* We rent the dot in .COM! **
-Original Message-
From: Laurie Landry [mailto:[EMAIL PROTECTED]]
Sent: Tuesda
gt; /_/\_\/_/_/_/ /_/ \/_/ /_/ /_/\_\/_/_/_//_/_/_/
> =
> Telephone : (03) 9329 1455 Facsimile : (03) 9329 6755
> ***** We rent the dot in .COM! **
>
>
> -Original Message-
>
See the following :
Where can I find some free hosting space by an ISP offering PHP.
http://www.faqts.com/knowledge-base/view.phtml/aid/4058/
regards,
philip
On Tue, 15 May 2001, Christian Dechery wrote:
> Does anyone knows any good free php/mysql hosting other than www.f2s.
Hi All,
Is there a way to return the results of a mysql_query or the array
that is generated after mysql_fetch_array, via a function? Note I have
tried to do a straight return. Another issue is that all of the tables
are a different size, therefore a static array size would be a big was
Hi,
Just wondering if anybody has experience in or can jot down any
gotchas / issues in providing a php/mysql vistral hosting service.
Problems with security? Are their things i have to watch out for?
Thanks
Simon Buchanan
--
Technical Director
Contact: 07 571
2001 8:22
AM
Subject: [PHP] Search engine php/mysql
Hello list,
I am coding a search engine that allow indexing
and searching internet sites based on php/mysql.
My problm is:
How can i index a given site, I
mean:
input: URL, like http://www.blabla.com/
Out
Hello list,
I am coding a search engine that allow indexing and searching internet sites
based on php/mysql.
My problm is:
How can i index a given site, I mean:
input: URL, like http://www.blabla.com/
Output: meta, body content, description that will be stored in a tables.
Regular
sage-From: Chris Anderson
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 1:16
AMTo: [EMAIL PROTECTED]Subject: [PHP] MySQL Dump
In PHP
I've been reading through the MySQL manual about
backing up my database using mysql dump. I tried passing it as a Query in PHP
but that do
I use the mysqldump command line utility to do this and I don't know how to
interface that from PHP. However:
I just checked how phpMyAdmin does it and apparently it has functions that
re-create the dump using queries. You might want to download it
(http://www.phpwizard.net/projects/phpMyAdmin/)
feeling that MySQL doesnt suppport nested queries.
BTW, "@MapID" in the above code is a variable with ID of the map you want
deleted.
Jason
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 05 July 1979 22:38
To: [EMAIL PROTECTED]
Subject: [PHP] mysql fu
Hi!
How is it possible to do a MySql query for something like:
SELECT value from table WHERE value < '500x100'
should return all values that part1 must be less than 500 and part2 less
than 100? like 499x99 and reject something like: 500x101
please give me suggestions!
--
PHP General Mail
The Exchange Project is by far my favorite.
www.theexchangeproject.org
- Original Message -
From: "Duane Douglas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 2:59 PM
Subject: [PHP] php/mysql ecommerce solution
> hi gang!
>
&
I agree with Chris. The Exchange Project has been one of my personal
favorites as well. www.theexchangeproject.org :)
Duane Douglas wrote:
>
> hi gang!
>
> i'm looking for a php/mysql ecommerce solution. i want something that is
> ready made and fully customizable. i&
the server is telling me line 43(which starts with $mp3d) is not a valid
mysql result resource. what am i doing wrong??
chris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list adm
Hello Plamen,
Friday, July 27, 2001, 2:04:15 PM, you wrote:
PS> Hi guys,
PS> I have a big MySQL table - about 300MB
PS> I want to get all the records from the table, make certain transformations and
write them to a text file (i can not use "select into outfile...)
PS> the problem is when i type
Try LIMIT in the select
Plamen Slavov wrote:
> Hi guys,
> I have a big MySQL table - about 300MB
> I want to get all the records from the table, make certain transformations and write
>them to a text file (i can not use "select into outfile...)
> the problem is when i type "select * from " the
I've been using PHP 4.0.4p1 WIN32, Apache 1.3.19 WIN32 and the latest MySQL WIN32
build for almost 6 months without a problem. But now if I try and run a php file using
MySQL functions it just processes forever. There is no output and I can stop with the
browser's stop button. I have tried remo
Hello !
Is there any free PHP/MySQL Web Hosting without add ? ... or ... at least ,
I could have the choice to choose where to place their banner on my pages
?
Thanks...
Arcad.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
>Warning: MySQL Connection Failed: Can't connect to local MySQL server
>through socket '/tmp/mysql.sock' (111) in
>/home/sites/site1/web/intranet/main.php on line 309
This sounds A LOT like the problem when you need to change the location of
the mysql.sock in your php.ini.. you did check that..
TED]>
Sent: Monday, April 09, 2001 3:59 PM
Subject: Re: [PHP] MySQL broken in 4.0.5RC6
>
> >Warning: MySQL Connection Failed: Can't connect to local MySQL server
> >through socket '/tmp/mysql.sock' (111) in
> >/home/sites/site1/web/intranet/main.php on line 3
>True...but I used the same php.ini as with php4.0.4pl1, so the location of
>all files is identical. If I don't specify a location in 4.0.4pl1, why
>should i need one in 4.0.5rc6?
Dunno, I don't have 4.0.5rc6 here, only 4.0.4pl1 so no change to test it..
or to take a look at the code.. It's pa
""FredrikAT"" <[EMAIL PROTECTED]> wrote:
> Hi!
>
> I'm starting a news site, and I have one problem.
> (not with php or mysql, workin' fine!):
>
> 1. I want my authors to be able to make the text bold, italic ++,
> but I can't find anything that works.
> 2. The best sollution must be something sim
In a MySQL query you can use the LIMIT keyword, like in phpmyadmin.
Use limit 0,10 to get the first ten results in a query.
Then do the query again but use 10,10 for the limit.
The first number is the "offset", and the second one is the maximum results
to return.
That's the way most people do
Hi Jason,
Say you have a search form that says search for "searchbox" and the search
box has a variable name of "search":
NO Valid search results.
">
1) {
echo "Previous";
}
if (($num > 25) && (($limit + 25) < $num)) {
echo "Next.";
}
/* End the initial "Else" */
}
?>
___
On Thu, Apr 12, 2001 at 10:20:28PM -0400, Chris Anderson wrote:
> If I grab values from fields and they contain nothing, and I retrieve
> them using mysql_field_array, it will give an index out of range. Is
> there a way to prevent the error or do I have to keep putting a @ in
> front of the varia
>Hello all, hope that everyone had a nice weekend.
>I'm new to this form. I am about to install mysql, apache, and php on my
>linux box
>(redhat 7)
WHy do you think people have invented archives for lists like these
This question has been asked some many times I can't even remember. Same
. van Ouwerkerk [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 20, 2001 4:01 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] SETUP PHP , MYSQL, APACHE
>Hello all, hope that everyone had a nice weekend.
>I'm new to this form. I am about to install mysql, apache, and php on my
>linux
Hi all,
Live is strange sometimes, and so is this error we have here.
I have a large forum (more then 300.000 pageviews a day) running.
We are using php-4.04pl1 (with the Zend/zend_list.c file patched)
and we are using MySQL 3.23.36-log.
We are using the following piece of code to connect to th
that would be:
select Id, count(*) from sometable group by Id
Sigitas
--
PHP General 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]
At 02:33 PM 4/23/01 -0700, elias wrote:
>how can i get an SQL statment that when run, i get a query result like that:
>
>Id: Value count:
>--- --
>a4 values
>b4 values
>c2 values
SELECT ID,COUNT(*) FROM table_name GROUP BY ID;
>i feel that it's easy...but i'm not re
Hi Guys,
Does anyone know how to select one field randomnly from a MySQL table
against a weighting column in the same row the field is selected from?
For example, "SELECT id, url, image FROM table ORDER BY rand() LIMIT 1".
And have a column like "weighting" where values between 1 and 100 ar
I have been using Abriasoft's products. You just plop in the CD and it
installs PHP, MySQL, Apache, Perl6, Perl DBI, and some other stuff on your
linux (or other os) box. All software also available for free by download.
http://www.abriasoft.com
At 05:12 AM 5/19/02 -0700, you wrote:
&
Do you have Macromedia Generator installed on your server? It's
responsible for taking the .swt and generating the .swf output.
- Tim
On 15 Aug 2001 14:28:24 +0100, AJDIN BRANDIC wrote:
> Hi,
>
> I have RH6.2, php4, MySQL and want to generate graphs with flash. I have
> done a graph with Fla
Hi, NO this is what i am trying to find out. where can i download it
from (for RD6.2 and Aache 1.3.12). I have tried RH site but no joy.
regards
Ajdin
On 15 Aug 2001, Tim wrote:
> Do you have Macromedia Generator installed on your server? It's
> responsible for taking the .swt and generatin
ECTED]
Subject: Re: [PHP] apache,php,mysql,flash
Hi, NO this is what i am trying to find out. where can i download it
from (for RD6.2 and Aache 1.3.12). I have tried RH site but no joy.
regards
Ajdin
On 15 Aug 2001, Tim wrote:
> Do you have Macromedia Generator installed on your serve
You have to buy Generator from Macromedia. It's not free. (in fact,
it's pretty expensive :)
There are some open/free alternatives out there, but there weren't
direct replacements last time I evaluated them.
There's also the ming extension for PHP which lets you generate a whole
SWF movie at r
> I have a security-question that I hope someone can answer, my question is:
> Will the DROP+TABLE+TBL_TEST-part in
> http://www.foo.bar/page.php?id=1;DROP+TABLE+TBL_TEST; be executed?
I don't think it will in CURRENT versions of MySQL.
Really *OLD* versions, maybe, if I recall correctly...
But
I have been coding php for a while now but can't seem to get a grasp on
which type of query I should use for a given situation.
mysql_fetch_array
mysql_fetch_object
mysql_fetch_row
Perhaps there is no right answer or perhaps the answer comes with
experience. In any case, I would love to get som
on? For example: The website is at www.domain01.de
(my domain), and the MySQL runs on mail.domain02.com (my ISP's mail
server, where he has the mysql server installed) and I want then to
use the PHP/MySQL combination from the website to run a forum.
If someone could point me in the right direction an
You can see hosts offer the package for around $10/month, so if it's inside
a package they shouldn't charge more than US$2-US$4/month. If it's an extra
feature, however, they may well charge around $5/month for the add-on and
possibly also a setup fee, because it's not in their actual product list
At 4:09 PM +1000 8/24/01, Chris Aitken wrote:
>Hi All,
>
>
>Just a quick non-technical question.
>
>I live in Australia and a friend of mine has a website hosted here
>in Oz, and he pays his set amount per month which simply is for
>Hosting, cgi-bin and log file access for his website.
>
>Hes wa
Hello All,
I think for a thin page with PHP+mySQL you can go as low as
$3 a month (35MB)
I have seen decent packages, with Vserver privileges at
around $18/mnt.
--- Alnisa Allgood <[EMAIL PROTECTED]> wrote:
> At 4:09 PM +1000 8/24/01, Chris Aitken wrote:
> >Hi All,
> >
&g
howdy,
this should be simple but i don't know it. i use the following mysql
table field as the Key for my tables:
"id int(10) unsigned NOT NULL auto_increment,"
now, when i have to clean up items in my tables, like when users have
sent off a .html form multiple times and i want to delete dupli
Yes, there is a problem.
--
SELECT *
FROM links
WHERE 1=1
and ( name LIKE "%te%"
OR description LIKE "%te%"
OR url LIKE "%te%" )
AND approved="1" LIMIT 5;
--
--- Jeff Lewis <[EMAIL PROTECTED]> wrote:
> Guys, why isn't this working? :)
>
> SELECT * FROM links WHERE name LIKE "%te%" OR descr
There is a Mysql error that is driving me mad. My ISP won't claim
resposibility for it and it tells me it is a scrpting error. I don't
agree with them. The error number is 2006, and it seems to restart the
database every now and then.
Please advice me as to what may be causing this problem. The e
i have a form where a user inputs a home service type and this results in a list of
that value, eg a user inputs 'plumber' and a list of plumbers is displayed.
if a user accidentally types plumbar no results are displayed.
is there anyway of making php/mysql recognise the first thr
On 09-Sep-2001 Dana Holt wrote:
>
> I have a query that uses a LEFT JOIN, but the two tables have some columns
> with the same name. How can I tell the columns from each table apart? It
> seems that the "joined" table overwrites the values from the other table.
>
If the column is part of the j
On Sun, 9 Sep 2001 13:34, Dana Holt wrote:
> I have a query that uses a LEFT JOIN, but the two tables have some
> columns with the same name. How can I tell the columns from each table
> apart? It seems that the "joined" table overwrites the values from the
> other table.
>
> Anyone know?
>
> Tha
INET_ATON
and
INET_NTOA
-Original Message-
From: Felix [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 11:49 AM
To: PHP list
Subject: [PHP] MySQl IP Address Storage
Hello all
Can anyone suggest their best idea for a way to store IP addresses in a
MySQL Database?
Felix
Thank you Robert.
Felix
- Original Message -
From: "Robert Covell" <[EMAIL PROTECTED]>
To: "Felix" <[EMAIL PROTECTED]>; "PHP list" <[EMAIL PROTECTED]>
Sent: Thursday, September 20, 2001 10:55 AM
Subject: RE: [PHP] MySQl IP Addre
x27;));
SELECT INET_NTOA(ipaddress) FROM mytable;
Make sense?
- Original Message -
From: "Felix" <[EMAIL PROTECTED]>
To: "Robert Covell" <[EMAIL PROTECTED]>; "PHP list"
<[EMAIL PROTECTED]>
Sent: Thursday, September 20, 2001 11:29 AM
Thank you very much.
Felix
- Original Message -
From: "Jason Bell" <[EMAIL PROTECTED]>
To: "PHP list" <[EMAIL PROTECTED]>
Sent: Thursday, September 20, 2001 12:49 PM
Subject: Re: [PHP] MySQl IP Address Storage
> Felix,
>
> Just to save you the
On 20-Sep-2001 Felix wrote:
> Hello all
>
> Can anyone suggest their best idea for a way to store IP addresses in a
> MySQL Database?
>
INT UNSIGNED
and use the MySQL functions INET_ATON() & INET_NTOA() for converting.
If you're on a pre-3.23 MySQL server then:
// Convert IP string (XXX.YY
My webhost recently migrated my site over to a new server and IP. Everything
looks ok, except that all my MySQL tables now are read-only (at least that's
the error I get when trying to delete or insert records). How do I change
the tables back to write? Can I switch individual tables to write or i
Im trying to display the tables in my database using $tables =
mysql(mydb, SHOW TABLES FROM mydbname) but this statement doesnt
seem to behave like selecting records from a table. Does this query
return an array of table names? If I use something like $records =
mysql(mydb, SELECT * FROM
The reason you aren't seeing any errors is because you used "or
die()" -- to the best of my knowledge, this replaces any standard errors
that PHP would normally generate.
It appears that you have omitted the second argument to mysql_query().
A common mistake that I've made many times myself.
-
From: "Hawk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 1:18 PM
Subject: [PHP] PHP & MySQL problems, updating database..
> Having a problem with this, I have a working login that supports multiple
> users, and I'm trying to mak
Hawk,
If you have a working login, can we safely assume that there is information
in the database for each user? If so, then we won't bother discussing
insert statements, but concentrate on updates. We'll also assume that $user
has update privileges on the database.
The normal form of an upda
Hi,
Can anyone point me to some good examples of how to add images using PHP 4 (from
within a browser) to a MySQL database running on MacOSX, which is already configured &
working, then display the images by selecting their name or category etc, again within
the browser. I also need to restric
Use PHPMyAdmin. You can dump to a CSV file or it can output all of the
INSERT statements to rebuild a table.
- Original Message -
From: "Wilbert Enserink" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 8:22 AM
Subject: [PHP] mysql
riginal Message -
>From: "Wilbert Enserink" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, February 04, 2002 8:22 AM
>Subject: [PHP] mysql backup function in php?
>
>
> > Hi all,
> >
> > i searched the manual for a php backup function
about PHP / MySQL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello All:
How do I read all of the data from just one column, then develop a
count based on those items? I think I start with mysql_fetch_field(),
but right there I get stuck. Any ideas to point me in the right
direction?
Thanks
I'm working with a simple form which submits field
data to a MySQL database. This is for the purpose of
generating a dynamic news page for my site.
Interestingly enough I've found that any time I try to
submit data that contains an apostrophe "'" it gives
me an error and will not send the data (
oor. Once that initial "yes" has been given,
the subsequent steps might come more easily.
Best of luck,
--
Barry C. Hawkins
Systems Consultant
All Things Computed
[EMAIL PROTECTED]
Mallen Baker wrote:
> Hi - the company we're talking to about doing some work on a simple
> site / d
Barry C. Hawkins wrote:
> Mallen, It sounds like you might have some non-technical or
> open-source execs to talk to, and that a non-MS platform is not an
> option (yet :^) ). If so, here are some more "managerial"-type
> arrows for your quiver:
>
> 1.) MySQL was one of the top 2 databases
. no-one ought to start from here, but if you're forced to use IIS (because
asp won't work with anything else) then php / mysql is not going to be the way to go
(xxx are proposing coldfusion / sqlserver).
Thanks - Mallen
>>> Michael Kimsal <[EMAIL PROTECTED]> 04/10/02 08:
: Thursday, April 11, 2002 12:34 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]; >
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Re: arguments against php / mysql?
Thanks to Michael, Barry, Steve, Cal and Rasmus for replies.
We have just taken a contract for a dedicate
art from here, but if
> you're forced to use IIS (because asp won't work with anything else)
> then php / mysql is not going to be the way to go (xxx are proposing
> coldfusion / sqlserver).
But there is really no point in switching from ASP to CF. What are you
hoping to gai
Sorry - I'm being clear as mud! We have an existing site which will need to live on
the server - I'm looking at new development. The two don't need to work on the same
thing - there's no question of recoding that site as coldfusion.
- M
>>> Rasmus Lerdorf <[EMAIL PROTECTED]> 04/11/02 08:37am >
901 - 1000 of 1323 matches
Mail list logo
