Hello,
(I’m sorry my English is bad)
MySQL table
[php]$ids=“1, 3, 4”; // Sample in IDs
if(table==‘MDU4’){
echo “Yes, MDU4 available”;
}else{
echo “No, MDU4 not available”;
}
[/php]
Not available or available in the IDs
These control how do I do it?
I recruits
Thanks
[php]<?php
// Place db host name. Sometimes “localhost” but
// sometimes looks like this: >> ???mysql??.someserver.net
$db_host = “localhost”;
// Place the username for the MySQL database here
$db_username = “username_here”;
// Place the password for the MySQL database here
$db_pass = “password_here”;
// Place the name for the MySQL database here
$db_name = “database_name_here”;
// Run the connection here
$con = mysql_connect("$db_host","$db_username","$db_pass") or die (“Couldn’t connect to server.”);
if (!$con) {
die('Could not connect: ’ . mysql_error());}
mysql_select_db("$db_name", $con);
$sql = “select * from table_name WHERE uydu_lnb_tipi = ‘MDU4’”;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$rowc=$row[‘uydu_lnb_tipi’];
if($rowc==‘MDU4’){
echo “Yes, MDU4 available”;
}else{
echo “No, MDU4 not available”;
}
?>[/php]
try that to understand mysql
Thank you for your reply
MySQL connection exists
according to IDs
I just want to do a search in these IDs “$ids=“1, 3, 4”;”
All tables is not in the
Thank you again
ok try this
[php]<?php
// Place db host name. Sometimes “localhost” but
// sometimes looks like this: >> ???mysql??.someserver.net
$db_host = “localhost”;
// Place the username for the MySQL database here
$db_username = “username_here”;
// Place the password for the MySQL database here
$db_pass = “password_here”;
// Place the name for the MySQL database here
$db_name = “database_name_here”;
// Run the connection here
$con = mysql_connect("$db_host","$db_username","$db_pass") or die (“Couldn’t connect to server.”);
if (!$con) {
die('Could not connect: ’ . mysql_error());}
mysql_select_db("$db_name", $con);
$sql = “select * from table_name WHERE id IN (1, 3, 4) AND uydu_lnb_tipi = ‘MDU4’”;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$rowc=$row[‘uydu_lnb_tipi’];
if($rowc==‘MDU4’){
echo “Yes, MDU4 available”;
}else{
echo “No, MDU4 not available”;
}
?>[/php]
Okay, thank you very very much
your welcome