[PHP-DB] Library Management System

Hi Everyone, Please bear with me.I am a final year student from India-Goa, and +developing a library management system which can be adopted by any University +(Hopefully). We are developing this project using PHP and PostgreSql.The good +thing that we appreciate is that this project is bas

[PHP-DB] Library Managament project

Hi Everyone, Please bear with me.I am a final year student from India-Goa, and developing a library management system which can be adopted by any University (Hopefully). We are developing this project using PHP and PostgreSql.The good thing that we appreciate is that this project is bas

Re: [PHP-DB] php.net website down?

sweet thnx man :) -- Chris Hall sytems administrator funnelbox mediaworks [EMAIL PROTECTED] ""Chris Hall"" <[EMAIL PROTECTED]> wrote in message 9a1g2o$6mb$[EMAIL PROTECTED]">news:9a1g2o$6mb$[EMAIL PROTECTED]... > Off subject but anyone know why php.net is down?? > > -- > Chris Hall > sytems admini

Re: [PHP-DB] How to eliminate bad fields from a mysql query?

If there are some fields that you absolutley require, or must be in a valid format, I'd use javascript to edit the form first - no reason to make a round trip to the server for something you can do server-side. **Or** - say the form is for selecting an automobile - make is required but color isn

Re: [PHP-DB] count function?

What is retrieved if you do a Select Count(*) from myDb where condition = parameters? Seems your result set should contain this value... Phil J. DC wrote: > Hi All > I cant quite work out how to count the number of rows in my mysql db that > match a certain critieria and the show that number n

Re: [PHP-DB] RE: [PHP] RE: what exactly are /path/to/blah lookingfor? .h? .so? .a? what?!

Daevid, just --with-iodbc or --with-openlink is fine. you should be using either: --with-iodbc=/usr/local/openlink/odbcsdk \ or --with-openlink=/usr/local/openlink/lib \ depending on which you use and where you installed the sdk. what error are you getting? Best regards, Andrew On 3/30/01 6

RE: [PHP-DB] connection to smtp

