 |  |  |  |  |  |  |  |
check
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
•
•
Join Date: Dec 2007
Posts: 52
Reputation: 
Solved Threads: 1
Junior Poster in Training
how do i check if a value is in my table?
like this:
INSERT INTO table_name (column1, column2,...)
VALUES (value1, value2,....)
and check if those values are in the table.
like this:
INSERT INTO table_name (column1, column2,...)
VALUES (value1, value2,....)
and check if those values are in the table.
You need to do a select query..
select * from table_name where column1="value1" and column2="value2" ...
The answers to these sort of questions are in php/mysql tutorials all over the internet.
select * from table_name where column1="value1" and column2="value2" ...
The answers to these sort of questions are in php/mysql tutorials all over the internet.
select * from table_name
this lis all the values in table .
g0 to w3schools.com this is very usefull site for bignner
this lis all the values in table .
g0 to w3schools.com this is very usefull site for bignner
Thanks
VSSP
VSSP
•
•
Join Date: Dec 2007
Posts: 52
Reputation:
Solved Threads: 1
Junior Poster in Training
•
•
•
•
Originally Posted by MickRip 
You need to do a select query..
select * from table_name where column1="value1" and column2="value2" ...
The answers to these sort of questions are in php/mysql tutorials all over the internet.
so what would it be like?
i was thinking it would be like this
elseif VALUES ('$_POST[Username]'==$_POST[Username])? this is just a guess.
•
•
Join Date: Dec 2007
Posts: 52
Reputation:
Solved Threads: 1
Junior Poster in Training
•
•
•
•
Originally Posted by vssp
select * from table_name
this lis all the values in table .
g0 to w3schools.com this is very usefull site for bignner
use this command
$res=mysql_query("select * from table name where value1= $_post['value1']");
if (mysql_num_rows($res)>0)
{
$ans="value already exist";
}
else
{
$ans="....insert command...";
}
$res=mysql_query("select * from table name where value1= $_post['value1']");
if (mysql_num_rows($res)>0)
{
$ans="value already exist";
}
else
{
$ans="....insert command...";
}
Thanks
VSSP
VSSP
•
•
Join Date: Dec 2007
Posts: 52
Reputation:
Solved Threads: 1
Junior Poster in Training
•
•
•
•
Originally Posted by vssp
use this command
$res=mysql_query("select * from table name where value1= $_post['value1']");
if (mysql_num_rows($res)>0)
{
$ans="value already exist";
}
else
{
$ans="....insert command...";
}
PHP Syntax (Toggle Plain Text)
•
•
Join Date: Dec 2007
Posts: 52
Reputation:
Solved Threads: 1
Junior Poster in Training
ok then i get this error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource.
•
•
•
•
Originally Posted by kishou
thanks dude! So then it would look like this?
ok then i get this error:PHP Syntax (Toggle Plain Text)
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource.
$res=mysql_query("SELECT * FROM registered_members where username=$_POST['Username']"); Ignorance is definitely not bliss!
*PM asking for help will be ignored*
*PM asking for help will be ignored*
 |
Similar Threads
- USB Ports not recognizing periferals (USB Devices and other Peripherals)
- Slow Network Access Not Always Due to Scheduled Tasks Check (Windows tips 'n' tweaks)
- Please Check The Errors'..Dont know what else to do (C++)
- Check items before installing for Spyware? (Viruses, Spyware and other Nasties)
- Another hijack this log to check (Viruses, Spyware and other Nasties)
- Spyware check (IT Professionals' Lounge)
- Check for Disk Errors in Windows XP (Windows tips 'n' tweaks)
- IE6 - dialogue boxes , check boxes and radio buttons work very slowly after hijacking (Viruses, Spyware and other Nasties)
- Ureaka!! I found it! Please check this log (Web Browsers)
- flash check it out (Geeks' Lounge)
Other Threads in the PHP Forum
- Previous Thread: http://localhost problem
- Next Thread: upload files
Views: 1801 | Replies: 17
| Thread Tools | Search this Thread |
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for PHP
.htaccess access ajax apache api array beginner binary broken cakephp checkbox class cms code cron curl customizableitems database date directory display download dynamic echo email error file files folder form format forms forum function functions google headmethod href htaccess html image include insert integration ip java javascript joomla jquery limit link login loop mail malfunctioning menu methods mlm mod_rewrite multiple mysql oop parse paypal pdf php problem query radio random recursion regex remote script search select server sessions sms soap source space speed sql structure syntax system table tutorial update updates upload url validation validator variable video web xml youtube
