asked on
MySQL, Searching for a nonexistant record
this is a piece of a module detection script for a dynamic content engine i am making.
If a module is in the folder, it adds it to the database when the admin tool is called.
It checks to see if the module is already in the database, and if it is in the folder, but not in the database, then it adds it to the database
the problem is where it says if(!mysql_num_rows($check)
thanks a lot if you can help XD
<?php
//search for uninstalled modules
$curdir = opendir("modules");
include($connect_src);
while($dir = readdir($curdir)) {
if(strlen($dir) >= 4){
$dirstr = $dir[0].$dir[1].$dir[2].$d
if(is_dir("modules/".$dir)
$query = "SELECT dir_name FROM modules WHERE dir_name = '".$dir."'";
$check = mysql_query($query);
if(!mysql_num_rows($check)
include("modules/".$dir."/
$query = "INSERT INTO modules VALUES ('NULL','".$name."','".$di
register_module($connect_s
}
}
}
}
?>
If a module is in the folder, it adds it to the database when the admin tool is called.
It checks to see if the module is already in the database, and if it is in the folder, but not in the database, then it adds it to the database
the problem is where it says if(!mysql_num_rows($check)
thanks a lot if you can help XD
<?php
//search for uninstalled modules
$curdir = opendir("modules");
include($connect_src);
while($dir = readdir($curdir)) {
if(strlen($dir) >= 4){
$dirstr = $dir[0].$dir[1].$dir[2].$d
if(is_dir("modules/".$dir)
$query = "SELECT dir_name FROM modules WHERE dir_name = '".$dir."'";
$check = mysql_query($query);
if(!mysql_num_rows($check)
include("modules/".$dir."/
$query = "INSERT INTO modules VALUES ('NULL','".$name."','".$di
register_module($connect_s
}
}
}
}
?>
PHP
Last Comment
HitByASquirrel
ASKER
nah, I've already tried that, for some reason, it always returns TRUE, even when there is nothing that fulfills the WHERE statement
simply use
$rowcnt=mysql_num_rows($ch
if($rowcnt==0)
{
include("modules/".$dir."/
$query = "INSERT INTO modules VALUES ('NULL','".$name."','".$di
register_module($connect_s
}
and one more thing
$query = "SELECT dir_name FROM modules WHERE dir_name = '$dir'";
regards
$rowcnt=mysql_num_rows($ch
if($rowcnt==0)
{
include("modules/".$dir."/
$query = "INSERT INTO modules VALUES ('NULL','".$name."','".$di
register_module($connect_s
}
and one more thing
$query = "SELECT dir_name FROM modules WHERE dir_name = '$dir'";
regards
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER
nope, same thing as before, i think its more of a problem with the query perams rather than how i handle the result
hers the error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/waveform/public_html
hers the error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/waveform/public_html
Ok...then try
if ($row = mysql_fetch_array ($check))
Phetu
if ($row = mysql_fetch_array ($check))
Phetu
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
carchitect already mentioned that it should be '$dir' instead of '.$dir.'
:)
:)
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Just use
$res = mysql_query("SELECT COUNT(*) FROM modules WHERE dir_name = '$dir'");
$count = mysql_fetch_row($res);
if (!$count[0]) {
do_your_stuff();
}
-baeuml
$res = mysql_query("SELECT COUNT(*) FROM modules WHERE dir_name = '$dir'");
$count = mysql_fetch_row($res);
if (!$count[0]) {
do_your_stuff();
}
-baeuml
$query = "SELECT dir_name FROM modules WHERE dir_name = '".$dir."'";
sorry but use this....
regards
sorry but use this....
regards
ASKER
it didn't fix it, but MySQL said that ther was no databse connection, so i moved the connect to inside the loop, and now it works ^_^ thanks guys!
<?
//search for uninstalled modules
$curdir = opendir("modules");
while($dir = readdir($curdir)) {
if(strlen($dir) >= 4){
$dirstr = $dir[0].$dir[1].$dir[2].$d
if(is_dir("modules/".$dir)
include($connect_src);
$query = "SELECT dir_name FROM modules WHERE dir_name = '".$dir."'";
$check = mysql_query($query) OR DIE("BAD QUERY '$query' Mysql said : ".mysql_error());
$check_res = mysql_num_rows($check);
if($check_res == 0) {
include("modules/".$dir."/
$query = "INSERT INTO modules VALUES ('NULL','".$name."','".$di
register_module($connect_s
}
}
}
}
<?
//search for uninstalled modules
$curdir = opendir("modules");
while($dir = readdir($curdir)) {
if(strlen($dir) >= 4){
$dirstr = $dir[0].$dir[1].$dir[2].$d
if(is_dir("modules/".$dir)
include($connect_src);
$query = "SELECT dir_name FROM modules WHERE dir_name = '".$dir."'";
$check = mysql_query($query) OR DIE("BAD QUERY '$query' Mysql said : ".mysql_error());
$check_res = mysql_num_rows($check);
if($check_res == 0) {
include("modules/".$dir."/
$query = "INSERT INTO modules VALUES ('NULL','".$name."','".$di
register_module($connect_s
}
}
}
}
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
ok, heres the more efficient code:
<?
//search for uninstalled modules
$curdir = opendir("modules");
while($dir = readdir($curdir)) {
if(strlen($dir) >= 4){
$dirstr = $dir[0].$dir[1].$dir[2].$d
if(is_dir("modules/".$dir)
include($connect_src);
$check = mysql_query("SELECT dir_name FROM modules WHERE dir_name = '".$dir."'") OR DIE("BAD QUERY '$query' Mysql said : ".mysql_error());
$check_res = mysql_num_rows($check);
if(!$check_res) {
include("modules/".$dir."/
$query = "INSERT INTO modules VALUES ('NULL','".$name."','".$di
register_module($connect_s
}
}
}
}
<?
//search for uninstalled modules
$curdir = opendir("modules");
while($dir = readdir($curdir)) {
if(strlen($dir) >= 4){
$dirstr = $dir[0].$dir[1].$dir[2].$d
if(is_dir("modules/".$dir)
include($connect_src);
$check = mysql_query("SELECT dir_name FROM modules WHERE dir_name = '".$dir."'") OR DIE("BAD QUERY '$query' Mysql said : ".mysql_error());
$check_res = mysql_num_rows($check);
if(!$check_res) {
include("modules/".$dir."/
$query = "INSERT INTO modules VALUES ('NULL','".$name."','".$di
register_module($connect_s
}
}
}
}
You should use:
if ($check = mysql_query($query))
to check if you got something!
Hth
Phetu