mysql Archives - Page 44 of 73

[Solved] Use PHP to render multiple images to the browser [closed]

October 10, 2022 by Kirat

You use a while loop in to fetch the results. $coverpic=””; $sql = “SELECT filename FROM photos WHERE user=”$u””; $query = mysqli_query($db_conx, $sql); if(mysqli_num_rows($query) > 0){ while($row = mysqli_fetch_row($query)) { $filename = $row[0]; $coverpic .= ‘<img src=”https://stackoverflow.com/questions/16442747/user/”.$u.”https://stackoverflow.com/”.$filename.'” alt=”pic”>’; //notice the .= to append to the string instead of overwrite } } But if you want … Read more

[Solved] How to insert a space delimited text file into mysql using Python? [closed]

October 10, 2022 by Kirat

You need to set the delimiter to csv.reader function: csvreader = csv.reader(textfile, delimiter=”\t”) You didn’t do it in your code, so Python doesn’t split the line of your CSV file. That’s why it gives the error. If you have the file with all the columns of MySQL table, you can use LOAD DATA INFILE command. … Read more

[Solved] joins in MySQL for leave management in PHP and MySQL [closed]

October 10, 2022 by Kirat

Let’s take it step-by-step… First, the entities you’re selecting are in the leave_request table. So let’s start there: SELECT leave_request.* FROM leave_request Now, you need to know the data for the applied_by column in the desired results. So you join the staff table: SELECT applied_staff.name AS applied_by FROM leave_request INNER JOIN staff AS applied_staff ON … Read more

[Solved] How to properly optimise mysql select statement

October 10, 2022 by Kirat

Unless there’s more to the picture, why not just query everything, ordered by section, to have the A-Z: SELECT * FROM Main_Section ORDER BY section … and then process the results with one loop, which could look something like this: $sections = $connect->query(“SELECT * FROM Main_Section ORDER BY section”); while ($row = $sections->fetch_array()) { echo … Read more

[Solved] Php, mysql coding error

October 10, 2022 by Kirat

You are getting that error simple because you are using a newer version of php that does not support mysql_* functions, those functions have been depreciated and completely removed from the latest version of php. You should use mysqli prepared functions or pdo prepared statements. using mysqli to connect to database you will use it … Read more

[Solved] how to select duplicate record as one record in mysql

October 10, 2022 by Kirat

You have to concatenate the two fields, and pass them together to the group by as following select id, concat(`field1`,`field2`) as `together` from table_name group by together 1 solved how to select duplicate record as one record in mysql

[Solved] SQL SELECT looking for a name like a substring in a join

October 10, 2022 by Kirat

I would read the “not certified on any” to be a check for the existence of a row. If a matching row exists, then don’t return the employee. Only return the emplouee if a matching row doesn’t exist. How would you find a matching row, to find out if an employee is “certified on any”? … Read more

[Solved] ALL PRIVILEGES except one table in MySQL [duplicate]

October 10, 2022 by Kirat

or is there another way to grant ALL PRIVILEGES and REVOKE the special one? NO, there is not any shortcut to do this. You will have to revoke ALL PRIVILEGE from user and then GRANT for each table separately. REVOKE ALL PRIVILEGES ON db.* FROM ‘carl’@’%’; Though there is option for automating this task of … Read more

[Solved] How to retrieve the value of selected id from a table or “list” [closed]

October 10, 2022 by Kirat

The traditional and simplest approach is: Make your “list” a database table. Add a new row to that table when you want to add a product. Put the value of the PRIMARY KEY column in the URL, usually in a query string. http://example.com/products.php?product_id=123 Read that value from $_GET and use it it in a database … Read more

[Solved] invalid memory address or nil pointer dereference golang database

October 10, 2022 by Kirat

So the crash is caused by the db pointer being nil. This means code which tries to use that connection on line 40 causes a panic. rows, errrows := db.Query(… The db pointer is nil because, as Peter pointed out, http.ListenAndServe is blocking, which means nothing after it will run. Try running this example locally … Read more

[Solved] Why is it saying no database selected?

October 9, 2022 by Kirat

Your final code should be identical to: <?php $con = mysqli_connect(“localhost”, “root”, “”, “radian”); if (!$con) { exit(“Couldn’t connect: ” . mysqli_connect_error()); } mysqli_set_charset($con, “utf8”); $insert_data = “UPDATE enquiries SET ResponseDate=”” . $current_date . “”, Response=”” . $txtResponse . “”,Enquiry_No = ‘” . $_SESSION[‘ses_staff’] . “‘ WHERE Enquiry_No = ‘” . $txtStudentId . “‘”; $execute … Read more

[Solved] mysql multiple queries or foreign keys (table relations) [closed]

October 9, 2022 by Kirat

Usually It depends on how frequently you fetch which columns from multiple tables. 1.If you create many foreign keys in a table and then connect with these keys to many others then you will end up joining many tables to fetch required data. 2.So I suggest you first decide what type of data you are … Read more

[Solved] most efficient way to write this sql query?

October 9, 2022 by Kirat

This is a little more difficult because MySQL doesn’t have Row_Number() so you’ll need to simulate it. One way is use a self join and a count. You could also use the @rownumber technique described here In my example I used animal_id to find the most recent but you may want to change the JOIN … Read more