Search:

Help!!! I'm still stuck on this, surely someone has loaded 2 datasets on a page before????

Surely someone must have tried to load 2 datasets before, has no-one come across this before?

Any ideas, anyone, I'm really stuck here, can't find anything on google that seems to suggest why this might be occurring :-(

Ok, so I've just tried the following:



$result=get_dataset($db1,"call sp_filter_issues_reduced_view(".$subsectorid.",".$bondticker.",".$currencyid.",".$countryid.")");...

Its a stored procedure, so it won't mean anything to you, but its correct, it has been working absolutely fine, up until I started changing the php.

The SQL has not been changed at all, it works...

oddly, if I use the get_dataset function (which is essentially the same code), I just get:

Fatal error: Call to a member function fetch_assoc() on a non-object in FILE PATH\functions.php on line...

Not sure why my bit double posted there!

But yes it does return an error, which makes sense, given the error message I was getting before.

But why?

The SQL is correct, even if I hard code...

Having played around a bit, I've still go absolutely nowhere, so I'd really appreciate any help...

In my efforts to try and get things working, I've tried to re-look at the function that converts...

Having played around a bit, I've still go absolutely nowhere, so I'd really appreciate any help...

In my efforts to try and get things working, I've tried to re-look at the function that converts...

Yep, fair point! This is the error:

<b>Warning</b>: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in <b>C:\FILE PATH\functions.php</b> on line <b>110</b><br />
...

...actually...perhaps more embarrassing...it doesn't work, I made the change, but re-loaded by backup copy (with very old code), the updated code unfortunately still does not work :-(

Interestingly if I comment out the code to add the buttons, but run the rest, the file size doesn't grow, so this suggests my theory is correct.

That said it doesn't explain why the file size...

I have some code that fires on a button press, which deletes any existing buttons, then adds a series of new buttons. I'm not 100% sure this is what is causing the file size to increase dramatically...

Great thank you, I will have a look through that!

Hmm, I tried searching on calendar, there are 4 pages of hits, but I can't see one that seems to refer to this (well not obviously anyway) :-(

I changed the code around quite a bit in between events, so I suspect that did occur. Either way, I'll mark this as resolved now :-)

I have some code that loops through a series of rows, the data comes from a MySQL database and when a query button is clicked the code fires and a command button is created on each row.

The name...

Um yes that fixed it...I feel quite embarrassed not to have noticed that myself!!!

I tried that, that made no difference :-(

However I re-wrote a separate function for opening the recordset:

Public Function open_recordset(SQL_String As String, Database_Connection As...

I know there are hundreds of examples around, for some reason none work for me...

I have a connection to a MYSQL database, which worked fine, but when trying to tidy up the code it stopped...

I've seen plenty of examples of how to do this and for some reason non seem to work for me.

On test.php I have:

$result=get_dataset($db1,"call...

Ok...all other problems aside...the key issue here (I think) is that now I'm only using the following line once:

$db1 = new mysqli($server_name, $user_name, $password, $database_name);

Only the...

I tried using the global, but that unfortunately doesn't seem to make any difference :-(

Ok, now I think I've confused myself! I tried to do what you said about only having one connection at the start, then closing it at the end, but I've done something wrong.

Here is the code:
...

I'm getting the following error:

Fatal error: Maximum execution time of 30 seconds exceeded in \SERVER_PATH\functions.php on line 19

(where SERVER_PATH is the actual path).

I can't work out...

I don't know if this is the neatest way...but this seems to work:

if (isset($_POST["btnupdate"]))
{
include_once('reduced_view_issues.php');

$irow=0;
foreach ($_POST['issueid'] as $result) {...

I have a form with an update button (btnupdate), which, when clicked triggers the php script 'select_issue3'php'. This is the section of code that I'm struggling with:

if...

Yep that makes sense, makes things much neater!

Got it!

One of those really frustrating ones that you feel you should have spotted straight away, but a day or two away seems to have done the trick...

When the bonddescriptiom array gets...

Hmm, that doesn't appear to work.

I'm not sure if it will help, but here is the initial page:

<head>
<title>Issues- Reduced View</title>
</head>
<body marginheight="0" topmargin="0"...

Here is 'select_issue2.php', I've included the whole page, as its just one form, which I believe is posting correctly (bar the issues mentioned above):

<html>
<head>
<title>View Issues</title>...

I have a series of webforms, that all look at the following .php script when a button is clicked (i.e. form action is set to post).

The script is firing, so this works correctly, however the...

Oooops!

Yeah, sorry, should have spotted that.

I've learnt something new today, I never realised you could have multiple forms on a single html page!

That will help me out quite a lot, many...

So you mean like this:

echo "<form>";
echo "<input type='submit' width='100%' id='bonddescription' name='bonddescription[]' value='" .$row['description']. "'><input type='hidden' id='issueid'...

Yep, which confuses me!

I can do this with checkboxes, but I can not find a single example of people doing this without checkboxes, which is odd as this scenario must come up all the time.

I am trying to submit a value, based on a button click, here is the php code for the button:

echo "<input type='submit' width='100%' id='bonddescription' name='bonddescription[]' value='"...

Ok cool, I'm not familiar with explain, so I'll educate myself on that, looks like it could be quite useful :-)

That aside, would that explain why the performance in MySQL Query Analizer is fine,...

Ok, solved it!

I created one new function, get_sub_dataset (which is for the inner loop), then I adapted my existing function for drop down/list boxes, here is the code:

function...

Yeah, I think thats what I meant, was really struggling to get my head around it last night. If it helps, the real world example is as follows (its for a bond trading system):

There is a list of...