Jump to content

yanti

Members
 View Profile  See their activity

  • Posts

    43

  • Joined

  • Last visited

 Content Type 

Posts posted by yanti

    Delete data with multiple database

    in MySQL Help

    Posted

    Hi,

     

    I had this problem which deleting data within 2 different database. My code is below:

     

    SELECT b.* FROM 33080_cdr.mt_1201 a INNER JOIN mot.mot9_member_on b ON a.mobile_no=b.mobile WHERE a.dn_status='psanumberbarred'

     

    this will select all the data that i want to delete. please help me how to delete the selected result.

     

    thank you  :(

    Error Report: ABUSE [IP Address]

    in Apache HTTP Server

    Posted

    hi...i have a question to ask..

     

    i got this report saying that my IP address was abuse which has been detected by other people. they complaining that my IP has been detected to breach their network.

     

    since im new in this matter, it would be great to have an advice from all of you.

     

    how can i fix this problem??

     

    thank you

    use IP beside domain name

    in Apache HTTP Server

    Posted

    hi, i got this problem...

     

    i already had a domain name....my question  is beside using that domain name, can i use an IP address to open my website? For example:

     

    My current domain name : www.slt.com/myfiles

    I would like to use: XXX.XXX.XXX/myfiles

     

    *XXX.XXX.XXX contains number for IP address

     

    tq

    UPDATE db from csv/txt files using php

    in MySQL Help

    Posted

    HI everyone,

     

    Does anyone can help me to update db from .csv / .txt files into mysql using php script.

     

    My code is like below:

     

    link = mysql_connect($dbhost, $dbuser, $dbpassword) or die('Could not
connect: ' . mysql_error());
mysql_select_db ($dbname);
$handle = fopen("/var/www/httpdocs/molog.csv", "r");

// loop content of csv file, using comma as delemiter
while (($data = fgetcsv($handle, 1000, ",")) !== false) {
$timestamp = $data[1];
$mobile_no = (int)$data[2];
$message_text = ($data[3]);
//$price2 = floatval($data[2]);

$query = 'SELECT id_pengguna FROM test_maklumat_pengguna';
if (!$result = mysql_query($query)) {
continue;
}

if ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
// entry exists update
[b]$query = "UPDATE test_maklumat_pengguna SET no_tel_penjaga='$mobile_no', no_tel_murid='mobile_no'
WHERE id=$id";[/b]

mysql_query($query);
if (mysql_affected_rows() <= 0) {
// no rows where affected by update query
}
} else {
// entry don't exists continue or insert...
}

mysql_free_result($result);
}

fclose($handle);
mysql_close($link);

     

    My problem was, i want to update 2 fields which had same data type based on passport no of the customer.

    My code is wrong i guess.

    Please help me on this...thank you

    checking for available data

    in PHP Coding Help

    Posted

    sorry for the lack of info. by the way, i want to match the input with database. if match, message saying that u are registered. if not, it will display a message to ask them to register. whenever i run the code, seems like checking part doesnt work.

    checking for available data

    in PHP Coding Help

    Posted

    hi guys, i had this code to check the match data and display the message.

    seems like it doesnt work. 

    mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");


$num=$_POST['txtMobile'];
$sql = mysql_query("SELECT * FROM $tbl_name WHERE Mobile='$num'");
$result = mysql_query($sql);
$count=mysql_num_rows($result);

if($count==1){
echo "You are a member of Roadwinner.";
}
else {
echo "Sorry, you are not a member of Roadwinner. To register as a member, please send via sms, ON SPOT send to 32425."; 
}

     

    free webmail

    in Miscellaneous

    Posted

    hi guys, i need a suggestion from all of u about free webmail for linux. is there any good and easy setup for that application?? pls give any suitable link if available.

    pls guide me on this coz i need it so badly. thanks guys.

    display database in html table...

    in MySQL Help

    Posted

    :-[

    pls check on this code....it doesnt display any data from database...

     

    <?php include('/include/dbConnection.php'); 
$result = mysql_query("SELECT * FROM ucapan ORDER BY datetime");
while($row = mysql_fetch_array($result))
?>
  <tr>
    <td><?php echo $row['id'] ?> </td>
    <td><?php echo $row['datetime'] ?> </td>
    <td><?php echo $row['ucapan'] ?> </td>
    <td><?php echo $row['sender'] ?> </td>
  </tr>
</table>
<? mysql_close($con);?>

     

    this is code to display

     

    below is code for html table

    <body>
<table width="100%" border="1" class="InternalHeader">
  <tr>
    <td>LIST OF SMS UCAPAN</td>
    <td> </td>
  </tr>
</table>
<p> </p>
<table width="100%" border="1" class="NormalTableTwo">
  <tr>
    <td>NO</td>
    <td>DATE TIME</td>
    <td>UCAPAN</td>
    <td>SENDER</td>
  </tr>

     

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.