Man, where do I start. There could be so many things wrong. First of
all, this is a PHP list, not MySQL. Second, use MySQL_error() after you
issue a query to see if an error was returned
http://www.php.net/mysql_error. Third, in this line:
, 14 June 2002 1:26 PM
To: Chris Kay; 'PHP General List'
Subject: RE: [PHP] MySQL Query Help
Man, where do I start. There could be so many things wrong.
First of all, this is a PHP list, not MySQL. Second, use
MySQL_error() after you issue a query to see if an error was
returned
On Fri, 14 Jun 2002, Chris Kay wrote:
The query does not error out it just does not give any records, and
I
Know
What part of The query does not error out do you not understand.
Why are there so many people willing to say what is wrong with a
code
but when it comes to A solution
Hi Hawk,
(snip auto-incrementing PKs)
is there somewhere the next number is located ?
No. Why would you care, anyway? The thing about PKs is that they have to be
unique, not sequential.
If you're *really* bothered by it, you'll have to dump the contents of the
table to a file, drop the
Primary Key's, by nature, are designed to always be uniqiue, which
means that even if you delete row 6, the next row you insert will be
10 because there is no id 10. If you simply need to get the list of
items in a query, in the order they were inserted, I would suggest using
something like:
On Monday 10 June 2002 16:34, Wilbert Enserink wrote:
Hi all,
I have a .txt file containing a mysql dump. Normally when I would restore
this dump I would go to the mysql 'prompt' and type something like: mysql
dimpfile.txt. I would use SSH or telnet for this.
Now I have this new
That's Ok
See :
http://www.zend.com/tips/tips.php?id=199single=1
Fincom [EMAIL PROTECTED] a écrit dans le message de news:
[EMAIL PROTECTED]
Hi,
how to make sql Result case sensitive with php.
thanks
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
: fincom [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 5:43 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: PHP-MySQL AND Case Sentivity
That's Ok
See :
http://www.zend.com/tips/tips.php?id=199single=1
Fincom [EMAIL PROTECTED] a écrit dans le message de news:
[EMAIL PROTECTED]
Hi
Sorry if this is an ignorant question, but I want to do one
simple thing - create an empty MySQL-type database to upload
to the server so I can start using PHP to access it... how
can I do this? I don't really want to have to download the
whole MySQL product just to create an empty
- Original Message -
From: David Freeman [EMAIL PROTECTED]
To: 'PHP Mailing List' [EMAIL PROTECTED]
Sent: Tuesday, June 04, 2002 11:50 AM
Subject: RE: [PHP] MySQL - Creating The Database
Ummm, not sure exactly what you're asking but you can use mysql_query to
issue the relevant sql
On Tuesday 04 June 2002 19:03, Jason Teagle wrote:
Ummm, not sure exactly what you're asking but you can use mysql_query to
issue the relevant sql commands to create your database and tables and
Am I correct in saying that none of the SQL functions in PHP can actually
create a database
Am I correct in saying that none of the SQL functions in PHP
can actually create a database file when no file existed
before? In other words, an empty database file must exist
before SQL functions can be called on it?
If you have appropriate access you can. You do need 'root' access
, 2002 11:50 AM
Subject: RE: [PHP] MySQL - Creating The Database
Ummm, not sure exactly what you're asking but you can use mysql_query to
issue the relevant sql commands to create your database and tables and
Am I correct in saying that none of the SQL functions in PHP can actually
create
If your site is hosted in a *nix machine with shell access, another option
might be to create a database and write up the SQL you need to structure
it in a text file, then just feed it straight into MySQL like this:
mysqladmin -uusername -ppassword create yourdatabase
mysql -uusername
David Freeman said:
From memory, you also have a few php commands that will help - why not
consult your local friendly php manual in the section under mysql
commands for choices and information.
Jason Wong:
The problem is that you haven't read the (mysql) manual. Either read the
manual or
On Tuesday 04 June 2002 19:59, Jason Teagle wrote:
to be fair, it is customary to get all the tools and other preparations
(including necessary files) ready before embarking on a project. Thus, it
is logical to get a blank database ready before beginning. Why read yards
of documentation
Also, if a person doesn't _know_ that PHP can create a
database for you, how would they know that somewhere in the
list of PHP functions is the answer to the problem? It would
be foolish to expect someone to read the _whole_ of the
documentation on MySQL or PHP just to see if there
- Original Message -
From: David Freeman [EMAIL PROTECTED]
To: 'Jason Teagle' [EMAIL PROTECTED]; 'PHP Mailing List'
[EMAIL PROTECTED]
Sent: Tuesday, June 04, 2002 1:58 PM
Subject: RE: [PHP] MySQL - Creating The Database
How very sad. It's not new - I've seen things like this on many
He'll Be Back, they all come back
Chris
- Original Message -
From: Jason Teagle [EMAIL PROTECTED]
To: PHP Mailing List [EMAIL PROTECTED]
Sent: Tuesday, June 04, 2002 9:45 AM
Subject: Re: [PHP] MySQL - Creating The Database
- Original Message -
From: David Freeman [EMAIL
]; 'PHP Mailing List'
[EMAIL PROTECTED]
Sent: Tuesday, June 04, 2002 1:58 PM
Subject: RE: [PHP] MySQL - Creating The Database
How very sad. It's not new - I've seen things like this on many lists and
newsgroups. Apparently it is easier for people to be sarcastic and give a
flippant RTFM response than
]On Behalf Of Christopher Riordan
Sent: Tuesday, June 04, 2002 6:51 AM
To: PHP Mailing List
Subject: Re: [PHP] MySQL - Creating The Database
He'll Be Back, they all come back
Chris
- Original Message -
From: Jason Teagle [EMAIL PROTECTED]
To: PHP Mailing List [EMAIL PROTECTED]
Sent
On Thursday 23 May 2002 22:20, Wilbert Enserink wrote:
Hi all,
I know this is rather OT, but I searched the mySQL manual all
over...couldn't find it.
Why not ask on the mysql list !?!
I want to perform a search in a table. More then 1
columns should be searched. namely column1 and
The only way I know how to do it is by doing boolean OR's... It's not
as compact and efficient as you'd like, but it works.
SELECT *
FROMgallery
LEFT JOIN designers ON (designers.designersID=gallery.designersID)
WHERE (gallery.column1 LIKE
Hey Eric:
mySQL_insert()
in :
Unified ODBC functions ???
I assume you mean mysql_insert_id(). No, there's no such function in odbc land. Do
another query to find the record you inserted then extract the ID number from that.
Lame,
--Dan
--
PHP classes that make web
Nevermind. Three hours after embarking on my voyage to insanity I finally
figured it out. If I type cast the variables as strings the error
dissapears. I've never had this problem before though.. so its still a bit
of a mystery since the data stored in the variables are most certainly
strings
On Mon, 20 May 2002, Cleeker wrote:
Is there a way to extract lets say a bunch of dates from a mysql db, and
the sort them in order from newest to oldest? Also how would you sort
names in alphabetical order?
Read the section of the MySQL manual that covers ORDER BY clauses.
miguel
--
PHP
The MySQL manual will explain this in great detail.
To sort by date:
SELECT * FROM table ORDER BY date ASC;
for that to work, all the values in date should be a timestamp (ex:
2002052000)
To sort by names:
SELECT * FROM table ORDER BY name ASC;
If you want reverse the order, replace the
On Tuesday 21 May 2002 10:11, Cleeker wrote:
Is there a way to extract lets say a bunch of dates from a mysql db, and
the sort them in order from newest to oldest? Also how would you sort
names in alphabetical order?
Yes, look at the date/time functions in the (mysql) manual.
--
Jason Wong
Is there a way to extract lets say a bunch of dates from a
mysql db, and the sort them in order from newest to oldest?
Also how would you sort names in alphabetical order?
Yes, and a php list is obviously a good place to ask an sql question.
In any case, you want to examine your
Thanks to all :-)
Bye,
Evan
Evan [EMAIL PROTECTED] ha scritto nel messaggio
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Is it possible to create an excel file with some data from mySQL, using
PHP
?
Thanks,
Evan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
Hello,
On 05/17/2002 01:18 PM, Evan wrote:
Is it possible to create an excel file with some data from mySQL, using PHP
?
Sure, you can use this class to generate Excel files on fly on even in
non-Windows platforms.
http://www.phpclasses.org/biffwriter
--
Regards,
Manuel Lemos
--
PHP
At 02:13 PM 5/17/2002 -0300, Manuel Lemos posted the following...
Hello,
On 05/17/2002 01:18 PM, Evan wrote:
Is it possible to create an excel file with some data from mySQL, using PHP
?
Sure, you can use this class to generate Excel files on fly on even in
non-Windows platforms.
Heck,
The mysql_select_db() function is going to return a handle. You need to
capture that handle and use it as the second parameter in your mysql_query()
function. Although this is not required in certain cases where the server
automatically knows which database to work with, chances are thats whats
[snip]
select cust_fnn, cust_name, agroup_access.group_access_cust from cust,
agroup_access where
agroup_access.group_access_group='$id'
cust.cust_fnn!=agroup_access.group_access_cust order by cust.cust_name
[/snip]
try this (note syntactical differences);
select cust_fnn, cust_name,
Todd,
/usr/bin/mysqladmin
HTH
Chris
Todd Cary wrote:
I tried locate and find and both come up empty for mysqladmin.
Am I missing something stupid here?
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PROTECTED]
--
PHP General Mailing
Also, try locate again now that it's been a day. The locate database
usually gets updated overnight, so it doesn't immediately reflect new
additions.
miguel
On Sun, 12 May 2002, Chris Hewitt wrote:
Todd,
/usr/bin/mysqladmin
HTH
Chris
Todd Cary wrote:
I tried locate and find and
Check to see that you have the mysql client package installed:
`rpm -q MySQL-client`
If not, grab it!
-J
On Sun, 12 May 2002, Chris Hewitt wrote:
Todd,
/usr/bin/mysqladmin
HTH
Chris
Todd Cary wrote:
I tried locate and find and both come up empty for mysqladmin.
Am I missing
On Sunday 12 May 2002 02:44, Todd Cary wrote:
I am completely new to MySQL and I just installed it on my RH 7.2 server
and I cannot determine where the MySQL admin program is located so that I
can set my password.
Sorry for the basic question...
mysqladmin
For further help please goto
I tried locate and find and both come up empty for mysqladmin.
Am I missing something stupid here?
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
I tried locate and find and both come up empty for mysqladmin.
Am I missing something stupid here?
How did you install it? Did you build from source or use rpm's? If you
installed from rpm's which ones did you install? From memory there's
about four rpm's that you'll need to have
MySQL
- Original Message -
From: David Duong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, May 11, 2002 10:29 AM
Subject: [PHP] MySQL or FlatFile
To store large values (100k+) and load them as much as 6+ times within the
same hour what would be better MySql or Flatfile?
Ha.. Aussie person too eh?
Ok.. Have you recently updated your php system?
Reason I ask is the way you are using the functions mysql_connect and
mysql_select_db are quite ... bad to say the least
You should have permissions setup for a root account or something in your
mysql.user table and
Thanks radix!
I'm new to PHP that's why..
so, what should I do to fix this?
please advise..
thanks again.
Dani
The_RadiX wrote:
Ha.. Aussie person too eh?
Ok.. Have you recently updated your php system?
Reason I ask is the way you are using the functions mysql_connect and
Warning: Access denied for user: 'nobody@localhost' (Using password:
NO)
in /www/host/doms/com/smpk2/create_tables.php on line 15
Hmm...let me see if I can decrypt that message. Apparently you were
denied access with user nobody and you were not using a password.
Read the manual page on
On Friday 03 May 2002 22:38, Brad Harriger wrote:
How does PHP 4 handle MySQL fields that are of type SET? Are the
strings, arrays, or something else?
RTFM, mysql treats them as strings. Before you ask, so does php.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source
On Wed, 1 May 2002, Jay Blanchard wrote:
If I name the file with a .xls extension it displays the code in the
excel worksheet in the browser. If I name the file with the .php
extension it opens Excel seperately, gives me a file download option (I
click 'Open') and then asks me to tell it what
N Hello, I have a question: does anyone know how to divide MySQL results to
N pages and display on a website in 1 2 3 4 form?
Use LIMIT within your SELECT statement:
http://www.mysql.com/doc/S/E/SELECT.html
- Julie
-- Julie Meloni
-- [EMAIL PROTECTED]
-- www.thickbook.com
Find Sams Teach
TEXT has a limit of 65535 characters.
BLOB
TEXT
A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1)
characters. See section 6.5.3.1 Silent Column Specification Changes.
See section 6.2.3.2 The BLOB and TEXT Types.
MEDIUMBLOB
MEDIUMTEXT
A BLOB or TEXT column with
I'm not sure how PHP would handle this, but have you tried this:
mysql_query(UPDATE sampcomp SET fg='N', pctd='69', maxpctd='69.1' WHERE
sampcompid='3';UPDATE sampcomp SET fg='N', pctd='69.2', maxpctd='69.3'
WHERE sampcompid='2');
??
I doubt you can put multiple queries in one execution of
In brief, and in no way finished (no error trapping, commenting, etc)...
?
$db = mysql_connect(localhost, root);
mysql_select_db(test,$db);
$result = mysql_query(SELECT CountryID, CountryName FROM
tblcountries,$db);
echo table border=1\n;
echo tr\n;
Ok the formatting got lost on that I will try this again.
-Original Message-
From: Fifield, Mike [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 8:57 AM
To: [EMAIL PROTECTED]
Subject: [PHP] MySql query
Ok this could be the wrong place to ask this but there seems to be some
Try:
SELECT gallery_name, image_id, image_name FROM galleries, Images WHERE
galleries.gallery_id = images.gallery_id
At 07:57 AM 4/19/2002 -0700, you wrote:
Ok this could be the wrong place to ask this but there seems to be some
people in here that know mysql quite well.
My question is this;
Kelly-
My way may not be perfect, but this is what I do.
$sql_temp = select last_insert_id() as mainid from transfers;
$sql_result_temp = mysql_query($sql_temp,$connection);
$row_temp = mysql_fetch_array($sql_result_temp);
$file_temp_id = $row_temp[mainid];
-Scott
On Wed, 17 Apr 2002,
Kelly Meeks wrote:
Hi folks,
I need to get the next auto_increment value of a mysql table thru php.
Looking at my mysql manual, it makes reference to a last_insert_id() function?
How would I use this via php, or is there some other way to do it?
Quickly and hardly accurately... but
I've seen other responses to your request answer with some VERY UGLY methods
to get the last id.
Instead, use mysql_insert_id() which was created specifically for the info
you need.
- Original Message -
From: Kelly Meeks [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 17,
Richard Emery wrote:
I've seen other responses to your request answer with some VERY UGLY methods
to get the last id.
Hey my method wasn't ugly, perhaps not optimal, but definately not ugly!
So *ptht* ;)
Instead, use mysql_insert_id() which was created specifically for the info
you
- Original Message -
From: Robert Cummings [EMAIL PROTECTED]
To: Richard Emery [EMAIL PROTECTED]
Cc: Kelly Meeks [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, April 17, 2002 1:49 PM
Subject: Re: [PHP] mysql quickie..
Richard Emery wrote:
I've seen other responses to your
That's fine, but you don't need the intermediate select step. Just use
mysql_insert_id() to get the value of userid. auto_increment values are
guaranteed to be unique no matter how quickly you are inserting.
miguel
On Wed, 17 Apr 2002, Vladislav Kulchitski wrote:
Hi, I was wondering if the
PROTECTED]
ABN: 64 235 749 494
Mobile: 0407 122 268
QUT Student #: 04475739
:::
- Original Message -
From: Vins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 7:12 AM
Subject: [PHP] Re: PHP MySQL Hosting services
04475739
:::
- Original Message -
From: Vins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 7:12 AM
Subject: [PHP] Re: PHP MySQL Hosting services
Hey.
I have the best hosting you can get.
for only $46 p/m
Vins wrote:
you get unlimited traffic.
here it is very cheep.
so they can offer a great service.
www.wthosting.cjb.net
and they also don't pay for a domain.
so that means even more cheeper prices.
LOL
they crazy.
I know they guy, his way of thinking is free is better for the
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
Hey... new to the list, but didn't have time to lurk and watch the traffic,
kind of in a bind here. I apologize in advance if I do something wrong...
Using this code:
?php
$link = mysql_connect()
http://webpipe.net
They seem to be doing good with uptime.. In the last couple months I've been
having a monitoring service check them frequently and so far we're at 100%..
Standard Virtual Package ($24.95/mo - $14.95 setup):
Linux RedHat 7.1
300mb Disk Space
25 POP3 Accounts
10GB/mo transfer
Check out linux web host comes with PHP and MySql
Their PHP compile is pretty nice, including GD support. Their DB is
run via phpMyAdmin.
http://www.linuxwebhost.com
http://webpipe.net
They seem to be doing good with uptime.. In the last couple months I've been
having a monitoring service
Yeah, I actually used to have a couple accounts with linuxwebhost.com...
They are nice and fast.. I just like the ability to be able to compile and
install my own software on the server..
Later,
Bob
Eat Pasta Type Fasta [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL
Jennifer
Check out Hub.Org Networking services
http://www.hub.org
They have Virtual Machine that can be configured to your NEEDS without
affecting other clients and vice versa. and MANY other features
including ssh, ftp, cgi/perl and I believe they have also added MySQL
3.23 to the list.
Hey.
I have the best hosting you can get.
for only $46 p/m
ALL THIS...
a.. 400 MB web space
a.. Execution of Custom CGI scripts
a.. Support for PERL
a.. Support for C and C++
a.. Support for SSI
a.. Support for GCC
a.. Support for GD
a.. Support for 5 independent MySQL Databases
Own URL
Hey.
I have the best hosting you can get.
for only $46 p/m
ALL THIS...
400 MB web space
Execution of Custom CGI scripts
Support for PERL
Support for C and C++
Support for SSI
Support for GCC
Support for GD
Support for 5 independent MySQL Databases
Own URL in the format
Extensive Support Forum
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
Just a noob php/mysql question... (I suppose)
When I try just putting php code in my insert queries, it goes like this:
insert into mytable values('?php echo some string; ?')
select * from mytable, returns:
?php echo some string;
http://webpipe.net
They seem to be doing good with uptime.. In the last couple months I've been
having a monitoring service check them frequently and so far we're at 100%..
Standard Virtual Package ($24.95/mo - $14.95 setup):
Linux RedHat 7.1
300mb Disk Space
25 POP3 Accounts
10GB/mo transfer
To use php+mysql on spaceports you have to sign up for a cgi-bin account and
store your files on that server..
/Micke
Simonk [EMAIL PROTECTED] skrev i meddelandet
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I have made a web site containing Php and Mysql script
And I have applied for a free
Myabe you should assign some string to a variable:
$string = some string;
insert into mytable values ($string)
/Just a noob trying to help out
Torkil Johnsen [EMAIL PROTECTED] skrev i meddelandet
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Just a noob php/mysql question... (I suppose)
select * from table_name where criteria=whatever limit 1;
-Original Message-
From: Mason Batley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 12:02 AM
To: [EMAIL PROTECTED]
Subject: [PHP] mysql
Hi guys,
I've been looking on the net and the php docs for a simple
mysql query
mysql is a relational database. therefore, the concept of a row number is
irrelevant.
that said, what do you REALLY want to do
-Original Message-
From: Julian [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 2:59 PM
To: [EMAIL PROTECTED]
Subject: [PHP] mysql question
Hi!!!
I
On Mon, 8 Apr 2002, Julian wrote:
I want to know if there is a function to know which is the number of the row
that I selected.
Not in MySQL.
You should add an auto_increment index field to your table, and then you
can always use that to see where you are.
miguel
--
PHP General Mailing
Why don't you just increment a counter as you are retrieving them.
mysql_select_db(some_DB) or die(DB not available);
$query = select some_data from some_table;
$result = mysql_query($query);
$rowcounter=0;
while ($row=mysql_fetch_array($result)){
extract($row);
$rowcounter++;
echo(You
Thanks James!
It is the perfect answer for my cuestion!!!
Regards! Julian
- Original Message -
From: James E. Hicks III
To: Julian ; [EMAIL PROTECTED]
Sent: Monday, April 08, 2002 5:12 PM
Subject: RE: [PHP] mysql question
Why don't you just increment a counter as you
The UPDATE syntax in the manual:
http://www.mysql.com/doc/U/P/UPDATE.html
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]
Yes, it is different than the INSERT syntax.
PS ...but only there are like 150
what happened when you tried your query?
-Original Message-
From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:58 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL - UPDATE INSERT
Is this query legal?
$query = UPDATE table SET (var1, var2, var3) VALUES
On Friday, April 5, 2002, at 01:58 PM, Phil Schwarzmann wrote:
Is this query legal?
$query = UPDATE table SET (var1, var2, var3) VALUES ($var1, $var2,
$var3) WHERE username='$username';
No. The SET modifier (or whatever that is) can only be used to create
column name/value
On Saturday 06 April 2002 06:01, Phil Schwarzmann wrote:
Is there a maximum number of characters you can use in a query?
I have a giant query using the UPDATE command (updating about 120
different columns).
Yes there is.
I run this query of mine and nothing happens. No errors. No updates
I noticed today that UPDATE will behave like that if you are running it on
an empty table.. I'm certain you would get an error if your query was too
large.
Bob
- Original Message -
From: Phil Schwarzmann [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 05, 2002 3:01 PM
change to:
SELECT * FROM tifrequest LEFT JOIN USING(user) WHERE tifexpire.exp_date
=2002-04-04
It helps if you provide the error message. Also, this would have been found
when you entered it directly into the mysql command line prompt.
-Original Message-
From: ROBERT MCPEAK
On Thu, 4 Apr 2002, ROBERT MCPEAK wrote:
I get an error with the follow query. There is a field user in both
tables, tifrequest tifexpire. Can anybody see what's wrong with it?
Thanks.
SELECT * FROM tifrequest LEFT JOIN USING(user) WHERE tifexpire.exp_date
=2002-04-04
You didn't tell
Hi,
if you want to select a unique threadid to be read, try the following
MySQL sentence :
SELECT DISTINCT threadid FROM tablename;
Hope it helps you
SR
Dhaval Desai a écrit :
Hello,
Well I have a field in Mysql Database called threadid.
I have unique threadid's stored in this field. But
OkThanks to all those who are helping me (sorry for cross-posting)...
My scripts are working great except for one thingwhen it queries the db
there are some fields that have a NULL value, thus when it writes the XML
file it does this:
null_field/null_field
What I would like to do is
On Monday, April 1, 2002, at 05:09 PM, Jay Fitzgerald wrote:
OkThanks to all those who are helping me (sorry for
cross-posting)...
That's okay. This script looks a lot better -- because you can actually
-do- something with the output! :)
My scripts are working great except for one
: Erik Price [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 4:12 PM
To: Jay Fitzgerald
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] RE: PHP/MySQL/XML
On Monday, April 1, 2002, at 05:09 PM, Jay Fitzgerald wrote:
OkThanks to all those who are helping me (sorry for
cross
31/03/2002 01:02:04, Patrick Hartnett [EMAIL PROTECTED] wrote:
You Need to use the command
Mysql_Select_Db($db_name) Or Die(Unable to connect!);
after connect with mysql
I use something like this:
mysql_connect($db_host, $db_user, $db_pass) or die (Unable to connect!);
I don't think those variables are readable in the function. Not totally
sure though.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: Patrick Hartnett [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 30, 2002 10:02
On Sat, 30 Mar 2002, Mantas Kriauciunas wrote:
I have few users in my small page. And it goes with ID numbers. I
did auto increasement. And i think all the settings are ok. but in
phpMyAdmin it shows ID numbers starting from 5 and i have 10 users
so when i deleted row(user) with ID
On Thu, 28 Mar 2002, David Duong wrote:
How do I add extra fields after it has already been set?
1) Read the manual conveniently available at http://www.mysql.org; this
is not rocket science.
2) ALTER TABLE mytable ADD boogers_per_hour INT;
miguel
--
PHP General Mailing List
Try,
[type] can be int or char () or blob or real or something else drawn
from the mysql manual
$query=ALTER table_name ADD column_name [type] AFTER other_column_name;
$result=mysql_query($query);
if (!$result) die(couldn't alter table.mysql_error());
Hope this helps,
Hugh
- Original
how can you take a size of a function: $len = sizeof($this-query);
and WTF (query is a function, not an array): $tq = $this-query[$q_id];
-Original Message-
From: Anzak Wolf [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 9:09 AM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL
Sorry my mistake the array is $this-query_id the function is $query I still
get the same results though.
From: Rick Emery [EMAIL PROTECTED]
To: 'Anzak Wolf' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: [PHP] MySQL arrays
Date: Tue, 26 Mar 2002 09:23:11 -0600
MIME-Version: 1.0
CHANGE:
$len = sizeof($this-query_id);
$len++;
$this-query_id = array($len=$q);
mysql_free_result($q);
return $len;
TO:
$this-query_id[] = $q;
return sizeof($this-query_id);
second:
$q is a resource, that is, a pointer variable.
CHANGE:
$len = sizeof($this-query_id);
$len++;
$this-query_id = array($len=$q);
mysql_free_result($q);
return $len;
TO:
$this-query_id[] = $q;
return sizeof($this-query_id);
second:
$q is a resource, that is, a pointer
]
Subject: RE: [PHP] MySQL arrays
CHANGE:
$len = sizeof($this-query_id);
$len++;
$this-query_id = array($len=$q);
mysql_free_result($q);
return $len;
TO:
$this-query_id[] = $q;
return sizeof($this-query_id);
second:
$q
$result = mysql_query(.)'
mysql_num_rows($result)
-Original Message-
From: Ashley M. Kirchner [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 5:28 PM
To: PHP-General List
Subject: [PHP] MySQL query results
How can I tell whether anything was matched and changed after a
Rick Emery wrote:
$result = mysql_query(.)'
mysql_num_rows($result)
Hrm, this is resulting in:
bWarning/b: Supplied argument is not a valid MySQL result resource in
b./index.php/b on line b16/bbr
Rows
The query does get executed, and the record does get changed.
The code
1201 - 1300 of 1710 matches
Mail list logo