Tagged Questions

-4
votes
0answers
14 views

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean

I want to Perform a query on the database, But I getting warning message. Please fix this error mysqli_multi_query($con, "SET @rownum=0; UPDATE rank SET rank1=(@rownum:=@rownum+1)ORDER BY Points ...
1
vote
1answer
22 views

Why can't I display data from four joined tables?

I'm using the following query to join two tables. Table gz_topics features basic information, such as page Title and Subtitle, while the articles for each page are stored in table ...
-4
votes
1answer
23 views

never ending syntax error in sql + mysql [closed]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Frequency', 'Cache', 'L2 Cache', 'L3 Cache', 'Cores', 'TDP', ...
0
votes
0answers
33 views

I am having a PHP error that my script is NOT catching

I have checked and rechecked my PHP script, HTML code, and SQL database table with no success at finding out what is wrong. When I submit my post on my website, the "You successfully posted." message ...
0
votes
1answer
14 views

Trying to display @mentions for a user but my query is spitting out an error

I'm trying to display @mentions for my currently logged in user but I'm getting a syntax error and I don't know what it is. My database is mysql and my query currently looks like this: $sql = "SELECT ...
-3
votes
0answers
21 views

What type of MySQL technology do PHP Data Objects (PDO) use?

So I use PDOs a lot and, maybe I haven't thoroughly read through the documentation, I don't really know what type of features they incorporate? This questions originally came up when I wanted to ...
1
vote
2answers
46 views

How to use variables in WHERE clause for a SQL SELECT query

My SQL SELECT query has 3 variables set by a HTML form, however these variables can be null: $suburb = (isset($_POST['suburb'])) ? $_POST['suburb'] : ''; $postcode = (isset($_POST['postcode'])) ...
0
votes
1answer
21 views

Saving Backbone JSON object to MySQL table with PHP

I'm saving Backbone model data, which POSTs a JSON object to my save.php file. As the model data will be for my application's users, I'd like to store unique values in a MySQL table. Currently, I'm ...
1
vote
1answer
25 views

PHP multidimensional array + MySQLi $row array data

$category = array( "Alpha", "Beta", "Gamma", "Delta", "Epsilon", "Zeta" ); for ($count = 0; $count < 5; $count++) { $query = "SELECT * FROM random_walk WHERE category = ...
0
votes
2answers
30 views

update mysql database according to the current values in it

How do I update the database according to the current values in it. I currently have the following - mysqli_query($con, "UPDATE Tasks SET completed = CASE WHEN completed == 0 THEN 1 ELSE 0 END WHERE ...
0
votes
3answers
33 views

Searching MYSQL with multiple words and ordering by relevency

I am creating a program in PHP where users submit a file and then can search for the file based off of 6 categories that they entered when they initially created the file. The categories are stored in ...
-2
votes
7answers
59 views

Return JSON from PHP file not working properly

Okay, I am trying to return stuff from a database and convert it into json and send it back to my javascript. However its not working as planned, it returns as an array on the javascript. Javascript ...
-5
votes
1answer
33 views

Parse error: syntax error, unexpected T_DOUBLE_ARROW [closed]

I am trying to display information from a MySQL database, but when I run this code, it throws this error: Parse error: syntax error, unexpected T_DOUBLE_ARROW I have tried looking around google but ...
0
votes
3answers
38 views

mysql_query inside for loop syntax error

I'm trying to get value from database, here is my code: function client() { $code=$_GET['actvcode']; $db = mysql_connect('localhost','root','0000'); if (!$db) die("Error connecting to ...
1
vote
1answer
15 views

PHP: Calling MySQL Stored Procedure with Both INPUT AND OUTPUT Parameters (NOT “INOUT”)

From PHP I would like to call a stored procedure in MySQL. The procedure takes input and output parameters -- not "INOUT" parameters. For a simple example, say I have the following stored procedure ...

1 2 3 4 5 … 4473
15 30 50 per page