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
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
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:
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).
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
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
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
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
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
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
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 immediatly
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 area with
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
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
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;
//
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
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,
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,
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
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
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
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.
--
22 matches
Mail list logo