do I got the wrong idea??

rayzun

if inside if
Parse error: parse error, unexpected T_ELSE

if ($determin)
{

$query = "SELECT FROM JS WHERE wrdprc LIKE $mkrs";
$good_query=mysql_query($query);
if (mysql_num_rows($good_query) == 0)
{ { $query = "SELECT FROM JS WHERE wrdprc LIKE m LIMIT 0"; }
else
{ $query = "INSERT INTO JS ( id , wrdprc , wrdnprc , pgld ) VALUES ( '', '$mkrs', '', '0' )";
$exec = mysql_query($query) or die (""); } }

}

rikmoncur

try this?


<?php 
if ($determin) 
{ $query = "SELECT * FROM `JS` WHERE `wrdprc` LIKE `$mkrs`"; 
$good_query=mysql_query($query); }
if (mysql_num_rows($good_query) == 0) 
 { $query = "SELECT * FROM `JS` WHERE `wrdprc` LIKE `m` LIMIT 0"; } 
else 
{ $query = "INSERT INTO `JS` ( `id` , `wrdprc` , `wrdnprc` , `pgld` ) VALUES ( '', '$mkrs', '', '0' )"; 
$exec = mysql_query($query) or die (""); } 
?>

thorpe

yeah... you have a few too many curly braces. you really should endent your code, makes it so much easier to read and stop erros like this happening.

if ($determin) {
	$query = "SELECT * FROM `JS` WHERE `wrdprc` LIKE `$mkrs`";
	$good_query=mysql_query($query);
	if (mysql_num_rows($good_query) == 0) {
		$query = "SELECT * FROM `JS` WHERE `wrdprc` LIKE `m` LIMIT 0";
	} else {
		$query = "INSERT INTO `JS` ( `id` , `wrdprc` , `wrdnprc` , `pgld` ) VALUES ( '', '$mkrs', '', '0' )";
		$exec = mysql_query($query) or die ("");
	} 
}

rayzun

thanks, I will keep that thought
Im using code together from other projects

Iam getting the error
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

  mysql_num_rows():

is used on my server in different pages what could this be?

thorpe

it meens your query is failing. try using mysql_error() to see why it fails. eg;

$good_query=mysql_query($query) or die(mysql_error());

hehe... maybe its not such a $good_query after all. :-p

rayzun

ya
I was coding a UPDATE query for every page load, when I got this same error

Unknown column '%E3%82%B8' in 'where clause'

for that instance a whitespace was not supposed to be between the = and `

thorpe

does that meen you know what the problem is?

rayzun

$determin .= "$harray[0]";
echo "$determin"; // this works good

if (isset($determin)) {

$query = "SELECT * FROM `JS` WHERE `wrdnprc` LIKE '$mkrs' LIMIT 1";

$good_query=mysql_query($query) or die(mysql_error());

if (mysql_num_rows($good_query) == 0) {   

    $query = "SELECT * FROM `JS` WHERE `wrdprc` LIKE 'm' LIMIT 0 , 1 ";  

} else {  

    $query = "INSERT INTO `JS` ( `id` , `wrdprc` , `wrdnprc` , `pgld` ) VALUES ('', '$mkrs', '', '0') ";

$query=mysql_query($query) or die(mysql_error());

}

No errors
BUT it is not working

had to add isset for some reason ??
checked the 3 queries in phpmyadmin they perform the query and work

My webpage has no other queries besides this one ,

basically i need to do this

if $determin
    check for entry in MySQL
if record already exist do nothing
if not add it to table JS in field wrdprc

thorpe

basically i need to do this

if $determin
check for entry in MySQL
if record already exist do nothing
if not add it to table JS in field wrdprc

then why have you got 3 queries?

rayzun

Hi
Thanks for all your input into this matter
My query is a bit more to it ...

example: apple = "$mkrs";

$query = "INSERT INTO JS ( id , wrdprc , wrdnprc , pgld ) VALUES ('', '12', '$mkrs', '0') ";

BUT

In the table JS and field wrdnprc
"apple" exists already
I dont want to INSERT any exact duplicates