[PHP-DB] Multiple rows for one column in a MySQL table?

2001-03-27 Thread Kevin Connolly
Hi, Is it possible to have multiple rows for one column of a MySQL databes? and if so how would I insert another row into the column in question? eg: idNamePhone Number 1Kev 123123 2John 234234 345345 3 Paul

[PHP-DB] continuously view database updates.

2001-03-26 Thread Kevin Connolly
Hi, I am doing a college project which involves using PHP scripts to update a MySQL database. For demonstration purposes I would like the new updated table in my Database to be shown each time it is updates without me having to go to the command prompt window and type in select * from members;

[PHP-DB] Help! Want to unsubscribe!

2001-03-09 Thread Kevin Connolly
Hi, I am trying to unsubscribe from this mailing list (I keep going over my allotted space on the mail server!) but can't seem to do it! I have gone to the remove link on the phpbuilder web page (twice) but still the mails arrive! Anybody know how to unsubscribe? Thanks to everyone who has hel

Re: [PHP-DB] php and mysql file insertion!

2001-03-06 Thread Kevin Connolly
ot; <[EMAIL PROTECTED]> Cc: "'Kevin Connolly'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, March 06, 2001 8:03 PM Subject: Re: [PHP-DB] php and mysql file insertion! > Couldn't you also just store the image on the server, then put the path t

[PHP-DB] php and mysql file insertion!

2001-03-06 Thread Kevin Connolly
Hi, I have a MySQL database that is updated using a PHP script. It stores a members details (name, address etc.) I also want it to store a file (a member photo to be exact). Is this possible? Any help is much appreciated! Thanks, Kevin.

[PHP-DB] $result = true or false??

2001-01-26 Thread Kevin Connolly
Hi, $db = mysql_connect("localhost", "root"); mysql_select_db("mydb",$db); $sql = "SELECT * FROM employees where first = '$login'"; $result = mysql_db_query ("mydb", $sql); echo "$result"; If I run this cose then $result always = Resource id #2 even if $login is not a mem

[PHP-DB] PHP, MySQL and WML! Checking a database column for a particular value!

2001-01-26 Thread Kevin Connolly
Hi, I am trying to check for the existance of a certain value (ie $login, taken from my first PHP page: member.php) in the "first" column of my database "mydb. The value of "$login" is passed from member.php. My data base "mydb" contains 1 table called emplyoees which was created as follows: CRE

[PHP-DB] Fw: PHP, MySQL and WML! Checking a database column for a particular value!

2001-01-26 Thread Kevin Connolly
SORRY IF YOU ALREADY GOT THIS BUT I DIDN'T RECEIVE IT EVEN THOUGH I AM ON THE MAILING LIST SO I WASN'T SURE IF IT SENT OR NOT!! Hi, I am trying to check for the existance of a certain value (ie $login, taken from my first PHP page: member.php) in the "first" column of my database "mydb. The val

[PHP-DB] PHP, MySQL and WML!

2001-01-25 Thread Kevin Connolly
;)); > printf("Position: %s\n", mysql_result($result,0,"position")); > > > > In the the following line: printf("First Name: %s\n", mysql_result($result,0,"first")); the 0 is the row we want to