2. PHPRunner General questions
  3. PHP error
This topic is locked

PHP error

 		2/25/2005 05:42:02
PHPRunner General questions
jfr author

Hello,
First of all I love the tool.

But....

For ease I have created a test database.

I have created one table with 3 fields and two records.

The fields are name, first_name, country.

I want to the user to be able to edit this information.
So far so good;
When I open the index.htm page, it logges on fine, and I see 2 records in the list.

But then when I click on edit, I'm getting an error on the select query.
You can see it yourselves at;
http://www.nbbzleden.net/test/index.htm
Can you please advise.
You can also login to see how it's been set-up.

I'm using the php script to login;
username test

password test123
http://www.nbbzleden.net/phprunner.php
Thx a lot,

John
500189 2/25/2005

Hi
Problem is in SQL query

Query needs look like this:
Select `name`,

`first_name`,

`country`

From `test`
Rebuild your project with this query in step 4
If you try modyfing SQL query manually, PHPRunner sometimes fail <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3478&image=1&table=forumreplies' class='bbc_emoticon' alt=':P' />
500190 2/25/2005

Hi Zzak,
I agree that with modifying I can break it.

But I didn't even touch the SQL.
And the SQL which I need to modify, is this the standard select statement which you see while building? Or is it in one of the PHP scripts. I hope it's not the last one.
thx,

John
500191 2/25/2005

It is standard select statement which you see while building => STEP 4
but look at STEP 3 too and add fields
maybe it helps <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3480&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />
jfr author 2/25/2005

OK,
I'm one step further.

Unfortunatly it was not the SQL statement.

But if in step 6 "Edit" Page is the only box checked, it does not generate output on the edit tab in step 8. I had to enable "delete" or "add" as well. And this is exactly what I don't want.
But no more SQL error <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3481&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
One step further, how many to go...... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3481&image=2&table=forumreplies' class='bbc_emoticon' alt=':mellow:' />
John
Sergey Kornilov admin 2/25/2005

John,
when I go to http://www.nbbzleden.net/test/index.htm and click Edit I don't see error message.
Could you explain again what is the problem with Edit page?
jfr author 2/25/2005

Correct Sergey,
the error is gone, but now if you see the list, all the options are highlighted.

Meaning people can "add", "delete" and "edit".

If I just on page "step 6" put the checkmark into "edit", which I have just done, please have a look then.
Also the funny thing is that when I just check the "edit" box on step 6, no output is available in "step 8" on the edit tab.
Thx a lot for your help,

John
Sergey Kornilov admin 2/25/2005

John,
could you send me a screenshot that explains no output is available in "step 8" on the edit tab problem?