No, the mail() function will not work without a valid MTA. I believe the default is sendmail. But yeah, you can change that in the php.ini file. > -Original Message- > From: fam.paauwe [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 30, 2001 1:20 PM > To: [EMAIL PROTECTED] > Subject: [

[PHP-DB] RE: [PHP] RE: what exactly are /path/to/blah looking for? .h? .so? .a? what?!

thanks for replying Andrew, but that's not working for me either. Also, do I need both "--with-iodbc" and "--with-openlink" or do I just need one of them? These are the instructions I've been following: http://www.iodbc.org/odbc-phpHOWTO.html so now I've tried: #--with-iodbc=/

[PHP-DB] CSS versus Includes

I have found that includes work just about as well. Any suggestions on going with one or the other? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL

RE: [PHP-DB] How to eliminate bad fields from a mysql query?

Bob, Don't know if this is what you're looking for, but you *could* do something like: $noData = true; $strSQL = "SELECT field1, field2, field3 FROM table "; $results = mysql_query($strSQL, $db) or $noData = false; if ($noData) { print ""; while (list($field1, $field2, $fiel

[PHP-DB] RE: what exactly are /path/to/blah looking for? .h? .so? .a? what?!

Daevid, It's the path/to/odbcsdk It's looking for libiodbc.so :) Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com > -Original Message- > From: Daevid

[PHP-DB] How to eliminate bad fields from a mysql query?

Dear PHP Helpers, Can you direct me to a solution for this problem: How can I eliminate bad (blank or incorrect) fields from a mysql query? In other words, if someone leaves a form field blank or enters a value that does not have a matching entry in the database, how can I eliminate that variabl

[PHP-DB] what exactly are /path/to/blah looking for? .h? .so? .a? what?!

> I'm having difficulties with that line: > > ./configure --with-openlink=/path/to/openlink/ > --with-iodbc=/path/to/iodbc/ so I've tried every combination I can think of related to "iodbc" and "openlink", and none of these are compiling. Every one results in "No such file or director

[PHP-DB] DONE - Confuse w/ count function? / THANKS

it's working now. Thanks Oson --- "Oson, Chris M." <[EMAIL PROTECTED]> > wrote: >try: > >$strSQL = "SELECT COUNT(*) AS 'ItemCount' FROM my_table"; >$result = mysql_query($strSQL, $db); >list($numberOfItems) = mysql_fetch_array($result); > >echo "The number of items in the database is:

RE: [PHP-DB] Confuse w/ count function?

try: $strSQL = "SELECT COUNT(*) AS 'ItemCount' FROM my_table"; $result = mysql_query($strSQL, $db); list($numberOfItems) = mysql_fetch_array($result); echo "The number of items in the database is: $numberOfItems\n"; hTH -Original Message- From: Naga Sean [mailto:[EMAIL PROTECTED]] Sent

[PHP-DB] PHP w/OOB

I have PHP compiled with OOB and Apache on one of my Linux bxes and it works great. My problem is that I need to run PHP w/ OOB on a second box as a stand alone app. Here is a sample script: #!/usr/local/bin/php Here is the error: X-Powered-By: PHP/4.0.4pl1 Content-type: text/html Warning:

[PHP-DB] Confuse w/ count function?

I try to use this count function, but no matter how. I got this result from $t = Resource id #4 $t = mysql_query("SELECT COUNT(*) FROM my_table",$db); echo($t); any comments ? -naga --- Andrei Skorokhod <[EMAIL PROTECTED]> > wrote: >if you just need the number > >SELECT COUNT(*

Re: [PHP-DB] count function?

Cheers Brian Thats sounds more like i am looking for Although i have put the other code examples offered for this prob in my code folder for later cause you never now when you'll need them. Cheers Dave C ""Brian S. Dunworth"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAI

RE: [PHP-DB] count function?

At 10:06 AM 3/30/01 -0800, Larry Rivera wrote: >I think you have to run multiple queries, ie run some loop after finding out >what topics you wil count from e==> > >run a select distinct to get the topics >run a while or for loop then run queries again like count(*) where >topic='$topic' Bette

[PHP-DB] connection to smtp

My php mail() function failes to make a connection to my local smtp server. Which server is best suitable and what do I have to change in my php.ini file so that the mail() function will operate correctly? Does the mail() function work without an smtp server? Do I have to have an internet conne

Re: [PHP-DB] MySQL max_connections

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Lee Stretton) wrote: > Got a bit of a problem with the number of users accessing a website > driven by a MySQL database. I want to increase the number of allowed > connections to the database, I have found the variable to change > (max_connecti

Re: [PHP-DB] count function?

Thanks i will give that ago. "Andrei Skorokhod" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > if you just need the number > > SELECT COUNT(*) FROM table where > > At 06:34 PM 3/30/2001 +0100, DC wrote: > >Hi All > >I cant quite work out how t

RE: [PHP-DB] count function?

try mysql_num_rows function -Original Message- From: DC [mailto:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 9:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] count function? Hi All I cant quite work out how to count the number of rows in my mysql db that match a certain critieria and

RE: [PHP-DB] HELP: Eporting data from mySQL with PHP

> Hello, > > I'm trying to figure out how to get the data out of a table in a format > which I can easily import into excel. I wanted to have tab delimited fields > enclosed by quotes. I'm not sure how to do this? I check the mySQL doc and > saw the mysqldump call but haven't found any mention

Re: [PHP-DB] count function?

if you just need the number SELECT COUNT(*) FROM table where At 06:34 PM 3/30/2001 +0100, DC wrote: >Hi All >I cant quite work out how to count the number of rows in my mysql db that >match a certain critieria and the show that number numericaly in my pages. > >Checked books, ph

Re: [PHP-DB] count function?

Ok i will get the books out and see if i can construct something. Thanks for the tip... Dave C ""Larry Rivera"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I think you have to run multiple queries, ie run some loop after finding out > what topics you wil c

RE: [PHP-DB] count function?

I think you have to run multiple queries, ie run some loop after finding out what topics you wil count from e==> run a select distinct to get the topics run a while or for loop then run queries again like count(*) where topic='$topic' etc then echo the result to each line -Original Messa

[PHP-DB] HELP: Eporting data from mySQL with PHP

Hello, I'm trying to figure out how to get the data out of a table in a format which I can easily import into excel. I wanted to have tab delimited fields enclosed by quotes. I'm not sure how to do this? I check the mySQL doc and saw the mysqldump call but haven't found any mention of it in th

Re: [PHP-DB] count function?

Ok i think i need to expand my help request... my fault I have a db that uses ids for topics in a message board ie each topic has messages of various numbers in them. >From my select a topic page i hope to put the number of messages in the topic, so it visually looks like this sort of... to

[PHP-DB] count function?

Hi All I cant quite work out how to count the number of rows in my mysql db that match a certain critieria and the show that number numericaly in my pages. Checked books, php.net etc. Any help is appreciated Yours Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-m

[PHP-DB] MySQL max_connections

Hi, Got a bit of a problem with the number of users accessing a website driven by a MySQL database. I want to increase the number of allowed connections to the database, I have found the variable to change (max_connections) but have not been able to find out how, or where to change it. So if any

Re: [PHP-DB] url-open

Hi, take a look at http://forums.devshed.com/showthread.php?threadid=12544&forumid=5 it might help. "Mirko Cegledi" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi! > > I know its offtopic, but I don't want to join another mailinglist for this > one q

Re: [PHP-DB] Problem with single qoutes

You shouldn't trust any inputs from users. This section of PHP manual may be useful. http://jp.php.net/manual/en/security.php http://jp.php.net/manual/en/security.variables.php http://jp.php.net/manual/en/function.addslashes.php You may need to write your own addslashes and stripslashes depends

Re: [PHP-DB] functions and using vars outside of them

I think it's time to read the manual. http://jp.php.net/manual/en/langref.php http://jp.php.net/manual/en/language.variables.scope.php http://jp.php.net/manual/en/functions.php -- Yasuo Ohgaki ""olinux"" <[EMAIL PROTECTED]> wrote in message 000f01c0b838$e332a3c0$6401a8c0@amdk7">news:000f01c0b83

[PHP-DB] url-open

Hi! I know its offtopic, but I don't want to join another mailinglist for this one question: I try to open a webpage per fopen, but it didn't work. We're using php3 and are behind a firewall. But the firewall isn't the problem, is it? Its annoying, I've tried this for about four months now a coul

RE: [PHP-DB] php.net website down?

> > Off subject but anyone know why php.net is down?? > no but uk.php.net is up if that's any good to you. M@ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-

[PHP-DB] php.net website down?

Off subject but anyone know why php.net is down?? -- Chris Hall sytems administrator funnelbox mediaworks [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list admin