) to get the bulk of the data out, then regex out the %s
string.
2) eregi_replace() Jun with the numeric
3) Dump it as numeric instead of a string month name
4) eregi_replace() the /'s with spaces then sscanf() it.
'Luck
-Mike
- Original Message -
From: Glenn Holden [EMAIL P
You'll need a table for each web site's connection parameters, but just look
them up based on the user and plug them in to your mysql_connect() and
mysql_select_db() arguments.
As long as their tables match the structure you are expecting everything
else should work. Voila!
Good luck with your
First, I think an AUTO_INCREMENT column must be a numeric column, not TEXT.
Second, be sure this column is indexed.
If you have trouble, send us the results of a
DESCRIBE TABLE `ajj47592`.`content`;
statement. That may help us give you some specific syntax to try.
Glenn
Daniel Broome
What's the error?
Do you already have an auto-inc field?
Have you tried it with another interface? Ie: directly in the MySQL command
line util.
Glenn
Notes from MySQL.com:
There can be only one AUTO_INCREMENT column per table, and it must be
indexed.
When you add an AUTO_INCREMENT column,
Normalization depends on how the data will be used. For instance in the
contacts database you want to enter a name only once. What you have looks
fine but it makes an assumption: Each address has only one contact and each
contact only one address.
I'm not sure why you want City, State and Zip
From MySQL.com documentation:
Our aim is to have stored procedures implemented in MySQL Server 4.1.
I think it's in beta but not sure if that feature is implemented now. I'm
using stable versions 3.x.x.
Glenn
Rick Emery [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL
In the following example, does the while loop with mysql_fetch_array() query
the server each time through the loop? Or does it do everything, while
parsing, using $result? Or is there some other subtlety I'm missing? How
is this working and where is the work being done?
Thanks, Glenn.
?php
#1 is the fastest with MySQL.
(copied from MySQL online docs...)
Glenn
a.. COUNT(*) on a single table without a WHERE is retrieved directly from
the table information for MyISAM and HEAP tables. This is also done for any
NOT NULL expression when used with only one table.
.
examples of
I'm looking for a reasonably simple and fast way to fill an array with the
results of a single column select query.
example results from query:
+---+
| productid |
+---+
| PS|
| PSLEB |
| MD1 |
| CPSS1 |
| CPSG1 |
| CPSP1 |
| CPSSR |
| CPSGR