mysql_connect
$con = mysql_connect("localhost","root","ednalan");
mysql_select_db("dbednalan", $con);
$sql = mysql_query("select * from dir_buscoupon WHERE busid = '{$_GET['busid']}'");
$rs = mysql_fetch_array($sql);
$id = $rs["id"];
$img = $rs["img"];
mysql_fetch_array
//1. list records where condition
$sql = mysql_query("select * from registrations WHERE id='$id'" ORDER BY asign_number Asc); ///////DESC Limit 5";
$rs = mysql_fetch_array($sql);
$id = $rs["id"];
$email = $rs["email"];
//2. while loop
define("REGISTRATION", "registration");
$sql_welcome = "SELECT * FROM ".REGISTRATION;
$sql_result = mysql_query($sql_welcome) or die("Could not connect");
while ($sql_row= mysql_fetch_array($sql_result, MYSQL_ASSOC)){
echo $sql_row['welcome'];
}
$sql="Select * From dbisubcategory";
$db_query=mysql_query($sql) or die("Could not requery");
while ($result=mysql_fetch_array($db_query, MYSQL_ASSOC))
{
$About=$result['id'];
echo($About);
}
//3 where condition
$result=mysql_query("SELECT * FROM gb_users where status='admin'") or die('Error 3- No database found.');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$mail=$row['email'];
//4. Define table in view records in table
define("ABOUT", "tblabout");
$sql_announcement = "SELECT * FROM ".ABOUT." WHERE id=4";
$sql_result = mysql_query($sql_announcement) or die("Could not connect");
echo "
";
while ($sql_row= mysql_fetch_array($sql_result, MYSQL_ASSOC)){
echo "
$sql_row[About] |
";
}
echo "
";
//5 get variables
$sql = mysql_query("select * from dir_buscoupon WHERE busid = '{$_GET['busid']}' AND id = '{$_GET['id']}'");
$rs = mysql_fetch_array($sql);
$id = $rs["id"];
$img = $rs["img"];
mysql_fetch_assoc
$qry = mysql_query("SELECT * FROM events WHERE id = '$event_id'") or die(mysql_error());
$rows = mysql_fetch_assoc($qry);
$event = $rows['name'];
mysql_num_rows
$sqld = "SELECT * FROM dir_coupon_print WHERE busid = '{$_GET['busid']}' AND userid = '{$_GET['iuser']}'";
$result = mysql_query($sqld);
$total = mysql_num_rows($result);//total
//echo $total;
if (mysql_num_rows($result)>0){ //no records founds
while ($rw = mysql_fetch_array($result, MYSQL_ASSOC)){
if (($dateadd >! $rw['dateexpire'])) {
echo "You already consume coupon for this business. wait 24 hours before printing the coupon again. ";
}else{
updateCoupon($rw['id']); //UPDATE RECORDS
}
}
}else {
insertCoupon($record); //INSERT RECORDS
}