MySQL help

[Limit]

i have this script:-

[code:1:68334ec501]<?php
$disable = 0;

if ($disable == 1) {
echo "Disabled";
exit;
}
?>[/code:1:68334ec501]

But i need it to look at a MySQL database and see the value in it.

I have a database called 'web' and a table in it called 'test'. In the test table there is two fields 'testname' and 'testvalue'.

and the first entry in the testname field is 'disable' and in test value '0'. However i need the script above so that when the disable value is 1 the disabled message will be displayed. Any ideas?

[littleFella]

I have a strong feeling this post is a joke

[SVB]

You need to do an SQL query to get the data from the database

[Limit]

no joke

i did this before but it did not work.

[code:1:c1073b332c]<?php
require "db.php";
$displaysql = "SELECT disable FROM test";
$displayexc = MYSQL_QUERY ($displaysql);
$disable = MYSQL_NUMROWS ($displayexc);

if ($disable == 1) {
echo "Disabled";
exit;
}
?>[/code:1:c1073b332c]

[Limit]

bump

[Limit]

bump

[hatchet]

SELECT disable FROM test WHERE id = $id
you need to tell it which row to look at.
$disable=mysql_num_rows($displayexc);

[Limit]

still doesn't work:-

[code:1:972ef73b06]<?php
require "connect.php";
$displaysql = "SELECT * FROM test WHERE value = $value";
$displayexc = MYSQL_QUERY ($displaysql);
$disable = mysql_num_rows($displayexc);

if ($disable == 1) {
echo "Disabled";
exit;
}
?>[/code:1:972ef73b06]

[Limit]

please can someone help me with this as this is the last thing a need before i launch my new website.

[hatchet]

Try this to see if you're getting anything from the mysql query
<?php
require "connect.php";
$displaysql = "SELECT * FROM test WHERE value = $value";
$displayexc = mysql_query($displaysql);
$disable = mysql_num_rows($displayexc);
echo $disable;
}
?>

[Limit]

when i do that i get:-

Notice: Undefined variable: value in test.php on line 3

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in test.php on line 5

[SVB]

Is connect.php working?

[Limit]

yep, but now i just get:-


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /test.php on line 5

[Limit]

this is what my table looks like in phpmyadmin:-

[hatchet]

Then when you connect you are not setting the initial value..
I'm assuming this is some type of list?
And it doesn't look like you have an indexed or unique value in your mysql table. Can you give me an idea of what you want the script to do? What will the page display, before and after this script.. anything else you can think of. Will there be more than one row in that particular table?

[Limit]

the table layout is going to look similar to phpBB's phpbb_config table with configuration entries.

Basically when the value in that table is 0 the webpage will show normally, but when it is 1 an under maintenance page will be shown.

The script at the very top does this but to get each page to show undermaintenance would require me having to edit every file and put the value 1 in. But i wanted to do it by database as it would be much easier.

[hatchet]

So you have a start function for each page in an include file? Could you do the select above like this..
SELECT value AS disable FROM tablename WHERE name = website_disable;
then
if($disable = 1) {
echo "Sorry this page is under maintenance";
}
else {
run your start function code
}

Now it's different if you're going to have a true / false for each page.. then you'll need someway to set the page name to send to the function above..

[Limit]

in each page there was an include to maintenance.php.

Which looked like this;-
[code:1:13a7e60d4c]<?php
$disable = 0;

if ($disable == 1) {
echo "Disabled";
exit;
}
?>[/code:1:13a7e60d4c]

[hatchet]

So am I correct in assuming that you will need a page by page maintenance script?
If so you can explode the URL (parse_url($PHP_SELF)) of each page and get the filename from that and compare that to a list that you would have to setup in the database.
Hopefully I'm not overcomplicating this

[Limit]

?