[PHP-DB] alphanumeric
the ctype_alnum is experimental. is there an easy way wherein i can identify if the input is an alphanumeric? thanks for your help.
[PHP-DB] SQL error:
hello!!! i'm getting this error. what does this mean? hope someone can help. i'm using sql7 in NT4 server Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_DEPT'., SQL state S0002 in SQLExecDirect in F:\Web
[PHP-DB] delay script
hello! does anyone knows how to delay a display of a certain page ... for example, if i will click on "logout" button, it will show a page which will say "logging out" then after 5 seconds it will redirect to the login page. thanks =) -- 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 PROTECTED]
[PHP-DB] delay script
hello! does anyone knows how to delay a display of a certain page ... for example, if i will click on logout button, it will show a page which will say logging out then after 5 seconds it will redirect to the login page. thanks =)
[PHP-DB] mssql_fetch_array problem
Thanks for all your answers, but, they still seem not to work. In my query, the value of countryname is retrieved as expected but the value of countryid is not. There seems to be no value retrieved for countryid. I am using PHP4 on IIS4 on an NT machine with SQL Server 7 as the database. countryname is of type varchar while countryid is type int, indentity, auto_increment. I tried listing them by printing the resultset but countryid still does not have any value. This could be a quirk that some of you experienced and I sure would like to hear how you overcame this. Thanks. I am posting again the code snippet below: ? $country_sql = select countryname, countryid from TBL_COUNTRY; if ($country_query = mssql_query($country_sql)) { while ($myrow = mssql_fetch_array($country_query)) { $countryid = $myrow[countryid]; $countryname = $myrow[countryname]; print countryid is . $countryid . ,countryname is . $countryname . br; } } ? -- 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 PROTECTED]
Re: [PHP-DB] mssql_fetch_array problem
Thanks for all your answers, but, they still seem not to work. In my query, the value of countryname is retrieved as expected but the value of countryid is not. There seems to be no value retrieved for countryid. I am using PHP4 on IIS4 on an NT machine with SQL Server 7 as the database. countryname is of type varchar while countryid is type int, indentity, auto_increment. I tried listing them by printing the resultset but countryid still does not have any value. This could be a quirk that some of you experienced and I sure would like to hear how you overcame this. I am posting again the code snippet below: ? $country_sql = select countryname, countryid from TBL_COUNTRY; if ($country_query = mssql_query($country_sql)) { while ($myrow = mssql_fetch_array($country_query)) { $countryid = $myrow[countryid]; $countryname = $myrow[countryname]; print countryid is . $countryid . ,countryname is . $countryname . br; } } ? Thanks. -- 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 PROTECTED]
[PHP-DB] mssql_fetch_array - still not working fine
Thanks for all your answers, but, they still seem not to work. In my query, the value of countryname is retrieved as expected but the value of countryid is not. There seems to be no value retrieved for countryid. I am using PHP4 on IIS4 on an NT machine with SQL Server 7 as the database. countryname is of type varchar while countryid is type int, indentity, auto_increment. I tried listing them by printing the resultset but countryid still does not have any value. This could be a quirk that some of you experienced and I sure would like to hear how you overcame this. I am posting again the code snippet below: ? $country_sql = select countryname, countryid from TBL_COUNTRY; if ($country_query = mssql_query($country_sql)) { while ($myrow = mssql_fetch_array($country_query)) { $countryid = $myrow[countryid]; $countryname = $myrow[countryname]; print countryid is . $countryid . ,countryname is . $countryname . br; } } ? Thanks. -- 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 PROTECTED]
[PHP-DB] mssql_fetch_array problem
hello all, hope someone could help me it seems that the mssql_fetch_array did not work as it should when the data type to be fetch is an integer ... is there any work around for this? Below is my script ... $country_sql = select countryname, countryid from TBL_COUNTRY; if ($country_query = mssql_query($country_sql)) { while ($myrow = mssql_fetch_array($country_query)) if ($country == $myrow[countryid]) { print option value= . $myrow[countryid] . selected . $countryid . /option; } else { print option value= . $myrow[countryid] . . $countryid . /option; } } } Thanks! -- 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 PROTECTED]
[PHP-DB] IMPORT DATA
hello all, did anyone know on how to import data from one database to another using Mysql? Thanks
[PHP-DB] nobody header
hello, i hope you could help me with this, the script below gives me a from header = Nobody; and the $from which is supposed to be the header has been included in the body of the email. How can i make the $from to be placed in the header? $from = [EMAIL PROTECTED]; $subject = Changes on employee's personal data\n\n; $message = $message.Changes on Employee's Personal Data since the last evaluation\n\n; $message = $message.Employee's Name: $emplname, $empfname, $empmname\n; $message = $message.Address: $address\n; $message = $message.Telephone Number: $telno\n; $message = $message.Civll Status: $civilstatus\n\n; $message = $message.Name/s and Birthday/s of children born within the last 6 months\n; $message = $message.Name: $name1 $name2 $name3\n; $message = $message.Birthday: $bday1 $bday2 $bday3\n; mail([EMAIL PROTECTED], $subject, $message,$from); thanx :)
[PHP-DB] PROBLEM IN INSERTING TEXT WITH SINGLE QUOTE
Hello all, I am having a problem in inserting text with apostrophe to mysql database. When a user fills out a form field that includes an apostrophe ex. Jen's , the verify screen shows it as Jen\'s and it is then input into the database as Jen\'s - automatically adding the backslash. The problem is that when the record is pulled out of the MySQL database into my display script it also shows up as Jen\'s - with the backslash - but I want viewers to see it as Jen's - without the slash. Then, if I modify the record and don't take out the slash, it adds an additional slash so I wind up with Jen\\'s. Can someone help me with my problem? Thanks in advance, Jen
[PHP-DB] Can't recognize new line
It works! Thanks for the help! Anyway, I hope you won't mind if I'll ask you another question, when the text type is pulled out from the MySQL database into my display script it can't recognize the new line. It diplays the text continuously. Ex. Has He increased his knowledge in his field, the business and its operations since his last evaluation? Has He acquired new skills; upgraded his skills or improved his competence level since his last evaluation? it displays Has He increased his knowledge in his field, the business and its operations since his last evaluation? Has He acquired new skills; upgraded his skills or improved his competence level since his last evaluation? Jen =) -- 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 PROTECTED]