[PHP-DB] Shoutout.....

2001-09-11 Thread Brunner, Daniel
This Shoutout goes to the people who have lost their lives today. My heart will be with them forever. May a quick death come for those who are involved We will never forget... All those innocent lives..lost.

RE: [PHP-DB] Previous | Next (Again)

2001-08-31 Thread Brunner, Daniel
Hello!!! Now that I have found a better link to understand and use the code for next/previous...here it is... http://www.onlamp.com/pub/a/php/2000/11/02/next_previous.html I use this idea with every database. This also teaches you...mysql_fetch_object PhPBuilder is OK but this one better

RE: [PHP-DB] Weird Problem In mysql_connect();

2001-08-31 Thread Brunner, Daniel
connection function to a separate file, and required that from the first required file (!), and it's working, but the original problem has still got me confused!!! Dave -Original Message- From: Brunner, Daniel [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 21:32 To: Dave

RE: [PHP-DB] Simple database error (SPACE)

2001-08-30 Thread Brunner, Daniel
Hello!!! Use mysql_fetch_object... $myrow-WHATEVER Whatever = whatever the field name is Dan -- From: Nagasea Reply To: [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 5:01 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Simple database

RE: [PHP-DB] restoring mysql db after mysqldump

2001-08-22 Thread Brunner, Daniel
Hello!!! Make sure that the ownership of the files are mysql.mysql This as happened to me too!!! I might be wrong but it worked for me Dan -- From: Jay Paulson Reply To: Jay Paulson Sent: Wednesday, August 22, 2001 11:29 AM To: [EMAIL

RE: [PHP-DB] determining the value of an auto-incremented field (mysql)

2001-08-16 Thread Brunner, Daniel
To: Brunner, Daniel Subject: Re: [PHP-DB] determining the value of an auto-incremented field (mysql) thanks, Dan ... i'll RTFM now to figure out exactly how to use it ... and thanks again for your prompt response ... Kenn - Original Message - From: Brunner, Daniel

RE: [PHP-DB] A newbie question

2001-08-15 Thread Brunner, Daniel
Hello!! Here use ECHO instead. echo (a href=list.php?Art_Number=$data-Art_JobHOSTNAME=$HOSTNAMEDATABASE=$DAT ABASE$table=$table$data-Art_Number/a); Notice $data-Art_job... $data is coming from mysql_fetch_object($result); That way you click on the actual Field result..Or in this

FW: [PHP-DB] How to stop blank entries

2001-04-16 Thread Brunner, Daniel
Hello!! Use an If statement... if (!$username=="") exit else ... Or something like that Change the !$username to (!isset($username)) Or something like that... Just play around with the if statements...it works for me... But I may be wrong... Dan

RE: [PHP-DB] Fatal error: Call to unsupported or undefined function mysql_connect()

2001-04-04 Thread Brunner, Daniel
Hello... Either the Username or Password or Database does not exist... Do this $db = mysql_connect(server, $user, $password) or die ("Sorry something is wrong"); $select = mysql_select_db("intranet", $db); or die ("Sorry something is wrong"); That way you can see if it

RE: [PHP-DB] Another newbie question

2001-03-26 Thread Brunner, Daniel
Hello I too wanted to have next/previous links... So I found this and it's the best out there... http://www.oreillynet.com/pub/a/php/2000/11/02/next_previous.html?page=1 to output the query... echo $data-Print_Name //Or whatever you want to display . Within that

RE: [PHP-DB] reading a URL...

2001-03-26 Thread Brunner, Daniel
Hello Try to use this one with mysql_fetch_object... printf ("TD WIDTH=80a href=\"%s?Art_Job_Number=%s\"%s %s/a\n","list.php", $data-Art_Job_Number, "BEdit/B", "BView/B"); Then on the list.php do a select statement like this query = "SELECT * FROM Table1 WHERE Art_Job_Number =

RE: [PHP-DB] What's wrong with this code?

2001-03-26 Thread Brunner, Daniel
Hello... Try mysql_pconnect instead Dan -- From: Emir Musabasic Sent: Monday, March 26, 2001 9:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] What's wrong with this code? Hi, I really need help, I wrote a function so that I can call for db

RE: [PHP-DB] diferent user passwords

2001-03-23 Thread Brunner, Daniel
Hello... What you can do is create different users tables within the Database... Then write a script that checks the username and passwords for each Database, during login. Like do a SELECT username FROM usertable if (!username) then echo .. Or stick with one user and

RE: [PHP-DB] Can't connect to local MySQL server error

2001-02-26 Thread Brunner, Daniel
need to do to allow user interaction for MySQL? thanks rick Richard L. Emery IT Sr. Project Manager "There is no 'trying'... There is only 'Do' or 'Not Do' " -Original Message- From: Brunner, Daniel [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001

FW: [PHP-DB] next previous record

2001-02-22 Thread Brunner, Daniel
Check this link out... http://www.oreillynet.com/pub/a/php/2000/11/02/next_previous.html?page =1 It's about Next/previous links... It does work, but I've yet to get to get it to work completely with displaying the records (rows) and the links at the same time... It just takes some

RE: [PHP-DB] Can't connect to local MySQL server error

2001-02-16 Thread Brunner, Daniel
Hello... Do a netstat -vatp To see if mysql is up and listening on your TCP. And it will give your PID/Program name as well... I remember reading something about if the mysql.sock didn't work...you needed to do something with mysql...I'll look into it this weekend. If nobody can help you