how would i check if records exist?

wil831

if i wanna check if $first and $last exists in table_names
and echo "Yes!" else "No!" how would i do this?

laserlight

Could you explain further?

It may be very clear to you what $first, $last and table_names mean, but it isnt clear to others (at least to me).

wil831

first and last are columns in table_names
before i insert new $first and $last, i would like to check if it exists in table_names first...

leatherback

Hi,

How about:

$query = "Select * from table_names where (first = $first) and (last = $last)";

$result = mysql_query($query);

$rows = mysql_num_rows($result);

if ($rows>0)
 {
 echo "Data exists";
 }
 else
  {
  echo "orry, we are all out of first and last!!";
  }

wil831

it does the echo "Sorry, we are all out of first and last!!";
even when the record exists.

leatherback

Hi,

try this:

To debug: place:
echo "number of records: ";
echo $rows;
This should show the number of rows.
Also, you could add echo $query; in the script after you have created the query, to see what it actually does. you could then parse the query in your phpadmin to check it works properly.

In the script try adding quotes around the vars: '$first' and '$last', perhaps use like instead of = in the script.

wil831

nevermind, it works now, just forgot to use mysql_select_db after i connected, thanks!

leatherback

Hi Will,

If it works, could you please mark the thread as resolved, as to save other people time to check?

There is a link at the bottom of the thread.