Devam Ediyor

Fix MySQL query

I've got a query thats running, but I'm not getting the state field to populate.

looking to spend no more then 10.00 on this. and trying to get it done within an hour.

I've got a query thats running, but I'm not getting the state field to populate.

looking to spend no more then 10.00 on this. and trying to get it done within an hour.

the query is listed below:


$result = @mysql_query("SELECT * FROM `services` LIMIT 15");
echo "<tr><th>Name</th><th>State</th><th>Description</th></tr>";
while($row = mysql_fetch_array($result)){
$result2 = $row['category_id'];
$result3 = @mysql_query("SELECT site_id from `service_categories` where category_id = '$result2'");
$state = @mysql_query("SELECT * from `sites` where site_id = '$result3'");

echo mysql_error();
echo "<tr><td>" . $row['name']. "</td>";
echo "<td>" . $state['state']. "</td>";
echo "<td>". $row['long_desc']. "</td></tr>";
}

Beceriler: MySQL, PHP

Daha fazlasını görün: n query, mysql query, fix mysql query, mysql running, fix query, query query, mysql field, query mysql, mysql populate, mysql fix 2013 query, query mysql con ajax, parent child query mysql, remote query mysql, bash script query mysql database, create update query mysql, mysql fix, oscommerce mysql fix, query mysql data php entries, query mysql database information

İşveren Hakkında:
( 1 değerlendirme ) Franklin, United States

Proje NO: #702556

4 freelancer bu iş için ortalamada 30$ teklif veriyor

kommandant

ok let's fix

in 0 gün içinde30$ USD
(23 Değerlendirme)
4.8
skorpland

can do it immediately. thanks

in 0 gün içinde30$ USD
(15 Değerlendirme)
4.5
jigneshprajapati

Hi, I can do this task within given time period.

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
zakiahmad

Dear Sir, We are here to solve your problems. Can you give me some more details about the problem you are facing. We can sort out with in short time with in minutes. Thanks in advance. Waiting for your response. Thanks Daha fazlası

in 0 gün içinde30$ USD
(1 Değerlendirme)
0.0