Lengkap

1 line php mysql command

We need a small 1 line code in php to work with mysql database and grab the records from 2 tables at once only.

Currently we are using

$rs=mysql_query("select * from abc");

while($arr=mysql_fetch_array($rs)) {

$rs1=mysql_query("select * from def where fieldname='$arr[1]'");

if(mysql_num_rows($rs1)<1) {

echo "Field Ok : $arr[1]";

}

}

Now we need to run these 2 queries in 1 only

like $rs=mysql_query("select * from abc where name='if(!mysql_query('select * from def where fieldname=name')'")

I know it is possible to do it some way but don't know exactly how to do it .

If you can do it just make a bid .

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

linux

Kemahiran: Kejuruteraan, MySQL, PHP, Kejuruteraan Perisian, Ujian Perisian

Lihat lagi: u line, rs components, make line, in this line, php command, one line php, code web php, run linux command php, mysql grab, run command linux, run php command, mysql select platform, mysql_num_rows, php mysql select exist, php run command, command web, command software, abc php mysql, linux arr, small grab

Tentang Majikan:
( 162 ulasan ) India

ID Projek: #3472298

Dianugerahkan kepada:

blexvw

See private message.

$2 USD dalam sehari
(17 Ulasan)
3.9

9 pekerja bebas membida secara purata $4 untuk pekerjaan ini

Return0Projects

See private message.

$4.25 USD dalam sehari
(91 Ulasan)
5.3
ffunch

See private message.

$3.4 USD dalam sehari
(17 Ulasan)
5.1
genetrix

See private message.

$4.25 USD dalam sehari
(26 Ulasan)
4.2
cebusolutionsco

See private message.

$4.25 USD dalam sehari
(6 Ulasan)
2.9
davidsch

See private message.

$4.25 USD dalam sehari
(2 Ulasan)
2.2
andyyy

See private message.

$4.25 USD dalam sehari
(9 Ulasan)
1.9
samveljan

See private message.

$4.25 USD dalam sehari
(2 Ulasan)
0.5
sonsamvw

See private message.

$3.4 USD dalam sehari
(6 Ulasan)
0.0