Try to put semicolon at the end of your query. SELECT topics.*, users.username, users.profilepic, catogories.name FROM topics INNER JOIN users ON topics.user_id = users.id INNER JOIN catogories ON topics.catogory_id = catogories.id ORDER BY create_date DESC; 18 solved how i can resolve this error as i m new to PHP and MySQL kindly help me out
If you are looking to search, you need to use the LIKE syntax, not WHERE $sql=”SELECT * FROM members WHERE FirstName LIKE ‘”. $fname .”%'”; The LIKE & % make it a wildcard. Now you said you want to search by first and last, but you only pass in your first variable and you only … Read more
Yes, it is possible. How depends on which OS you’re running. One approach is the PHP exec function to execute a external program. The command to be executed depend on the OS, as I said. Here are the command (If I’m correct, please tell me if I’m not): Debian / Ubuntu: /etc/init.d/mysql restart Mac OS … Read more
Use UNION like: SELECT id,name,add1 from mytable UNION SELECT id,name,add2 from mytable EDIT: for better performance you can use UNION ALL instead, that will give you the same result: SELECT id,name,add1 from mytable UNION ALL SELECT id,name,add2 from mytable 4 solved 1 x chen hyd 2 y bang mum [closed]
In Login Page, add this: $_SESSION[‘uid’] = $row[1]; Suppose row[1] includes the user id or username Then in the sidebar: <?php echo $_SESSION[‘uid’]; ?> I dont know what the rank is for but you can echo out the rank in a similar way as username 4 solved Retrieving username from MYSQL database [closed]
Try something like this as your select statement SELECT message, country FROM Countrys AS c INNER JOIN Messages as m on c.country_id = m.country_id; 1 solved php mysql how to select what i need from 2 tables [closed]
You query has syntax error, for each “or”, you need to put city like instead of or. In addition, remember that in most of the dbms, it is case sensitive. If you want to ignore both upper case and lower case, do it like this. I am using mysql syntax, different dbms has different functions … Read more
If you’re using MySQL 5.6.1 or higher you can use the FROM_BASE64() function. You can write your query inside file like : $query = mysqli_query($connection,”SELECT testid, setno, qnid, FROM_BASE64(question) as question FROM `table_name`”); SQL Query SELECT testid, setno, qnid, FROM_BASE64(question) as question FROM `table_name` Hope it will help you. 0 solved base64 encoded column want … Read more
All you need to do is remove the < and > characters: SELECT r1.rnr, r1.anaam FROM regisseur r1, regisseur r2 WHERE r2.anaam = ‘input last name director’ AND r1.gdatum < r2.gbdatum Here’s a working demo on SQLFiddle. Presuming you don’t have a good reason to SELECT from regisseur twice, this can be further condensed down … Read more
<SCRIPT language=”javascript”> function addRow(tableID) { var table = document.getElementById(tableID); var rowCount = table.rows.length; if(rowCount < 10){ // limit the user from creating fields more than your limits var row = table.insertRow(rowCount); var colCount = table.rows[0].cells.length; for(var i=0; i <colCount; i++) { var newcell = row.insertCell(i); newcell.innerHTML = table.rows[0].cells[i].innerHTML; } }else{ alert(“Maximum Number of Books is … Read more
try if($_SERVER[‘REQUEST_METHOD’]==”POST”){ or if(isset($_POST[‘update’])){ instead of if (isset($_POST[‘Submit’])) { the name of the submit button is update not Submit on your form also stop using mysql_* functions. If you have to use them for now, at least escape the inputs properly before inserting them to database. 1 solved Submit returning a blank page
Codeigniter and other popular frameworks like Zend, cake, Yii etc. they all provide methods and structure which to a certain extent force the developer to write code that is resistant to common exploits such as cross site scripting XSS, and SQL injection and other hacks. but everything really depends on the developer. frameworks will only … Read more
count the columns in your statement! There are seven columns but six values: INSERT INTO alumnos(legajo,nombre,apellido,curso,dni,edad,fechanc) ” + “VALUES(?,?,?,?,?,?)”); you easily forgott a questionmark(column place holder) try this: INSERT INTO alumnos(legajo,nombre,apellido,curso,dni,edad,fechanc) ” + “VALUES(?,?,?,?,?,?,?)”); solved I can create a student but it doesn’t save on mysql table. i get a console error that i can … Read more
Introduction If you are having trouble creating a student and saving it to a MySQL table, you have come to the right place. This post will provide you with a solution to your problem. We will discuss the console error you are receiving and how to troubleshoot it. By the end of this post, you … Read more
What you are really asking is that the request to details.php gets routed to index.php. You will therefore need some code in index.php to understand this request is for details. You can use this in your .htaccess file RewriteEngine On RewriteBase / RewriteCond %{REQUEST_FILENAME} !-l RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule ^(.*)$ index.php/$1 In … Read more