[RESOLVED] cheecking to see if something exists in a mysql table?

krrose27

I dont know to much about php and mysql, but is their a way to check if theirs something in a secific colum and if so then do one thing if not then do something else?

if(check=true)
echo 'it existsed';
else
echo 'it didnt exist';

bradgrafelman

I think we need a bit more information. Are you trying to see if ANY row in the database has a given value for a certain column? Or, do you have some ID identifying a unique row and you want to know if that specific row has the given value for the specified column?

krrose27

i have a database and then a table the table has three colums they areauth,user, ip

now what i want to know is their a way to say like:

$auth=$_GET['auth'];
if(in column auth we find the auth value)
do this
else
do this

im using this with a java application sorry i know more ava then php.

I have the connections and the select data base and all. I know tha much i know how to insert data but i have no clue how to ceck if somthing exists.

bradgrafelman

Okay, well here's the basic SQL query:

SELECT user, ip FROM myTable WHERE auth='auth_code_here'

If you're only expecting 1 row to be returned, you can add a "LIMIT 1" onto the end of that query.

After that, it's simply a matter of using [man]mysql_query/man to execute the query and something like [man]mysql_fetch_assoc/man to retrieve the row (or use this function in a while() loop to retrieve all rows matched) and use the data.

krrose27

see thatsnot what i want i just wanna see if the auth vale is found in a colum if so just return tru like a boolean dont return user or ip or anything thats just for my reffrence.

bradgrafelman

Ah, okay. Try something like this:

$query = "SELECT 1 FROM myTable WHERE auth='auth_code_here' LIMIT 1";
$exec = mysql_query($query);

$exists = (mysql_num_rows($exec) == 1 ? TRUE : FALSE);

krrose27

thank you, works wondefully

bradgrafelman

Don't forget to mark this thread resolved.

krrose27

hey sry to add, can u do something like:

$query = "SELECT 1 FROM myTable WHERE auth='auth_code_here' && state='active' LIMIT 1";

like also check one it finds the auth if it says active? yeah i just changed the degsin of my system lol. SRY

bradgrafelman

Of course you can... except you need to use 'AND' instead of '&&'.

krrose27

i recivie:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in blah/print_auths.php on line 17
false

the code:

<?php

$username="";
$password="";
$database="";

$auth=$_GET["auth"];
$ip=@$REMOTE_ADDR;
date_default_timezone_set('EST');
$date=date('l dS \of F Y h:i:s A');

mysql_connect(localhost,$username,$password) or die( "Unable to connect to server");
@mysql_select_db($database) or die( "Unable to select database");

$query = "SELECT 1 FROM auths WHERE auth=".$auth." AND state=active LIMIT 1";
$exec = mysql_query($query);
[line 17]$exists = (mysql_num_rows($exec) == 1 ? TRUE : FALSE);
if($exists){
	$sql = "INSERT INTO connections (auth,ip,time) VALUES ('$auth','$ip','$date')";
	mysql_query($sql);
	echo 'active';
}else{
	echo 'false';
}
mysql_close();

krrose27

i have the clsing tag lol didnt copy it, amy clue?

bradgrafelman

You're missing the single quotes around the string values in your query (your post above, #9, has these quotes).