Re: [PHP-DB] Windoze crashes on this simple logon script.

2001-02-16 Thread Phil Driscoll
I suspect that what is going on is that your code is just going around in circles - the redirect is just opening the same page over and over again because your logic is flawed somewhere. Instead of outputting the location header, output an a href= instead and echo out sundry values until you find

Re: [PHP-DB] mysql_query failure

2001-02-16 Thread Russ Michell
$con = mysql_connect($DB_SERVER, $DB_USER, $DB_PASS) or die ("Cant connect"); mysql_select_db($DB_NAME); Try: $con = mysql_connect($DB_SERVER, $DB_USER, $DB_PASS) or die ("Cant connect"); mysql_select_db($DB_NAME, $con); Also try and make your php functions like so: mysql_x() instead of:

[PHP-DB] Dynamil Links

2001-02-16 Thread Sridhar Ranganathan
Hi, I have a search engine. It finds articles and displays the headings. When I click on the heading, I wanna load the article using a single page on the fly. I did as follows. $h is the heading. echo("font size='4' color='#003399'$hbr/fontfont size='1'a href='articleload.php?head=$h'Read

[PHP-DB] double posts

2001-02-16 Thread Marc Bragg
Is it possible to post to two forms with one click, one post command? What would statement look like? -- 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:

[PHP-DB] primary field

2001-02-16 Thread Marc Bragg
Does the first field in a form have special significance? Have two fields in table: last_name member_id member_id is key and autoincrement. mysql won't accept two last names as same when last_name is first field. when member_id is made first field, then can input same last name into last_name

Re: [PHP-DB] double posts

2001-02-16 Thread phobo
No you cant. What are you trying to do? Siggy - Original Message - From: "Marc Bragg" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 9:53 AM Subject: [PHP-DB] double "posts" Is it possible to post to two forms with one click, one post command? What

Re: [PHP-DB] double posts

2001-02-16 Thread JJeffman
Using a JavaScript function instead of the "action" form property I think is possible . HTH. Jayme. -Mensagem Original- De: Marc Bragg [EMAIL PROTECTED] Para: [EMAIL PROTECTED] Enviada em: sexta-feira, 16 de fevereiro de 2001 17:53 Assunto: [PHP-DB] double "posts" Is it possible to

Re: [PHP-DB] primary field

2001-02-16 Thread JJeffman
No it hasn't. The field order in the form doesn't matter, but the order you use their values in the query yes ! I don't know what kind of operation you're making on the database updating, inserting, etc. ). If you are inserting you must not give any member_id, as long as it is generated by the

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

2001-02-16 Thread Chris Weiss
Help! I'm experimenting with several of the PHP based WebDatabase front ends and am getting the following errors from all of them: "Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/httpd/html/pub/mainfile.php on line 9 Unable to select

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

Re: [PHP-DB] double posts

2001-02-16 Thread phobo
You can have multiple SUBMIT buttons (one for 'save', one for 'cancel' etc). if you have a button called 'SAVE', then a varable called save will be set in the script. eg, have the html: INPUT TYPE=SUBMIT NAME=SaveRecord VALUE="Save Your Details" INPUT TYPE=SUBMIT NAME=EditRecord VALUE="Edit

Re: [PHP-DB] double posts

2001-02-16 Thread Andrew Apold
At 12:53 PM 2/16/01 -0800, Marc Bragg wrote: Is it possible to post to two forms with one click, one post command? What would statement look like? I've long wanted to do this but never found something to do it. Usually it is for something where I am submitting it to someone else but want to

[PHP-DB] SQL Select statement

2001-02-16 Thread bill
I have a table with three simple columns: id(unique), memberID, and choice I want to find out which memberIDs have BOTH choice 2 AND choice 3. -- SELECT memberID from table where choice=2 AND choice = 3 That won't work (0 results, of course, because no row has two choices, they're mutually

[PHP-DB] Using include() to specify mysql_connection??

2001-02-16 Thread Boclair
Is it possible to place the mysql_connect and mysql_select_db functions in an include file and to open the connection and use the database in a PHP file using include(); ? All that happens when I attempt it is that the text of the include file is dumped, the connection to the mysql server is

AW: [PHP-DB] SQL Select statement

2001-02-16 Thread Matthias Kopolt
try something like: select a.memberID from table a, table b where a.choice=2 and b.choice=3 and a.memberID = b.memberID; or select memberID, count(*) from table where choice=2 or choice=3 group by memberID having count(*) = 2; (i don't know what is more effizient, might depend on your indexes

Re: [PHP-DB] Using include() to specify mysql_connection??

2001-02-16 Thread CC Zona
In article 96klap$c8p$[EMAIL PROTECTED], [EMAIL PROTECTED] ("Boclair") wrote: Is it possible to place the mysql connect and mysql select db functions in an include file and to open the connection and use the database in a PHP file using include(); ? All that happens when I attempt it is

[PHP-DB] Security on Windows2000/Nt

2001-02-16 Thread Fusion
Hello.. I am using windows2000 and when I run php it enables anyone on my network to allow php coding to make directorys in my computer.. How can I disable this feature so they can only make directorys/files in their own directory? Thanks Michael(Fusion)

Re: [PHP-DB] Using include() to specify mysql_connection??

2001-02-16 Thread boclair
- Original Message - From: CC Zona [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 12:30 PM Subject: Re: [PHP-DB] Using include() to specify mysql_connection?? To be parsed as PHP code, the contents of the included file also need to be in PHP mode ?php ...

[PHP-DB] shopping cart classes

2001-02-16 Thread Randall Perry
I've checked out the shopping cart packages available for PHP and am not thrilled by any of them. Was wondering if there are a set of classes available that could be used to support a shopping cart. I'm interested in the 'back end' -- working with the actual data, rather than the front end -- the

[PHP-DB] Text field types and efficiency

2001-02-16 Thread Alan Hale
Question from a beginner: I want to associate a fairly small amount of text (about 2500 chars) with records in a MySQL table, and display that as html. But is it more efficient to include the text in the database (in the appropriate text field type) and generate the html on the fly, or to just