Is it possible to have multiple prepared statements associated with a
single mysqli object at one time?
For example:
$db = new mysqli($sqlServer, $sqlUser, $sqlPass, $sqlDB);
$query1 = $db->prepare($sql1);
$query2 = $db->prepare($sql2);
foreach ($arr as $key => $val)
if($val)
{
$que
Try doing print_r($row); in your while loop and see what exactly is in
that array.
Ken
On Tue, Apr 29, 2008 at 1:46 PM, Jon L. <[EMAIL PROTECTED]> wrote:
> I could be wrong, but I don't think table aliases continue to exist in PHP;
> only the column names.
>
> $g_name = $row["gigName"];
>
Unfortunately it is windows only (written with .NET). When I was stuck
on a windows box, it was a very nice tool. I'd use it now if it
existed on other platforms...
Ken
On Thu, May 1, 2008 at 9:30 AM, Yves Sucaet <[EMAIL PROTECTED]> wrote:
> Just like to point out http://www.sqlyog.com, an alter
I know the package you need is called php-sybase in ubuntu. It's
probably something similar in Fedora. Know that this package will only
let you do a subset of the mssql function calls. If you are just
connecting and doing a normal query, it will suffice. If you need to
do prepared statements for st
Alice, make sure the php-mssql package is installed.
# yum install php-mssql
You shouldn't have to compile php or freetds as there are packages
available to do what you want...
Ken
On Thu, Jun 12, 2008 at 11:14 AM, Wei, Alice J. <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am currently using a Linux
ECTED]> wrote:
> ________
> From: Ken Keefe [EMAIL PROTECTED]
> Sent: Thursday, June 12, 2008 1:44 PM
> To: Wei, Alice J.
> Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] PHP to MS SQL Package
>
> Alice, make sure the php-mssql package is instal
That error message tells you that you are getting closer. Next step
would be to make sure you have a connection to that system:
$ ping 192.168.10.128
Next thing I would do is see if that port is open on the server:
$ telnet 192.168.10.128 1433
If it says something about "Escape character is ...
I'm a little surprised no one else has commented on this, but for a
website that complicated, 10k is way too low. I've done work on
websites that do almost all of those things separately, but not
combined and I can tell you to have a high quality website that does
just one of the things you mention
I am trying to use mysqli's prepared statements to execute a stored
procedure that returns multiple result sets. I've been struggling with
this for some time now. I have created a short example test script that
demonstrates the problem. The script can be found here:
http://pastebin.com/YZtDCNM