How would I assign the output of a query into variables? I have the
following code:
$sql = "SELECT caa44340041, caa442400042 FROM caa44340, caa44240 WHERE
caa443400018 = caa442400018; // THE QUERY ITSELF TO SELECT THE DATA
$result = ifx_query($sql, $connect_id) or die ("couldn't execute the
que
This could also be caused by a mismatch in the fields. Try opening up your
SQL Management Studio and then paste your INSERT statement into a new query,
execute it and see if it works.
On 4/26/07, Gustav Wiberg <[EMAIL PROTECTED]> wrote:
Hi again!
Maybe it's something about rights for the IUSR
How does it "not" work?
On 5/9/07, Gustav Wiberg <[EMAIL PROTECTED]> wrote:
Hi!
I can only view html-files.. PHP don't seem to work?
Windows 2003 Server, IIS 6... PHP 5.2...
/Gustav
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I think what you're asking is how can you have a form pull data from your
database, populate the form, but then have fields to the side so the user
and update the database based on the user input.
Kind of like a "Change my personal information" page.
I would do it like this:
1. Write your quer
If you set mssql.secure_connection = On, is there a way in PHP where you can
then retrieve the username of the person that is trying to update the
database?
On 5/30/07, Frank M. Kromann <[EMAIL PROTECTED]> wrote:
use the mssql.secure_connection = On in your php.ini file and make sure
the
IIS us
I know you don't need it to connect/update the database. I was thinking
more along the lines of using it for an event logging type of scenario.
User A opens and processes an order. Upon completion User A saves the order
with its new status. Would it be possible to extract who User A is by
pull
Well, it looks like you're trying to get your results in an array and run
the query all at the same time. Also, I believe you need to put the variable
in your SELECT statement inside of some single quotes.
Try something like this:
$query = "SELECT * FROM '$table_name' ORDER BY DESC";
$result = my
>
> Sukhwinder,
I would suggest trying something simple like adding a variable to see if
your page posted. Then, if it has run a simple Javascript function to
redirect your page.
Are you sure it's not something in your code?
I am also using IE/IIS/PHP and I have a form that on submission closes the
page and opens up a new window displaying "Your data has been saved" and it
does not create 2 rows in my MSSQL database.
Dan
>
> How do you specify the value of the option?
>
Or if you are working with values from a database you could do something
simple like:
--SELECT--\n";
foreach ($name as $n)
{
if ($n['full_name'] == $_POST['name'])
echo "{$n['full_name']}\n";
else
e
10 matches
Mail list logo
