[Ilugc] Help

From: imthiazrafiq@xxxxxxx (Imthiaz Rafiq)
Date: Mon, 19 Aug 2002 16:27:10 +0530

This is a multi-part message in MIME format.

------=_NextPart_000_000B_01C2479D.44B7A9C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello All

Please help me with this.

I want to know how to find whether a given field in mysql table is a =
reference key or not. If so what is the table it is referencing to. Let =
me show a sample query.

MYSQL:-------------------------------------------------------------------=
-----------
CREATE TABLE Main(
id VARCHAR(10) NOT NULL,
Name VARCHAR(100),
PRIMARY KEY (id));

CREATE TABLE Phone(
id VARCHAR(10),
phone VARCHAR(15),
FOREIGN KEY (id) REFERENCES Main (id));

-------------------------------------------------------------------------=
-----

From above we can see two tables. Phone id field is referenced to main =

id field. If we know the query we can tell easily. I want to read the =
same thru php. like....

PHP:---------------------------------------------------------------------=
---------

<?
 $USERNAME =3D 'root';
 $PASSWORD =3D 'passme';

 $DATABASE =3D 'imthiaz';
 $TABLE_NAME =3D 'Phone';

 mysql_connect('localhost', $USERNAME, $PASSWORD)
 or die ("Could not connect");

 $result =3D mysql_query("SHOW FIELDS FROM $DATABASE.$TABLE_NAME");

 $i =3D 0;

 while ($row =3D mysql_fetch_array($result))=20
 {
 echo $row['Field'] . ' ' . $row['Type'];
 }
?>

-------------------------------------------------------------------------=
-----

Please tell me is there any way we can do this as I did above and it =
didn't give the result what I have expected. Please help me with =
this.....

Thanks in Advance...

------=_NextPart_000_000B_01C2479D.44B7A9C0
Content-Type: text/html;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
Hello =
All Please help me=20
with this. I want to know how to find whether a given field in =
mysql=20
table is a reference key or not. If so what is the table it is =
referencing to.=20
Let me show a sample query. 
<BLOCKQUOTE><PRE>MYSQL:<HR><CODE>
 CREATE TABLE Main(
 id VARCHAR(10) NOT NULL,
 Name VARCHAR(100),
 PRIMARY KEY (id));
 
 CREATE TABLE Phone(
 id VARCHAR(10),
 phone VARCHAR(15),
 FOREIGN KEY (id) REFERENCES Main (id)); 

</CODE><HR></PRE></BLOCKQUOTE> From=20
above we can see two tables. Phone id field is referenced to main id =
field. If=20
we know the query we can tell easily. I want to read the same thru php.=20
like.... 
<BLOCKQUOTE><PRE>PHP:<HR><CODE>

 <?
     $USERNAME =3D 'root';
     $PASSWORD =3D 'passme';
 
     $DATABASE =3D 'imthiaz';
     $TABLE_NAME =3D 'Phone';
 
     mysql_connect('localhost', $USERNAME, $PASSWORD)
     or die ("Could not connect");
 
     $result =3D mysql_query("SHOW FIELDS FROM $DATABASE.$TABLE_NAME"</=
FONT>);
 
     $i =3D 0;
 
     while ($row =3D mysql_fetch_array($result)) 
     {
         echo <FON=
T color=3D#0000bb>$row['Field'] . ' =
' . $row['Type'];
     }
 ?>
 
</CODE><HR></PRE></BLOCKQUOTE> Please=20
tell me is there any way we can do this as I did above and it didn't =
give the=20
result what I have expected. Please help me with this..... Thanks =
in=20
Advance...</DIV></BODY></HTML>

------=_NextPart_000_000B_01C2479D.44B7A9C0--

[Ilugc] Help

Other related posts: