Project / Support Center
Welcome, Guest. Please login or register. April 06, 2020, 11:21: PM
Home Help Search Login Register
D-Web Web Site Creator D - Web Web Site Creator On-line HTML Editor No Programming knowledge required. Web Global Net PayPal-Cart Shopping Cart System PayPal - Kart Shopping Cart System for E-Commerce over the internet, that's easy to use. Web Global Net Newsletter Manager Newsletter Manager On-line Newsletter Creator with Email Subscriber Management.
Ring Central Discount
Web Global Net Web Application & Web Development Project Center  |  Recent Posts
Pages: [1] 2 3 4 5 6 ... 10

 1 
 on: March 18, 2020, 01:48: PM 
Started by admin - Last post by admin
I'm sure there are better ways to write the SQL but this works too.

Table fields enclosed in ` ` and the queries are enclosed in  " " Separate each not statement with an AND

SELECT *  FROM `events` WHERE `event_category_type` != 'Church'

AND `event_category_type` != 'Park'

AND `event_category_type` != 'Destination Location'

ORDER BY `event_category_type`  ASC

 2 
 on: March 12, 2020, 08:43: PM 
Started by admin - Last post by admin
<strong>CLICK HERE TO REPLY TO THIS EMAIL ADDRESS - Replying to the message itself will not go anywhere :  <a href=\"{message_reply_to}\"> {message_reply_to}[/url]</strong>

4

The trick is to place forward slashes in the right place \

\ Place them as shown above in Bold red

This is how a mailto: link would look

<a href=\"mailto:{message_reply_to}\"> {class_message_reply_to}[/url]

 3 
 on: February 04, 2020, 02:38: PM 
Started by admin - Last post by admin
Go to the table you want to backup in phpadmin in this case it is country.

Next go to the trigger tab and click on add new trigger name the trigger what you want and include root@localhost in the definer.

The blue portion defines the table fields you want to copy- make sure the table is different (in this case the blue bold )
The red portion defines where the values are inserted

You do need to include the fields in the same order that the table structure is in.

INSERT INTO class
(`group_id`,
`creation_date`,
`group`,
`creation_year`,
`creation_month`)


values
(
NEW.group_id,
NEW.creation_date,
NEW.group,
NEW.creation_year,
NEW.creation_month

)

 4 
 on: January 10, 2020, 12:42: PM 
Started by Gregoryclita - Last post by Gregoryclita
закладки соль

 5 
 on: January 09, 2020, 10:19: AM 
Started by Fanielroole - Last post by Fanielroole
viagra and alcohol safe announcements
 generic viagra available
  viagra tadalafilo guestbook-add.html
 cheap generic soft viagra
- viagra aim address
 viagra 10mg or 20mg msn messenger

 6 
 on: January 03, 2020, 08:01: PM 
Started by admin - Last post by admin
AND sba_id IS NULL

this will find all fields (sba_id) that are empty

"SELECT id, year, class_year, use_reason, sba_id, country_region,  high, unique_url, city, country, st, zip FROM `group` WHERE level = 1 AND sba_id IS NULL ";

 7 
 on: January 01, 2020, 03:40: PM 
Started by admin - Last post by admin
<a href="#" onclick="javascript:window.history.back(-1);return false;"> Previous [/url]

This is useful in a listing record set when viewing a single record this will return the user to the same page in the list they were viewing.

 8 
 on: November 19, 2019, 03:15: PM 
Started by admin - Last post by admin
This I had a tough time doing and although I am sure there is a more "Correct" way to do this this is what finally worked for me after trying NOT CONTAIN, NOT LIKE and others in the where clause.

I had customers enter a fake email for certain people in their list, the email always contained person@noemail.com at the end

To eliminate those records from receiving emails I included in the mysql query the following:

WHERE RIGHT(group.contact_email,11)!='noemail.com'

The green is the table.field and the 11 is the number of characters in the noemail.com string itself.. By adding RIGHT to the expression it is saying count 11 characters from the right side of the field.

!= this means not

So the expression says - count the 11 characters from right side of the field and don't include those in the displaying results

 9 
 on: November 01, 2019, 05:46: PM 
Started by admin - Last post by admin
URL Values are call year & month

mysql_select_db($database_reuniomysql, $reuniomysql);
$query_nonactive = sprintf("SELECT class.class_id, class.class_active, class.class_level, class.email_list, class.reunion_year_current, class.reunion_month, class.creation_year, class.creation_month, class.use_reason, class.creation_date, class.reunion_date, class.reunion_year, class.high_school, class.event_active, class.class_year, class.class_military_branch, class.class_contact, class.contact_email FROM class WHERE class.class_level=1 AND class.creation_year=".$_GET[year]." AND class.creation_month=".$_GET[month]." ORDER BY class.creation_month ASC");
$nonactive = mysql_query($query_nonactive, $reuniomysql) or die(mysql_error());
$row_nonactive = mysql_fetch_assoc($nonactive);
$totalRows_nonactive = mysql_num_rows($nonactive);

Bold is how to write the query pulling the URL values year & month
encase URL variable in this format ".$_GET[month]."

Notice the quotes "' and where they are placed.

 10 
 on: October 28, 2019, 09:32: PM 
Started by admin - Last post by admin
<?php
// Show IF Conditional
if ($row_rslisting_show['ad_paid'] == 1 || $row_rsadlisting['ad_renewal'] == 1) {
?>

this will show something here if these two variables are met  

<?php }
// end show if Conditional
?>   

ad_paid = 1
and
ad_renewal = 1

I assume you can put as many variable as you wish each separated by ||

Pages: [1] 2 3 4 5 6 ... 10
Web Global Net Web Application & Web Development Project Center  |  Recent Posts


Login with username, password and session length
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!