[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] 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 PRO

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

2001-08-31 Thread Brunner, Daniel
:-( > > I've done a temporary fix - moved the entire database 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 > > >

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 bette

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 dat

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 PR

RE: [PHP-DB] please, please can we stop this kind of thing ..... !

2001-08-20 Thread Brunner, Daniel
HAHAHAHAHAHAHHAHAHAHAHAHAHAAHAH Dan > -- > From: Walter, Marcel > Sent: Monday, August 20, 2001 9:20 AM > To: 'B. van Ouwerkerk'; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] please, please can we stop this kind of > thing . ! > > Hmmm > @B: In future...

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

2001-08-16 Thread Brunner, Daniel
='$month_due', > day_due='$day_due' > " ; > > $result = mysql_query($sql) or die("ERROR -- try again11 or see > Kenn > Murrah"); > > $order_number=mysql_insert_id; > > > and I'm still not getting a value for $order_number,

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

2001-08-16 Thread Brunner, Daniel
day, August 16, 2001 12:29 PM > 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 ... &

RE: [PHP-DB] A newbie question

2001-08-15 Thread Brunner, Daniel
Hello!! Here use ECHO instead. echo ("Art_Job&HOSTNAME=$HOSTNAME&DATABASE=$DAT ABASE$table=$table>$data->Art_Number"); Notice $data->Art_job... $data is coming from mysql_fetch_object($result); That way you click on the actual Field result..Or in this case The Art Number... And th

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

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 connect

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

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

2001-03-26 Thread Brunner, Daniel
Hello Try to use this one with mysql_fetch_object... printf ("%s %s\n","list.php", $data->Art_Job_Number, "Edit", "View"); Then on the list.php do a select statement like this query = "SELECT * FROM Table1 WHERE Art_Job_Number = $Art_Job_Number"; Then echo the result and you shoul

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 co

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 o

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

2001-02-26 Thread Brunner, Daniel
on > Redhat Linux. I'm having same problem connecting via a > mysql_connect(---) call in PHP. > > What do I need to do to allow user interaction for MySQL? > thanks > > rick > > Richard L. Emery > IT Sr. Project Manager > > > "There is no 'tr

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 take

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 ou