Php syntax error? - Page 2

Question

rpv_sen 59 Junior Poster

13 Years Ago

Hi

$latest="select * from Products order by 'serialno' desc limit 0,1";

Pls dont use 'serialno' simply try to use serialno

Let me check the status

karthik_ppts commented: correct +3

karthik_ppts 81 Posting Pro

13 Years Ago

Replace the single quotes(') with (`) as follows

$latest="select * from Products order by `serialno` desc limit 0,1";

Or else as rpv_sen said, dont use any character as follows

$latest="select * from Products order by serialno desc limit 0,1";

please use code tags to post your codes.

vivekchandra 0 Newbie Poster

13 Years Ago

the problem is in line 21 u havent declare $result...1st declare it in
mysql_query("SELECT*FROM Products='"$result"'");

although it will again give you error..because the syntax is

mysql_query(query,connection)...

in your code add $con in the connection as it hold the database connection otherwise it will create some problem later..

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

rpv_sen 59 Junior Poster · Answer 1 · 2011-05-05T09:53:52+00:00

Hi

Pls check have put Dot after serial number in database or not. if so please remove the dot(.)

$latest="select * from Products order by serial no. desc limit 0,1";

Pls use this

$latest="select * from Products order by serial no desc limit 0,1";

Let me check how it works

eduardc 0 Light Poster · Answer 2 · 2011-05-06T05:48:59+00:00

Hi
Pls check have put Dot after serial number in database or not. if so please remove the dot(.)
$latest="select * from Products order by serial no. desc limit 0,1";
Pls use this
$latest="select * from Products order by serial no desc limit 0,1";
Let me check how it works

Unfornately it doesn´t work!

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 'no desc limit 0,1' at line 1

<?php
$con = mysql_connect("localhost","eduardli_user","-z.x,c");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

$description = $_POST["description"];
$price = $_POST["price"];
$quantity = $_POST["quantity"];

mysql_select_db("eduardli_company", $con) or die(mysql_error());

mysql_query ("INSERT INTO Products (description, price, quantity)
VALUES ('$description', '$price', '$quantity')") or die(mysql_error());

$latest="select * from Products order by serial no desc limit 0,1";
$result = mysql_query($latest,$con) or die(mysql_error());
$row = mysql_fetch_array($result);
{
echo $row . " " . $row . " " . $row . " " . $row;
echo "<br />";
}

mysql_close($con);
?>

</body>
</html>

rpv_sen 59 Junior Poster · Answer 3 · 2011-05-06T09:43:22+00:00

HI

Are you storing Serial no in the BD, if so please post your BD details, it will help me to rectify your issue

karthik_ppts 81 Posting Pro · Answer 4 · 2011-05-06T10:26:04+00:00

Just replace the following line

$latest="select * from Products order by serial no desc limit 0,1";

with

$latest="select * from Products order by `serial no` desc limit 0,1";

The space between serial and no is the problem so place the serial no within quotes as `serial no`.

Use code tags to post your codes.

eduardc 0 Light Poster · Answer 5 · 2011-05-06T19:33:37+00:00

Just replace the following line
$latest="select * from Products order by serial no desc limit 0,1";
with
$latest="select * from Products order by `serial no` desc limit 0,1";
The space between serial and no is the problem so place the serial no within quotes as `serial no`.
Use code tags to post your codes.

Hi,

Now it´s there 1 output, but not the latest! And there are the output of 3 fields and I want 4 (serial no, description, price, quantity)

<?php
$con = mysql_connect("localhost","eduardli_user","-z.x,c");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

$description = $_POST["description"];
$price = $_POST["price"];
$quantity = $_POST["quantity"];

mysql_select_db("eduardli_company", $con) or die(mysql_error());

mysql_query ("INSERT INTO Products (description, price, quantity)
VALUES ('$description', '$price', '$quantity')") or die(mysql_error());

$latest="select * from Products order by 'serialno' desc limit 0,1";
$result = mysql_query($latest,$con) or die(mysql_error());
$row = mysql_fetch_array($result);
{
echo $row . " " . $row . " " . $row . " " . $row;
echo "<br />";
}

mysql_close($con);
?>

</body>
</html>

kekkaishi 18 Junior Poster · Answer 6 · 2011-05-06T19:41:39+00:00

Could you share your database table with us for reference. From the look of it I think the problem is that you are using $row when there is no such field in the database table. Perhaps you should change $row after checking your table carefully. But, it would be very easy if you could share your table with us.

PS: One advice on database naming convention: You should avoid having names like 'serial no' where you are required to use quotes. Instead of the space use underscore.

eduardc 0 Light Poster · Answer 7 · 2011-05-06T19:52:42+00:00

Could you share your database table with us for reference. From the look of it I think the problem is that you are using $row when there is no such field in the database table. Perhaps you should change $row after checking your table carefully. But, it would be very easy if you could share your table with us.
PS: One advice on database naming convention: You should avoid having names like 'serial no' where you are required to use quotes. Instead of the space use underscore.

I think that´s indeed the problem! But how do I get my db from phpMyAdmin to you? (Exporting?)

kekkaishi 18 Junior Poster · Answer 8 · 2011-05-06T20:07:16+00:00

Well if that was the only problem I guess you do not need to share your table :) What you need to know is that the associative name should be the name of a field in the table and a field that you are selecting in the select query. ($row). If you still want to share the table then yes, export the table. That is, browse to the table and go to the export link at the top menu.

eduardc 0 Light Poster · Answer 9 · 2011-05-06T20:32:51+00:00

Well if that was the only problem I guess you do not need to share your table :) What you need to know is that the associative name should be the name of a field in the table and a field that you are selecting in the select query. ($row). If you still want to share the table then yes, export the table. That is, browse to the table and go to the export link at the top menu.

Thanks!

aidant 0 Newbie Poster · Answer 10 · 2011-05-07T01:45:20+00:00

your first error is because $result isent a set var.

eduardc 0 Light Poster · Answer 11 · 2011-05-07T08:49:00+00:00

Still not the latest query!

<html>
<body>

<?php
$con = mysql_connect("localhost","eduardli_user","-z.x,c");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

$description = $_POST["description"];
$price = $_POST["price"];
$quantity = $_POST["quantity"];

mysql_select_db("eduardli_company", $con) or die(mysql_error());


mysql_query ("INSERT INTO Products (description, price, quantity) 
VALUES ('$description', '$price', '$quantity')") or die(mysql_error());

$latest="select * from Products order by 'serialno' desc limit 0,1";
$result = mysql_query($latest,$con) or die(mysql_error());
$row = mysql_fetch_array($result);
{
echo $row['serialno.'] . " " . $row['description'] . " " . $row['price'] . " " . $row['quantity'];
echo "<br />";
}

mysql_close($con);
?>

</body>
</html>

eduardc 0 Light Poster · Answer 12 · 2011-05-10T05:22:58+00:00

I´ve made the changes above, but I still don´t get the latest output! I want what the visitor fills into my form.html of my website (www.eduardlid.com) directly as output on a computer screen!

rpv_sen 59 Junior Poster · Answer 13 · 2011-05-10T10:09:41+00:00

Hi

I need one favour from you can you pls provide your DB structure for the reference

karthik_ppts 81 Posting Pro · Answer 14 · 2011-05-10T10:58:08+00:00

karthik_ppts 81 Posting Pro

13 Years Ago

What is your output now?

eduardc 0 Light Poster · Answer 15 · 2011-05-10T21:56:30+00:00

Please, can someone explain exactly how I send my db from phpMyAdmin to you?
Thanks!

P. s. at this moment I have a bad connection (mobile)!

ko ko 97 Practically a Master Poster · Answer 16 · 2011-05-10T23:39:35+00:00

Attach the screen-shot of your PhpMyadmin or show the structure of your table. For example:

--------------------------------------------------
| id | serial_no | price | description | quantity |
--------------------------------------------------
| 1  | 1234567890 | 10$  | Loram ipsum | 3        |

P.S: Please wrap your code in code tags. Or select your codes and click the CODE button on the toolbar of the editor.

rpv_sen 59 Junior Poster · Answer 17 · 2011-05-11T00:06:41+00:00

Hi

Please try the below code

<html>
<body>

<?php
$con = mysql_connect("localhost","eduardli_user","-z.x,c");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

$description = $_POST["description"];
$price = $_POST["price"];
$quantity = $_POST["quantity"];

mysql_select_db("eduardli_company", $con) or die(mysql_error());


mysql_query ("INSERT INTO Products (description, price, quantity) 
VALUES ('$description', '$price', '$quantity')") or die(mysql_error());

$latest="select * from Products order by serial_no desc limit 0,1";
$result = mysql_query($latest,$con) or die(mysql_error());
$row = mysql_fetch_array($result);
{
echo $row['serial_no'] . " " . $row['description'] . " " . $row['price'] . " " . $row['quantity'];
echo "<br />";
}

mysql_close($con);
?>

</body>
</html>

eduardc 0 Light Poster · Answer 18 · 2011-05-11T03:00:12+00:00

Attach the screen-shot of your PhpMyadmin or show the structure of your table. For example:
--------------------------------------------------
| id | serial_no | price | description | quantity |
--------------------------------------------------
| 1  | 1234567890 | 10$  | Loram ipsum | 3        |
P.S: Please wrap your code in code tags. Or select your codes and click the CODE button on the toolbar of the editor.

I have a Mac (spanish keyboard!) and I don´t know how to make a screenshot! Can I also do this by exporting my db from phpMyAdmin? How?

rpv_sen 59 Junior Poster · Answer 19 · 2011-05-11T10:11:47+00:00

Hi

Please export your table from phpMyAdmin

eduardc 0 Light Poster · Answer 20 · 2011-05-12T05:04:38+00:00

Hi
Please export your table from phpMyAdmin

How do I do that? (I´m just a beginner)

rpv_sen 59 Junior Poster · Answer 21 · 2011-05-12T10:01:37+00:00

Hi

If you are using xampp server locally in your system, please check this

http://localhost/phpmyadmin

eduardc 0 Light Poster · Answer 22 · 2011-05-12T17:46:05+00:00

Hi
If you are using xampp server locally in your system, please check this
http://localhost/phpmyadmin

I have MAMP, but what do I have to do with the URL?

rpv_sen 59 Junior Poster · Answer 23 · 2011-05-13T12:43:52+00:00

i think you can able to access phpmysql by

http://localhost:80/phpMyAdmin/

eduardc 0 Light Poster · Answer 24 · 2011-05-13T21:37:02+00:00

How do I do that? (I´m just a beginner)

Please, can you answer this question?

rpv_sen 59 Junior Poster · Answer 25 · 2011-05-14T09:58:46+00:00

Hi eduardc

sorry to say this, i dont know more about Mac.

eduardc 0 Light Poster · Answer 26 · 2011-05-15T05:35:32+00:00

I started this thread 13 days ago, but still the problem isn´t solved!
I can´t imagine that there isn´t anyone in this forum who really can help me!

P. s. many different answers and I´ve tried a lot of them but the problem still exist!

cossay 7 Junior Poster · Answer 27 · 2011-05-15T05:52:15+00:00

Rewrite your code this way

<html>
<body>

<?php
	$con = mysql_connect("localhost","eduardli_user","-z.x,c");
	if (!$con)
	{
		die('Could not connect: ' . mysql_error());
	}

	$description = $_POST["description"];
	$price = $_POST["price"];
	$quantity = $_POST["quantity"];

	mysql_select_db("eduardli_company", $con);


	mysql_query ("INSERT INTO Products (Description, Price, Quantity)  
	VALUES ('$description', '$price', '$quantity')");

	$result = mysql_query("SELECT * FROM Products");                  

	while($row = mysql_fetch_array($result))
	{
		echo $row['Description'] . " " . $row['Price'] . " " . $row['Quantity'];
		echo "<br />";
	}

	mysql_close($con);
?>

</body>
</html