MySql database error or errors in PHP script used for MySql

[Rogerio_Rios (Professional Support)]

At the beginning your script, so that Query with Select can recognize the variable.

[Zia_Choudhary (Zia Ur Rahman)]

Thanku for your help and suggestions m gonna try and then let u know about this
And what about

@Zia_Choudhary

And tell me script writing need professional level knowledge of PHP or basic knowledge is enough to understand php scripts and modify them

[Zia_Choudhary (Zia Ur Rahman)]

@Rogerio_Rios

This is a variable declaration that you are using to count the number of rows that will be returned from Select. Try to put it in your script and not in the Kodular block.

its not working when i used SET @row_number = 0;
and error is acurring due to ’ @ ’
i think its because it is used to assign variable in sql but not in PHP as the script is in PHP so its causing error

[Rogerio_Rios (Professional Support)]

SELECT
@c:= @c+ 1 AS linesnumber, t.yourfield1, t.yourfield2
FROM
(SELECT @c := 0) AS something,
yourtable t
It’s work
https://rextester.com/l/mysql_online_compiler

[Zia_Choudhary (Zia Ur Rahman)]

it is working when used as such but not with remove headings of columns

[Rogerio_Rios (Professional Support)]

Hey friend, explain it right. You started the topic by saying that there was an error in executing the Select command. Am I right ? You didn’t talk about removing the column names.
The error problem was solved, correct?
Removing the column names is another topic and this you will do in the Kodular blocks.

[Zia_Choudhary (Zia Ur Rahman)]

No i think u mis understand
Please have a look
I appreciate your suggestions and help its means a lot for me but i asked a little bit different thing
Here check it

@Zia_Choudhary

And currently I m facin two errors in MySQL database

@Zia_Choudhary

Query 1

SET @row_number = 0; SELECT (@row_number:=@row_number + 1) AS num, POst FROM Posts LIMIT 5;
a. Behaviour in PHP My admin

it works fine and gives the results perfectly

b. Behaviour in app(Companion)

It shows an error 400 false

@Zia_Choudhary

Query 2

SET @row_number = 0;
– without column headings
SELECT (@row_number:=@row_number + 1) AS num, Post ‘’ FROM Posts LIMIT 3;

a. Behaviour in PHP My admin

it works fine and gives the results perfectly

b. Behaviour in app(Companion)

It gives following statement

My problem was to solve these two
One is solved by your suggested query​

[Zia_Choudhary (Zia Ur Rahman)]

@Rogerio_Rios And one thing by your query the first problem is solved and the second one is still persistent
Again thanks

Edit
Please have a look if somehow it could be solved!!! Then we will b all done

[Taifun]

@Zia_Choudhary

SET @row_number = 0; SELECT (@row_number:=@row_number + 1) AS num, POst FROM Posts LIMIT 5;

concatenated queries like this are not possible without modifying the provided php script
Taifun

[Zia_Choudhary (Zia Ur Rahman)]

This post was flagged by the community and is temporarily hidden.

[Rogerio_Rios (Professional Support)]

What is the second mistake? In his post, you presented 2 errors inside Companion, because the Set command was not giving the script a correct result. The second query you inserted a comment - without collumn headings and in my view this will always give error. Well, I couldn’t find where you ask not to have the column names.

[Rogerio_Rios (Professional Support)]

@Rogerio_Rios

SELECT
@c:= @c+ 1 AS linesnumber, t.yourfield1, t.yourfield2
FROM
(SELECT @c := 0) AS something,
yourtable t

this select solved the concatenation problem

[Taifun]

@Zia_Choudhary

can u do this

you could add an autoincrement column in the table (column name could be for example id) and use a simple Select statement like this

SELECT id, Post FROM Posts LIMIT 5

Taifun

[Zia_Choudhary (Zia Ur Rahman)]

@Rogerio_Rios

• without collumn headings and in my view this will always give error.

No it works fine with php my admin and give the results perfectly
Then why its not working through app

@Rogerio_Rios

Well, I couldn’t find where you ask not to have the column names.

Sory it was my mistake i forget to add these lines
Buy i added that this is the problem i m faccing with this query and during writing forget to add a little more details
Sory for that i m gonna edit it and will add these to

[Zia_Choudhary (Zia Ur Rahman)]

Yup i can do this but in my case i m sorting data with a coloum time stamp named “latest activity”
And after ordering by this column i cannot load items 5 by 5 or 10 by 10 because i did not know the range (here i m loading data as between 5 and 10 etc ) as id column is now arranged randomly due to odering by latest ‘activity column’
That’s way i need to run this complex query

But if u have another solution then suggest me

[Zia_Choudhary (Zia Ur Rahman)]

@Rogerio_Rios

this select solved the concatenation problem

Yes it is satisfied solution to problem no 1

But now please once try to resolve the 2nd problem too
I will be very grateful to you​

[Rogerio_Rios (Professional Support)]

1-
Select field1 as ‘’ , field2 as ‘’ from table

2-
Select (@row_number:=@row_number + 1) AS ‘’, Post as ‘’ FROM Posts LIMIT 3;

This should work 100% in php script
3-Double quotes worked fine
Ultimate Version !
Select @c:= @c+1 as “”, t.CNOMEALU as “” From (Select @c := 0) as x, alunos t

[Zia_Choudhary (Zia Ur Rahman)]

Finally problem gets solved
Thank u @Rogerio_Rios for you time and suggestions
>3000
I was unable to solve this problem if u didn’t help
I have no words to express my feelings right now​
Stay blessed

[Zia_Choudhary (Zia Ur Rahman)]

And m also thankful to others too who also help me through their suggestions
Love this comunity
Here are regards to all of these
@Rogerio_Rios
@vknow360
@ShaikhSajidAli
@Taifun
Thank u gyz especially @Rogerio_Rios