You will find the Legal Info at the bottom
RE: PayPal Account
This is something that I wouldn't normally even look at, except that, I read
an article in the Wall Street Journal about PayPal and x.com.
There have been other articles written
in PHP, coming out in yyy-mm-dd
date("Y-m-d", mktime(0,0,0, date("m"), date("d")+14, date("Y"));
untested, so please test it - this will ignore hours, minutes, seconds (the
leading 3 0's) and make a timestamp using mktime for this month, this day +
14, this year, then return it formatted as yyy-m
How do you get the date that is 14 days from today's date?
I can get that date with mysql monitor but PHP. I am using PHP4 and MySQL. I
have tried many things but nothing works.
Does anyone give me a help?
Thank you.
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail
How do you get the date that is 14 days from today's date.
I am using PHP4 and MySQL. I can get that date with MySQL monitor but php. I
have tried many things but nothing works.
Does anyone give me a help?
Thank you.
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail
Hey Matt..you would use the substr function for this...for example:
$stuff = the number you're checking..
$fnum = substr($stuff, 0, 1)
and $fnum is the first number (as a string) from $stuff =)
- Tim
--
>From PHPGalaxy.com, earn up to $10 per order selling our PHP Scripts
and Software on
or even
mysql_list_tables()
:)
/beau
// -Original Message-
// From: Rick Emery [mailto:[EMAIL PROTECTED]]
// Sent: Tuesday, 13 November 2001 1:47 AM
// To: 'mike luce'; [EMAIL PROTECTED]
// Subject: RE: [PHP-DB] getting database tables
//
//
// In PHP:
// $query = "SHOW TABLES";
// $
I have numbers stored in a text field in my database:
ie.
321
322
401
402
403
404
405
406
I think you get the picture ;) Anyway I need to know how to get just the
first character of each stored number and store it in the variable $season.
Any help much appreciated, thanks in advance,
Matt
_
HI all,
Just a week or so ago I started testing PHP and MySQL databases. Testing is over. I
have figured out the basic controls etc. and it is time for the construction of the
database and the PhP scripts to get the site up and running. The general layout of the
database and its tables is mor
On Tue, 13 Nov 2001 04:30:06 +0800
Brian Tegtmeier "Brian Tegtmeier" <[EMAIL PROTECTED]> wrote:
> Sup all. I'm currently running into a problem (can send source if
> needed) with this news script called "PHP-News" at
> http://www.hotscripts.com/Detailed/7145.html where if I login to
> the admin a
Sup all. I'm currently running into a problem (can send source if needed) with this
news script called "PHP-News" at http://www.hotscripts.com/Detailed/7145.html where if
I login to the admin area with Internet Explorer 5 and click on one of the sectional
links like "Users" or "News" I am immed
show us your table structure. which fields do you want to select on in both
tables
-Original Message-
From: Carlo Loiudice [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 1:15 PM
To: PHP DB
Subject: [PHP-DB] is it a Many-to-Many relationship ???
HI again.
I'm doing this:
I'm
HI again.
I'm doing this:
I'm a table where there are 4 fields like this:
height,measure height,weight, measure weight.
Then a 2nd table, where I've all measures defibed.
How can I select 2 different rows from the 2nd
(measures) table related to 1 entry in the 1st table
with a single select query
SELECT * FROM messages WHERE userID NOT LIKE '%$userid%'
-Original Message-
From: Peter Brown [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 11, 2001 11:28 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] PHP/MySQL Question
HI,
New to PHP/MySQL,
I was wondering if th
In PHP:
$query = "SHOW TABLES";
$result = mysql_query($query) or DIE("Error: ".mysql_error());
while( $row = mysql_fetch_array($result) )
{
do some stuff with $row
}
-Original Message-
From: mike luce [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 3:10 AM
To: [EMAIL P
> There isn't the field table_name.ID_city!!!
because you didn't ask for it. You asked for:
table_name.name
table_city.ID
table_city.city
-Original Message-
From: Carlo Loiudice [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 4:02 PM
To: PHP DB
Subject: [PHP-DB] JOIN op
Jacob, Ryan
MSSQL functions use the Sybase OpenClient or FreeTDS,
Some ODBC drivers do impose this restriction, however OpenLink's 4.1 ODBC
drivers allow return of the full overloaded data.
Please let me know if you require any assistance in configuring ODBC.
Best regards,
Andrew Hill
Director
The "bug" as you call it is a limitation in the libraries from Microsoft. SQL Server
ships with a set of C-Libraries called DBLIB, and these were developed for MSSQL
Server 4.x and 6.x. In version 7.x Microsoft extended char and varchar column max
length to 8000 but did not update the DBLIB stu
The VARCHAR(255) "bug" is actually a limitation imposed by ODBC - so I
suspect the MSSQL library uses ODBC for communication with a SQLServer
installation. I've experienced the same problem using Java JDBC and some
older SQL Server drivers. Recent type-4 MS SQL Server drivers for JDBC have
fixed
LIKE is a very good option. You can use:
LIKE \n'$id'\n;
Or similar, where \n stands for the Mysql carriage return 'symbol'.
Also, you may try selecting the whole text field, explod()ing contents by
carriage returns and checking with in_array() for the id if the above
doesn't works.
--
I fixed this issue by using a text field instead of a varchar field. For
some reason, it didn't want to read anything over 255 characters, although
the data was still stored. Maybe it's a bug, or maybe just a limitation.
Ryan
-Original Message-
From: Michael Schmidt [mailto:[EMAIL PRO
Use sql keyword LIKE, unless you have access to the design of the database,
in which case design it properly (i.e. something approaching normal form).
Tim
--
From: Peter Brown [SMTP:[EMAIL PROTECTED]]
Sent: 12 November 2001 05:28
To: [EMAIL PROTECTED];
Hi All.
With the Microsoft SQL Server it is possible to make a table with fields of
the type varchar which can have more then 255 characters width.
When use a query to get the content, i only get the first 255 characters all
others are cut off. (i connect to the DB via the mssql_... commands).
> Thanks but I think subselect is not possible with MYSQL.
You're right. Here's a MySQL compatible alternative:
SELECT
table1.* FROM table1
LEFT JOIN table2 ON table1.id=table2.id
where table2.id IS NULL
From the MySQL manual on sub-selects at:
http://www.mysql.com/doc/A/N/ANSI
Hello!
I have a MySQL DB on a web server, and I also have a MySQL on my PC. I want
the local machine to connect to the external machine and update the tables
on the external machine.
I have tried to connect true standard way but it doesn't work. Must I use
SOCKETS to connect to the external mach
Can someone give me some help on obtaining a list of tables in a database?
Ive had no luck so far because i keep encountering an error which just times
out the page.
Any help would be welcome.
thanks.
_
Get your FREE download of MS
25 matches
Mail list logo