Project / Support Center
Welcome, %1$s. Please login or register. February 28, 2024, 11:15: AM
Web Global Net Web Application & Web Development Project Center  | 
: 1 2 3 [4] 5 6 7 8 9 10

 31 
 : May 07, 2020, 07:10: PM 
admin - admin
to change a link on a specific page or area or a website use the CSS ID tase #

#listgrouplink {
    color: #00FF00;
    font-family: "Lucida Grande", "Lucida Sans Unicode", "Lucida Sans", "DejaVu Sans", Verdana, sans-serif;
} /* CSS link color Green */

      #listgrouplink:hover { color: #29DDE0; } /* CSS link hover (green) */

then use in the link href tag like this

/* CSS link colors wit ID tag #  <a id="listgrouplink" href="_new_view_group.php?ag=<?php echo $_GET['ag']; ?>"><?php echo $row_rsgroup['group_name']; ?> [/url] */

 32 
 : March 18, 2020, 01:48: PM 
admin - 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


You can also eliminates this way

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

 33 
 : March 12, 2020, 08:43: PM 
admin - 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]

 34 
 : February 04, 2020, 02:38: PM 
admin - 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

)

 35 
 : January 03, 2020, 08:01: PM 
admin - 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 ";

 36 
 : January 01, 2020, 03:40: PM 
admin - 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.

 37 
 : November 19, 2019, 03:15: PM 
admin - 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

 38 
 : November 01, 2019, 05:46: PM 
admin - 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.

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

this will show something here if either of these two variables are met  

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

 <?php
// Show IF Conditional region either url variable   
if (@$_GET['order'] == "yes" || $_GET['preview'] == "yes") {
?>

 <table width="1%" border="0">
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Model</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Size</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>Total</td>
    <td>&nbsp;</td>
  </tr>
</table>
 

<?php }
// endif Conditional either url variable
?>

ad_paid = 1
and
ad_renewal = 1

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

 40 
 : October 01, 2019, 04:41: PM 
admin - admin

<?php
  $url = htmlspecialchars($_SERVER['HTTP_REFERER']);
  echo "<a href='$url' class='SBAButton2'>Back[/url]";
?>

normally you'd use " " in the class declaration but in this case use '  ' instead


You can also use

<input type="button" value="Go Back From Whence You Came!" onclick="history.back(-1)" />

: 1 2 3 [4] 5 6 7 8 9 10
Web Global Net Web Application & Web Development Project Center  | 


Powered by MySQL Powered by PHP Valid XHTML 1.0! Valid CSS!
Sorry, the copyright must be in the template.
Please notify this forum's administrator that this site is missing the copyright message for SMF so they can rectify the situation. Display of copyright is a legal requirement. For more information on this please visit the Simple Machines website.