I need help I have added filters to my code, they all are working fine but only month & year filter is creating confliction, although when I print the SQL in PHPMyAdmin I'm getting the desired results but not in…
I have an array of category , and this categories have many books (belongToMany) how i can get all book sorry about my English category model class category_b extends Model { protected $table = 'categoryb'; protected $attributes = array( 'lang'=>…
Looking for advice on whether I can improve my database statements or if I should start caching query results to increase performance. The schema is set up as a Many-To-Many Polymorphic relationship. I have a Videos table that contains video…
We are working on a small follow up email script and now need to determine if an email appears more than once in the query results. If the email appears only once then use email content A, if it appears…
I creeate an app on android ,database registers user correctly but no email is send out and app displays my error message "cant register user at the moment" don't know what i am doing wrong This is part of the…
Essentially, I'm trying to repair a broken WooCommerce database for a client. I have a table wp_woocommerce_order_itemmeta and all of the _product_id values are erased. I am able to get the correct ID using this select statement. It will return…
I think the problem is in the format. I have this code in the class: public DataTable CheckDate(DateTime day) { MySqlCommand command = new MySqlCommand("SELECT * FROM `appuntamenti` WHERE `date`='@date'", conn.getConnection()); command.Parameters.Add("@date", MySqlDbType.Date).Value = date; MySqlDataAdapter adapter = new MySqlDataAdapter();…
I have a problem in SQL. I want to update a value on a given row if and only if a value on another row matches a condition; then update another value on the second row. Ok it can't be…
I'm having difficulty to make a cron job on cpanel to update the state of an user if the account has been created for 5 days. It just doesn't work at all. When I program the cron job on the…
I am trying to make a java program program can takes just one row/line from phpMyAdmin database. what I mean is in the photo The problem is that I couldnt figure out how to take just the first line because…