Sql syntax inside php

sql syntax in php

[buildersweb]

I want to insert an sql query into an article using php

The sql query is simple .. i just dont know haw to make the syntax in order to call it to the article


the sql is

SELECT COUNT( fullname )
FROM table
WHERE (
fullname = 'myname'
)
AND (
STATUS = '1'
) 

I made a lot of test but none was correct .


Can i have a little help on that?

[Furiat]

Too little information...
[Edited out the stupid stuff I wrote]

Do you want to:
1. Call this query and display the results? If so: what is the SQL server you are using?
2. Show this query to the users? In HTML or some other form of text file?
3. Something totally different?

[Matthew1980]

Hi there buildersweb,

Ok, tell me if i have understood you correctly first; you would like to know how to show the data returned from that query to the user using php/html - is this about right?

If so, we can try to help!

Cheers,
MRb