Jiaxin

Hi, I got this error. Please help. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in $result_1= mysqli_query($link, "SELECT $criteria FROM table ORDER BY '".$crieria."' ASC); $array1 = array(); while($row = mysqli_fetch_array($result_1)){ array_push($array1, "$row[0]->$criteria", "$row[5]->$criteria" , "$row[10]->$criteria"); }

Hi, i got this error. Please help. Fatal error: Call to undefined function mysqli_list_fields() This is my code, <?php include 'dbFunctions'; $fields = mysqli_list_fields("fyp", "criteria", $link); $columns = mysqli_num_fields($fields); ?> <form method="post" action="doSelectCriteria.php">; <select name = criteria>; <?php for ($i = 0; $i < $columns; $i++) { echo "<option value='".mysqli_field_name($fields, …

Hi, I need help to go about doing this. If I have a table, in the database containing fruits, price, quantity. I want to arrange the price of the fruits into 3 groups of around the same average. How do I do this? Thank you

Hi, I really need help with this. I read from various sources but they are complicated and I do not understand them at all. Is anyone kind enough to help how do I go about it?

Hello, I am trying this code out but has error. Please help, This is my code. <?php include 'dbFunctions.php'; $result = mysql_query('select * from criteria_m'); if (!$result){ die('Query failed: ' . mysql_error()); } $i = 0; while ($i < mysql_num_fields($result)){ echo"information for column $i:<br />\n"; $meta = mysql_fetch_field($result, $i); if(!$meta){ …

Hello, I need help with this. If in my form i put this, <td><input type="text" name"Example" id="Example"></td> and my sql what would i put? Mine is, $insertQuery = "ALTER TABLE atable ADD column '$example' INT"; this is the error shown, You have an error in your SQL syntax; check the …

Greetings everyone i'm new to php and this is what i want to do if you can help me , i have a DB on my web server and there are two column one for the name of the product and the other for the id of the product , …