[PHP-DB] RE: PHP4 on Windows using MSSQL

Thanks Ollie. I will check Tcp or Named Pipes. I have found a Linux Journal article dated 14 Feb 2003 using a FreeTDS driver and ODBC to MSSQL and will try that. Cheers, Kevin On Tue, 2003-02-25 at 23:25, Oliver Cronk wrote: Yes, but I have never personally used Linux to connect to MSSQL so I

[PHP-DB] RE: PHP4 on Windows using MSSQL

Sorry made a typo in my last email - I mean't to say wouldn't recommend it rather than would (in reference to using MSSQL from Linux). Hope you get the issue sorted Cheers Ollie -Original Message- From: Kevin Gordon [mailto:[EMAIL PROTECTED] Sent: 26 February 2003 08:23 To: Oliver

Re: [PHP-DB] Multiple select box using mysql

Yeah, I think I am going to reconsider the software box. The idea I have now is to have an Add Expert link attached to each software entry, which will then load a page to add experts to that piece of software. The page could contain two select boxes, one with a list of all experts, and one with a

Re: [PHP-DB] SESSIONS

And also use $_POST[SUBMIT] or set register_globals On You need to register you varible first with the session -Original Message- From: David Rice [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 3:10 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] SESSIONS Here's

Re: [PHP-DB] SESSIONS

on 26/2/03 12:58 pm, MaN at [EMAIL PROTECTED] wrote: And also use $_POST[SUBMIT] or set register_globals On Just use $_POST[SUBMIT] register_globals was turned off for security reasons. You are compromising the security of your system if you turn it back on. -- Mike Karthauser Managing

[PHP-DB] A-Z Listings

Hi There., I have a script that lists directorys then how many files are in each. although it won't list in an A-Z format, would anyone know how i would do this? Any help would be greatly appreciated and all required code is included below TIA Andy ? function romcount($system,

[PHP-DB] ODBC Stored Procedure

Hi all, I have a system PHP4+LINUX+DB2. I'm using stored procedure on IBM DB2 7.1, and in PHP(4.23) I can execute the procedure but I can't get the return values. Does anyone know why? Below is my source code. Thank you, Renato Preti

RE: [PHP-DB] RE: PHP4 on Windows using MSSQL

I use this combination very successfully. I stick with ODBC for the SQL access though. Ryan -Original Message- From: Oliver Cronk [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 3:23 AM To: Kevin Gordon Cc: PHP Mail Subject: [PHP-DB] RE: PHP4 on Windows using MSSQL Sorry

[PHP-DB] Trouble with Joins

I have a survey I created that when the formis being filled out it will select values from list. The list values are other tables in the same DB. When I go to get the info again I am trying to do a left join of the two table to get the description instead of the id's associated in the table.

[PHP-DB] MD5()

Hi there everyone, I have to store some CC details in a database which are inputted from a form, is MD5() the best way to secure the data? If so, how do I view MD5() data after it has been inserted? Any good MD5() tutorials out there? Thanks for your help :-) Regards Chris

Re: [PHP-DB] MD5()

md5() is a one-way encryption algorithm. So once they are encrypted, you cannot decrypt them. Just look at the md5() function on the php website. It has what you need to do. Of course if you eventually need these back in the clear, then md5 would not be a solution. -Brad Chris Payne wrote:

[PHP-DB] Re: Get MySQL table schema for a dump

[EMAIL PROTECTED] (Jonathan Villa) writes: Is there was to get a database's table schema? I don't think it's called schemas in mysql, but I'm not sure :-) So far, I have a simple function which will output INSERT INTO table (x,x,x,) VALUES(x,x,x); [ ... ] but what I'm missing is CREATE

RE: [PHP-DB] Re: Get MySQL table schema for a dump

Sorry, I should have explained that I want to do this via PHP. --- Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fredrik de Vibe Sent: Wednesday, February 26, 2003 5:31 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Get MySQL table

[PHP-DB] Parse Error

Hi there everyone, I'm trying to run an if statement and inside that have other if's, but it keeps telling me I have a parse error on the first if in the if statement (The second if down). Can anyone see what i'm doing wrong? if ($packages == 1)( if ($airporttransfer == car)(

Re: [PHP-DB] Parse Error

If statements use curly braces. Do this: if ($packages == 1){ if ($airporttransfer == car) $airporttransfer2 = 12.00); if ($airporttransfer == bus) $airporttransfer2 = 10.00); if ($airporttransfer == none) $airporttransfer2 = 0.00); } On Wed, 2003-02-26 at 16:42, Chris Payne wrote: Hi

RE: [PHP-DB] Parse Error

if ($packages == 1){ if ($airporttransfer == car){ $airporttransfer2 = 12.00}; if ($airporttransfer == bus){ $airporttransfer2 = 10.00}; if ($airporttransfer == none){ $airporttransfer2 = 0.00}; }; () round brackets round the condition {} braces around the 'do it' bit :) HTH Peter

[PHP-DB] If Statement thanks

Hi there everyone, Thank you all for your answer - DOH I can't believe I missed something so simple :-) Regards Chris

[PHP-DB] [[PHP-DB] Re: Get MySQL table schema for a dump

Jonathan, You can use Describe TABLENAME as a query and then use that information to built you create statements. Eric Eric Girard Varsity Crew Team Computer Science major, Management Information Systems minor, Worcester Polytechnic Institute Class of '03 -Original Message-

RE: [PHP-DB] MD5()

I have to store some CC details in a database which are inputted from a form, is MD5() the best way to secure the data? If so, how do I view MD5() data after it has been inserted? Any good MD5() tutorials out there? Please do your users a favor and do not store credit card numbers on your

RE: [PHP-DB] Get MySQL table schema for a dump

Is there was to get a database's table schema? For example, I want to be able to click on a link and then create a .txt file of a table (or even better a databases) schema. So far, I have a simple function which will output INSERT INTO table (x,x,x,) VALUES(x,x,x); INSERT INTO table

[PHP-DB] One more date question (NOOOOOOO) :-)

Hi there everyone, Sorry about all these emails :-) I have one final question (For this week - LOL). How can I get the current month + the next 11 months in a dropdown form box? Ideally there'd be 3 boxes, 1 with the day, dependant on the month you select plus the year, though I can

[PHP-DB] Database Notification

Hi all, Permit me to recive your valuable knowledge , We are working on a project where the backend churns data for about 1 Minute (time out limit is 2 min) we would like to put a page like PROCESSING during the database is busy doing its fine job. And also a sucess page appears when

Re: [PHP-DB] One more date question (NOOOOOOO) :-)

Sure -- for ($x=0;$x12;$x++) { echo option.date('F',mktime(0,0,0,(date('n')+$x),date('j'),date('Y')))./option\n; } For the day limitation, there are lots of javascripts out there to do that. Peter On Thu, 27 Feb 2003, Chris Payne wrote: Hi there everyone, Sorry about all these emails

RE: [PHP-DB] Get MySQL table schema for a dump

Ok, that works great. Now, what is the best way to echo the result. For example $connection = mysql_connect(localhost,u,p); mysql_select_db(killerspin_com, $connection); $sql = SHOW CREATE TABLE update_list; $result_id = mysql_query($sql,$connection); then what, if (mysql_num_rows($res...))

[PHP-DB] help about session

i can't start session under incule row ex: include(file.php); start_session(); it say : can't add header header already sent by...v somebody can help me? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php